## Companies

id | name
--- | ---
1 | TechCorp
2 | Software Inc.
3 | Data Solutions Ltd.
4 | AI Developers
5 | Network Services Co.

## Jobs

id | title | description | location | salary | company_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.id)
1 | Software Engineer | Developing software applications. | New York | 80000.0 | 1
2 | Data Analyst | Analyzing data to support decision making. | Los Angeles | 70000.0 | 2
3 | UI/UX Designer | Designing user interfaces and experiences. | Chicago | 60000.0 | 3
4 | Network Administrator | Managing computer networks. | San Francisco | 75000.0 | 4
5 | Project Manager | Coordinating project activities and resources. | Boston | 90000.0 | 5

## Applicants

id | first_name | last_name | email | phone | application_date
--- | --- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | +1234567890 | 2024-03-13 13:29:19
2 | Jane | Doe | janedoe@email.com | +0987654321 | 2024-03-13 13:29:19
3 | Alice | Wonderland | alicewonderland@email.com | +1122334455 | 2024-03-13 13:29:19
4 | Bob | Builder | bobbuilder@email.com | +2233445566 | 2024-03-13 13:29:19
5 | Carol | Stone | caroline@email.com | +3344556677 | 2024-03-13 13:29:19

## Applications

id | applicant_id | job_id | cover_letter | resume_url | status
--- | --- | --- | --- | --- | ---
| (→ Applicants.id) | (→ Jobs.id) |  |  |
1 | 1 | 1 | Cover letter text... | http://example.com/resume1.pdf | Pending
2 | 1 | 2 | Cover letter text... | http://example.com/resume2.pdf | Rejected
3 | 2 | 3 | Cover letter text... | http://example.com/resume3.pdf | Accepted
4 | 3 | 4 | Cover letter text... | http://example.com/resume4.pdf | Interview Scheduled
5 | 4 | 5 | Cover letter text... | http://example.com/resume5.pdf | Offered

## Customer_Facing_Roles

id | role
--- | ---
1 | Customer Service Advisor
2 | IT Support Technician

## Language_Proficiencies

id | language
--- | ---
1 | Bilingual
2 | Multilingual

## Employees

id | first_name | last_name | email | phone | customer_role_id | language_proficiency_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Customer_Facing_Roles.id) | (→ Language_Proficiencies.id)
1 | Mike | Adams | mikeadams@email.com | +1112223333 | 1 | 1
2 | Nancy | Walker | nancywalker@email.com | +2223334444 | 1 | 2
3 | Tom | Hanks | thanks@email.com | +3344556677 | 2 | 1
4 | Laura | Williams | laurawilliams@email.com | +4455667788 | 2 | 2
5 | Steve | Martin | stevemartin@email.com | +5566778899 | 1 | 1