ID | Profession | Equipment | YearsExperience | Location |
---|---|---|---|---|
(→ Audio_Equipments.Model) | ||||
1 | Music Therapist | Beyerdynamic T1 | 3 | New York |
2 | Music Therapist | Shure SE846 | 2 | Los Angeles |
3 | Sound Engineer | Beyerdynamic T1 | 5 | Chicago |
4 | Sound Engineer | AKG K701 | 4 | San Francisco |
Model | Brand | Type | Price | Inventory |
---|---|---|---|---|
Beyerdynamic T1 | Beyerdynamic | Headphone | 399.99 | 10 |
Shure SE846 | Shure | Earbud | 419 | 15 |
AKG K701 | AKG | Headphone | 349 | 8 |
CompanyID | Name | Address | PhoneNumber |
---|---|---|---|
1 | ABC Co. | 123 Main St. | 555-123-4567 |
2 | XYZ Inc. | 456 Elm St. | 555-987-6543 |
JobID | Title | Description | Salary | PostedDate | CompanyID |
---|---|---|---|---|---|
(→ Companies.CompanyID) | |||||
1 | Software Developer | Developing software applications | 80000 | 2024-03-07 21:29:34 | 1 |
2 | Graphic Designer | Designing visual content | 60000 | 2024-03-07 21:29:34 | 2 |
PostID | JobID | ApplicationDeadline | ContactEmail |
---|---|---|---|
(→ Jobs.JobID) | |||
1 | 1 | 2023-01-15 | john.doe@example.com |
2 | 2 | 2023-01-20 | jane.smith@example.com |
ApplicantID | FirstName | LastName | ResumePath | PhoneNumber | ApplyDate | JobPostID | |
---|---|---|---|---|---|---|---|
(→ JobPosts.PostID) | |||||||
1 | John | Doe | johndoe@email.com | /path/to/resume.pdf | 555-123-4567 | 2023-01-10 | 1 |
2 | Jane | Smith | janesmith@email.com | /path/to/another/resume.pdf | 555-987-6543 | 2023-01-15 | 2 |