Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 151–175 of 2,015

exhibition_booking, page 7 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
151	24	1434	2015-11-12 08:25:14
152	24	1435	2015-11-12 08:25:14
153	24	1436	2015-11-12 08:25:14
154	26	1451	2015-11-14 12:29:49
155	26	1452	2015-11-14 12:29:49
156	30	1456	2015-11-15 20:46:07
157	25	1461	2015-11-17 19:43:54
158	37	1462	2015-11-20 18:18:35
159	37	1463	2015-11-20 18:18:35
160	37	1464	2015-11-20 18:18:35
161	37	1465	2015-11-20 18:18:35
162	37	1466	2015-11-20 18:18:35
163	37	1467	2015-11-20 18:18:35
164	37	1468	2015-11-20 18:18:35
165	37	1469	2015-11-20 18:18:35
166	37	1470	2015-11-20 18:18:35
167	37	1471	2015-11-20 18:18:35
168	37	1472	2015-11-20 18:18:35
169	37	1473	2015-11-20 18:18:35
170	37	1474	2015-11-20 18:18:35
171	37	1475	2015-11-20 18:18:35
172	37	1476	2015-11-20 18:18:35
173	37	1477	2015-11-20 18:18:35
174	37	1478	2015-11-20 18:18:35
175	37	1479	2015-11-20 18:18:35

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;