id | photographerName | price | experience | specialization |
---|---|---|---|---|
1 | John Smith | 500 | 10 | Wedding |
2 | Jane Doe | 600 | 8 | Portraiture |
3 | Mike Johnson | 700 | 5 | Landscape |
id | videographerName | price | experience | specialization |
---|---|---|---|---|
1 | David Wilson | 500 | 7 | Corporate Events |
2 | Emily Brown | 600 | 9 | Documentary |
3 | William Taylor | 700 | 3 | Music Video |
id | jobTitle | description | requiredSkills | budget |
---|---|---|---|---|
1 | Event Photographer | Capture photos at a corporate event. | Adobe Lightroom, Camera Operation | 2000 |
2 | Freelance Videographer | Shoot and edit promotional video for small business. | Final Cut Pro, Cinematography | 3000 |
3 | Product Photographer | Take high quality images of products for online store. | Studio Lighting, Retouching | 1500 |
id | applicantId | applicationDate | coverLetter | status |
---|---|---|---|---|
1 | 1 | 2022-01-01 10:00:00 | Dear Hiring Manager... | Pending |
2 | 2 | 2022-01-02 10:00:00 | Thank you for considering my application... | Accepted |
3 | 3 | 2022-01-03 10:00:00 | I have extensive experience working on projects similar to this one... | Rejected |
skillId | skillName |
---|---|
1 | Adobe Lightroom |
2 | Camera Operation |
3 | Final Cut Pro |
4 | Cinematography |
5 | Studio Lighting |
6 | Retouching |
requirementID | jobPostId | skillId |
---|---|---|
(→ JobPosts.id) | (→ Skills.skillId) | |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 3 |
4 | 2 | 4 |
5 | 3 | 5 |