Company

idnameaddress
1Company A123 Main St
2Company B456 Elm St
3Company C789 Oak St
4Company D000 Pine St
5Company E999 Maple Ave

JobPosting

idtitledescriptioncompanyId
(→ Company.id)
1Software EngineerDesign and develop software applications.1
2Data AnalystAnalyze and interpret data sets.1
3Graphic DesignerCreate visual designs for marketing materials.2
4Product ManagerOversee product development and launch.2
5Marketing SpecialistDevelop and execute marketing strategies.3

Employee

idfirstNamelastNamejobTitle
1JohnSmithSoftware Engineer
2JaneDoeData Analyst
3MichaelBrownGraphic Designer
4AliceGreenProduct Manager
5RobertBlackMarketing Specialist

AppliedJob

idemployeeIdpostingIdapplicationDate
(→ Employee.id)(→ JobPosting.id)
1112021-08-15 10:30:00
2222021-08-15 10:35:00
3332021-08-15 10:40:00
4442021-08-15 10:45:00
5552021-08-15 10:50:00

SpacePlanningJob

idtype
1Interior Designer
2Exterior Designer
3Landscape Architect
4Urban Planner
5Architect

Style

idstyleName
1Minimalism
2Modern
3Contemporary
4Traditional
5Victorian

AssignedJob

spacePlanningJobIdstyleIdjobPostingIdassignedEmployeeIdstartDateendDate
(→ SpacePlanningJob.id)(→ Style.id)(→ JobPosting.id)(→ Employee.id)
11112021-09-012021-09-15
12222021-09-012021-09-15
21332021-09-162021-09-30
22442021-09-162021-09-30
31552021-10-012021-10-15