Music_Therapists

IDNameLocationExperienceAudio_Equipment
1John DoeNew York3 yearsBeyerdynamic T1
2Jane SmithLos Angeles6 monthsShure SE846
3Alice JohnsonChicago2 yearsBeyerdynamic DT 990 PRO

Sound_Engineers

IDNameLocationExperienceAudio_Equipment
4Mike BrownSan Francisco5 yearsBeyerdynamic T1
5David LeeWashington DC7 yearsAudeze LCD-XC
6Robert WhiteHouston4 yearsSennheiser HD 800 S

Companies

CompanyIDCompanyNameIndustryNumberOfEmployees
1Acme Inc.Technology10
2Global Corp.Finance500
3Creative SolutionsDesign5
4Healthcare ProviderHealthcare100
5Education InnovatorsEducation20

Jobs

JobIDTitleDescriptionTypeDatePostedCompanyID
(→ Companies.CompanyID)
1Software EngineerDevelop web applications using Java and Spring Boot.Full Time2022-01-011
2Graphic DesignerCreate visually appealing designs for print and digital media.Contract2022-02-013
3Data AnalystAnalyse data sets and provide insights for decision making.Part Time2022-03-015
4AccountantManage financial records and ensure accuracy of all transactions.Permanent2022-04-012
5NurseAdminister patient care and monitor vital signs.Temp2022-05-014

Applicants

ApplicationIdFullnameEmailPhoneNumberResumePathJobId
(→ Jobs.JobId)
1John Doejohndoe@example.com555-1234/path/to/resume.pdf1
2Jane Smithjanesmith@example.com555-5678/path/to/another/resume.pdf2
3Alice Johnsonalicejohnson@example.com555-9012/path/to/yet/another/resume.pdf3
4Michael Brownmikebrown@example.com555-1357/path/to/resume_brown.pdf4
5David Leedavidlee@example.com555-1415/path/to/resume_lee.pdf5