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,476–1,500 of 2,015

exhibition_booking, page 60 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
147628284462019-06-28 15:59:39
147728284472019-06-28 15:59:39
147828384562019-07-04 10:05:25
147928384572019-07-04 10:05:25
148028384582019-07-04 10:05:25
148128384592019-07-04 10:05:25
148229184632019-07-05 11:14:26
148329184642019-07-05 11:14:26
148429184652019-07-05 11:14:26
148529184662019-07-05 11:14:26
148629184672019-07-05 11:14:26
148729184682019-07-05 11:14:26
148829184692019-07-05 11:14:26
148929184702019-07-05 11:14:26
149029184712019-07-05 11:14:26
149129184722019-07-05 11:14:26
149229184732019-07-05 11:14:26
149329184742019-07-05 11:14:26
149429184752019-07-05 11:14:26
149529184762019-07-05 11:14:26
149629184772019-07-05 11:14:26
149729184782019-07-05 11:14:26
149829184792019-07-05 11:14:26
149929184802019-07-05 11:14:26
150029184812019-07-05 11:14:26
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;