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,501–1,525 of 2,015

exhibition_booking, page 61 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
150129184822019-07-05 11:14:26
150229184832019-07-05 11:14:26
150329184842019-07-05 11:14:26
150429184852019-07-05 11:14:26
150529184862019-07-05 11:14:26
150629184872019-07-05 11:14:26
150729184882019-07-05 11:14:26
150829184892019-07-05 11:14:26
150929184902019-07-05 11:14:26
151029184912019-07-05 11:14:26
151129184922019-07-05 11:14:26
151229184932019-07-05 11:14:26
151328485102019-07-09 08:05:02
151428485112019-07-09 08:05:02
151528685172019-07-09 23:47:17
151629285232019-07-10 19:26:46
151729285242019-07-10 19:26:46
151829285252019-07-10 19:26:46
151929285262019-07-10 19:26:46
152028985502019-07-13 10:24:10
152128985512019-07-13 10:24:10
152229085972019-07-23 11:26:47
152329385982019-07-23 20:00:09
152429486412019-07-26 19:35:23
152529486422019-07-26 19:35:23
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;