employees |
Official MySQL example database
| departments | |
| Content |
| dept_no | dept_name |
d001 |
Marketing |
d002 |
Finance |
d003 |
Human Resources |
d004 |
Production |
d005 |
Development |
d006 |
Quality Management |
d007 |
Sales |
d008 |
Research |
d009 |
Customer Service |
| dept_emp | |
| Content |
| emp_no | dept_no | from_date | to_date |
10001 |
d005 |
1986-06-26 |
9999-01-01 |
10002 |
d007 |
1996-08-03 |
9999-01-01 |
10003 |
d004 |
1995-12-03 |
9999-01-01 |
10004 |
d004 |
1986-12-01 |
9999-01-01 |
10005 |
d003 |
1989-09-12 |
9999-01-01 |
10006 |
d005 |
1990-08-05 |
9999-01-01 |
10007 |
d008 |
1989-02-10 |
9999-01-01 |
10008 |
d005 |
1998-03-11 |
2000-07-31 |
10009 |
d006 |
1985-02-18 |
9999-01-01 |
10010 |
d004 |
1996-11-24 |
2000-06-26 |
| dept_manager | |
| Content |
| dept_no | emp_no | from_date | to_date |
d001 |
110022 |
1985-01-01 |
1991-10-01 |
d001 |
110039 |
1991-10-01 |
9999-01-01 |
d002 |
110085 |
1985-01-01 |
1989-12-17 |
d002 |
110114 |
1989-12-17 |
9999-01-01 |
d003 |
110183 |
1985-01-01 |
1992-03-21 |
d003 |
110228 |
1992-03-21 |
9999-01-01 |
d004 |
110303 |
1985-01-01 |
1988-09-09 |
d004 |
110344 |
1988-09-09 |
1992-08-02 |
d004 |
110386 |
1992-08-02 |
1996-08-30 |
d004 |
110420 |
1996-08-30 |
9999-01-01 |
| employees | |
| Content |
| emp_no | birth_date | first_name | last_name | gender | hire_date |
10001 |
1953-09-02 |
Georgi |
Facello |
M |
1986-06-26 |
10002 |
1964-06-02 |
Bezalel |
Simmel |
F |
1985-11-21 |
10003 |
1959-12-03 |
Parto |
Bamford |
M |
1986-08-28 |
10004 |
1954-05-01 |
Chirstian |
Koblick |
M |
1986-12-01 |
10005 |
1955-01-21 |
Kyoichi |
Maliniak |
M |
1989-09-12 |
10006 |
1953-04-20 |
Anneke |
Preusig |
F |
1989-06-02 |
10007 |
1957-05-23 |
Tzvetan |
Zielinski |
F |
1989-02-10 |
10008 |
1958-02-19 |
Saniya |
Kalloufi |
M |
1994-09-15 |
10009 |
1952-04-19 |
Sumant |
Peac |
F |
1985-02-18 |
10010 |
1963-06-01 |
Duangkaew |
Piveteau |
F |
1989-08-24 |
| salaries | |
| Content |
| emp_no | salary | from_date | to_date |
10001 |
60117 |
1986-06-26 |
1987-06-26 |
10001 |
62102 |
1987-06-26 |
1988-06-25 |
10001 |
66074 |
1988-06-25 |
1989-06-25 |
10001 |
66596 |
1989-06-25 |
1990-06-25 |
10001 |
66961 |
1990-06-25 |
1991-06-25 |
10001 |
71046 |
1991-06-25 |
1992-06-24 |
10001 |
74333 |
1992-06-24 |
1993-06-24 |
10001 |
75286 |
1993-06-24 |
1994-06-24 |
10001 |
75994 |
1994-06-24 |
1995-06-24 |
10001 |
76884 |
1995-06-24 |
1996-06-23 |
| titles | |
| Content |
| emp_no | title | from_date | to_date |
10001 |
Senior Engineer |
1986-06-26 |
9999-01-01 |
10002 |
Staff |
1996-08-03 |
9999-01-01 |
10003 |
Senior Engineer |
1995-12-03 |
9999-01-01 |
10004 |
Engineer |
1986-12-01 |
1995-12-01 |
10004 |
Senior Engineer |
1995-12-01 |
9999-01-01 |
10005 |
Senior Staff |
1996-09-12 |
9999-01-01 |
10005 |
Staff |
1989-09-12 |
1996-09-12 |
10006 |
Senior Engineer |
1990-08-05 |
9999-01-01 |
10007 |
Senior Staff |
1996-02-11 |
9999-01-01 |
10007 |
Staff |
1989-02-10 |
1996-02-11 |
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 License.