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,401–1,425 of 2,015

exhibition_booking, page 57 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
140126078552019-03-19 08:52:54
140226078562019-03-19 08:52:54
140326078572019-03-19 08:52:54
140426078582019-03-19 08:52:54
140526078592019-03-19 08:52:54
140626078602019-03-19 08:52:54
140726078612019-03-19 08:52:54
140826078622019-03-19 08:52:54
140926078632019-03-19 08:52:54
141026078642019-03-19 08:52:54
141126078652019-03-19 08:52:54
141226078662019-03-19 08:52:54
141326078672019-03-19 08:52:54
141426078682019-03-19 08:52:54
141526078692019-03-19 08:52:54
141626178702019-03-19 08:52:54
141726178712019-03-19 08:52:54
141826178722019-03-19 08:52:54
141926178732019-03-19 08:52:54
142026178742019-03-19 08:52:54
142125779782019-04-04 12:18:07
142225879802019-04-04 14:45:01
142325879812019-04-04 14:45:01
142425879822019-04-04 14:45:01
142525679862019-04-04 22:09:44
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;