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 726–750 of 2,015

exhibition_booking, page 30 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
72614449122017-12-01 23:58:30
72714449132017-12-01 23:58:30
72814849142017-12-02 10:14:46
72914849152017-12-02 10:14:46
73014649192017-12-05 16:31:18
73114649202017-12-05 16:31:18
73215049352017-12-12 10:02:20
73314949402017-12-13 19:42:48
73414949412017-12-13 19:42:48
73515249422017-12-14 08:42:31
73615249432017-12-14 08:42:31
73715149522017-12-18 07:06:55
73815149532017-12-18 07:06:55
73915149542017-12-18 07:06:55
74015149552017-12-18 07:06:55
74115449792017-12-23 09:34:21
74215449802017-12-23 09:34:21
74315349862017-12-23 15:07:24
74415349872017-12-23 15:07:24
74515550402018-01-01 13:36:53
74615550412018-01-01 13:36:53
74715750602018-01-06 16:10:02
74817650672018-01-07 14:35:08
74917650682018-01-07 14:35:08
75017650692018-01-07 14:35: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;