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,426–1,450 of 2,015

exhibition_booking, page 58 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
142625679872019-04-04 22:09:44
142727480462019-04-12 07:49:15
142827480472019-04-12 07:49:15
142925980512019-04-12 15:04:10
143025980522019-04-12 15:04:10
143125980532019-04-12 15:04:10
143225980542019-04-12 15:04:10
143325980552019-04-12 15:04:10
143426380562019-04-12 20:39:20
143526280822019-04-15 15:37:54
143626481072019-04-22 07:06:51
143726481082019-04-22 07:06:51
143826781152019-04-22 21:12:27
143926781162019-04-22 21:12:27
144026581312019-04-24 11:40:18
144126581322019-04-24 11:40:18
144226881432019-04-29 13:26:51
144326681502019-04-30 09:13:01
144426681512019-04-30 09:13:01
144526681522019-04-30 09:13:01
144627581632019-05-02 18:03:49
144727081962019-05-08 18:44:35
144827081972019-05-08 18:44:35
144926982082019-05-12 10:17:13
145026982092019-05-12 10:17:13
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;