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,876–1,900 of 2,015

exhibition_booking, page 76 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
187639095492019-12-15 14:20:55
187739095502019-12-15 14:20:55
187839095512019-12-15 14:20:55
187937495522019-12-15 20:32:00
188037495532019-12-15 20:32:00
188137995562019-12-16 12:52:32
188237995572019-12-16 12:52:32
188338895582019-12-16 23:42:01
188438195592019-12-17 07:56:58
188538495602019-12-17 12:14:46
188638495612019-12-17 12:14:46
188738495622019-12-17 12:14:46
188838495632019-12-17 12:14:46
188938795642019-12-18 07:30:35
189038995672019-12-18 11:11:19
189137795692019-12-18 20:31:02
189237795702019-12-18 20:31:02
189338995712019-12-18 22:18:19
189440495742019-12-19 18:51:34
189540495752019-12-19 18:51:34
189637895782019-12-20 08:17:32
189738395802019-12-22 17:05:00
189839295812019-12-22 17:06:50
189940395882019-12-23 14:34:56
190040395892019-12-23 14:34:56
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;