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 426–450 of 2,015

exhibition_booking, page 18 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
4269732992016-12-24 10:38:09
4279733002016-12-24 10:38:09
4289733012016-12-24 10:38:09
4298433352016-12-31 12:30:22
4309433422017-01-05 12:27:04
4319433432017-01-05 12:27:04
4329433442017-01-05 12:27:04
4339433452017-01-05 12:27:04
4349433462017-01-05 12:27:04
4359433472017-01-05 12:27:04
4369433482017-01-05 12:27:04
4379433492017-01-05 12:27:04
4389433502017-01-05 12:27:04
4399433512017-01-05 12:27:04
4409433522017-01-05 12:27:04
4419433532017-01-05 12:27:04
4429433542017-01-05 12:27:04
4439433552017-01-05 12:27:04
4449433562017-01-05 12:27:04
4459433572017-01-05 12:27:04
4469433582017-01-05 12:27:04
4479433592017-01-05 12:27:04
4489433602017-01-05 12:27:04
4499433612017-01-05 12:27:04
4509433622017-01-05 12:27:04
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;