Historical_Studies

study_idprofessiontime_period
(→ Time_Periods.time_period)
1HistorianAncient Rome
2HistorianMedieval Europe
3ArcheologistAncient Rome
4ArcheologistEgyptian Civilization

Time_Periods

period_idtime_period
1Ancient Rome
2Medieval Europe
3Egyptian Civilization

Companies

company_idname
1ABC Company
2XYZ Corporation
3PQR Enterprises
4LMT Industries
5UVW Holdings

Jobs

job_idtitledescriptionposted_daterequired_skillshistorical_studycompany_id
(→ Historical_Studies.study_id)(→ Companies.company_id)
1Software EngineerDevelopment of new software applications.2023-01-01Strong programming skills in Java, Python or C++11
2Data AnalystAnalysis of large datasets to identify trends.2023-02-01Experience with R or Python22
3Graphic DesignerDesign creative visual content for marketing campaigns.2023-03-01Proficiency in Adobe Creative Suite33
4Marketing ManagerLead the development of marketing strategies.2023-04-01MBA degree, experience in digital marketing44
5Project ManagerOversee projects from initiation to completion.2023-05-01PMP certification, excellent organizational skills55

Applicants

applicant_idfirst_namelast_nameemailphone_numberresume
1JohnSmithjohnsmith@email.com+1-123-456-7890resume_johnsmith.pdf
2JaneDoejanedoe@email.com+1-987-654-3210resume_janedoe.pdf
3AlexBrownalexbrown@email.com+1-135-790-2460resume_alexbrown.pdf
4EmmaGreenemmagreen@email.com+1-147-895-3600resume_emmagreen.pdf
5WilliamBlackwilliamblack@email.com+1-126-489-7500resume_williamblack.pdf

Application_Statuses

application_idstatusjob_idapplicant_id
(→ Jobs.job_id)(→ Applicants.applicant_id)
1Pending11
2Interview Scheduled22
3Rejected33
4Offered44
5Hired55