Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 201–225 of 2,015

exhibition_booking, page 9 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
201	29	1590	2015-12-15 20:37:52
202	33	1651	2015-12-28 13:52:56
203	32	1674	2016-01-05 09:31:03
204	32	1675	2016-01-05 09:31:03
205	32	1676	2016-01-05 09:31:03
206	32	1677	2016-01-05 09:31:03
207	35	1744	2016-01-18 11:50:54
208	35	1745	2016-01-18 11:50:54
209	35	1746	2016-01-18 11:50:54
210	35	1747	2016-01-18 11:50:54
211	35	1748	2016-01-18 11:50:54
212	34	1773	2016-02-01 23:12:30
213	34	1774	2016-02-01 23:12:30
214	38	1823	2016-02-19 13:40:39
215	38	1824	2016-02-19 13:40:39
216	36	1840	2016-02-28 08:19:45
217	36	1841	2016-02-28 08:19:45
218	36	1842	2016-02-28 08:19:45
219	36	1843	2016-02-28 08:19:45
220	43	1844	2016-03-02 07:16:48
221	43	1845	2016-03-02 07:16:48
222	39	1854	2016-03-03 10:00:33
223	39	1855	2016-03-03 10:00:33
224	40	1873	2016-03-07 13:20:35
225	40	1874	2016-03-07 13:20: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;