| ClientID | Name | |
|---|---|---|
| 1 | John Doe | john@example.com |
| 2 | Jane Smith | jane@example.com |
| 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 |
| PhotographerID | Name | ContactInfo | HourlyRate |
|---|---|---|---|
| 1 | Alice Johnson | +1 (555) 123-4567 | 500.0 |
| 2 | Bob Brown | +1 (555) 987-6543 | 600.0 |
| VideographerID | Name | ContactInfo | HourlyRate |
|---|---|---|---|
| 1 | Charlie White | +1 (555) 098-7654 | 500.0 |
| 2 | Diana Green | +1 (555) 432-1234 | 600.0 |
| PostingID | JobID | PhotographerID | VideographerID | Price |
|---|---|---|---|---|
| (→ Jobs.JobID) | (→ Photographers.PhotographerID) | (→ Videographers.VideographerID) | ||
| 1 | 1 | 1 | 1 | 1500.0 |
| 2 | 2 | 2 | 2 | 1800.0 |
| 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 |