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,951–1,975 of 2,015

exhibition_booking, page 79 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
195141296772020-01-14 13:35:21
195241296782020-01-14 13:35:21
195341296792020-01-14 13:35:21
195441296802020-01-14 13:35:21
195541296812020-01-14 13:35:21
195641596822020-01-15 10:48:16
195741596832020-01-15 10:48:16
195843496902020-01-17 18:41:48
195943496912020-01-17 18:41:48
196043496922020-01-17 18:41:48
196141396932020-01-18 08:19:28
196241396942020-01-18 08:19:28
196341796982020-01-18 14:00:45
196441497012020-01-19 21:17:06
196541497022020-01-19 21:17:06
196641697112020-01-22 07:58:08
196742097122020-01-22 09:42:47
196842097132020-01-22 09:42:47
196941997142020-01-22 12:19:30
197041997152020-01-22 12:19:30
197142297262020-01-24 20:08:55
197242297272020-01-24 20:08:55
197342297282020-01-24 20:08:55
197442297292020-01-24 20:08:55
197542297302020-01-24 20:08:55
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;