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,701–1,725 of 2,015

exhibition_booking, page 69 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
170137592412019-10-19 17:07:10
170237592422019-10-19 17:07:10
170337592432019-10-19 17:07:10
170437592442019-10-19 17:07:10
170537592452019-10-19 17:07:10
170637592462019-10-19 17:07:10
170737592472019-10-19 17:07:10
170837592482019-10-19 17:07:10
170937592492019-10-19 17:07:10
171037592502019-10-19 17:07:10
171137592512019-10-19 17:07:10
171237592522019-10-19 17:07:10
171337592532019-10-19 17:07:10
171437592542019-10-19 17:07:10
171537592552019-10-19 17:07:10
171637592562019-10-19 17:07:10
171737592572019-10-19 17:07:10
171837592582019-10-19 17:07:10
171937592592019-10-19 17:07:10
172037592602019-10-19 17:07:10
172137592612019-10-19 17:07:10
172237592622019-10-19 17:07:10
172337592632019-10-19 17:07:10
172437592642019-10-19 17:07:10
172537592652019-10-19 17:07:10
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;