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

exhibition_booking, page 78 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
192639896392020-01-03 21:03:13
192739796402020-01-04 10:20:47
192841896442020-01-06 21:38:55
192941896452020-01-06 21:38:55
193040596482020-01-07 18:42:18
193140596492020-01-07 18:42:18
193240696502020-01-07 20:00:41
193340696512020-01-07 20:00:41
193441096532020-01-08 16:44:30
193540296542020-01-08 23:21:14
193640296552020-01-08 23:21:14
193740896592020-01-10 17:43:21
193840896602020-01-10 17:43:21
193940896612020-01-10 17:43:21
194042196642020-01-11 11:27:00
194142196652020-01-11 11:27:00
194240796662020-01-12 14:40:29
194340796672020-01-12 14:40:29
194440796682020-01-12 14:40:29
194541196692020-01-13 12:33:27
194641196702020-01-13 12:33:27
194741196712020-01-13 12:33:27
194841196722020-01-13 12:33:27
194940996732020-01-14 07:48:35
195040996742020-01-14 07:48:35
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;