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 701–725 of 2,015

exhibition_booking, page 29 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
70114247362017-10-01 13:20:13
70214247372017-10-01 13:20:13
70314247382017-10-01 13:20:13
70414247392017-10-01 13:20:13
70514247402017-10-01 13:20:13
70614247412017-10-01 13:20:13
70713747492017-10-05 09:38:40
70813347582017-10-09 23:13:38
70913347592017-10-09 23:13:38
71013347602017-10-09 23:13:38
71113347612017-10-09 23:13:38
71213447742017-10-15 14:39:51
71313647902017-10-19 16:08:49
71413647912017-10-19 16:08:49
71513647922017-10-19 16:08:49
71613647932017-10-19 16:08:49
71713547942017-10-19 18:06:28
71814048072017-10-21 15:34:02
71914048082017-10-21 15:34:02
72013948172017-10-27 17:27:56
72113948182017-10-27 17:27:56
72214748572017-11-17 17:51:16
72314748582017-11-17 17:51:16
72414548592017-11-18 17:24:38
72514348662017-11-20 15:49:26
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;