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 526–550 of 2,015

exhibition_booking, page 22 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
52612037782017-04-17 12:59:43
52711437792017-04-18 07:08:35
52811437802017-04-18 07:08:35
52911437812017-04-18 07:08:35
53011437822017-04-18 07:08:35
53111638312017-04-22 14:02:40
53211638322017-04-22 14:02:40
53311838332017-04-22 17:43:59
53411838342017-04-22 17:43:59
53511938492017-04-24 18:25:41
53612138542017-04-28 17:25:02
53713138552017-04-28 22:24:41
53812438562017-04-28 22:40:48
53912438572017-04-28 22:40:48
54012438582017-04-28 22:40:48
54112438592017-04-28 22:40:48
54212438602017-04-28 22:40:48
54313038672017-04-30 12:38:04
54413038682017-04-30 12:38:04
54513038692017-04-30 12:38:04
54612338722017-04-30 20:50:23
54712238802017-05-03 19:29:18
54812238812017-05-03 19:29:18
54912238822017-05-03 19:29:18
55012238832017-05-03 19:29:18
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;