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

exhibition_booking, page 81 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
200143798062020-02-15 14:36:36
200244398072020-02-16 07:55:03
200344398082020-02-16 07:55:03
200444398092020-02-16 07:55:03
200544398102020-02-16 07:55:03
200643698112020-02-16 12:36:10
200743898122020-02-16 14:42:43
200844298242020-02-18 15:32:05
200944298252020-02-18 15:32:05
201044298262020-02-18 15:32:05
201144298272020-02-18 15:32:05
201243998282020-02-19 10:06:37
201343998292020-02-19 10:06:37
201444098312020-02-20 14:00:09
201544098322020-02-20 14:00:09
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;