Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 126–150 of 443

exhibition_slot, page 6 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
126	6	2017-05-13	11:00	35
127	6	2017-05-14	14:30	35
128	6	2017-05-18	12:15	35
129	6	2017-05-18	13:15	35
130	6	2017-05-20	14:15	35
131	6	2017-05-20	17:15	35
132	7	2017-10-10	11:00	45
133	7	2017-10-10	17:15	45
134	7	2017-10-21	10:15	45
135	7	2017-10-22	12:15	45
136	7	2017-10-28	11:45	45
137	7	2017-10-28	15:15	45
138	7	2017-11-06	14:30	45
139	7	2017-11-11	13:00	45
140	7	2017-11-18	12:00	45
141	7	2017-11-22	13:00	45
142	7	2017-11-22	13:15	45
143	7	2017-11-23	15:00	45
144	7	2017-12-06	11:45	45
145	7	2017-12-06	12:45	45
146	7	2017-12-07	10:45	45
147	7	2017-12-10	17:00	45
148	7	2017-12-17	12:00	45
149	7	2017-12-17	12:45	45
150	7	2017-12-19	12: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;