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 76–100 of 2,015

exhibition_booking, page 4 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
76111272015-03-20 16:14:05
77111282015-03-20 16:14:05
78111292015-03-20 16:14:05
79111302015-03-20 16:14:05
80111312015-03-20 16:14:05
81111322015-03-20 16:14:05
82111332015-03-20 16:14:05
83111342015-03-20 16:14:05
84111352015-03-20 16:14:05
85111362015-03-20 16:14:05
86111372015-03-20 16:14:05
87111382015-03-20 16:14:05
88111392015-03-20 16:14:05
89111402015-03-20 16:14:05
90111412015-03-20 16:14:05
91111422015-03-20 16:14:05
92111432015-03-20 16:14:05
93111442015-03-20 16:14:05
94111452015-03-20 16:14:05
95111462015-03-20 16:14:05
96111472015-03-20 16:14:05
97111482015-03-20 16:14:05
98111492015-03-20 16:14:05
99111502015-03-20 16:14:05
100111512015-03-20 16:14:05
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;