## Degree_Level

id | level_name | description
--- | --- | ---
1 | Bachelor | A bachelors degree is typically a four-year undergraduate program.
2 | Master | A masters degree is usually pursued after obtaining a bachelors degree and can take one to three years.
3 | PhD | A doctoral degree requires extensive research and study beyond a master's degree.
4 | Associate | An associate degree is typically a two-year program that provides vocational training.
5 | High School Diploma | A high school diploma represents completion of secondary education.

## Certification

id | cert_name | description
--- | --- | ---
1 | Project Management Professional | This certification demonstrates expertise in project management principles.
2 | Microsoft Certified Solutions Developer | This certification validates proficiency in developing software solutions on Microsoft platforms.
3 | Certified Scrum Master | This certification indicates knowledge and skills in Agile methodologies, specifically the Scrum framework.
4 | CompTIA A+ | This certification signifies foundational IT support skills.
5 | Oracle Certified Java Programmer | This certification verifies programming skill with the Java language.

## Job_Type

id | type_name | description
--- | --- | ---
1 | Full Time | Permanent position offering regular hours and benefits.
2 | Part Time | Non-permanent position with limited hours and benefits.
3 | Contract | Temporary position for a fixed period of time.
4 | Internship | Short-term work experience opportunity often related to educational field.
5 | Freelance | Independent contractor providing services on a per-project basis.

## Company

id | company_name | location
--- | --- | ---
1 | ABC Tech Corporation | New York
2 | XYZ Software Solutions | San Francisco
3 | MNO Consulting Group | Chicago
4 | KLM International Inc. | Los Angeles
5 | RST Media Networks | Washington

## Job_Post

id | title | job_type_id | degree_level_id | certification_id | company_id
--- | --- | --- | --- | --- | ---
|  | (→ Job_Type.id) | (→ Degree_Level.id) | (→ Certification.id) | (→ Company.id)
1 | Software Engineer | 1 | 3 | 5 | 1
2 | Data Analyst | 2 | 1 | 2 | 2
3 | UX Designer | 1 | 2 | 4 | 3
4 | Marketing Manager | 1 | 1 | 1 | 4
5 | HR Specialist | 2 | 1 | 3 | 5

## Applicant

id | first_name | last_name | email | phone_number | application_date
--- | --- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | 555-123-4567 | 2024-02-19 12:44:27
2 | Jane | Doe | janedoe@email.com | 555-987-6543 | 2024-02-19 12:44:27
3 | Alice | Williams | alicewilliams@email.com | 555-098-7654 | 2024-02-19 12:44:27
4 | Tom | Brown | tommybrown@email.com | 555-135-7890 | 2024-02-19 12:44:27
5 | Emily | Green | emilygreen@email.com | 555-246-8790 | 2024-02-19 12:44:27

## Application

id | applicant_id | job_post_id | resume_url | cover_letter | status
--- | --- | --- | --- | --- | ---
| (→ Applicant.id) | (→ Job_Post.id) |  |  |
1 | 1 | 1 | https://example.com/resume/johnsmith.pdf | https://example.com/coverletters/johnsmith.txt | Received
2 | 1 | 2 | https://example.com/resume/johnsmith.pdf | https://example.com/coverletters/johnsmith.txt | Rejected
3 | 2 | 1 | https://example.com/resume/janedoe.pdf | https://example.com/coverletters/janedoe.txt | Interview Scheduled
4 | 2 | 2 | https://example.com/resume/janedoe.pdf | https://example.com/coverletters/janedoe.txt | Hired
5 | 3 | 1 | https://example.com/resume/alicewilliams.pdf | https://example.com/coverletters/alicewilliams.txt | Waitlisted