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,826–1,850 of 2,015

exhibition_booking, page 74 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
182634594552019-11-22 07:38:28
182734594562019-11-22 07:38:28
182834594572019-11-22 07:38:28
182934594582019-11-22 07:38:28
183034694632019-11-23 09:13:25
183134694642019-11-23 09:13:25
183235794682019-11-23 18:24:25
183335794692019-11-23 18:24:25
183435394702019-11-24 23:59:22
183535394712019-11-24 23:59:22
183635394722019-11-24 23:59:22
183735394732019-11-24 23:59:22
183836194742019-11-25 12:53:04
183936194752019-11-25 12:53:04
184036394762019-11-25 19:03:55
184136394772019-11-25 19:03:55
184238294882019-11-30 17:09:11
184338294892019-11-30 17:09:11
184438294902019-11-30 17:09:11
184535494932019-12-01 09:36:44
184635694972019-12-03 12:37:07
184735694982019-12-03 12:37:07
184835694992019-12-03 12:37:07
184935695002019-12-03 12:37:07
185037295062019-12-04 19:04:15
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;