Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 1–25 of 443

exhibition_slot, page 1 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
1	1	2015-03-23	11:00	45
2	1	2015-03-23	12:30	45
3	1	2015-03-23	14:00	45
4	1	2015-03-31	15:45	45
5	1	2015-04-04	12:00	45
6	1	2015-04-25	11:30	45
7	1	2015-04-25	11:45	45
8	1	2015-05-21	13:15	45
9	1	2015-05-22	16:00	45
10	1	2015-05-25	12:15	45
11	1	2015-05-28	11:00	45
12	1	2015-05-28	11:15	45
13	1	2015-06-07	12:00	45
14	1	2015-06-11	17:15	45
15	1	2015-06-14	16:30	45
16	2	2015-09-27	16:45	40
17	2	2015-10-04	11:30	40
18	2	2015-10-07	15:15	40
19	2	2015-10-11	11:45	40
20	2	2015-10-26	12:45	40
21	2	2015-10-30	12:45	40
22	2	2015-11-06	12:15	40
23	2	2015-11-10	15:30	40
24	2	2015-11-18	10:30	40
25	2	2015-11-18	14:45	40

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;