Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 251–275 of 2,015

exhibition_booking, page 11 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
251	70	1914	2016-03-12 17:39:58
252	70	1915	2016-03-12 17:39:58
253	70	1916	2016-03-12 17:39:58
254	70	1917	2016-03-12 17:39:58
255	70	1918	2016-03-12 17:39:58
256	70	1919	2016-03-12 17:39:58
257	70	1920	2016-03-12 17:39:58
258	70	1921	2016-03-12 17:39:58
259	71	1922	2016-03-12 17:39:58
260	71	1923	2016-03-12 17:39:58
261	71	1924	2016-03-12 17:39:58
262	71	1925	2016-03-12 17:39:58
263	71	1926	2016-03-12 17:39:58
264	71	1927	2016-03-12 17:39:58
265	71	1928	2016-03-12 17:39:58
266	71	1929	2016-03-12 17:39:58
267	71	1930	2016-03-12 17:39:58
268	71	1931	2016-03-12 17:39:58
269	71	1932	2016-03-12 17:39:58
270	71	1933	2016-03-12 17:39:58
271	71	1934	2016-03-12 17:39:58
272	71	1935	2016-03-12 17:39:58
273	71	1936	2016-03-12 17:39:58
274	71	1937	2016-03-12 17:39:58
275	71	1938	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;