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 851–875 of 2,015

exhibition_booking, page 35 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
85119057052018-05-08 11:47:34
85218757382018-05-10 12:29:48
85318757392018-05-10 12:29:48
85418157452018-05-12 09:12:29
85518157462018-05-12 09:12:29
85618157472018-05-12 09:12:29
85718357692018-05-13 23:45:57
85818357702018-05-13 23:45:57
85918357712018-05-13 23:45:57
86018357722018-05-13 23:45:57
86118457872018-05-16 19:09:03
86218657972018-05-18 13:47:28
86318657982018-05-18 13:47:28
86418558322018-05-28 22:08:45
86518558332018-05-28 22:08:45
86619158782018-05-31 14:32:14
86719158792018-05-31 14:32:14
86819158802018-05-31 14:32:14
86919158812018-05-31 14:32:14
87018858822018-05-31 15:05:42
87118858832018-05-31 15:05:42
87218858842018-05-31 15:05:42
87318958942018-06-02 19:11:07
87418958952018-06-02 19:11:07
87519259422018-06-06 07:00:49
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;