EquipmentID | EquipmentName |
---|---|
1 | Beyerdynamic T1 |
2 | Shure SE846 |
TherapistID | FirstName | LastName | PhoneNumber | SoundCloudURL | SpotifyURL | AudioEquipmentID | |
---|---|---|---|---|---|---|---|
(→ Audio_Equipments.EquipmentID) | |||||||
1 | John | Doe | john.doe@example.com | +1234567890 | https://soundcloud.com/johndoe | https://open.spotify.com/artist/123456789 | 1 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 | https://soundcloud.com/janesmith | https://open.spotify.com/artist/abcdefghij | 2 |
EngineerID | FirstName | LastName | PhoneNumber | LinkedInURL | GitHubURL | AudioEquipmentID | |
---|---|---|---|---|---|---|---|
(→ Audio_Equipments.EquipmentID) | |||||||
1 | Mike | Johnson | mike.johnson@example.com | +1234567890 | https://www.linkedin.com/in/mikejohnson | https://github.com/mikejohnson | 1 |
2 | Emily | Williams | emily.williams@example.com | +0987654321 | https://www.linkedin.com/in/emilywilliams | https://github.com/emilywilliams | 2 |
PostingID | Title | Description | Location | PostedDate | ClosingDate | MusicTherapistID | SoundEngineerID |
---|---|---|---|---|---|---|---|
(→ Music_Therapists.TherapistID) | (→ Sound_Engineers.EngineerID) | ||||||
1 | Music Therapist | Seeking a certified music therapist... | New York, NY | 2024-03-13 19:46:07 | 2023-01-31 | None | None |
2 | Sound Engineer | Experienced sound engineer needed... | Los Angeles, CA | 2024-03-13 19:46:07 | 2023-01-31 | None | None |
ApplicationID | FullName | ResumeText | CoverLetter | InterviewStatus | JobPostingID | |
---|---|---|---|---|---|---|
(→ JobPostings.PostingID) | ||||||
1 | John Doe | john.doe@example.com | Resume Text | Cover Letter | Interviewed | 1 |
2 | Jane Smith | jane.smith@example.com | Resume Text | Cover Letter | Not Interviewed | 1 |