ER diagram
Booking database
Resources, availability, bookings and customers.
- Category
- Business
- Diagram type
- ER diagram
- Elements
- 4
- Connectors
- 3
What it is for
Holds are modelled as bookings with an expiry, rather than a separate table, so a single unique constraint prevents double booking.
More about the er diagram makerWhen it helps
- Designing a reservation system
- Preventing double bookings
- Planning a calendar integration