employee:
id: INT PRIMARY KEY
first_name: VARCHAR(30) to hold employees first name
last_name: VARCHAR(30) to hold employee last name
role_id: INT to hold reference to employee role
manager_id: INT to hold reference to another employee that is
the manager of the current employee(NULL if
the employee has no manager)
westgards
commented
1 year ago
employee: id: INT PRIMARY KEY first_name: VARCHAR(30) to hold employees first name last_name: VARCHAR(30) to hold employee last name role_id: INT to hold reference to employee role manager_id: INT to hold reference to another employee that is the manager of the current employee(NULL if the employee has no manager)