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,176–1,200 of 2,015

exhibition_booking, page 48 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
117624071322018-11-21 11:56:32
117724071332018-11-21 11:56:32
117824071342018-11-21 11:56:32
117924071352018-11-21 11:56:32
118024071362018-11-21 11:56:32
118124071372018-11-21 11:56:32
118224071382018-11-21 11:56:32
118324071392018-11-21 11:56:32
118424071402018-11-21 11:56:32
118524071412018-11-21 11:56:32
118624071422018-11-21 11:56:32
118724071432018-11-21 11:56:32
118824071442018-11-21 11:56:32
118922671672018-11-22 22:50:39
119022671682018-11-22 22:50:39
119122871782018-11-24 07:39:35
119222871792018-11-24 07:39:35
119323071962018-11-26 13:01:17
119423071972018-11-26 13:01:17
119522572032018-11-27 17:45:33
119622772082018-11-29 17:05:41
119722772092018-11-29 17:05:41
119823572242018-12-03 22:40:07
119923372252018-12-04 19:57:50
120023772542018-12-11 18:37:16
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;