forked from floraachy/xiuos_IoT
54 lines
2.0 KiB
SQL
54 lines
2.0 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 115.238.53.59
|
|
Source Server Type : PostgreSQL
|
|
Source Server Version : 120012
|
|
Source Host : 115.238.53.59:5432
|
|
Source Catalog : xiuosiot
|
|
Source Schema : public
|
|
|
|
Target Server Type : PostgreSQL
|
|
Target Server Version : 120012
|
|
File Encoding : 65001
|
|
|
|
Date: 01/11/2022 17:47:21
|
|
*/
|
|
DROP SEQUENCE IF EXISTS "public"."seq_alarm_rule";
|
|
CREATE SEQUENCE "public"."seq_alarm_rule"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
ALTER SEQUENCE "public"."seq_alarm_rule" OWNER TO "xiuosiot";
|
|
-- ----------------------------
|
|
-- Table structure for alarm_rule
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."alarm_rule";
|
|
CREATE TABLE "public"."alarm_rule" (
|
|
"id" int4 NOT NULL DEFAULT nextval('seq_alarm_rule'::regclass),
|
|
"alarm_name" varchar(64) COLLATE "pg_catalog"."default",
|
|
"alarm_level" int4,
|
|
"device_no" varchar(32) COLLATE "pg_catalog"."default",
|
|
"alarm_sql" varchar(500) COLLATE "pg_catalog"."default",
|
|
"rule_status" int4,
|
|
"notice_type" varchar(32) COLLATE "pg_catalog"."default",
|
|
"notice_content" varchar(255) COLLATE "pg_catalog"."default",
|
|
"org" varchar(32) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."alarm_rule"."alarm_name" IS '告警名称';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."alarm_level" IS '告警级别 0紧急 1重要 2次要 3提示';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."device_no" IS '设备编号';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."alarm_sql" IS '告警条件';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."rule_status" IS '规则状态0 停止 1启动';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."notice_type" IS '推送方式';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."notice_content" IS '推送内容';
|
|
COMMENT ON COLUMN "public"."alarm_rule"."org" IS '所属公司';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table alarm_rule
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."alarm_rule" ADD CONSTRAINT "alarm_rule_pkey" PRIMARY KEY ("id");
|