Qualifications

idlevel_namedescription
1BachelorA bachelors degree is typically a four-year undergraduate program.
2MasterA masters degree is usually pursued after obtaining a bachelors degree and can take one to three years.
3PhDA doctoral degree requires extensive research and study beyond a master's degree.
4AssociateAn associate degree is typically a two-year program that provides vocational training.
5High School DiplomaA high school diploma represents completion of secondary education.

Job_Type

idtype_namedescription
1Full TimePermanent position offering regular hours and benefits.
2Part TimeNon-permanent position with limited hours and benefits.
3ContractTemporary position for a fixed period of time.
4InternshipShort-term work experience opportunity often related to educational field.
5FreelanceIndependent contractor providing services on a per-project basis.

Company

idcompany_namelocation
1ABC Tech CorporationNew York
2XYZ Software SolutionsSan Francisco
3MNO Consulting GroupChicago
4KLM International Inc.Los Angeles
5RST Media NetworksWashington

Applicant

idfirst_namelast_nameemailphone_numberapplication_date
1JohnSmithjohnsmith@email.com555-123-45672024-02-19 12:44:27
2JaneDoejanedoe@email.com555-987-65432024-02-19 12:44:27
3AliceWilliamsalicewilliams@email.com555-098-76542024-02-19 12:44:27
4TomBrowntommybrown@email.com555-135-78902024-02-19 12:44:27
5EmilyGreenemilygreen@email.com555-246-87902024-02-19 12:44:27

Application

idapplicant_idjob_post_idresume_urlcover_letterstatus
(→ Applicant.id)(→ Job_Post.id)
111https://example.com/resume/johnsmith.pdfhttps://example.com/coverletters/johnsmith.txtReceived
212https://example.com/resume/johnsmith.pdfhttps://example.com/coverletters/johnsmith.txtRejected
321https://example.com/resume/janedoe.pdfhttps://example.com/coverletters/janedoe.txtInterview Scheduled
422https://example.com/resume/janedoe.pdfhttps://example.com/coverletters/janedoe.txtHired
531https://example.com/resume/alicewilliams.pdfhttps://example.com/coverletters/alicewilliams.txtWaitlisted

Job_Post

idtitlejob_type_iddegree_level_idcompany_id
(→ Job_Type.id)(→ Qualifications.id)(→ Company.id)
1Software Engineer131
2Data Analyst212
3UX Designer123
4Marketing Manager114
5HR Specialist215