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,776–1,800 of 2,015

exhibition_booking, page 72 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
177634293432019-11-02 21:21:45
177734293442019-11-02 21:21:45
177832493462019-11-03 18:50:22
177932493472019-11-03 18:50:22
178032793482019-11-03 19:11:05
178132793492019-11-03 19:11:05
178232393572019-11-04 22:46:36
178332393582019-11-04 22:46:36
178433093592019-11-05 10:03:15
178533093602019-11-05 10:03:15
178633093612019-11-05 10:03:15
178733493622019-11-05 17:52:48
178833793632019-11-05 22:33:26
178933793642019-11-05 22:33:26
179033793652019-11-05 22:33:26
179132593702019-11-07 10:25:58
179232693712019-11-07 19:26:54
179332693722019-11-07 19:26:54
179435193752019-11-08 11:00:14
179535193762019-11-08 11:00:14
179633693792019-11-08 12:39:22
179733693802019-11-08 12:39:22
179835093812019-11-08 17:48:42
179933593822019-11-09 17:24:44
180033193832019-11-10 10:12:16
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;