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 |