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 951–975 of 2,015

exhibition_booking, page 39 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
95120361002018-06-28 17:23:50
95220461082018-06-29 16:35:24
95320461092018-06-29 16:35:24
95420061102018-06-29 20:19:21
95520061112018-06-29 20:19:21
95619961122018-06-29 22:07:28
95719961132018-06-29 22:07:28
95821561202018-06-30 13:28:55
95921561212018-06-30 13:28:55
96021561222018-06-30 13:28:55
96121561232018-06-30 13:28:55
96221561242018-06-30 13:28:55
96321561252018-06-30 13:28:55
96421561262018-06-30 13:28:55
96521561272018-06-30 13:28:55
96621561282018-06-30 13:28:55
96721561292018-06-30 13:28:55
96821561302018-06-30 13:28:55
96921561312018-06-30 13:28:55
97021561322018-06-30 13:28:55
97121561332018-06-30 13:28:55
97221561342018-06-30 13:28:55
97321561352018-06-30 13:28:55
97421561362018-06-30 13:28:55
97521561372018-06-30 13:28:55
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;