Companies

idnameaddressphoneemail
1Company A123 Main St+1 555-555-5555companyA@example.com
2Company B456 Elm St+1 555-555-5556companyB@example.com

Business_Professions

idprofession
1Sales Representative
2Marketing Manager

Commissions

idcommission
1Base Salary Plus Commission
2Salaried Position

Positions

idtitledescriptioncompany_idbusiness_profession_idcommission_id
(→ Companies.id)(→ Business_Professions.id)(→ Commissions.id)
1Software DeveloperDeveloping web applications111
2Graphic DesignerCreating visual content121
3Account Executive - Sales RepresentativeClosing sales deals212
4Digital Marketing SpecialistManaging online marketing campaigns233
5Product Manager - Marketing ManagerOverseeing product launches244

Applicants

idfirstnamelastnameemailphone
1JohnDoejohn.doe@example.com+1 555-555-5557
2JaneSmithjane.smith@example.com+1 555-555-5558

Application

idposition_idapplicant_idapplication_datestatus
(→ Positions.id)(→ Applicants.id)
1112024-03-13 11:25:04Applied
2222024-03-13 11:25:04Interview Scheduled
3312024-03-13 11:25:04Rejected
4422024-03-13 11:25:04Hired
5512024-03-13 11:25:04On Hold