Audio_Professionals

IDProfessionEquipmentYearsExperienceLocation
(→ Audio_Equipments.Model)
1Music TherapistBeyerdynamic T13New York
2Music TherapistShure SE8462Los Angeles
3Sound EngineerBeyerdynamic T15Chicago
4Sound EngineerAKG K7014San Francisco

Audio_Equipments

ModelBrandTypePriceInventory
Beyerdynamic T1BeyerdynamicHeadphone399.9910
Shure SE846ShureEarbud41915
AKG K701AKGHeadphone3498

Companies

CompanyIDNameAddressPhoneNumber
1ABC Co.123 Main St.555-123-4567
2XYZ Inc.456 Elm St.555-987-6543

Jobs

JobIDTitleDescriptionSalaryPostedDateCompanyID
(→ Companies.CompanyID)
1Software DeveloperDeveloping software applications800002024-03-07 21:29:341
2Graphic DesignerDesigning visual content600002024-03-07 21:29:342

JobPosts

PostIDJobIDApplicationDeadlineContactEmail
(→ Jobs.JobID)
112023-01-15john.doe@example.com
222023-01-20jane.smith@example.com

Applicants

ApplicantIDFirstNameLastNameEmailResumePathPhoneNumberApplyDateJobPostID
(→ JobPosts.PostID)
1JohnDoejohndoe@email.com/path/to/resume.pdf555-123-45672023-01-101
2JaneSmithjanesmith@email.com/path/to/another/resume.pdf555-987-65432023-01-152