subtitle VARCHAR,
venue VARCHAR,
city VARCHAR,
- start INTEGER NOT NULL, -- timestamp (Unix Epoch)
- end INTEGER NOT NULL, -- timestamp (Unix Epoch)
+ start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
+ end INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
day_change INTEGER,
timeslot_duration INTEGER,
active INTEGER DEFAULT 0,
subtitle VARCHAR,
venue VARCHAR,
city VARCHAR,
- start INTEGER NOT NULL, -- timestamp (Unix Epoch)
- end INTEGER NOT NULL, -- timestamp (Unix Epoch)
+ start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
+ end INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
day_change INTEGER,
timeslot_duration INTEGER,
active INTEGER DEFAULT 0,
CREATE TABLE event (
xid_conference INTEGER NOT NULL REFERENCES conference(id),
id INTEGER NOT NULL,
- start INTEGER NOT NULL,
+ start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
duration INTEGER NOT NULL, -- duration of the event in seconds
xid_track INTEGER NOT NULL REFERENCES track(id),
type VARCHAR,