## Company

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

## JobPosting

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

## Employee

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

## AppliedJob

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

## SpacePlanningJob

id | type
--- | ---
1 | Interior Designer
2 | Exterior Designer
3 | Landscape Architect
4 | Urban Planner
5 | Architect

## Style

id | styleName
--- | ---
1 | Minimalism
2 | Modern
3 | Contemporary
4 | Traditional
5 | Victorian

## AssignedJob

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