## Photographers

id | name | email
--- | --- | ---
1 | John Smith | johnsmith@example.com
2 | Emily Johnson | emilyjohnson@example.com
3 | Michael Brown | michaelbrown@example.com
4 | Lisa Wilson | lisawilson@example.com
5 | David Lee | davidlee@example.com

## Styles

id | styleName
--- | ---
1 | Portrait
2 | Landscape
3 | Wedding
4 | Fashion
5 | Commercial

## Photographers_Styles

photographerId | styleId
--- | ---
(→ Photographers.id) | (→ Styles.id)
1 | 1
2 | 1
3 | 2
4 | 2
5 | 3
3 | 1
4 | 1
5 | 1

## JobPostings

jobID | title | description | deadline
--- | --- | --- | ---
1 | Family Portrait Session | A beautiful family portrait session at your home. | 2023-08-01
2 | Landscape Photography Shoot | Capture stunning landscapes for a travel blog. | 2023-07-20
3 | Wedding Ceremony Coverage | Document the special day of a couple getting married. | 2023-09-01
4 | Fashion Photo Shoot | Create a high fashion photo shoot for an upcoming clothing line. | 2023-06-15
5 | Corporate Event Coverage | Capture the essence of a corporate event for marketing purposes. | 2023-05-30