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 401–425 of 2,015

exhibition_booking, page 17 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
4019632742016-12-24 10:38:09
4029632752016-12-24 10:38:09
4039632762016-12-24 10:38:09
4049632772016-12-24 10:38:09
4059632782016-12-24 10:38:09
4069632792016-12-24 10:38:09
4079632802016-12-24 10:38:09
4089632812016-12-24 10:38:09
4099632822016-12-24 10:38:09
4109632832016-12-24 10:38:09
4119632842016-12-24 10:38:09
4129632852016-12-24 10:38:09
4139632862016-12-24 10:38:09
4149632872016-12-24 10:38:09
4159732882016-12-24 10:38:09
4169732892016-12-24 10:38:09
4179732902016-12-24 10:38:09
4189732912016-12-24 10:38:09
4199732922016-12-24 10:38:09
4209732932016-12-24 10:38:09
4219732942016-12-24 10:38:09
4229732952016-12-24 10:38:09
4239732962016-12-24 10:38:09
4249732972016-12-24 10:38:09
4259732982016-12-24 10:38:09
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;