Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 76–100 of 443

exhibition_slot, page 4 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
76	5	2016-10-12	13:15	45
77	5	2016-10-18	15:00	45
78	5	2016-10-26	17:15	45
79	5	2016-11-24	16:00	45
80	5	2016-11-26	12:45	45
81	5	2016-12-15	09:45	45
82	5	2016-12-28	15:30	45
83	5	2017-01-06	11:15	45
84	5	2017-01-07	09:45	45
85	6	2017-02-22	16:00	35
86	6	2017-02-23	17:15	35
87	6	2017-02-26	12:00	35
88	6	2017-02-27	15:45	35
89	6	2017-02-28	12:15	35
90	6	2017-03-06	11:30	35
91	6	2017-03-10	13:45	35
92	6	2017-03-11	12:45	35
93	6	2017-03-12	12:45	35
94	6	2017-03-14	12:15	35
95	6	2017-03-14	12:30	35
96	6	2017-03-15	12:00	35
97	6	2017-03-15	12:15	35
98	6	2017-03-15	16:00	35
99	6	2017-03-16	15:00	35
100	6	2017-03-18	13:15	35

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;