Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 401–425 of 443

exhibition_slot, page 17 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
401	12	2020-01-08	11:30	45
402	12	2020-01-09	11:30	45
403	12	2020-01-09	12:45	45
404	12	2020-01-09	15:00	45
405	12	2020-01-09	16:30	45
406	12	2020-01-12	16:45	45
407	12	2020-01-13	10:30	45
408	12	2020-01-14	11:00	45
409	12	2020-01-14	12:45	45
410	12	2020-01-16	11:30	45
411	12	2020-01-17	16:00	45
412	12	2020-01-18	09:30	45
413	12	2020-01-18	16:00	45
414	12	2020-01-20	13:15	45
415	12	2020-01-20	16:30	45
416	12	2020-01-22	11:00	45
417	12	2020-01-22	11:15	45
418	12	2020-01-22	13:30	45
419	12	2020-01-22	14:45	45
420	12	2020-01-22	15:30	45
421	12	2020-01-23	13:45	45
422	12	2020-01-25	15:15	45
423	12	2020-01-31	13:30	45
424	12	2020-02-02	14:30	45
425	12	2020-02-04	15:30	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;