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,626–1,650 of 2,015

exhibition_booking, page 66 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
162636789942019-09-11 10:27:08
162736789952019-09-11 10:27:08
162836789962019-09-11 10:27:08
162936789972019-09-11 10:27:08
163036789982019-09-11 10:27:08
163136789992019-09-11 10:27:08
163236790002019-09-11 10:27:08
163336790012019-09-11 10:27:08
163436790022019-09-11 10:27:08
163536790032019-09-11 10:27:08
163636890042019-09-11 10:27:08
163736890052019-09-11 10:27:08
163836890062019-09-11 10:27:08
163936890072019-09-11 10:27:08
164036890082019-09-11 10:27:08
164131891092019-09-24 15:58:47
164231891102019-09-24 15:58:47
164331891112019-09-24 15:58:47
164431891122019-09-24 15:58:47
164530491522019-10-08 12:52:42
164630491532019-10-08 12:52:42
164730791632019-10-10 14:41:03
164830391702019-10-12 14:21:47
164931091732019-10-13 15:27:15
165033991802019-10-16 10:30:59
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;