employees
Documentation | Employees (MySQL database) |
Name | employees |
Module | Employees database diagram |
Employee information such as first name, last name, date of birth.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | emp_no | int(10, 0) | Employee identification number.Primary key for employee table. | |||||
Employee identification number.Primary key for employee table. |
||||||||
2 | birth_date | date | Date of birth. | |||||
Date of birth. |
||||||||
3 | first_name | varchar(14) | The employee's first name. | |||||
The employee's first name. |
||||||||
4 | last_name | varchar(16) | The employee's last name. | |||||
The employee's last name. |
||||||||
5 | gender | enum | M = Male, F = Female | |||||
M = Male, F = Female |
||||||||
6 | hire_date | date | Employee hired on this date. | |||||
Employee hired on this date. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dept_emp | employees | dept_emp.emp_no = employees.emp_no | dept_emp_ibfk_1 Foreign key constraint referencing employees.emp_no |
|
dept_emp.emp_no = employees.emp_no Name: dept_emp_ibfk_1Foreign key constraint referencing employees.emp_no |
||||
dept_manager | employees | dept_manager.emp_no = employees.emp_no | dept_manager_ibfk_1 Foreign key constraint referencing employees.emp_no |
|
dept_manager.emp_no = employees.emp_no Name: dept_manager_ibfk_1Foreign key constraint referencing employees.emp_no |
||||
salaries | employees | salaries.emp_no = employees.emp_no | salaries_ibfk_1 Foreign key constraint referencing employees.emp_no |
|
salaries.emp_no = employees.emp_no Name: salaries_ibfk_1Foreign key constraint referencing employees.emp_no |
||||
titles | employees | titles.emp_no = employees.emp_no | titles_ibfk_1 Foreign key constraint referencing employees.emp_no |
|
titles.emp_no = employees.emp_no Name: titles_ibfk_1Foreign key constraint referencing employees.emp_no |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PRIMARY | emp_no | Primary key constraint. | |
Primary key constraint. |
Used by
Name |
---|
employees
|
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21