Companies

idnamelocation
1TechCorpNew York
2SoftwareIncSan Francisco

Departments

iddepartmentNamecompanyId
(→ Companies.id)
1Engineering1
2Data Science1
3Marketing2

Positions

idpositionNamedepartmentId
(→ Departments.id)
1Software Engineer1
2Data Scientist1
3Product Manager2

JobPosts

idtitledescriptionpositionIdsalary
(→ Positions.id)
1Senior Software EngineerDesign and develop complex software systems.190000.0
2Mid-Level Data ScientistAnalyze large datasets to provide insights.280000.0
3Associate Product ManagerManage product roadmap and features.370000.0

Applicants

idfirstNamelastNameemailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

ApplicationStatuses

idstatusapplicantIdjobPostId
(→ Applicants.id)(→ JobPosts.id)
1Interview Scheduled11
2Rejected12

ManagementRoles

idrole
1Project Manager
2Business Analyst

ProjectDurations

idduration
14 weeks
26 weeks

JobsAndDurations

jobPostIdmanagementRoleIdprojectDurationId
(→ JobPosts.id)(→ ManagementRoles.id)(→ ProjectDurations.id)
111
112
221
222