## Audio_Equipments

EquipmentID | EquipmentName
--- | ---
1 | Beyerdynamic T1
2 | Shure SE846

## Music_Therapists

TherapistID | FirstName | LastName | Email | 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

## Sound_Engineers

EngineerID | FirstName | LastName | Email | 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

## JobPostings

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

## Applicants

ApplicationID | FullName | Email | 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