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,726–1,750 of 2,015

exhibition_booking, page 70 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
172637592662019-10-19 17:07:10
172737592672019-10-19 17:07:10
172837592682019-10-19 17:07:10
172937592692019-10-19 17:07:10
173037592702019-10-19 17:07:10
173137592712019-10-19 17:07:10
173237592722019-10-19 17:07:10
173337592732019-10-19 17:07:10
173437592742019-10-19 17:07:10
173537592752019-10-19 17:07:10
173637592762019-10-19 17:07:10
173737592772019-10-19 17:07:10
173837592782019-10-19 17:07:10
173937592792019-10-19 17:07:10
174037592802019-10-19 17:07:10
174137592812019-10-19 17:07:10
174237592822019-10-19 17:07:10
174337592832019-10-19 17:07:10
174437592842019-10-19 17:07:10
174537592852019-10-19 17:07:10
174637692862019-10-19 17:07:10
174737692872019-10-19 17:07:10
174837692882019-10-19 17:07:10
174937692892019-10-19 17:07:10
175037692902019-10-19 17:07:10
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;