13 lines
309 B
SQL
13 lines
309 B
SQL
CREATE TABLE IF NOT EXISTS events (
|
|
id SERIAL PRIMARY KEY,
|
|
changeover_id VARCHAR(100),
|
|
changeover_date DATE,
|
|
start_time TIME,
|
|
end_time TIME,
|
|
duration_seconds INTEGER,
|
|
camera_zone VARCHAR(50),
|
|
event_description TEXT,
|
|
state VARCHAR(50),
|
|
state_duration_seconds INTEGER
|
|
);
|