Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 251–275 of 443

exhibition_slot, page 11 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
251	10	2019-03-15	17:15	45
252	10	2019-03-18	11:15	45
253	10	2019-03-22	16:30	45
254	10	2019-04-02	11:30	45
255	10	2019-04-05	12:45	45
256	10	2019-04-06	10:30	45
257	10	2019-04-07	13:15	45
258	10	2019-04-13	11:15	45
259	10	2019-04-15	12:00	45
260	10	2019-04-15	12:45	45
261	10	2019-04-15	13:00	45
262	10	2019-04-19	16:00	45
263	10	2019-04-21	13:30	45
264	10	2019-04-22	11:00	45
265	10	2019-04-28	10:45	45
266	10	2019-05-03	11:30	45
267	10	2019-05-03	16:30	45
268	10	2019-05-05	14:30	45
269	10	2019-05-14	13:00	45
270	10	2019-05-17	09:45	45
271	10	2019-05-17	12:00	45
272	10	2019-05-21	12:00	45
273	10	2019-05-22	10:00	45
274	10	2019-05-24	14:00	45
275	10	2019-05-24	17:15	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;