Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 101–125 of 443

exhibition_slot, page 5 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
101	6	2017-03-20	16:45	35
102	6	2017-03-25	13:00	35
103	6	2017-03-25	13:15	35
104	6	2017-03-25	14:30	35
105	6	2017-03-28	13:00	35
106	6	2017-03-29	11:15	35
107	6	2017-04-05	14:45	35
108	6	2017-04-12	12:15	35
109	6	2017-04-18	10:45	35
110	6	2017-04-19	11:00	35
111	6	2017-04-19	11:15	35
112	6	2017-04-19	13:30	35
113	6	2017-04-19	15:00	35
114	6	2017-04-20	12:15	35
115	6	2017-04-22	16:30	35
116	6	2017-04-23	11:15	35
117	6	2017-04-23	14:15	35
118	6	2017-04-28	17:15	35
119	6	2017-04-29	13:30	35
120	6	2017-05-01	15:15	35
121	6	2017-05-04	16:00	35
122	6	2017-05-06	11:00	35
123	6	2017-05-06	16:15	35
124	6	2017-05-07	13:15	35
125	6	2017-05-07	17:15	35

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;