blob: 04e94fd715994608490a1be1548552a05d88a756 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
CREATE TABLE status ( code VARCHAR(255) PRIMARY KEY, class VARCHAR(255) NOT NULL, description VARCHAR(255) NOT NULL, is_active BOOLEAN NOT NULL ); CREATE TABLE line ( id INT PRIMARY KEY, name VARCHAR(255) NOT NULL UNIQUE ); CREATE TABLE line_status ( time DATETIME NOT NULL, line_id INT NOT NULL REFERENCES line(id), status_code VARCHAR(255) NOT NULL REFERENCES status(code), is_active BOOLEAN NOT NULL, details TEXT );
|