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 926–950 of 2,015

exhibition_booking, page 38 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
92620860072018-06-08 13:27:02
92720860082018-06-08 13:27:02
92820860092018-06-08 13:27:02
92920860102018-06-08 13:27:02
93020860112018-06-08 13:27:02
93120860122018-06-08 13:27:02
93220860132018-06-08 13:27:02
93320860142018-06-08 13:27:02
93419360152018-06-10 07:07:55
93519760182018-06-10 10:59:34
93619760192018-06-10 10:59:34
93719760202018-06-10 10:59:34
93819460222018-06-10 14:46:17
93919560372018-06-13 08:46:10
94019560382018-06-13 08:46:10
94119560392018-06-13 08:46:10
94219560402018-06-13 08:46:10
94319560412018-06-13 08:46:10
94419860452018-06-14 17:30:09
94520260502018-06-15 18:00:59
94620260512018-06-15 18:00:59
94719660562018-06-17 11:15:40
94819660572018-06-17 11:15:40
94919660582018-06-17 11:15:40
95019660592018-06-17 11:15:40
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;