## Clients

ClientID | Name | Email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com

## Jobs

JobID | Title | Description | Date
--- | --- | --- | ---
1 | Wedding Photography | Capture photos at a beautiful wedding ceremony. | 2023-06-10
2 | Corporate Video Production | Produce a professional video for a corporate event. | 2023-07-15

## Photographers

PhotographerID | Name | ContactInfo | HourlyRate
--- | --- | --- | ---
1 | Alice Johnson | +1 (555) 123-4567 | 500.0
2 | Bob Brown | +1 (555) 987-6543 | 600.0

## Videographers

VideographerID | Name | ContactInfo | HourlyRate
--- | --- | --- | ---
1 | Charlie White | +1 (555) 098-7654 | 500.0
2 | Diana Green | +1 (555) 432-1234 | 600.0

## JobPostings

PostingID | JobID | PhotographerID | VideographerID | Price
--- | --- | --- | --- | ---
| (→ Jobs.JobID) | (→ Photographers.PhotographerID) | (→ Videographers.VideographerID) |
1 | 1 | 1 | 1 | 1500.0
2 | 2 | 2 | 2 | 1800.0

## BookedJobs

BookingID | PostingID | ClientID | BookDate | PaymentAmount
--- | --- | --- | --- | ---
| (→ JobPostings.PostingID) | (→ Clients.ClientID) |  |
1 | 1 | 1 | 2023-06-12 | 1600.0
2 | 2 | 2 | 2023-07-17 | 1850.0