| id | name | address |
|---|---|---|
| 1 | Company A | 123 Main St |
| 2 | Company B | 456 Elm St |
| 3 | Company C | 789 Oak St |
| 4 | Company D | 000 Pine St |
| 5 | Company E | 999 Maple Ave |
| id | title | description | companyId |
|---|---|---|---|
| (→ Company.id) | |||
| 1 | Software Engineer | Design and develop software applications. | 1 |
| 2 | Data Analyst | Analyze and interpret data sets. | 1 |
| 3 | Graphic Designer | Create visual designs for marketing materials. | 2 |
| 4 | Product Manager | Oversee product development and launch. | 2 |
| 5 | Marketing Specialist | Develop and execute marketing strategies. | 3 |
| id | firstName | lastName | jobTitle |
|---|---|---|---|
| 1 | John | Smith | Software Engineer |
| 2 | Jane | Doe | Data Analyst |
| 3 | Michael | Brown | Graphic Designer |
| 4 | Alice | Green | Product Manager |
| 5 | Robert | Black | Marketing Specialist |
| id | employeeId | postingId | applicationDate |
|---|---|---|---|
| (→ Employee.id) | (→ JobPosting.id) | ||
| 1 | 1 | 1 | 2021-08-15 10:30:00 |
| 2 | 2 | 2 | 2021-08-15 10:35:00 |
| 3 | 3 | 3 | 2021-08-15 10:40:00 |
| 4 | 4 | 4 | 2021-08-15 10:45:00 |
| 5 | 5 | 5 | 2021-08-15 10:50:00 |
| id | type |
|---|---|
| 1 | Interior Designer |
| 2 | Exterior Designer |
| 3 | Landscape Architect |
| 4 | Urban Planner |
| 5 | Architect |
| id | styleName |
|---|---|
| 1 | Minimalism |
| 2 | Modern |
| 3 | Contemporary |
| 4 | Traditional |
| 5 | Victorian |
| spacePlanningJobId | styleId | jobPostingId | assignedEmployeeId | startDate | endDate |
|---|---|---|---|---|---|
| (→ SpacePlanningJob.id) | (→ Style.id) | (→ JobPosting.id) | (→ Employee.id) | ||
| 1 | 1 | 1 | 1 | 2021-09-01 | 2021-09-15 |
| 1 | 2 | 2 | 2 | 2021-09-01 | 2021-09-15 |
| 2 | 1 | 3 | 3 | 2021-09-16 | 2021-09-30 |
| 2 | 2 | 4 | 4 | 2021-09-16 | 2021-09-30 |
| 3 | 1 | 5 | 5 | 2021-10-01 | 2021-10-15 |