Companies

idname
1TechCorp
2Software Inc.
3Data Solutions Ltd.
4AI Developers
5Network Services Co.

Jobs

idtitledescriptionlocationsalarycompany_id
(→ Companies.id)
1Software EngineerDeveloping software applications.New York80000.01
2Data AnalystAnalyzing data to support decision making.Los Angeles70000.02
3UI/UX DesignerDesigning user interfaces and experiences.Chicago60000.03
4Network AdministratorManaging computer networks.San Francisco75000.04
5Project ManagerCoordinating project activities and resources.Boston90000.05

Applicants

idfirst_namelast_nameemailphoneapplication_date
1JohnSmithjohnsmith@email.com+12345678902024-03-13 13:29:19
2JaneDoejanedoe@email.com+09876543212024-03-13 13:29:19
3AliceWonderlandalicewonderland@email.com+11223344552024-03-13 13:29:19
4BobBuilderbobbuilder@email.com+22334455662024-03-13 13:29:19
5CarolStonecaroline@email.com+33445566772024-03-13 13:29:19

Applications

idapplicant_idjob_idcover_letterresume_urlstatus
(→ Applicants.id)(→ Jobs.id)
111Cover letter text...http://example.com/resume1.pdfPending
212Cover letter text...http://example.com/resume2.pdfRejected
323Cover letter text...http://example.com/resume3.pdfAccepted
434Cover letter text...http://example.com/resume4.pdfInterview Scheduled
545Cover letter text...http://example.com/resume5.pdfOffered

Customer_Facing_Roles

idrole
1Customer Service Advisor
2IT Support Technician

Language_Proficiencies

idlanguage
1Bilingual
2Multilingual

Employees

idfirst_namelast_nameemailphonecustomer_role_idlanguage_proficiency_id
(→ Customer_Facing_Roles.id)(→ Language_Proficiencies.id)
1MikeAdamsmikeadams@email.com+111222333311
2NancyWalkernancywalker@email.com+222333444412
3TomHanksthanks@email.com+334455667721
4LauraWilliamslaurawilliams@email.com+445566778822
5SteveMartinstevemartin@email.com+556677889911