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 351–375 of 2,015

exhibition_booking, page 15 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
3516824122016-06-25 17:37:38
3526824132016-06-25 17:37:38
3536824142016-06-25 17:37:38
3547324502016-07-05 13:07:54
3557426852016-08-22 19:47:17
3567426862016-08-22 19:47:17
3577426872016-08-22 19:47:17
3587426882016-08-22 19:47:17
3597426892016-08-22 19:47:17
3607628162016-09-17 20:44:28
3617628172016-09-17 20:44:28
3627528562016-09-29 13:29:02
3637528572016-09-29 13:29:02
3647728932016-10-10 22:07:36
3657728942016-10-10 22:07:36
3667728952016-10-10 22:07:36
3677728962016-10-10 22:07:36
3687829172016-10-16 23:50:35
3697829182016-10-16 23:50:35
3708029462016-11-01 22:24:57
3718029472016-11-01 22:24:57
3728029482016-11-01 22:24:57
3738029492016-11-01 22:24:57
3747930122016-11-11 11:26:04
3758230152016-11-11 15:18:48
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;