## Historical_Studies

study_id | profession | time_period
--- | --- | ---
|  | (→ Time_Periods.time_period)
1 | Historian | Ancient Rome
2 | Historian | Medieval Europe
3 | Archeologist | Ancient Rome
4 | Archeologist | Egyptian Civilization

## Time_Periods

period_id | time_period
--- | ---
1 | Ancient Rome
2 | Medieval Europe
3 | Egyptian Civilization

## Companies

company_id | name
--- | ---
1 | ABC Company
2 | XYZ Corporation
3 | PQR Enterprises
4 | LMT Industries
5 | UVW Holdings

## Jobs

job_id | title | description | posted_date | required_skills | historical_study | company_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Historical_Studies.study_id) | (→ Companies.company_id)
1 | Software Engineer | Development of new software applications. | 2023-01-01 | Strong programming skills in Java, Python or C++ | 1 | 1
2 | Data Analyst | Analysis of large datasets to identify trends. | 2023-02-01 | Experience with R or Python | 2 | 2
3 | Graphic Designer | Design creative visual content for marketing campaigns. | 2023-03-01 | Proficiency in Adobe Creative Suite | 3 | 3
4 | Marketing Manager | Lead the development of marketing strategies. | 2023-04-01 | MBA degree, experience in digital marketing | 4 | 4
5 | Project Manager | Oversee projects from initiation to completion. | 2023-05-01 | PMP certification, excellent organizational skills | 5 | 5

## Applicants

applicant_id | first_name | last_name | email | phone_number | resume
--- | --- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | +1-123-456-7890 | resume_johnsmith.pdf
2 | Jane | Doe | janedoe@email.com | +1-987-654-3210 | resume_janedoe.pdf
3 | Alex | Brown | alexbrown@email.com | +1-135-790-2460 | resume_alexbrown.pdf
4 | Emma | Green | emmagreen@email.com | +1-147-895-3600 | resume_emmagreen.pdf
5 | William | Black | williamblack@email.com | +1-126-489-7500 | resume_williamblack.pdf

## Application_Statuses

application_id | status | job_id | applicant_id
--- | --- | --- | ---
|  | (→ Jobs.job_id) | (→ Applicants.applicant_id)
1 | Pending | 1 | 1
2 | Interview Scheduled | 2 | 2
3 | Rejected | 3 | 3
4 | Offered | 4 | 4
5 | Hired | 5 | 5