Clients

ClientIDNameEmail
1John Doejohn@example.com
2Jane Smithjane@example.com

Jobs

JobIDTitleDescriptionDate
1Wedding PhotographyCapture photos at a beautiful wedding ceremony.2023-06-10
2Corporate Video ProductionProduce a professional video for a corporate event.2023-07-15

Photographers

PhotographerIDNameContactInfoHourlyRate
1Alice Johnson+1 (555) 123-4567500.0
2Bob Brown+1 (555) 987-6543600.0

Videographers

VideographerIDNameContactInfoHourlyRate
1Charlie White+1 (555) 098-7654500.0
2Diana Green+1 (555) 432-1234600.0

JobPostings

PostingIDJobIDPhotographerIDVideographerIDPrice
(→ Jobs.JobID)(→ Photographers.PhotographerID)(→ Videographers.VideographerID)
11111500.0
22221800.0

BookedJobs

BookingIDPostingIDClientIDBookDatePaymentAmount
(→ JobPostings.PostingID)(→ Clients.ClientID)
1112023-06-121600.0
2222023-07-171850.0