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,576–1,600 of 2,015

exhibition_booking, page 64 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
157632089342019-09-07 10:32:28
157732089352019-09-07 10:32:28
157832089362019-09-07 10:32:28
157932089372019-09-07 10:32:28
158032089382019-09-07 10:32:28
158132089392019-09-07 10:32:28
158232089402019-09-07 10:32:28
158332089412019-09-07 10:32:28
158432089422019-09-07 10:32:28
158532089432019-09-07 10:32:28
158632089442019-09-07 10:32:28
158732089452019-09-07 10:32:28
158832189462019-09-07 10:32:28
158932189472019-09-07 10:32:28
159030289492019-09-07 21:10:17
159136789592019-09-11 10:27:08
159236789602019-09-11 10:27:08
159336789612019-09-11 10:27:08
159436789622019-09-11 10:27:08
159536789632019-09-11 10:27:08
159636789642019-09-11 10:27:08
159736789652019-09-11 10:27:08
159836789662019-09-11 10:27:08
159936789672019-09-11 10:27:08
160036789682019-09-11 10:27:08
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;