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 826–850 of 2,015

exhibition_booking, page 34 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
82616655402018-04-10 23:18:48
82716655412018-04-10 23:18:48
82816655422018-04-10 23:18:48
82916655432018-04-10 23:18:48
83016955622018-04-14 08:18:03
83116955632018-04-14 08:18:03
83217555692018-04-14 21:57:02
83317155702018-04-15 07:06:32
83417155712018-04-15 07:06:32
83517256362018-04-22 08:53:12
83617256372018-04-22 08:53:12
83717856552018-04-26 14:49:14
83817856562018-04-26 14:49:14
83917356572018-04-26 15:04:29
84017356582018-04-26 15:04:29
84117456632018-04-28 07:57:25
84218056742018-05-01 19:12:28
84318056752018-05-01 19:12:28
84418256782018-05-02 19:38:49
84518256792018-05-02 19:38:49
84618256802018-05-02 19:38:49
84718256812018-05-02 19:38:49
84818256822018-05-02 19:38:49
84917956832018-05-04 07:18:00
85017956842018-05-04 07:18: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;