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 |