| 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 |