Skip to content
Louvre Ops DB

Table

exhibition_booking

A ticket's place in a slot; a trigger stops overbooking.

Replaces in 2020: Exhibition Booking, Booking Ticket

Download CSV Query in playground

Rows 751–775 of 2,015

exhibition_booking, page 31 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
75117650702018-01-07 14:35:08
75217650712018-01-07 14:35:08
75317650722018-01-07 14:35:08
75417650732018-01-07 14:35:08
75517650742018-01-07 14:35:08
75617650752018-01-07 14:35:08
75717650762018-01-07 14:35:08
75817650772018-01-07 14:35:08
75917650782018-01-07 14:35:08
76017650792018-01-07 14:35:08
76117650802018-01-07 14:35:08
76217650812018-01-07 14:35:08
76317650822018-01-07 14:35:08
76417650832018-01-07 14:35:08
76517650842018-01-07 14:35:08
76617650852018-01-07 14:35:08
76717650862018-01-07 14:35:08
76817650872018-01-07 14:35:08
76917650882018-01-07 14:35:08
77017650892018-01-07 14:35:08
77117650902018-01-07 14:35:08
77217650912018-01-07 14:35:08
77317650922018-01-07 14:35:08
77417650932018-01-07 14:35:08
77517650942018-01-07 14:35:08
Table definition
CREATE TABLE exhibition_booking (
  booking_id INTEGER PRIMARY KEY,
  slot_id    INTEGER NOT NULL REFERENCES exhibition_slot (slot_id),
  ticket_id  INTEGER NOT NULL REFERENCES ticket (ticket_id),
  booked_at  TEXT NOT NULL,
  UNIQUE (slot_id, ticket_id)
) STRICT;