Table
exhibition_slot
A dated 15-minute slot of one exhibition.
Replaces in 2020: Time Slot
Rows 151–175 of 443
| slot_idINTEGER | exhibition_id→ exhibition.exhibition_id | slot_dateTEXT | start_timeTEXT | capacityINTEGER |
|---|---|---|---|---|
| 151 | 7 | 2017-12-20 | 12:00 | 45 |
| 152 | 7 | 2017-12-20 | 17:15 | 45 |
| 153 | 7 | 2017-12-24 | 12:30 | 45 |
| 154 | 7 | 2018-01-06 | 14:45 | 45 |
| 155 | 7 | 2018-01-07 | 15:45 | 45 |
| 156 | 7 | 2018-01-11 | 11:15 | 45 |
| 157 | 7 | 2018-01-12 | 11:15 | 45 |
| 158 | 7 | 2018-01-15 | 13:00 | 45 |
| 159 | 7 | 2018-01-22 | 14:30 | 45 |
| 160 | 8 | 2018-03-28 | 11:15 | 45 |
| 161 | 8 | 2018-04-01 | 10:30 | 45 |
| 162 | 8 | 2018-04-01 | 15:30 | 45 |
| 163 | 8 | 2018-04-04 | 09:45 | 45 |
| 164 | 8 | 2018-04-07 | 16:45 | 45 |
| 165 | 8 | 2018-04-09 | 10:00 | 45 |
| 166 | 8 | 2018-04-11 | 14:15 | 45 |
| 167 | 8 | 2018-04-15 | 17:15 | 45 |
| 168 | 8 | 2018-04-16 | 15:15 | 45 |
| 169 | 8 | 2018-04-18 | 11:30 | 45 |
| 170 | 8 | 2018-04-18 | 14:45 | 45 |
| 171 | 8 | 2018-04-22 | 12:30 | 45 |
| 172 | 8 | 2018-04-25 | 12:45 | 45 |
| 173 | 8 | 2018-04-27 | 15:00 | 45 |
| 174 | 8 | 2018-04-28 | 10:30 | 45 |
| 175 | 8 | 2018-05-02 | 12:30 | 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;