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 801–825 of 2,015

exhibition_booking, page 33 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
80117751202018-01-07 14:35:08
80217751212018-01-07 14:35:08
80317751222018-01-07 14:35:08
80415651302018-01-11 09:09:07
80515651312018-01-11 09:09:07
80615851462018-01-13 21:17:03
80715851472018-01-13 21:17:03
80815952082018-01-21 08:31:25
80915952092018-01-21 08:31:25
81015952102018-01-21 08:31:25
81115952112018-01-21 08:31:25
81217052922018-02-17 17:05:23
81317052932018-02-17 17:05:23
81416353502018-03-08 11:02:31
81516353512018-03-08 11:02:31
81616054702018-03-26 20:07:38
81716254762018-03-28 12:39:17
81816454842018-03-30 15:23:24
81916454852018-03-30 15:23:24
82016155002018-04-01 07:03:57
82116555062018-04-02 12:16:12
82216555072018-04-02 12:16:12
82316555082018-04-02 12:16:12
82416855222018-04-06 11:16:58
82516755232018-04-06 12:31: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;