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 551–575 of 2,015

exhibition_booking, page 23 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
55112238842017-05-03 19:29:18
55212538922017-05-06 17:07:37
55312538932017-05-06 17:07:37
55412538942017-05-06 17:07:37
55512739152017-05-10 12:44:44
55612739162017-05-10 12:44:44
55712939202017-05-11 11:40:01
55812939212017-05-11 11:40:01
55912639312017-05-12 09:57:03
56012639322017-05-12 09:57:03
56112639332017-05-12 09:57:03
56212639342017-05-12 09:57:03
56312839422017-05-15 12:36:18
56413844222017-08-20 12:49:00
56513844232017-08-20 12:49:00
56613844242017-08-20 12:49:00
56713844252017-08-20 12:49:00
56813844262017-08-20 12:49:00
56913844272017-08-20 12:49:00
57013844282017-08-20 12:49:00
57113844292017-08-20 12:49:00
57213844302017-08-20 12:49:00
57313844312017-08-20 12:49:00
57413844322017-08-20 12:49:00
57513844332017-08-20 12:49:00
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;