Table

exhibition_slot

A dated 15-minute slot of one exhibition.

Replaces in 2020: Time Slot

Rows 51–75 of 443

exhibition_slot, page 3 of 18
slot_idINTEGER	exhibition_id→ exhibition.exhibition_id	slot_dateTEXT	start_timeTEXT	capacityINTEGER
51	3	2016-04-24	11:45	45
52	3	2016-04-28	14:45	45
53	3	2016-05-01	13:30	45
54	3	2016-05-04	10:30	45
55	3	2016-05-04	13:15	45
56	3	2016-05-06	15:15	45
57	3	2016-05-08	15:15	45
58	3	2016-05-16	12:45	45
59	3	2016-05-18	16:15	45
60	3	2016-05-22	14:30	45
61	3	2016-05-25	12:00	45
62	3	2016-05-25	12:15	45
63	3	2016-05-27	13:00	45
64	3	2016-05-27	16:00	45
65	3	2016-05-28	11:45	45
66	3	2016-05-29	15:30	45
67	4	2016-06-24	10:45	30
68	4	2016-06-27	13:30	30
69	4	2016-06-29	15:45	30
70	4	2016-07-01	14:15	30
71	4	2016-07-01	14:30	30
72	4	2016-07-07	10:45	30
73	4	2016-07-24	11:00	30
74	4	2016-08-25	12:15	30
75	5	2016-10-12	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;