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,851–1,875 of 2,015

exhibition_booking, page 75 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
185137295072019-12-04 19:04:15
185238095082019-12-05 13:48:37
185338095092019-12-05 13:48:37
185435895122019-12-05 16:51:46
185535895132019-12-05 16:51:46
185635895142019-12-05 16:51:46
185736095152019-12-06 13:40:36
185836095162019-12-06 13:40:36
185936995172019-12-06 21:51:34
186036995182019-12-06 21:51:34
186135995212019-12-07 11:29:50
186235995222019-12-07 11:29:50
186335995232019-12-07 11:29:50
186439195242019-12-07 23:45:20
186539195252019-12-07 23:45:20
186636495282019-12-09 22:46:12
186736495292019-12-09 22:46:12
186836295302019-12-10 10:29:12
186936295312019-12-10 10:29:12
187036595372019-12-13 17:24:19
187136595382019-12-13 17:24:19
187237395392019-12-13 20:45:54
187336695412019-12-14 12:03:23
187437195472019-12-15 08:13:01
187537195482019-12-15 08:13:01
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;