Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 176–200 of 2,015

exhibition_booking, page 8 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
176	37	1480	2015-11-20 18:18:35
177	37	1481	2015-11-20 18:18:35
178	37	1482	2015-11-20 18:18:35
179	37	1483	2015-11-20 18:18:35
180	37	1484	2015-11-20 18:18:35
181	37	1485	2015-11-20 18:18:35
182	37	1486	2015-11-20 18:18:35
183	37	1487	2015-11-20 18:18:35
184	37	1488	2015-11-20 18:18:35
185	37	1489	2015-11-20 18:18:35
186	37	1490	2015-11-20 18:18:35
187	37	1491	2015-11-20 18:18:35
188	37	1492	2015-11-20 18:18:35
189	37	1493	2015-11-20 18:18:35
190	37	1494	2015-11-20 18:18:35
191	37	1495	2015-11-20 18:18:35
192	37	1496	2015-11-20 18:18:35
193	37	1497	2015-11-20 18:18:35
194	37	1498	2015-11-20 18:18:35
195	37	1499	2015-11-20 18:18:35
196	37	1500	2015-11-20 18:18:35
197	37	1501	2015-11-20 18:18:35
198	31	1525	2015-11-27 20:32:27
199	31	1526	2015-11-27 20:32:27
200	28	1574	2015-12-09 11:45:08

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;