Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 226–250 of 2,015

exhibition_booking, page 10 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
226	40	1875	2016-03-07 13:20:35
227	40	1876	2016-03-07 13:20:35
228	40	1877	2016-03-07 13:20:35
229	70	1892	2016-03-12 17:39:58
230	70	1893	2016-03-12 17:39:58
231	70	1894	2016-03-12 17:39:58
232	70	1895	2016-03-12 17:39:58
233	70	1896	2016-03-12 17:39:58
234	70	1897	2016-03-12 17:39:58
235	70	1898	2016-03-12 17:39:58
236	70	1899	2016-03-12 17:39:58
237	70	1900	2016-03-12 17:39:58
238	70	1901	2016-03-12 17:39:58
239	70	1902	2016-03-12 17:39:58
240	70	1903	2016-03-12 17:39:58
241	70	1904	2016-03-12 17:39:58
242	70	1905	2016-03-12 17:39:58
243	70	1906	2016-03-12 17:39:58
244	70	1907	2016-03-12 17:39:58
245	70	1908	2016-03-12 17:39:58
246	70	1909	2016-03-12 17:39:58
247	70	1910	2016-03-12 17:39:58
248	70	1911	2016-03-12 17:39:58
249	70	1912	2016-03-12 17:39:58
250	70	1913	2016-03-12 17:39:58

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;