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 126–150 of 2,015

exhibition_booking, page 6 of 81
booking_idINTEGERslot_id→ exhibition_slot.slot_idticket_id→ ticket.ticket_idbooked_atTEXT
126156682015-06-12 23:26:08
127156692015-06-12 23:26:08
128156702015-06-12 23:26:08
129156712015-06-12 23:26:08
1301710702015-09-05 17:15:36
1311710712015-09-05 17:15:36
1321611262015-09-14 11:21:09
1331611272015-09-14 11:21:09
1341811882015-09-20 20:16:08
1351811892015-09-20 20:16:08
1361913002015-10-11 09:39:03
1371913012015-10-11 09:39:03
1381913022015-10-11 09:39:03
1391913032015-10-11 09:39:03
1402013222015-10-14 22:20:51
1412013232015-10-14 22:20:51
1422113502015-10-23 16:12:04
1432214172015-11-03 09:51:19
1442314212015-11-06 15:12:08
1452314222015-11-06 15:12:08
1462314232015-11-06 15:12:08
1472714292015-11-09 19:08:18
1482714302015-11-09 19:08:18
1492714312015-11-09 19:08:18
1502414332015-11-12 08:25:14
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;