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 |