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,126–1,150 of 2,015

exhibition_booking, page 46 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
112622470442018-11-12 10:11:40
112722470452018-11-12 10:11:40
112822470462018-11-12 10:11:40
112923970852018-11-21 11:56:32
113023970862018-11-21 11:56:32
113123970872018-11-21 11:56:32
113223970882018-11-21 11:56:32
113323970892018-11-21 11:56:32
113423970902018-11-21 11:56:32
113523970912018-11-21 11:56:32
113623970922018-11-21 11:56:32
113723970932018-11-21 11:56:32
113823970942018-11-21 11:56:32
113923970952018-11-21 11:56:32
114023970962018-11-21 11:56:32
114123970972018-11-21 11:56:32
114223970982018-11-21 11:56:32
114323970992018-11-21 11:56:32
114423971002018-11-21 11:56:32
114523971012018-11-21 11:56:32
114623971022018-11-21 11:56:32
114723971032018-11-21 11:56:32
114823971042018-11-21 11:56:32
114923971052018-11-21 11:56:32
115023971062018-11-21 11:56:32
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;