Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 26–50 of 443

exhibition_slot, page 2 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
26	2	2015-11-20	13:15	40
27	2	2015-11-21	15:00	40
28	2	2015-12-15	14:15	40
29	2	2015-12-21	14:30	40
30	2	2015-12-22	13:45	40
31	2	2016-01-04	11:30	40
32	2	2016-01-05	17:15	40
33	2	2016-01-06	11:45	40
34	3	2016-02-26	11:15	45
35	3	2016-02-27	13:15	45
36	3	2016-02-29	15:45	45
37	3	2016-03-03	12:00	45
38	3	2016-03-05	13:45	45
39	3	2016-03-10	12:30	45
40	3	2016-03-16	13:15	45
41	3	2016-03-19	13:15	45
42	3	2016-03-21	16:00	45
43	3	2016-03-26	16:15	45
44	3	2016-03-28	11:45	45
45	3	2016-03-28	13:15	45
46	3	2016-03-29	11:00	45
47	3	2016-04-01	15:15	45
48	3	2016-04-03	15:00	45
49	3	2016-04-14	12:00	45
50	3	2016-04-19	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;