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 451–475 of 2,015

exhibition_booking, page 19 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
4519433632017-01-05 12:27:04
4529433642017-01-05 12:27:04
4539433652017-01-05 12:27:04
4549433662017-01-05 12:27:04
4559433672017-01-05 12:27:04
4569433682017-01-05 12:27:04
4579433692017-01-05 12:27:04
4589433702017-01-05 12:27:04
4599433712017-01-05 12:27:04
4609433722017-01-05 12:27:04
4619433732017-01-05 12:27:04
4629433742017-01-05 12:27:04
4639433752017-01-05 12:27:04
4649433762017-01-05 12:27:04
4659533772017-01-05 12:27:04
4669533782017-01-05 12:27:04
4679533792017-01-05 12:27:04
4689533802017-01-05 12:27:04
4699533812017-01-05 12:27:04
4708333822017-01-06 10:13:39
4718333832017-01-06 10:13:39
4728333842017-01-06 10:13:39
4738635352017-02-16 16:36:03
4748535472017-02-20 13:29:06
4758535482017-02-20 13:29:06
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;