## Companies

id | name | address
--- | --- | ---
1 | Company A | 123 Main St
2 | Company B | 456 Elm St
3 | Company C | 789 Oak St
4 | Company D | 001 Pine St
5 | Company E | 246 Maple Ave

## Locations

id | city | state
--- | --- | ---
1 | New York | NY
2 | Los Angeles | CA
3 | Chicago | IL
4 | Houston | TX
5 | Phoenix | AZ

## Support_Roles

id | role
--- | ---
1 | Customer Service Representative
2 | Call Center Agent
3 | Technical Support Specialist
4 | Help Desk Analyst
5 | Customer Support Manager

## Skills

id | skill
--- | ---
1 | Proactivity
2 | Communication
3 | Active Listening
4 | Conflict Resolution
5 | Time Management

## Education

id | degree | institution | major | start_date | end_date
--- | --- | --- | --- | --- | ---
1 | Bachelor of Science | University of XYZ | Computer Science | 2015-08-20 | 2019-05-15
2 | Associate of Arts | College ABC | Business Administration | 2012-01-10 | 2014-05-15
3 | Master of Business Administration | University DEF | Management | 2016-08-20 | 2018-05-15
4 | High School Diploma | School GHI |  | 2011-08-20 | 2015-05-15
5 | Certificate in Data Analysis | Institute JKL |  | 2017-01-10 | 2017-05-15

## Experience

id | company_id | position | start_date | end_date
--- | --- | --- | --- | ---
| (→ Companies.id) |  |  |
1 | 1 | Software Engineer | 2019-06-01 | 2021-05-31
2 | 2 | Web Developer | 2018-08-01 | 2020-05-31
3 | 3 | Data Analyst | 2020-06-01 | Present
4 | 4 | Project Coordinator | 2017-01-01 | 2018-12-31
5 | 5 | Graphic Designer | 2016-05-01 | 2017-12-31

## Applicants

id | first_name | last_name | email | phone_number | education_id | experience_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Education.id) | (→ Experience.id)
1 | John | Doe | john.doe@example.com | 555-123-4567 | 1 | 1
2 | Jane | Smith | jane.smith@example.com | 555-987-6543 | 2 | 2
3 | Michael | Johnson | michael.johnson@example.com | 555-321-7654 | 3 | 3
4 | Emily | Williams | emily.williams@example.com | 555-456-1239 | 4 | 4
5 | David | Brown | david.brown@example.com | 555-765-4321 | 5 | 5

## JobPostings

id | title | description | location_id | support_role_id | skills_id | posted_date | closing_date | salary | applicant_id
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  | (→ Locations.id) | (→ Support_Roles.id) | (→ Skills.id) |  |  |  | (→ Applicants.id)
1 | Customer Service Representative | Respond to customer inquiries via phone, email, and chat. | 1 | 1 | 1 | 2021-09-01 | 2021-10-31 | 35000 | None
2 | Customer Service Representative | Assist customers with technical issues over the phone. | 1 | 1 | 2 | 2021-09-01 | 2021-10-31 | 35000 | None
3 | Call Center Agent | Handle incoming calls from customers and provide assistance. | 2 | 2 | 1 | 2021-09-01 | 2021-10-31 | 32000 | None
4 | Call Center Agent | Answer questions about products and services. | 2 | 2 | 3 | 2021-09-01 | 2021-10-31 | 32000 | None
5 | Software Engineer | Design, develop, and maintain software applications. | 3 | None | 4 | 2021-09-01 | 2021-10-31 | 70000 | None