Companies

idnameaddress
1Company A123 Main St
2Company B456 Elm St
3Company C789 Oak St
4Company D001 Pine St
5Company E246 Maple Ave

Locations

idcitystate
1New YorkNY
2Los AngelesCA
3ChicagoIL
4HoustonTX
5PhoenixAZ

Support_Roles

idrole
1Customer Service Representative
2Call Center Agent
3Technical Support Specialist
4Help Desk Analyst
5Customer Support Manager

Skills

idskill
1Proactivity
2Communication
3Active Listening
4Conflict Resolution
5Time Management

Education

iddegreeinstitutionmajorstart_dateend_date
1Bachelor of ScienceUniversity of XYZComputer Science2015-08-202019-05-15
2Associate of ArtsCollege ABCBusiness Administration2012-01-102014-05-15
3Master of Business AdministrationUniversity DEFManagement2016-08-202018-05-15
4High School DiplomaSchool GHI2011-08-202015-05-15
5Certificate in Data AnalysisInstitute JKL2017-01-102017-05-15

Experience

idcompany_idpositionstart_dateend_date
(→ Companies.id)
11Software Engineer2019-06-012021-05-31
22Web Developer2018-08-012020-05-31
33Data Analyst2020-06-01Present
44Project Coordinator2017-01-012018-12-31
55Graphic Designer2016-05-012017-12-31

Applicants

idfirst_namelast_nameemailphone_numbereducation_idexperience_id
(→ Education.id)(→ Experience.id)
1JohnDoejohn.doe@example.com555-123-456711
2JaneSmithjane.smith@example.com555-987-654322
3MichaelJohnsonmichael.johnson@example.com555-321-765433
4EmilyWilliamsemily.williams@example.com555-456-123944
5DavidBrowndavid.brown@example.com555-765-432155

JobPostings

idtitledescriptionlocation_idsupport_role_idskills_idposted_dateclosing_datesalaryapplicant_id
(→ Locations.id)(→ Support_Roles.id)(→ Skills.id)(→ Applicants.id)
1Customer Service RepresentativeRespond to customer inquiries via phone, email, and chat.1112021-09-012021-10-3135000None
2Customer Service RepresentativeAssist customers with technical issues over the phone.1122021-09-012021-10-3135000None
3Call Center AgentHandle incoming calls from customers and provide assistance.2212021-09-012021-10-3132000None
4Call Center AgentAnswer questions about products and services.2232021-09-012021-10-3132000None
5Software EngineerDesign, develop, and maintain software applications.3None42021-09-012021-10-3170000None