42 lines
1.5 KiB
SQL
42 lines
1.5 KiB
SQL
CREATE DATABASE monitor
|
|
WITH
|
|
OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'zh_CN.UTF-8' LC_CTYPE = 'zh_CN.UTF-8' TEMPLATE template0;
|
|
|
|
DROP TABLE IF EXISTS "public"."gzjc_data";
|
|
CREATE TABLE "public"."gzjc_data" (
|
|
"time" timestamptz(6) NOT NULL,
|
|
"sensor_id" int2 NOT NULL,
|
|
"id" INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
"o3" numeric(32,0),
|
|
"co2" numeric(32,0),
|
|
"h2s" numeric(32,0),
|
|
"cl2" numeric(32,0),
|
|
"nh3" numeric(32,1),
|
|
"tvoc" numeric(32,3),
|
|
"ch2o" numeric(32,0),
|
|
"c2h5oh" numeric(32,1),
|
|
"ch4" numeric(32,1),
|
|
"o2" numeric(32,1),
|
|
"aqs" numeric(32,0),
|
|
"humidity" numeric(32,1),
|
|
"temperature" numeric(32,1),
|
|
"pm1d0" numeric(32,0),
|
|
"pm2d5" numeric(32,0),
|
|
"pm10" numeric(32,0),
|
|
"windspeed" numeric(32,2),
|
|
"winddirection" numeric(32,0),
|
|
"airpressure" numeric(32,1),
|
|
"voice" numeric(32,1)
|
|
)
|
|
;
|
|
ALTER TABLE "public"."gzjc_data" OWNER TO "postgres";
|
|
COMMENT ON COLUMN "public"."gzjc_data"."humidity" IS '湿度';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."temperature" IS '温度';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."pm1d0" IS 'pm1.0';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."pm2d5" IS 'pm2.5';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."pm10" IS 'pm10';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."windspeed" IS '风速';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."winddirection" IS '风向';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."airpressure" IS '气压';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."time" IS '获取时间';
|
|
COMMENT ON COLUMN "public"."gzjc_data"."voice" IS '噪音'; |