Degree_Level

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.

Certification

idcert_namedescription
1Project Management ProfessionalThis certification demonstrates expertise in project management principles.
2Microsoft Certified Solutions DeveloperThis certification validates proficiency in developing software solutions on Microsoft platforms.
3Certified Scrum MasterThis certification indicates knowledge and skills in Agile methodologies, specifically the Scrum framework.
4CompTIA A+This certification signifies foundational IT support skills.
5Oracle Certified Java ProgrammerThis certification verifies programming skill with the Java language.

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

Job_Post

idtitlejob_type_iddegree_level_idcertification_idcompany_id
(→ Job_Type.id)(→ Degree_Level.id)(→ Certification.id)(→ Company.id)
1Software Engineer1351
2Data Analyst2122
3UX Designer1243
4Marketing Manager1114
5HR Specialist2135

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