Audio_Equipments

EquipmentIDEquipmentName
1Beyerdynamic T1
2Shure SE846

Music_Therapists

TherapistIDFirstNameLastNameEmailPhoneNumberSoundCloudURLSpotifyURLAudioEquipmentID
(→ Audio_Equipments.EquipmentID)
1JohnDoejohn.doe@example.com+1234567890https://soundcloud.com/johndoehttps://open.spotify.com/artist/1234567891
2JaneSmithjane.smith@example.com+0987654321https://soundcloud.com/janesmithhttps://open.spotify.com/artist/abcdefghij2

Sound_Engineers

EngineerIDFirstNameLastNameEmailPhoneNumberLinkedInURLGitHubURLAudioEquipmentID
(→ Audio_Equipments.EquipmentID)
1MikeJohnsonmike.johnson@example.com+1234567890https://www.linkedin.com/in/mikejohnsonhttps://github.com/mikejohnson1
2EmilyWilliamsemily.williams@example.com+0987654321https://www.linkedin.com/in/emilywilliamshttps://github.com/emilywilliams2

JobPostings

PostingIDTitleDescriptionLocationPostedDateClosingDateMusicTherapistIDSoundEngineerID
(→ Music_Therapists.TherapistID)(→ Sound_Engineers.EngineerID)
1Music TherapistSeeking a certified music therapist...New York, NY2024-03-13 19:46:072023-01-31NoneNone
2Sound EngineerExperienced sound engineer needed...Los Angeles, CA2024-03-13 19:46:072023-01-31NoneNone

Applicants

ApplicationIDFullNameEmailResumeTextCoverLetterInterviewStatusJobPostingID
(→ JobPostings.PostingID)
1John Doejohn.doe@example.comResume TextCover LetterInterviewed1
2Jane Smithjane.smith@example.comResume TextCover LetterNot Interviewed1