· 9 years ago · Feb 01, 2017, 10:36 AM
1DROP TABLE IF EXISTS "chunks"."alarm_20170630";
2CREATE TABLE "chunks"."alarm_20170630" (
3 "uuid" char(36) NOT NULL DEFAULT gen_uuid('alarm'::character varying) COLLATE "default",
4 "term_id" varchar(100) NOT NULL COLLATE "default",
5 "user_uid" char(36) COLLATE "default",
6 "car_uid" char(36) COLLATE "default",
7 "serv_time" timestamp(6) WITH TIME ZONE,
8 "date_time" timestamp(6) WITH TIME ZONE NOT NULL,
9 "alarm_source_uid" char(36) NOT NULL COLLATE "default",
10 "alarm_type_uid" char(36) NOT NULL COLLATE "default",
11 "value" float4,
12 "protocol" varchar(50) COLLATE "default",
13 "params" varchar(2048) COLLATE "default"
14)
15INHERITS ("public"."alarm_inner")
16WITH (OIDS=FALSE);
17ALTER TABLE "chunks"."alarm_20170630" OWNER TO "dba";