Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 426–443 of 443

exhibition_slot, page 18 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
426	12	2020-02-05	13:45	45
427	12	2020-02-08	10:30	45
428	12	2020-02-09	10:00	45
429	12	2020-02-09	17:15	45
430	12	2020-02-11	11:30	45
431	12	2020-02-11	15:00	45
432	12	2020-02-15	10:30	45
433	12	2020-02-15	12:45	45
434	12	2020-02-17	12:00	45
435	12	2020-02-17	12:15	45
436	12	2020-02-17	13:15	45
437	12	2020-02-18	12:00	45
438	12	2020-02-18	14:45	45
439	12	2020-02-19	17:15	45
440	12	2020-02-22	11:15	45
441	12	2020-02-23	11:30	45
442	12	2020-02-23	16:15	45
443	12	2020-02-24	13: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;