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,976–2,000 of 2,015

exhibition_booking, page 80 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
197644197342020-01-25 14:38:50
197744197352020-01-25 14:38:50
197842397412020-01-27 23:30:11
197942597512020-01-31 14:23:01
198042497612020-02-02 08:08:02
198142497622020-02-02 08:08:02
198242697692020-02-04 22:38:16
198342697702020-02-04 22:38:16
198442697712020-02-04 22:38:16
198542697722020-02-04 22:38:16
198643297732020-02-05 13:23:38
198742897772020-02-06 09:51:49
198842897782020-02-06 09:51:49
198942797812020-02-08 08:00:50
199043097842020-02-08 15:36:01
199143097852020-02-08 15:36:01
199242997872020-02-09 08:39:28
199343197902020-02-09 14:33:41
199443197912020-02-09 14:33:41
199543397922020-02-10 08:29:10
199643397932020-02-10 08:29:10
199743397942020-02-10 08:29:10
199843598022020-02-13 16:48:23
199943598032020-02-13 16:48:23
200043798052020-02-15 14:36:36
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;