Table

exhibition_booking

A ticket's place in a slot; a trigger stops overbooking.

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 1,651–1,675 of 2,015

exhibition_booking, page 67 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
1651	339	9181	2019-10-16 10:30:59
1652	308	9182	2019-10-16 11:09:45
1653	308	9183	2019-10-16 11:09:45
1654	329	9184	2019-10-17 12:29:12
1655	329	9185	2019-10-17 12:29:12
1656	329	9186	2019-10-17 12:29:12
1657	329	9187	2019-10-17 12:29:12
1658	329	9188	2019-10-17 12:29:12
1659	329	9189	2019-10-17 12:29:12
1660	329	9190	2019-10-17 12:29:12
1661	329	9191	2019-10-17 12:29:12
1662	329	9192	2019-10-17 12:29:12
1663	329	9193	2019-10-17 12:29:12
1664	329	9194	2019-10-17 12:29:12
1665	329	9195	2019-10-17 12:29:12
1666	329	9196	2019-10-17 12:29:12
1667	329	9197	2019-10-17 12:29:12
1668	329	9198	2019-10-17 12:29:12
1669	329	9199	2019-10-17 12:29:12
1670	329	9200	2019-10-17 12:29:12
1671	329	9201	2019-10-17 12:29:12
1672	329	9202	2019-10-17 12:29:12
1673	329	9203	2019-10-17 12:29:12
1674	329	9204	2019-10-17 12:29:12
1675	329	9205	2019-10-17 12:29:12

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;