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 1,751–1,775 of 2,015

exhibition_booking, page 71 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
175131792922019-10-20 14:26:18
175230692932019-10-21 09:06:10
175330692942019-10-21 09:06:10
175431693002019-10-23 08:22:18
175531693012019-10-23 08:22:18
175631993032019-10-23 20:28:27
175730593042019-10-24 15:23:34
175830593052019-10-24 15:23:34
175933393062019-10-25 13:13:59
176031493072019-10-25 15:03:45
176131493082019-10-25 15:03:45
176231193112019-10-27 17:02:33
176331193122019-10-27 17:02:33
176431593132019-10-27 20:11:46
176531593142019-10-27 20:11:46
176631593152019-10-27 20:11:46
176731593162019-10-27 20:11:46
176831593172019-10-27 20:11:46
176931293202019-10-28 09:47:51
177031293212019-10-28 09:47:51
177132893232019-10-28 13:10:42
177232893242019-10-28 13:10:42
177331393282019-10-29 08:42:42
177432293372019-10-31 12:58:57
177532293382019-10-31 12:58:57
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;