Table
exhibition_slot
A dated 15-minute slot of one exhibition.
Replaces in 2020: Time Slot
Rows 176–200 of 443
| slot_idINTEGER | exhibition_id→ exhibition.exhibition_id | slot_dateTEXT | start_timeTEXT | capacityINTEGER |
|---|---|---|---|---|
| 176 | 8 | 2018-05-04 | 13:15 | 45 |
| 177 | 8 | 2018-05-04 | 13:30 | 45 |
| 178 | 8 | 2018-05-06 | 10:45 | 45 |
| 179 | 8 | 2018-05-11 | 11:00 | 45 |
| 180 | 8 | 2018-05-11 | 15:15 | 45 |
| 181 | 8 | 2018-05-16 | 13:00 | 45 |
| 182 | 8 | 2018-05-19 | 17:15 | 45 |
| 183 | 8 | 2018-05-23 | 11:45 | 45 |
| 184 | 8 | 2018-05-25 | 11:45 | 45 |
| 185 | 8 | 2018-05-29 | 13:15 | 45 |
| 186 | 8 | 2018-05-30 | 11:45 | 45 |
| 187 | 8 | 2018-05-31 | 11:45 | 45 |
| 188 | 8 | 2018-06-01 | 12:30 | 45 |
| 189 | 8 | 2018-06-04 | 11:00 | 45 |
| 190 | 8 | 2018-06-04 | 13:00 | 45 |
| 191 | 8 | 2018-06-05 | 15:30 | 45 |
| 192 | 8 | 2018-06-06 | 13:15 | 45 |
| 193 | 8 | 2018-06-10 | 11:30 | 45 |
| 194 | 8 | 2018-06-11 | 17:00 | 45 |
| 195 | 8 | 2018-06-13 | 16:30 | 45 |
| 196 | 8 | 2018-06-17 | 13:00 | 45 |
| 197 | 8 | 2018-06-23 | 14:30 | 45 |
| 198 | 8 | 2018-06-26 | 11:30 | 45 |
| 199 | 8 | 2018-07-04 | 16:15 | 45 |
| 200 | 8 | 2018-07-05 | 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;