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,151–1,175 of 2,015

exhibition_booking, page 47 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
115123971072018-11-21 11:56:32
115223971082018-11-21 11:56:32
115323971092018-11-21 11:56:32
115423971102018-11-21 11:56:32
115523971112018-11-21 11:56:32
115623971122018-11-21 11:56:32
115723971132018-11-21 11:56:32
115823971142018-11-21 11:56:32
115923971152018-11-21 11:56:32
116023971162018-11-21 11:56:32
116123971172018-11-21 11:56:32
116223971182018-11-21 11:56:32
116323971192018-11-21 11:56:32
116423971202018-11-21 11:56:32
116523971212018-11-21 11:56:32
116623971222018-11-21 11:56:32
116723971232018-11-21 11:56:32
116823971242018-11-21 11:56:32
116923971252018-11-21 11:56:32
117023971262018-11-21 11:56:32
117123971272018-11-21 11:56:32
117223971282018-11-21 11:56:32
117323971292018-11-21 11:56:32
117424071302018-11-21 11:56:32
117524071312018-11-21 11:56:32
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;