Schema

Booking

A table reservation or walk-in visit. Central hub connecting customers to venues, orders, threads, upgrades, and events.

16 fields12 relationships

Fields

Name	Type	Req	Description
id	uuid	yes	Booking UUID.
status	enum	yes	enquiry_pending \| enquiry_confirmed \| active \| arrived \| partially_seated \| seated \| starter \| main \| appetizer \| entree \| dessert \| table_ready \| cleared \| check_dropped \| paid \| cancelled \| no_show \| complete.
party_size	number	yes	Number of covers.
start_time	datetime	yes	Reservation start. Indexed.
end_time	datetime	—	Reservation end.
completed_at	datetime	—	When booking completed.
booking_type	string	—	Service type, e.g. Lunch, Dinner, Brunch.
walk_in	boolean	—	Walked in without prior reservation.
vip	boolean	—	VIP flag.
reference	string	—	Human-readable reference.
deposit_amount	pennies	—	Deposit charged in pennies.
total_loyalty_points	number	—	Points earned on booking.
allergens	array	—	Allergen strings.
dietary_requirements	array	—	vegan, vegetarian, gluten-free etc.
message	string	—	Free-text request from guest.
message_embedding	vector	—	Semantic-search embedding of guest message.

Outbound (10)

Inbound (2)