Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 201–225 of 443

exhibition_slot, page 9 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
201	8	2018-07-07	10:45	45
202	8	2018-07-08	12:30	45
203	8	2018-07-10	11:45	45
204	8	2018-07-11	13:00	45
205	8	2018-07-12	11:15	45
206	8	2018-07-15	14:00	45
207	8	2018-07-17	11:30	45
208	8	2018-07-17	11:45	45
209	8	2018-07-17	14:30	45
210	8	2018-07-19	10:15	45
211	8	2018-07-21	12:30	45
212	8	2018-07-22	13:30	45
213	9	2018-10-20	11:00	45
214	9	2018-10-20	13:30	45
215	9	2018-10-25	11:15	45
216	9	2018-10-25	11:30	45
217	9	2018-10-27	16:00	45
218	9	2018-10-27	17:15	45
219	9	2018-10-29	12:00	45
220	9	2018-11-03	09:30	45
221	9	2018-11-11	11:30	45
222	9	2018-11-11	14:15	45
223	9	2018-11-12	11:30	45
224	9	2018-11-16	16:45	45
225	9	2018-11-28	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;