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 776–800 of 2,015

exhibition_booking, page 32 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
77617650952018-01-07 14:35:08
77717650962018-01-07 14:35:08
77817650972018-01-07 14:35:08
77917650982018-01-07 14:35:08
78017650992018-01-07 14:35:08
78117651002018-01-07 14:35:08
78217651012018-01-07 14:35:08
78317651022018-01-07 14:35:08
78417651032018-01-07 14:35:08
78517651042018-01-07 14:35:08
78617651052018-01-07 14:35:08
78717651062018-01-07 14:35:08
78817651072018-01-07 14:35:08
78917651082018-01-07 14:35:08
79017651092018-01-07 14:35:08
79117651102018-01-07 14:35:08
79217651112018-01-07 14:35:08
79317751122018-01-07 14:35:08
79417751132018-01-07 14:35:08
79517751142018-01-07 14:35:08
79617751152018-01-07 14:35:08
79717751162018-01-07 14:35:08
79817751172018-01-07 14:35:08
79917751182018-01-07 14:35:08
80017751192018-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;