14 lines
402 B
MySQL
14 lines
402 B
MySQL
|
CREATE TABLE "IoT-Sensors-Data" (
|
||
|
|
"id" serial PRIMARY KEY NOT NULL,
|
||
|
|
"deviceType" integer NOT NULL,
|
||
|
|
"deviceID" integer NOT NULL,
|
||
|
|
"timestamp" date NOT NULL,
|
||
|
|
"xCoordinates" integer NOT NULL,
|
||
|
|
"yCoordinates" integer NOT NULL,
|
||
|
|
"zCoordinates" integer NOT NULL,
|
||
|
|
"dataType" text NOT NULL,
|
||
|
|
"mean_value" real NOT NULL,
|
||
|
|
"std_value" real NOT NULL,
|
||
|
|
CONSTRAINT "IoT-Sensors-Data_id_unique" UNIQUE("id")
|
||
|
|
);
|