Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 226–250 of 443

exhibition_slot, page 10 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
226	9	2018-11-28	15:00	45
227	9	2018-11-30	10:15	45
228	9	2018-11-30	13:45	45
229	9	2018-12-01	10:45	45
230	9	2018-12-01	12:45	45
231	9	2018-12-04	15:15	45
232	9	2018-12-04	15:30	45
233	9	2018-12-09	11:45	45
234	9	2018-12-09	13:15	45
235	9	2018-12-11	11:15	45
236	9	2018-12-27	16:45	45
237	9	2019-01-12	12:45	45
238	10	2019-02-25	17:00	45
239	10	2019-02-27	14:15	45
240	10	2019-02-27	14:30	45
241	10	2019-03-01	12:15	45
242	10	2019-03-03	13:15	45
243	10	2019-03-05	10:30	45
244	10	2019-03-06	10:30	45
245	10	2019-03-07	09:45	45
246	10	2019-03-12	11:30	45
247	10	2019-03-12	12:45	45
248	10	2019-03-13	11:00	45
249	10	2019-03-15	13:45	45
250	10	2019-03-15	14:00	45

Table definition

CREATE TABLE exhibition_slot (
  slot_id       INTEGER PRIMARY KEY,
  exhibition_id INTEGER NOT NULL REFERENCES exhibition (exhibition_id),
  slot_date     TEXT NOT NULL,
  start_time    TEXT NOT NULL CHECK (start_time GLOB '[0-2][0-9]:[0-5][0-9]' AND substr(start_time, 4, 2) IN ('00', '15', '30', '45')),
  capacity      INTEGER NOT NULL CHECK (capacity > 0),
  UNIQUE (exhibition_id, slot_date, start_time)
) STRICT;