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,376–1,400 of 2,015

exhibition_booking, page 56 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
137626078302019-03-19 08:52:54
137726078312019-03-19 08:52:54
137826078322019-03-19 08:52:54
137926078332019-03-19 08:52:54
138026078342019-03-19 08:52:54
138126078352019-03-19 08:52:54
138226078362019-03-19 08:52:54
138326078372019-03-19 08:52:54
138426078382019-03-19 08:52:54
138526078392019-03-19 08:52:54
138626078402019-03-19 08:52:54
138726078412019-03-19 08:52:54
138826078422019-03-19 08:52:54
138926078432019-03-19 08:52:54
139026078442019-03-19 08:52:54
139126078452019-03-19 08:52:54
139226078462019-03-19 08:52:54
139326078472019-03-19 08:52:54
139426078482019-03-19 08:52:54
139526078492019-03-19 08:52:54
139626078502019-03-19 08:52:54
139726078512019-03-19 08:52:54
139826078522019-03-19 08:52:54
139926078532019-03-19 08:52:54
140026078542019-03-19 08:52:54
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;