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 |