| id | name |
|---|---|
| 1 | TechCorp |
| 2 | Software Inc. |
| 3 | Data Solutions Ltd. |
| 4 | AI Developers |
| 5 | Network Services Co. |
| 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 |
| id | first_name | last_name | 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 |
| 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 |
| id | role |
|---|---|
| 1 | Customer Service Advisor |
| 2 | IT Support Technician |
| id | language |
|---|---|
| 1 | Bilingual |
| 2 | Multilingual |
| id | first_name | last_name | 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 |