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,451–1,475 of 2,015

exhibition_booking, page 59 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
145126982102019-05-12 10:17:13
145227282282019-05-15 18:44:53
145327282292019-05-15 18:44:53
145427282302019-05-15 18:44:53
145527382632019-05-21 20:15:28
145627382642019-05-21 20:15:28
145727382652019-05-21 20:15:28
145827682732019-05-24 21:37:59
145927682742019-05-24 21:37:59
146027783242019-06-07 07:01:12
146127883552019-06-14 08:01:58
146227883562019-06-14 08:01:58
146327883572019-06-14 08:01:58
146427983622019-06-14 12:57:08
146527983632019-06-14 12:57:08
146627983642019-06-14 12:57:08
146728783872019-06-16 17:37:37
146828883992019-06-19 17:52:47
146928084092019-06-21 10:24:08
147028084102019-06-21 10:24:08
147128584292019-06-24 23:48:54
147228184362019-06-26 22:26:55
147328184372019-06-26 22:26:55
147428284442019-06-28 15:59:39
147528284452019-06-28 15:59:39
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;