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,801–1,825 of 2,015

exhibition_booking, page 73 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
180133293842019-11-10 22:36:40
180234493972019-11-12 20:03:03
180334493982019-11-12 20:03:03
180434094032019-11-13 17:41:45
180533894082019-11-14 19:27:00
180633894092019-11-14 19:27:00
180734394102019-11-15 10:27:16
180834394112019-11-15 10:27:16
180935594122019-11-15 11:20:59
181038694172019-11-16 18:54:33
181138694182019-11-16 18:54:33
181234194212019-11-17 19:21:49
181334194222019-11-17 19:21:49
181435294282019-11-20 09:22:43
181535294292019-11-20 09:22:43
181634794342019-11-20 12:27:42
181734894352019-11-20 19:17:57
181834894362019-11-20 19:17:57
181937094482019-11-21 22:05:03
182034994492019-11-21 22:26:40
182134994502019-11-21 22:26:40
182234994512019-11-21 22:26:40
182334994522019-11-21 22:26:40
182434994532019-11-21 22:26:40
182534594542019-11-22 07:38:28
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;