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 |
period_id | time_period |
---|---|
1 | Ancient Rome |
2 | Medieval Europe |
3 | Egyptian Civilization |
company_id | name |
---|---|
1 | ABC Company |
2 | XYZ Corporation |
3 | PQR Enterprises |
4 | LMT Industries |
5 | UVW Holdings |
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 |
applicant_id | first_name | last_name | 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_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 |