Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 276–300 of 2,015

exhibition_booking, page 12 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
276	71	1939	2016-03-12 17:39:58
277	71	1940	2016-03-12 17:39:58
278	71	1941	2016-03-12 17:39:58
279	71	1942	2016-03-12 17:39:58
280	71	1943	2016-03-12 17:39:58
281	71	1944	2016-03-12 17:39:58
282	71	1945	2016-03-12 17:39:58
283	71	1946	2016-03-12 17:39:58
284	71	1947	2016-03-12 17:39:58
285	71	1948	2016-03-12 17:39:58
286	71	1949	2016-03-12 17:39:58
287	42	1950	2016-03-12 19:48:51
288	42	1951	2016-03-12 19:48:51
289	42	1952	2016-03-12 19:48:51
290	42	1953	2016-03-12 19:48:51
291	42	1954	2016-03-12 19:48:51
292	41	1955	2016-03-14 17:45:52
293	41	1956	2016-03-14 17:45:52
294	45	1957	2016-03-15 10:20:10
295	45	1958	2016-03-15 10:20:10
296	48	1965	2016-03-19 12:35:53
297	48	1966	2016-03-19 12:35:53
298	44	1984	2016-03-24 13:28:01
299	44	1985	2016-03-24 13:28:01
300	44	1986	2016-03-24 13:28:01

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;