RollerskatesTelemetry/init.sql at master · okomiss-dev/RollerskatesTelemetry · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
CREATE SCHEMA DETECTORS;

CREATE TABLE DETECTORS.TEMPERATURE(
                          ID SERIAL PRIMARY KEY,
                          VALUE FLOAT(20) NOT NULL,
                          MEASURE CHAR(20) NOT NULL,
                          DATE_TIME TIMESTAMP NOT NULL
);

CREATE TABLE DETECTORS.HUMIDITY(
                       ID SERIAL PRIMARY KEY,
                       VALUE FLOAT(20) NOT NULL,
                       MEASURE CHAR(20) NOT NULL,
                       DATE_TIME TIMESTAMP NOT NULL
);

CREATE TABLE DETECTORS.PRESSURE(
                       ID SERIAL PRIMARY KEY,
                       VALUE FLOAT(20) NOT NULL,
                       MEASURE CHAR(20) NOT NULL,
                       DATE_TIME TIMESTAMP NOT NULL
);

CREATE TABLE DETECTORS.SPEED(
                    ID SERIAL PRIMARY KEY,
                    VALUE FLOAT(20) NOT NULL,
                    MEASURE CHAR(20) NOT NULL,
                    DATE_TIME TIMESTAMP NOT NULL
)