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

exhibition_booking, page 37 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
90120759822018-06-08 13:27:02
90220759832018-06-08 13:27:02
90320759842018-06-08 13:27:02
90420759852018-06-08 13:27:02
90520759862018-06-08 13:27:02
90620759872018-06-08 13:27:02
90720759882018-06-08 13:27:02
90820759892018-06-08 13:27:02
90920759902018-06-08 13:27:02
91020759912018-06-08 13:27:02
91120759922018-06-08 13:27:02
91220759932018-06-08 13:27:02
91320759942018-06-08 13:27:02
91420759952018-06-08 13:27:02
91520759962018-06-08 13:27:02
91620759972018-06-08 13:27:02
91720759982018-06-08 13:27:02
91820759992018-06-08 13:27:02
91920760002018-06-08 13:27:02
92020760012018-06-08 13:27:02
92120760022018-06-08 13:27:02
92220760032018-06-08 13:27:02
92320760042018-06-08 13:27:02
92420860052018-06-08 13:27:02
92520860062018-06-08 13:27:02
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;