The scenario
A music festival organizer needs to coordinate security guard bookings across multiple events and venues, schedule guard shifts, and track check-in/check-out assignments.
What is in this drawing
Read the decisions behind it.
01
Separating Booking from GuardAssignment normalizes shift requests from actual guard staffing.
02
Using a Client-to-Event and Event-to-Venue FK chain keeps organizer and location data independent.
03
Storing check-in/check-out timestamps on GuardAssignment supports attendance tracking and payroll.
Reuse for event staffing, volunteer shift scheduling, or any booking system where a request is fulfilled by multiple person assignments.
More like this