## Photographers

id | photographerName | price | experience | specialization
--- | --- | --- | --- | ---
1 | John Smith | 500 | 10 | Wedding
2 | Jane Doe | 600 | 8 | Portraiture
3 | Mike Johnson | 700 | 5 | Landscape

## Videographers

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

## JobPosts

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

## Applications

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

## Skills

skillId | skillName
--- | ---
1 | Adobe Lightroom
2 | Camera Operation
3 | Final Cut Pro
4 | Cinematography
5 | Studio Lighting
6 | Retouching

## SkillRequirements

requirementID | jobPostId | skillId
--- | --- | ---
| (→ JobPosts.id) | (→ Skills.skillId)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 2 | 4
5 | 3 | 5