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. |
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. |
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 |
id | first_name | last_name | 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 |
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 |
id | title | job_type_id | degree_level_id | company_id |
---|---|---|---|---|
(→ Job_Type.id) | (→ Qualifications.id) | (→ Company.id) | ||
1 | Software Engineer | 1 | 3 | 1 |
2 | Data Analyst | 2 | 1 | 2 |
3 | UX Designer | 1 | 2 | 3 |
4 | Marketing Manager | 1 | 1 | 4 |
5 | HR Specialist | 2 | 1 | 5 |