Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 301–325 of 443

exhibition_slot, page 13 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
301	11	2019-09-11	15:45	40
302	11	2019-09-12	11:30	40
303	12	2019-10-24	15:00	45
304	12	2019-10-24	15:15	45
305	12	2019-10-25	10:30	45
306	12	2019-10-25	15:45	45
307	12	2019-10-25	16:45	45
308	12	2019-10-26	12:15	45
309	12	2019-10-26	15:30	45
310	12	2019-10-28	13:15	45
311	12	2019-10-29	11:15	45
312	12	2019-10-29	11:30	45
313	12	2019-10-29	12:30	45
314	12	2019-10-29	14:15	45
315	12	2019-10-29	15:15	45
316	12	2019-11-01	11:45	45
317	12	2019-11-02	11:00	45
318	12	2019-11-03	12:00	45
319	12	2019-11-03	16:00	45
320	12	2019-11-05	11:00	45
321	12	2019-11-05	11:15	45
322	12	2019-11-06	10:15	45
323	12	2019-11-07	11:15	45
324	12	2019-11-07	13:45	45
325	12	2019-11-07	15:45	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;