id | name |
---|---|
1 | Events Unlimited |
2 | Grand Celebrations |
id | companyId | experience | skills |
---|---|---|---|
(→ Company.id) | |||
1 | 1 | 3 | Organization, Communication |
2 | 2 | 6 | Decorating, Coordination |
id | companyId | experience | skills |
---|---|---|---|
(→ Company.id) | |||
1 | 1 | 2 | Designing, Planning |
2 | 2 | 7 | Vendor Relationships, Budgeting |
id | firstName | lastName | |
---|---|---|---|
1 | John | Smith | johnsmith@gmail.com |
2 | Jane | Doe | janedoe@gmail.com |
3 | Alice | Brown | alicebrown@gmail.com |
4 | Mike | White | mwhite@gmail.com |
5 | Emily | Black | eblack@gmail.com |
id | employeeId | salary | startDate | endDate |
---|---|---|---|---|
(→ Employee.id) | ||||
1 | 1 | 80000 | 2021-01-01 | 2023-12-31 |
2 | 2 | 90000 | 2019-01-01 | 2022-12-31 |
3 | 3 | 85000 | 2020-01-01 | Present |
4 | 4 | 82000 | 2018-01-01 | 2021-12-31 |
5 | 5 | 88000 | 2021-01-01 | Present |
id | employeeId | healthInsurance | retirementPlan | vacationDays |
---|---|---|---|---|
(→ Employee.id) | ||||
1 | 1 | 1 | 1 | 15 |
2 | 2 | 1 | 1 | 20 |
3 | 3 | 1 | 0 | 25 |
4 | 4 | 0 | 1 | 30 |
5 | 5 | 1 | 1 | 22 |