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,351–1,375 of 2,015

exhibition_booking, page 55 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
135124577572019-03-05 07:06:13
135224577582019-03-05 07:06:13
135324577592019-03-05 07:06:13
135424577602019-03-05 07:06:13
135524577612019-03-05 07:06:13
135624377622019-03-05 08:28:18
135724377632019-03-05 08:28:18
135824377642019-03-05 08:28:18
135924377652019-03-05 08:28:18
136024477732019-03-06 08:50:28
136125177752019-03-07 21:39:41
136225177762019-03-07 21:39:41
136325177772019-03-07 21:39:41
136425177782019-03-07 21:39:41
136525177792019-03-07 21:39:41
136624777982019-03-12 08:31:20
136724777992019-03-12 08:31:20
136825378012019-03-12 20:21:52
136925378022019-03-12 20:21:52
137025278112019-03-15 17:25:32
137126078252019-03-19 08:52:54
137226078262019-03-19 08:52:54
137326078272019-03-19 08:52:54
137426078282019-03-19 08:52:54
137526078292019-03-19 08:52:54
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;