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,601–1,625 of 2,015

exhibition_booking, page 65 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
160136789692019-09-11 10:27:08
160236789702019-09-11 10:27:08
160336789712019-09-11 10:27:08
160436789722019-09-11 10:27:08
160536789732019-09-11 10:27:08
160636789742019-09-11 10:27:08
160736789752019-09-11 10:27:08
160836789762019-09-11 10:27:08
160936789772019-09-11 10:27:08
161036789782019-09-11 10:27:08
161136789792019-09-11 10:27:08
161236789802019-09-11 10:27:08
161336789812019-09-11 10:27:08
161436789822019-09-11 10:27:08
161536789832019-09-11 10:27:08
161636789842019-09-11 10:27:08
161736789852019-09-11 10:27:08
161836789862019-09-11 10:27:08
161936789872019-09-11 10:27:08
162036789882019-09-11 10:27:08
162136789892019-09-11 10:27:08
162236789902019-09-11 10:27:08
162336789912019-09-11 10:27:08
162436789922019-09-11 10:27:08
162536789932019-09-11 10:27:08
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;