MySQL One to Many Example Company Tables
Example
Consider a company where every employee who is a manager, manages 1 or more employees, and every employee has only 1 manager.
This results in two tables:
EMPLOYEES
| EMP_ID | FIRST_NAME | LAST_NAME | MGR_ID |
|---|---|---|---|
| E01 | Johnny | Appleseed | M02 |
| E02 | Erin | Macklemore | M01 |
| E03 | Colby | Paperwork | M03 |
| E04 | Ron | Sonswan | M01 |
MANAGERS
| MGR_ID | FIRST_NAME | LAST_NAME |
|---|---|---|
| M01 | Loud | McQueen |
| M02 | Bossy | Pants |
| M03 | Barrel | Jones |
