| 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 |
| id | city | state |
|---|---|---|
| 1 | New York | NY |
| 2 | Los Angeles | CA |
| 3 | Chicago | IL |
| 4 | Houston | TX |
| 5 | Phoenix | AZ |
| id | role |
|---|---|
| 1 | Customer Service Representative |
| 2 | Call Center Agent |
| 3 | Technical Support Specialist |
| 4 | Help Desk Analyst |
| 5 | Customer Support Manager |
| id | skill |
|---|---|
| 1 | Proactivity |
| 2 | Communication |
| 3 | Active Listening |
| 4 | Conflict Resolution |
| 5 | Time Management |
| 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 |
| 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 |
| id | first_name | last_name | 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 |
| 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 |