Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 376–400 of 443

exhibition_slot, page 16 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
376	12	2019-12-20	15:30	45
377	12	2019-12-20	16:00	45
378	12	2019-12-21	10:30	45
379	12	2019-12-21	11:45	45
380	12	2019-12-21	12:30	45
381	12	2019-12-21	16:45	45
382	12	2019-12-22	12:30	45
383	12	2019-12-24	10:00	45
384	12	2019-12-24	16:15	45
385	12	2019-12-25	17:15	45
386	12	2019-12-26	13:00	45
387	12	2019-12-28	12:30	45
388	12	2019-12-28	13:45	45
389	12	2019-12-28	17:15	45
390	12	2019-12-29	14:15	45
391	12	2019-12-30	10:30	45
392	12	2019-12-30	12:30	45
393	12	2020-01-01	11:30	45
394	12	2020-01-02	16:00	45
395	12	2020-01-04	11:00	45
396	12	2020-01-04	11:45	45
397	12	2020-01-05	16:45	45
398	12	2020-01-06	13:15	45
399	12	2020-01-06	16:45	45
400	12	2020-01-07	11: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;