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,326–1,350 of 2,015

exhibition_booking, page 54 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
132627175652019-01-31 12:13:23
132727175662019-01-31 12:13:23
132827175672019-01-31 12:13:23
132927175682019-01-31 12:13:23
133027175692019-01-31 12:13:23
133127175702019-01-31 12:13:23
133227175712019-01-31 12:13:23
133327175722019-01-31 12:13:23
133427175732019-01-31 12:13:23
133524876402019-02-13 08:42:37
133624876412019-02-13 08:42:37
133724876422019-02-13 08:42:37
133824876432019-02-13 08:42:37
133925576462019-02-16 08:19:57
134025576472019-02-16 08:19:57
134125576482019-02-16 08:19:57
134225576492019-02-16 08:19:57
134325576502019-02-16 08:19:57
134424277162019-02-20 11:25:36
134524277172019-02-20 11:25:36
134623877192019-02-21 23:47:11
134724177362019-02-28 11:33:56
134824177372019-02-28 11:33:56
134924177382019-02-28 11:33:56
135024677392019-02-28 17:19:08
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;