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 501–525 of 2,015

exhibition_booking, page 21 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
5019936162017-03-12 19:46:51
5029936172017-03-12 19:46:51
50310236242017-03-16 12:07:44
50410236252017-03-16 12:07:44
50510636892017-03-23 13:32:39
50610436912017-03-24 20:00:27
50710736932017-03-25 20:07:30
50810536942017-03-26 21:21:31
50911737142017-04-01 18:38:59
51011737152017-04-01 18:38:59
51111737162017-04-01 18:38:59
51211737172017-04-01 18:38:59
51310837332017-04-09 20:08:01
51410837342017-04-09 20:08:01
51511337372017-04-10 19:48:29
51611337382017-04-10 19:48:29
51711337392017-04-10 19:48:29
51811337402017-04-10 19:48:29
51911537472017-04-11 15:07:57
52010937572017-04-12 10:09:24
52111237592017-04-12 20:07:09
52211237602017-04-12 20:07:09
52311137612017-04-13 19:01:26
52411037662017-04-14 12:27:47
52512037772017-04-17 12:59:43
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;