Companies

idnameaddressphone_number
1Company AAddress APhone Number A
2Company BAddress BPhone Number B
3Company CAddress CPhone Number C
4Company DAddress DPhone Number D
5Company EAddress EPhone Number E

Departments

idcompany_iddepartment_name
(→ Companies.id)
11HR Department
21IT Department
32Marketing Department
42Finance Department
53Engineering Department

JobPostings

idtitledescriptionsalarypost_datedepartment_id
(→ Departments.id)
1Software EngineerDevelop software solutions.700002022-06-011
2Data AnalystAnalyze data and provide insights.600002022-06-022
3Project ManagerLead projects and coordinate teams.800002022-06-033
4Web DeveloperDesign and develop websites.650002022-06-044
5Graphic DesignerCreate visual designs.500002022-06-055

Applicants

idfirst_namelast_nameemailphone_number
1JohnSmithjohnsmith@email.com123-456-7890
2JaneDoejanedoe@email.com098-765-4321
3AliceBrownalicebrown@email.com555-123-4567
4CharlieWhitecharliewhite@email.com555-456-7890
5DavidGreendavidgreen@email.com555-789-1234

ApplicationStatuses

idjob_posting_idapplicant_idstatusapplication_date
(→ JobPostings.id)(→ Applicants.id)
111Pending2022-06-01
212Rejected2022-06-02
321Accepted2022-06-03
422Rejected2022-06-04
531Interview Scheduled2022-06-05

EarthScienceCareerOptions

idcareer_optionuniversity_id
(→ Universities.id)
1Chemist1
2Chemist2
3Geoscientist1
4Geoscientist2
5Environmental Scientist1

Universities

idname
1Massachusetts Institute of Technology (MIT)
2Stanford University
3California Institute of Technology (Caltech)
4Harvard University
5Princeton University