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 876–900 of 2,015

exhibition_booking, page 36 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
87619259432018-06-06 07:00:49
87719259442018-06-06 07:00:49
87819259452018-06-06 07:00:49
87920759602018-06-08 13:27:02
88020759612018-06-08 13:27:02
88120759622018-06-08 13:27:02
88220759632018-06-08 13:27:02
88320759642018-06-08 13:27:02
88420759652018-06-08 13:27:02
88520759662018-06-08 13:27:02
88620759672018-06-08 13:27:02
88720759682018-06-08 13:27:02
88820759692018-06-08 13:27:02
88920759702018-06-08 13:27:02
89020759712018-06-08 13:27:02
89120759722018-06-08 13:27:02
89220759732018-06-08 13:27:02
89320759742018-06-08 13:27:02
89420759752018-06-08 13:27:02
89520759762018-06-08 13:27:02
89620759772018-06-08 13:27:02
89720759782018-06-08 13:27:02
89820759792018-06-08 13:27:02
89920759802018-06-08 13:27:02
90020759812018-06-08 13:27:02
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;