CREATE TABLE "MONITOR_VISUAL"."ALARMTABLE"
(
"ALARM_ID" INT,
"ALARM_TIME" DATETIME(0),
"AUTHORIZEID" VARCHAR(50)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."ALARMTABLE" IS '违规操作信息表单';


CREATE TABLE "MONITOR_VISUAL"."ATTACKTABLE"
(
"ATTACK_ID" INT,
"ATTACK_TIME" DATETIME(0),
"AUTHORIZEID" VARCHAR(50)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."ATTACKTABLE" IS '可疑人员入侵信息表单';


CREATE TABLE "MONITOR_VISUAL"."COMM_CODE"
(
"ID" VARCHAR(384) DEFAULT '' NOT NULL,
"CODE" VARCHAR(384),
"SUPER_CODE" VARCHAR(384),
"CODE_VALUE" VARCHAR(384),
"CODE_NAME" VARCHAR(1200),
"CODE_ALIAS" VARCHAR(1200),
"CODE_LEVEL" DECIMAL(8,0),
"REMARK" VARCHAR(3900),
"IS_DELETE" VARCHAR(24),
"CREATE_USER" VARCHAR(384),
"CREATE_DATETIME" TIMESTAMP(0),
"UPDATE_USER" VARCHAR(384),
"UPDATE_DATETIME" TIMESTAMP(0),
"USE_SCOPE" VARCHAR(384) DEFAULT '0',
CONSTRAINT "PRIMARY" NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_ADVANCED_REGION"
(
"ID" INT,
"X1" DECIMAL(8,2) DEFAULT 0.,
"Y1" DECIMAL(8,2) DEFAULT 0.,
"X2" DECIMAL(8,2) DEFAULT 0.,
"Y2" DECIMAL(8,2) DEFAULT 0.,
"X3" DECIMAL(8,2) DEFAULT 0.,
"Y3" DECIMAL(8,2) DEFAULT 0.,
"X4" DECIMAL(8,2) DEFAULT 0.,
"Y4" DECIMAL(8,2) DEFAULT 0.,
"ULTRASONIC_STATUS" TINYINT DEFAULT 0,
"DROP_STATUS" TINYINT DEFAULT 0,
"DESCRIPTION" VARCHAR(384),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_ADVANCED_REGION" IS '高级区域';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."DESCRIPTION" IS '描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."DROP_STATUS" IS '跌落使能（1屏蔽，0不屏蔽）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."ID" IS '自增ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."ULTRASONIC_STATUS" IS '超声使能（1屏蔽，0不屏蔽）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."X1" IS 'X1坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."X2" IS 'X2坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."X3" IS 'X3坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."X4" IS 'X4坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."Y1" IS 'Y1坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."Y2" IS 'Y2坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."Y3" IS 'Y3坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ADVANCED_REGION"."Y4" IS 'Y4坐标';


CREATE TABLE "MONITOR_VISUAL"."RT_ALARM"
(
"ID" VARCHAR(100) NOT NULL,
"UNIT_SIGN" INT,
"UNIT_TITLE" VARCHAR(384),
"UNIT_VALUE" TINYINT DEFAULT 0,
"ALARM_TIME" TIMESTAMP(0),
"SMS_STATUS" TINYINT,
"AUTHORIZEID" VARCHAR(600),
"ROBOT_ID" VARCHAR(200),
"IS_BUDID_PROFESS" CHAR(1) DEFAULT 0,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_ALARM" IS '变电告警表';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."ALARM_TIME" IS '报警时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."AUTHORIZEID" IS '站室编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."IS_BUDID_PROFESS" IS '是否已生成专业检修记录 0 未生成 1 已生成';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."SMS_STATUS" IS '短信状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."UNIT_SIGN" IS '区域标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."UNIT_TITLE" IS '区域名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ALARM"."UNIT_VALUE" IS '区域值（0,1）';


CREATE TABLE "MONITOR_VISUAL"."RT_AREA"
(
"AREA_TAG" INT,
"AREA_SERIAL" INT,
"AREA_NAME" VARCHAR(384),
"AREA_MARK" VARCHAR(768),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_AREA" IS '巡检区域';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_AREA"."AREA_MARK" IS '区域标示描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_AREA"."AREA_NAME" IS '区域名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_AREA"."AREA_SERIAL" IS '区域序号';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_AREA"."AREA_TAG" IS '区域唯一标记ID、主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_AREA"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_AREA"."ROBOT_ID" IS 'robotId';


CREATE TABLE "MONITOR_VISUAL"."RT_ARTIFICIAL_COGNITION"
(
"ID" VARCHAR(100) NOT NULL,
"DATA_DATE" DATETIME(6),
"DATA_IMG_URL" VARCHAR(384),
"DATA_IMG_NAME" VARCHAR(384),
"RESULT_VALUE" VARCHAR(50),
"RESULT_STATUS" INT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_AUDIT"
(
"ID" INT,
"DEVICE_TAG" INT,
"DATA_STATUS" TINYINT DEFAULT 1,
"DATA_VALUE" VARCHAR(33),
"DATA_DATE" TIMESTAMP(0),
"ALARM_LEVEL" TINYINT,
"AUDITOR" VARCHAR(33),
"AUDIT_DATE" TIMESTAMP(0),
"AUDIT_RESULT" VARCHAR(150),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_CAMERA"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"FACTORY" VARCHAR(150),
"IS_ROBOT_TYPE" INT DEFAULT 0,
"CAMERA_TYPE" INT DEFAULT 0,
"NAME" VARCHAR(384),
"IP" VARCHAR(45),
"PORT" VARCHAR(50),
"IP_MAPPING" VARCHAR(45),
"PORT_MAPPING" VARCHAR(50),
"USERNAME" VARCHAR(50),
"PWD" VARCHAR(90),
"RTSP_ADDR" VARCHAR(300),
"CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"ROBOT_ID" VARCHAR(50),
"AUTHORIZEID" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_CAMERA" IS '相机设备表';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."AUTHORIZEID" IS '站室编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."CAMERA_TYPE" IS 'camera type, 0:可见光,1:红外';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."FACTORY" IS '相机厂家';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."ID" IS 'camera id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."IP" IS '相机设备的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."IP_MAPPING" IS '网关映射的相机设备的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."IS_ROBOT_TYPE" IS 'is_robot_type, 0:球机,1:机器人本体相机';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."NAME" IS '相机设备的名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."PORT" IS '相机设备的port';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."PORT_MAPPING" IS '网关映射的相机设备的port';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."PWD" IS '相机设备的密码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."RTSP_ADDR" IS 'rtsp流地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CAMERA"."USERNAME" IS '相机设备的用户名';


CREATE TABLE "MONITOR_VISUAL"."RT_CHECK_LINE"
(
"LINE_ID" INT,
"START_X" DECIMAL(8,2),
"START_Y" DECIMAL(8,2),
"END_X" DECIMAL(8,2),
"END_Y" DECIMAL(8,2),
"LINE_TYPE" INT DEFAULT 0,
"CON1_X" DECIMAL(8,2),
"CON1_Y" DECIMAL(8,2),
"CON2_X" DECIMAL(8,2),
"CON2_Y" DECIMAL(8,2),
"ENABLE" TINYINT DEFAULT 1,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
"START_ID" INT,
"END_ID" INT) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_CHECK_LINE" IS '巡检路径';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."CON1_X" IS '控制点1 x坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."CON1_Y" IS '控制点1 y坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."CON2_X" IS '控制点2 x坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."CON2_Y" IS '控制点2 y坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."ENABLE" IS '该巡检线路是否可用，1:可用，0:不可用';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."END_X" IS '结束点x坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."END_Y" IS '结束点y坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."LINE_ID" IS '自增ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."LINE_TYPE" IS '类型，0:直线(circle数据为0)，1:贝塞尔曲线';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."START_X" IS '起始点x坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_LINE"."START_Y" IS '起始点y坐标';


CREATE TABLE "MONITOR_VISUAL"."RT_CHECK_POINT"
(
"POINT_TAG" INT,
"AREA_TAG" INT,
"POINT_NAME" VARCHAR(384),
"POINT_X" DECIMAL(8,2),
"POINT_Y" DECIMAL(8,2),
"POINT_ANGLE" DECIMAL(8,2),
"POINT_MARK" VARCHAR(768),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_CHECK_POINT" IS '巡检点';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."AREA_TAG" IS '区域标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."POINT_ANGLE" IS '巡检点车头角度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."POINT_MARK" IS '巡检点描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."POINT_NAME" IS '巡检点名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."POINT_TAG" IS '巡检点标记ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."POINT_X" IS '巡检点X坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."POINT_Y" IS '巡检点Y坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CHECK_POINT"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_CURRENT_TASK"
(
"ID" VARCHAR(50) DEFAULT 1,
"TASK_ID" INT DEFAULT (-1),
"START_TIME" TIMESTAMP(0) DEFAULT '2017-01-03 00:00:00',
"PAUSE_TIME" TIMESTAMP(0) DEFAULT '2017-01-03 00:00:00',
"DEVICE_BUG" INT,
"DEVICE_NUM" INT,
"DEVICE_EXC" INT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_CURRENT_TASK" IS '当前任务';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."DEVICE_BUG" IS '当前设备缺陷数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."DEVICE_EXC" IS '当前检查设备数量';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."DEVICE_NUM" IS '当前设备异常数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."PAUSE_TIME" IS '暂停时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."START_TIME" IS '开始时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_CURRENT_TASK"."TASK_ID" IS '任务ID，关联rt_task_plane表中的task_id';


CREATE TABLE "MONITOR_VISUAL"."RT_DATA_DETAIL"
(
"TASK_ID" INT,
"TASK_DATE" TIMESTAMP(0),
"DEVICE_TAG" INT,
"DATA_DATE" TIMESTAMP(0),
"DATA_VALUE" VARCHAR(384),
"DATA_UNIT" VARCHAR(384),
"DATA_STATUS" TINYINT DEFAULT 1,
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."DATA_DATE" IS '数据时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."DATA_STATUS" IS '识别状态（1正常，0识别异常，2连接异常，3数据超限,4异常（超量程、外观异常））';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."DATA_UNIT" IS '单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."DATA_VALUE" IS '数据值（超量程、外观异常或者真实int型值）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."DEVICE_TAG" IS '设备ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."ID" IS '主键id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."ROBOT_ID" IS '机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."TASK_DATE" IS '任务日期';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DATA_DETAIL"."TASK_ID" IS '任务Id';


CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE"
(
"DEVICE_TAG" INT,
"POINT_TAG" INT,
"DEVICE_NAME" VARCHAR(384),
"DEVICE_TYPE" TINYINT DEFAULT 0,
"RECOGNIZE_TYPE" INT,
"METER_TYPE" INT,
"DEVICE_UNIT" VARCHAR(84),
"DEVICE_UPER" DECIMAL(8,2),
"DEVICE_LOWER" DECIMAL(8,2),
"RECORD_TIME" DECIMAL(8,2),
"DEVICE_MARK" VARCHAR(768),
"AUTHORIZEID" VARCHAR(600),
"ROBOT_ID" VARCHAR(200),
"DEVICE_GENERAL_TYPE" INT,
"BURN_TYPE" INT) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE_ALARM"
(
"ALARM_ID" INT,
"DEVICE_TAG" INT,
"ALARM_DATE" TIMESTAMP(0),
"ALARM_VALUE" VARCHAR(50),
"DATA_UNIT" VARCHAR(93),
"LIMIT_VALUE" VARCHAR(90),
"ALARM_LEVEL" TINYINT DEFAULT 0,
"ALARM_STATUS" TINYINT DEFAULT 0,
"CANCLE_DATE" TIMESTAMP(0),
"ALARM_MARK" VARCHAR(384),
"SMS_STATUS" TINYINT,
"AUTHORIZEID" VARCHAR(200),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_DEVICE_ALARM" IS '设备告警';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ALARM_DATE" IS '告警日期时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ALARM_ID" IS '主键，自增ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ALARM_LEVEL" IS '告警级别（3-三相温差报警；4-识别内容异常报警5-设备识别异常报警；6-预警报警；7-一般报警；8-严重报警；9-危急报警；）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ALARM_MARK" IS '描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ALARM_STATUS" IS '告警状态（0-不告警；1-告警），告警确认后变为0';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ALARM_VALUE" IS '告警值，巡检结果值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."CANCLE_DATE" IS '取消报警时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."DATA_UNIT" IS '界限值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."DEVICE_TAG" IS '设备标示ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."LIMIT_VALUE" IS '单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."ROBOT_ID" IS '机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_ALARM"."SMS_STATUS" IS '为华云app服务，判断告警状态是否已上送，避免重复上送0未上送，1已上送';


CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"
(
"DEVICE_TAG" INT,
"DATA_DATE" TIMESTAMP(0),
"TASK_ID" INT,
"DATA_IMG_URL" VARCHAR(2000),
"DATA_IMG_NAME" VARCHAR(2000),
"DEVICE_TEM" DECIMAL(8,2),
"R_MIN_TEMP" DECIMAL(8,2) DEFAULT 0.,
"R_AVG_TEMP" DECIMAL(8,2),
"FILTER_TEM" DECIMAL(8,2),
"IMG_MAX_TEM" DECIMAL(8,2),
"DEVICE_TEM_UP" DECIMAL(8,2),
"ENV_TEM" DECIMAL(8,2),
"DATA_STATUS" TINYINT DEFAULT 1,
"BURN_TYPE" INTEGER DEFAULT 0,
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."BURN_TYPE" IS '类型';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DATA_DATE" IS '2016-06-30 18:25:14';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DATA_IMG_NAME" IS '红外图片（名称）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DATA_IMG_URL" IS '红外图片（地址）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DATA_STATUS" IS '识别状态（1正常，0异常，2连接异常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DEVICE_TAG" IS '设备标记即设备ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DEVICE_TEM" IS '设备温度（区域最高温）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."DEVICE_TEM_UP" IS '设备温升';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."ENV_TEM" IS '环境温度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."FILTER_TEM" IS '过滤温度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."ID" IS 'ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."IMG_MAX_TEM" IS '全图最高温';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."ROBOT" IS '机器人Id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."R_AVG_TEMP" IS '区域平均温度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."R_MIN_TEMP" IS '区域最低温';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INF"."TASK_ID" IS '任务Id，没有时赋值0';


CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"
(
"DEVICE_TAG" INT,
"DATA_DATE" TIMESTAMP(0),
"TASK_ID" INT,
"DATA_IMG_URL" VARCHAR(768),
"DATA_IMG_NAME" VARCHAR(384),
"DATA_IDENTITY_STATUS" INT,
"DATA_VALUE" VARCHAR(384),
"DATA_UNIT" VARCHAR(384),
"DATA_NORMAL_RANGE" VARCHAR(384),
"DATA_STATUS" TINYINT DEFAULT 1,
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_DATE" IS '2016-06-30 18:25:14';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_IDENTITY_STATUS" IS '初始状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_IMG_NAME" IS '仪表识别图片（名称）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_IMG_URL" IS '仪表识别图片（地址）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_NORMAL_RANGE" IS '正常范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_STATUS" IS '识别状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_UNIT" IS '单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DATA_VALUE" IS '识别值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."DEVICE_TAG" IS '设备标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."ID" IS 'id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_DATA_INS"."TASK_ID" IS '当前数据所属任务Id，没有时赋值0';


CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE_INFO"
(
"ID" INT IDENTITY(5, 1) NOT NULL,
"DEVICE_NAME" VARCHAR(90),
"LINE_ID" VARCHAR(90),
"STATION_ID" VARCHAR(90),
"DEVICE_TYPE" VARCHAR(90),
"DEVICE_STATUS" VARCHAR(90),
"IMPORTANT_LEVEL" VARCHAR(90),
"ABC_TYPE" VARCHAR(90),
"DEVICE_GRADE" VARCHAR(90),
"FUNCTION_TYPE" VARCHAR(90),
"CABINET_CODE" INT,
"NAMEPLATE_NO" VARCHAR(90),
"LOCATION_ZONE" VARCHAR(90),
"MANUFACTURER" VARCHAR(90),
"BRAND" VARCHAR(90),
"MODEL" VARCHAR(90),
"SPECIFICATION" VARCHAR(90),
"SUPPLIER" VARCHAR(90),
"STATUS" INT,
"CREATE_TIME" TIMESTAMP(0),
"UPDATE_TIME" TIMESTAMP(0),
"DEVICE_CODE" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."ABC_TYPE" IS 'ABC分类 ABC分类';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."BRAND" IS '品牌、以实际品牌为准 品牌、以实际品牌为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."CABINET_CODE" IS '区域编码 区域编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."DEVICE_CODE" IS '设备编号';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."DEVICE_GRADE" IS '设备评级 设备评级';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."DEVICE_NAME" IS '设备名称，如：35kV诸虹Ⅰ进线开关柜，以设计上的铭牌为准 设备名称，如：35kV诸虹Ⅰ进线开关柜，以设计上的铭牌为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."DEVICE_STATUS" IS '设备状态，未启用/在用/备用/停役等 设备状态，未启用/在用/备用/停役等';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."DEVICE_TYPE" IS '设备分类、以集团分类为准 设备分类、以集团分类为准。大类中类小类';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."FUNCTION_TYPE" IS '功能类型 设备功能类型编码共八位，由两位设备类别+两位设备大类+两位功能类型+两位预留位组成';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."IMPORTANT_LEVEL" IS '重要程度、重要设备/瓶颈设备/普通设备 重要程度、重要设备/瓶颈设备/普通设备';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."LINE_ID" IS '所属线路以集团编码为准 所属线路以集团编码为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."LOCATION_ZONE" IS '所在段、以实际位置为准，无分段/Ⅰ段/Ⅱ段 所在段、以实际位置为准，无分段/Ⅰ段/Ⅱ段';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."MANUFACTURER" IS '制造商、以实际制造单位营业执照上的公司名称为准 制造商、以实际制造单位营业执照上的公司名称为准*';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."MODEL" IS '型号、以厂商定义的型号为准 型号、以厂商定义的型号为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."NAMEPLATE_NO" IS '设备铭牌，如：H11，以设计图纸为准 设备铭牌，如：H11，以设计图纸为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."SPECIFICATION" IS '规格、以厂商的规格数据为准 规格、以厂商的规格数据为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."STATION_ID" IS '所属变电所/站点 所属变电所/站点';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."STATUS" IS '状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."SUPPLIER" IS '供应商、实际供货单位，以营业执照上的名称为准 供应商、实际供货单位，以营业执照上的名称为准';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_INFO"."UPDATE_TIME" IS '修改时间';


CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE_LIMIT"
(
"DEVICE_TAG" INT,
"UPPER_LIMIT" VARCHAR(60) DEFAULT '0.00',
"UPPER_ENABLE" TINYINT DEFAULT 0,
"LOWER_LIMIT" VARCHAR(60),
"LOWER_ENABLE" TINYINT DEFAULT 0,
"COMMON_UPPER_LIMIT" VARCHAR(60) DEFAULT '0.00',
"COMMON_UPPER_ENABLE" TINYINT DEFAULT 0,
"COMMON_LOWER_LIMIT" VARCHAR(60) DEFAULT '0.00',
"COMMON_LOWER_ENABLE" TINYINT DEFAULT 0,
"SERIOUS_UPPER_LIMIT" VARCHAR(60) DEFAULT '0.00',
"SERIOUS_UPPER_ENABLE" TINYINT DEFAULT 0,
"SERIOUS_LOWER_LIMIT" VARCHAR(60) DEFAULT '0.00',
"SERIOUS_LOWER_ENABLE" TINYINT DEFAULT 0,
"CRITICAL_UPPER_LIMIT" VARCHAR(60) DEFAULT '0.00',
"CRITICAL_UPPER_ENABLE" TINYINT DEFAULT 0,
"CRITICAL_LOWER_LIMIT" VARCHAR(60),
"CRITICAL_LOWER_ENABLE" TINYINT DEFAULT 0,
"LIMIT_MARK" VARCHAR(384),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_DEVICE_LIMIT" IS '设备界限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."COMMON_LOWER_ENABLE" IS '一般报警下限是否（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."COMMON_LOWER_LIMIT" IS '一般报警下限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."COMMON_UPPER_ENABLE" IS '一般报警上限是否（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."COMMON_UPPER_LIMIT" IS '一般报警上限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."CRITICAL_LOWER_ENABLE" IS '危急报警下限是否（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."CRITICAL_LOWER_LIMIT" IS '危急报警下限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."CRITICAL_UPPER_ENABLE" IS '危急报警上限是否（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."CRITICAL_UPPER_LIMIT" IS '危急报警上限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."DEVICE_TAG" IS '设备标示ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."LIMIT_MARK" IS '描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."LOWER_ENABLE" IS '预警下限是否使能（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."LOWER_LIMIT" IS '预警下限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."SERIOUS_LOWER_ENABLE" IS '严重报警下限是否（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."SERIOUS_LOWER_LIMIT" IS '严重报警下限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."SERIOUS_UPPER_ENABLE" IS '严重报警上限是否（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."SERIOUS_UPPER_LIMIT" IS '严重报警上限';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."UPPER_ENABLE" IS '预警上限是否使能（0非使能,1等于，2不等于，3大于，4小于）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_LIMIT"."UPPER_LIMIT" IS '预警上限';


CREATE TABLE "MONITOR_VISUAL"."RT_DEVICE_TYPE"
(
"TYPE_ID" INT DEFAULT 1,
"TYPE_NAME" VARCHAR(84),
"REMARK" VARCHAR(768),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_DEVICE_TYPE" IS '设备类型';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_TYPE"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_TYPE"."REMARK" IS '描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_TYPE"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_TYPE"."TYPE_ID" IS '设备类型标记唯一ID、主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_DEVICE_TYPE"."TYPE_NAME" IS '类型名称';


CREATE TABLE "MONITOR_VISUAL"."RT_ENERGY_LOG"
(
"ID" VARCHAR(200) NOT NULL,
"LOG_TIME" TIMESTAMP(0),
"DATA_VALUE" DECIMAL(8,2) DEFAULT 0.,
"DATA_VOLTAGE" DECIMAL(8,2) DEFAULT 0.,
"DATA_CURRENT" DECIMAL(8,2) DEFAULT 0.,
"AUTHORIZEID" VARCHAR(600),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."DATA_CURRENT" IS '记录电流值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."DATA_VALUE" IS '记录电量值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."DATA_VOLTAGE" IS '记录电压值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."LOG_TIME" IS '记录时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ENERGY_LOG"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_ENVIRONMENT_INFO"
(
"ENV_ID" INT,
"ENV_NAME" VARCHAR(20),
"ENV_VALUE" DECIMAL(8,2) DEFAULT NULL,
"ENV_THRESHOLD" DECIMAL(8,2) DEFAULT NULL,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
"ID" VARCHAR(50) NOT NULL,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_FIXED_TASK"
(
"ID" INT,
"NAME" VARCHAR(192),
"TYPE" INT DEFAULT 0,
"DEVICES" VARCHAR(3900),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" CHAR(10)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_FIXED_TASK" IS '恶劣天气固定任务';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_FIXED_TASK"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_FIXED_TASK"."DEVICES" IS '''设备ID字符串''';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_FIXED_TASK"."NAME" IS '名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_FIXED_TASK"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_FIXED_TASK"."TYPE" IS '类型';


CREATE TABLE "MONITOR_VISUAL"."RT_LINE_INFO"
(
"ID" INT IDENTITY(3, 1) NOT NULL,
"LINE_NAME" VARCHAR(120),
"LINE_CODE" VARCHAR(120),
"DEPT_ID" INT,
"CREATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"UPDATE_TIME" TIMESTAMP(0),
"DELETE_FLAG" TINYINT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_LINE_INFO" IS '线路基础属性';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."DELETE_FLAG" IS '删除标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."DEPT_ID" IS '线路负责部门id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."LINE_CODE" IS '线路编码（不可重复）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."LINE_NAME" IS '线路名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LINE_INFO"."UPDATE_TIME" IS '更新时间';


CREATE TABLE "MONITOR_VISUAL"."RT_LOG"
(
"LOG_ID" INT,
"USER_ID" INT,
"USER_NAME" VARCHAR(384),
"MODULE" VARCHAR(135),
"ACTION" VARCHAR(135),
"QUERYSTRING" VARCHAR(360),
"IP" VARCHAR(135),
"OPERATE_TIME" TIMESTAMP(0),
"STATUS" TINYINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_LOG" IS '日志表';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."ACTION" IS '方法名';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."IP" IS 'IP地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."LOG_ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."MODULE" IS '模块名';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."OPERATE_TIME" IS '操作时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."QUERYSTRING" IS 'sql';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."STATUS" IS '操作结果';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_LOG"."USER_NAME" IS '用户名';


CREATE TABLE "MONITOR_VISUAL"."RT_MAP"
(
"ID" INT DEFAULT 1,
"START_X_POINT" DECIMAL(8,2),
"START_Y_POINT" DECIMAL(8,2),
"END_X_POINT" DECIMAL(8,2),
"END_Y_POINT" DECIMAL(8,2),
"PIXEL_RATE" DECIMAL(4,2),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
"ROTATE_ANGLE" DECIMAL(8,2)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_MAP" IS '地图坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."AUTHORIZEID" IS '地图旋转角度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."END_X_POINT" IS '地图终点x坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."END_Y_POINT" IS '地图终点y坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."ID" IS '地图标记（只有一个值1）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."PIXEL_RATE" IS '像素比率（1像素代表多少厘米）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."ROBOT_ID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."START_X_POINT" IS '地图起点x坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP"."START_Y_POINT" IS '地图起点y坐标';


CREATE TABLE "MONITOR_VISUAL"."RT_MAP_EDGE"
(
"ID" INT IDENTITY(265, 1) NOT NULL,
"LINE_CODE" VARCHAR(24) DEFAULT NULL,
"COLOR" VARCHAR(24) DEFAULT NULL,
"SOURCE" VARCHAR(24) DEFAULT NULL,
"TARGET" VARCHAR(24) DEFAULT NULL,
"DESCRIPTION" VARCHAR(128) DEFAULT NULL,
"STATUS" TINYINT DEFAULT NULL,
"CREATE_TIME" TIMESTAMP(0) DEFAULT NULL,
"UPDATE_TIME" TIMESTAMP(0) DEFAULT NULL,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_MAP_LINE"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"LABEL" VARCHAR(64) DEFAULT NULL,
"CODE" VARCHAR(24) DEFAULT NULL,
"COLOR" VARCHAR(24) DEFAULT NULL,
"STATUS" TINYINT DEFAULT NULL,
"CREATE_TIME" TIMESTAMP(0) DEFAULT NULL,
"UPDATE_TIME" TIMESTAMP(0) DEFAULT NULL,
"POSITION" VARCHAR(50),
"OFFSET" INT,
"LABELCFG" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP_LINE"."LABELCFG" IS '名称定位（refY，refX）';


CREATE TABLE "MONITOR_VISUAL"."RT_MAP_POINT"
(
"ID" INT IDENTITY(175, 1) NOT NULL,
"LINE_CODE" VARCHAR(50),
"LABEL" VARCHAR(128) DEFAULT NULL,
"CODE" VARCHAR(24) DEFAULT NULL,
"DESCRIPTION" VARCHAR(64) DEFAULT NULL,
"POSITION" VARCHAR(255) DEFAULT NULL,
"OFFSET" INT DEFAULT NULL,
"COORDINATE" VARCHAR(64) DEFAULT NULL,
"STATUS" TINYINT DEFAULT NULL,
"CREATE_TIME" TIMESTAMP(0) DEFAULT NULL,
"UPDATE_TIME" TIMESTAMP(0) DEFAULT NULL,
"SHAPE" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MAP_POINT"."SHAPE" IS '自定义动画';


CREATE TABLE "MONITOR_VISUAL"."RT_MEDIA_MANAGE"
(
"ID" VARCHAR(200) NOT NULL,
"FILE_NAME" VARCHAR(135),
"FILE_PATH" VARCHAR(384),
"FILE_TYPE" TINYINT DEFAULT 0,
"FILE_SIZE" INT DEFAULT 0,
"IP" CHAR(45),
"CREATE_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MEDIA_MANAGE"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MEDIA_MANAGE"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_MEDIA_MANAGE"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_METER_TYPE"
(
"METER_ID" INT,
"METER_NAME" VARCHAR(150),
"REMARK" VARCHAR(150),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_OIL_LIMIT"
(
"OIL_LEVEL_TAG" INT,
"OIL_TEMPERATURE_TAGS" VARCHAR(90),
"COEFFICIENT" DECIMAL(8,2),
"ERROR" INT,
"CREATE_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_LIMIT"."COEFFICIENT" IS '系数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_LIMIT"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_LIMIT"."ERROR" IS '误差';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_LIMIT"."OIL_LEVEL_TAG" IS '油位';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_LIMIT"."OIL_TEMPERATURE_TAGS" IS '油温';


CREATE TABLE "MONITOR_VISUAL"."RT_OIL_RECORD"
(
"ID" VARCHAR(200) NOT NULL,
"TASK_DATE" TIMESTAMP(0),
"OIL_LEVEL_TAG" INT,
"LIMIT_VALUE" INT,
"STATUS" INT DEFAULT 1,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_RECORD"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_RECORD"."ID" IS '主键ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OIL_RECORD"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_OVERHAUL_AREA"
(
"ID" INT,
"X1" DECIMAL(8,2) DEFAULT 0.,
"Y1" DECIMAL(8,2) DEFAULT 0.,
"X2" DECIMAL(8,2) DEFAULT 0.,
"Y2" DECIMAL(8,2) DEFAULT 0.,
"X3" DECIMAL(8,2) DEFAULT 0.,
"Y3" DECIMAL(8,2) DEFAULT 0.,
"X4" DECIMAL(8,2) DEFAULT 0.,
"Y4" DECIMAL(8,2) DEFAULT 0.,
"MARK" VARCHAR(384),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_OVERHAUL_AREA" IS '检修区域';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."ID" IS 'ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."MARK" IS '描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."X1" IS 'X1坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."X2" IS 'X2坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."X3" IS 'X3坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."X4" IS 'X4坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."Y1" IS 'Y1坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."Y2" IS 'Y2坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."Y3" IS 'Y3坐标';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_OVERHAUL_AREA"."Y4" IS 'Y4坐标';


CREATE TABLE "MONITOR_VISUAL"."RT_RADAR"
(
"ID" VARCHAR(200) NOT NULL,
"X" DECIMAL(8,2),
"Y" DECIMAL(8,2),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_RADAR" IS '雷达';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RADAR"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RADAR"."ID" IS '主键自增';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RADAR"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RADAR"."X" IS 'x';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RADAR"."Y" IS 'y';


CREATE TABLE "MONITOR_VISUAL"."RT_RECHECK_DEVICE"
(
"ID" VARCHAR(200) NOT NULL,
"DEVICE_TAG" INT,
"DEVICE_STATUS" TINYINT DEFAULT 0,
"TASK_SERIAL" INT DEFAULT 1,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_RECHECK_DEVICE" IS '缺陷设备记录';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RECHECK_DEVICE"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RECHECK_DEVICE"."DEVICE_STATUS" IS '0-未执行；1-正在执行；2-暂停；3-完成；4-连接异常（下发表计读取异常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RECHECK_DEVICE"."DEVICE_TAG" IS '设备标示ID，唯一存在';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RECHECK_DEVICE"."ID" IS 'ID主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RECHECK_DEVICE"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RECHECK_DEVICE"."TASK_SERIAL" IS '任务执行顺序';


CREATE TABLE "MONITOR_VISUAL"."RT_RECOGNIZE_TYPE"
(
"RECOGNIZE_ID" INT,
"RECOGNIZE_NAME" VARCHAR(150),
"REMARK" VARCHAR(150),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_ROBOT_INFO"
(
"ID" VARCHAR(100) DEFAULT 1,
"RT_TEM" DECIMAL(8,2),
"RT_X" DECIMAL(8,2),
"RT_Y" DECIMAL(8,2),
"RT_THETA" DECIMAL(8,2),
"RT_BATTERY" DECIMAL(8,2),
"RT_BLOCKED" TINYINT,
"RT_IS_CHARGED" TINYINT,
"RT_RUNNING_MODE" TINYINT,
"RT_FORWARD_SPEED" DECIMAL(8,2),
"RT_ROTATE_SPEED" DECIMAL(8,2),
"RT_CHARGE_VOLTAGE" DECIMAL(8,2),
"RT_CHARGE_CURRENT" DECIMAL(8,2),
"RT_RADAR_DISTANCE" DECIMAL(8,2),
"RT_RADAR_ANGLE" DECIMAL(8,2),
"RT_TASK_STATUS" TINYINT DEFAULT 0,
"RT_NEXT_TASK" INT DEFAULT 0,
"RT_ARRIVE" TINYINT DEFAULT 0,
"RT_DOOR_ENABLE" TINYINT DEFAULT 1,
"RT_CHARGE_DOOR" TINYINT,
"RT_RUN_DAY" BIGINT,
"RT_RUN_TIME" BIGINT,
"RT_CHECK_NUM" INT,
"RT_RUN_MIL" DECIMAL(16,2),
"RT_STATUS" TINYINT,
"RT_CAMERA_K" TINYINT,
"RT_CAMERA_H" TINYINT,
"RT_BACK" TINYINT DEFAULT 0,
"RT_LOWER" TINYINT DEFAULT 0,
"RT_RESTART" TINYINT DEFAULT 0,
"RT_ULTRASONIC" TINYINT DEFAULT 0,
"RT_DROP" TINYINT DEFAULT 0,
"RT_CHARGE_POINT" TINYINT DEFAULT 0,
"RT_HOME_COMMUNICATE" TINYINT DEFAULT 0,
"RT_IS_STOP" TINYINT DEFAULT 0,
"RT_CAR_STOP" TINYINT DEFAULT 0,
"RT_HUMIDITY" DECIMAL(8,2),
"RT_CLOUD_TURN" DECIMAL(8,2),
"RT_CLOUD_PIT" DECIMAL(8,2),
"RT_CLOUD_RATE" DECIMAL(8,2),
"RT_OTHER_POINT" VARCHAR(384),
"RT_ROBOT_NAME" VARCHAR(192),
"RT_CLOUD_PARAM_PATH" VARCHAR(384) DEFAULT 'D:\config_temp\deviceInfos.xml',
"RT_CONFIDENCE" DECIMAL(8,2) DEFAULT 1.,
"RT_TRAJECTORY" TINYINT DEFAULT 0,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
"ROBOT_TYPE" TINYINT DEFAULT 1,
"RT_WIPER_STATUS" TINYINT,
"RT_LOADMAP" INTEGER,
"RT_LEFT_WHEEL_SPEED" DECIMAL(22,6),
"RT_RIGHT_WHEEL_SPEED" DECIMAL(22,6),
"RT_OUT_ELECTRIC_CURRENT" DECIMAL(22,6),
"RT_OUT_VOLTAGE" DECIMAL(22,6),
"RT_INFRARED_STATUS" DECIMAL(22,6),
"RT_LIGHT_STATUS" DECIMAL(22,6),
"RT_AVOIDING_STATUS" INTEGER,
"RT_OVERHAUL_AREA_STATUS" INTEGER) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_ROBOT_INFO" IS '机器人信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."ID" IS '机器人标记（只有一个值为1），只有一条记录';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."ROBOT_TYPE" IS '机器人类型 1变电机器人    2配电机器人';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_ARRIVE" IS '到达状态（2-正在前往，4-到达）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_BACK" IS '有任务执行时，电量到点自动返回充电时置1（电量低于下限20%时置1，否则置0）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_BATTERY" IS '电池电量';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_BLOCKED" IS '是否被阻挡（0否，1是）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CAMERA_H" IS '红外状态（0异常，1正常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CAMERA_K" IS '可见光状态（0异常，1正常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CAR_STOP" IS '是否急停（本体急停）（0 否，1 是）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CHARGE_CURRENT" IS '充电电流';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CHARGE_DOOR" IS '充电房门状态（0关闭，1开启，2异常，3半开）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CHARGE_POINT" IS '充电触点状态（0可用，1不可用，2触点通讯异常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CHARGE_VOLTAGE" IS '充电电压';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CHECK_NUM" IS '累计巡检设备数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CLOUD_PARAM_PATH" IS '巡检线路附加点（格式：x,y,cx1,cy1,cx2,cy2）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CLOUD_PIT" IS '云台转向角度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CLOUD_RATE" IS '云台俯仰角度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CLOUD_TURN" IS '湿度（%RH）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_CONFIDENCE" IS '云台参数配置文件路径';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_DOOR_ENABLE" IS '充电房门按钮使能状态（0：不可控制；1：可以控制）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_DROP" IS '跌落使能（0使能，1不使能）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_FORWARD_SPEED" IS '前进速度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_HOME_COMMUNICATE" IS '充电房通讯状态（0 正常，1异常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_HUMIDITY" IS '温度（摄氏度）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_IS_CHARGED" IS '是否在充电（0否，1是，2充电失败，3正在前往充电）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_IS_STOP" IS '是否急停（站控急停）（0 否，1 是）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_LOWER" IS '充电中低电量模式（电量低于上限80%时置1，否则置0）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_NEXT_TASK" IS '下项任务ID（-999表示没有）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_OTHER_POINT" IS '云台上视频倍率';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RADAR_ANGLE" IS '雷达角度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RADAR_DISTANCE" IS '雷达距离';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RESTART" IS '重定位状态（0-failed,1-success,2-relocing,3-completed）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_ROBOT_NAME" IS '机器人名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_ROTATE_SPEED" IS '转弯速度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RUNNING_MODE" IS '运行模式（0手动，1自动）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RUN_DAY" IS '运行天数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RUN_MIL" IS '累计运行里程';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_RUN_TIME" IS '本次运行时长';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_STATUS" IS '机器人状态（0不可用，1可用）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_TASK_STATUS" IS '任务状态（0正在执行，1-执行完成，2-执行失败）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_TEM" IS '温度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_THETA" IS '位置朝向角度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_ULTRASONIC" IS '超声使能（0使能，1不使能）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_X" IS '位置X';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROBOT_INFO"."RT_Y" IS '位置Y';


CREATE TABLE "MONITOR_VISUAL"."RT_ROOM_INFO"
(
"ID" INT IDENTITY(2, 1) NOT NULL,
"ROOM_CODE" VARCHAR(120),
"ROOM_NAME" VARCHAR(200),
"ROOM_TYPE" TINYINT DEFAULT 0,
"ROOM_ENABLE" TINYINT DEFAULT 0,
"ALL_CODE" VARCHAR(120),
"WEB_IP" VARCHAR(80),
"WEB_PORT" VARCHAR(80),
"STATION_CODE" VARCHAR(120),
"IS_METRO" TINYINT DEFAULT 0,
"CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"UPDATE_TIME" TIMESTAMP(0),
"DELETE_FLAG" TINYINT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_ROOM_INFO" IS '房间基础信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."ALL_CODE" IS '全路径编码（线路编码_站所编码_区域编码）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."DELETE_FLAG" IS '删除标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."IS_METRO" IS '是否属于地铁(0-是  1-否)';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."ROOM_CODE" IS '区域编码(房间)';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."ROOM_ENABLE" IS '是否启用（0：未启用、1：启用）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."ROOM_NAME" IS 'room_name';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."ROOM_TYPE" IS '房间类型（0：变电、1：配电、2：其他待定）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."STATION_CODE" IS '主站所编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_ROOM_INFO"."UPDATE_TIME" IS '更新时间';


CREATE TABLE "MONITOR_VISUAL"."RT_RUN_LINE"
(
"ID" VARCHAR(200) NOT NULL,
"POINT_TAG" INT,
"TASK_ID" INT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_RUN_LINE" IS '执行路线';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RUN_LINE"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RUN_LINE"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RUN_LINE"."POINT_TAG" IS '点ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RUN_LINE"."ROBOT_ID" IS '机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_RUN_LINE"."TASK_ID" IS '任务id';


CREATE TABLE "MONITOR_VISUAL"."RT_SMS"
(
"ID" VARCHAR(200) NOT NULL,
"CREATE_TIME" VARCHAR(60),
"UPDATE_TIME" VARCHAR(60),
"PHONE" VARCHAR(60),
"SMSCONTENT" VARCHAR(765),
"STATE" VARCHAR(15),
"DEVICE_TAG" INT,
"REQUEST_ID" VARCHAR(765),
"TIMES" INT,
"ALARM_TYPE" TINYINT,
"DEVICE_NAME" VARCHAR(384),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_SMS" IS '短信发送记录';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS"."ID" IS '主键ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS"."TIMES" IS '发送短信次数';


CREATE TABLE "MONITOR_VISUAL"."RT_SMS_CONFIG"
(
"ID" INT,
"USER_ID" INT,
"USER_NAME" VARCHAR(384),
"DEVICE_TAG" INT,
"SEND_FREQUENCY" TINYINT DEFAULT 0,
"ALARM_LEVEL" VARCHAR(60),
"SEND_TIME" TINYINT DEFAULT 0,
"DEVICE_NAME" VARCHAR(384),
"DATA_DATE" TIMESTAMP(0),
"ALARM_TYPE" TINYINT,
"CRONTAB_TIME" VARCHAR(384),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."ALARM_LEVEL" IS '告警等级 7-一般告警 8-严重告警 9-危急告警';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."ALARM_TYPE" IS '告警类型 1--设备告警  2--系统告警';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."CRONTAB_TIME" IS '定时发送时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."DEVICE_NAME" IS '设备名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."DEVICE_TAG" IS '点位ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."SEND_FREQUENCY" IS '发送频率 1-首次告警 2--重复告警';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."SEND_TIME" IS '发送时间 1-实时发送 2-巡检结束 3-定时发送';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."USER_ID" IS '接收人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SMS_CONFIG"."USER_NAME" IS '接收人账号';


CREATE TABLE "MONITOR_VISUAL"."RT_SPECIAL_TASK"
(
"ID" VARCHAR(200) NOT NULL,
"DEVICE_TAG" INT,
"DEVICE_STATUS" TINYINT DEFAULT 0,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_SPECIAL_TASK" IS '特巡任务详细';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SPECIAL_TASK"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SPECIAL_TASK"."DEVICE_STATUS" IS 'device_status	TINYINT(1)		是	0	0-未执行；1-正在执行；2-暂停；3-完成；4-连接异常（下发表计读取异常）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SPECIAL_TASK"."DEVICE_TAG" IS '设备标示ID，唯一存在';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SPECIAL_TASK"."ID" IS '主键ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SPECIAL_TASK"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_STATION_INFO"
(
"ID" INT IDENTITY(2, 1) NOT NULL,
"LINE_CODE" VARCHAR(120),
"STATION_CODE" VARCHAR(120),
"STATION_NAME" VARCHAR(200),
"STATION_LONGITUDE" DOUBLE,
"STATION_LATITUDE" DOUBLE,
"LINE_FLAG" TINYINT DEFAULT 0,
"CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"UPDATE_TIME" TIMESTAMP(0),
"DELETE_FLAG" TINYINT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_STATION_INFO" IS '站所基础信息，包括站室地理位置';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."DELETE_FLAG" IS '删除标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."LINE_CODE" IS '所属线路编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."LINE_FLAG" IS '是否属于地铁标记 0-是   1-否';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."STATION_CODE" IS '站所编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."STATION_LATITUDE" IS '纬度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."STATION_LONGITUDE" IS '经度';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."STATION_NAME" IS '站所名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_STATION_INFO"."UPDATE_TIME" IS '更新时间';


CREATE TABLE "MONITOR_VISUAL"."RT_STATION_ORG"
(
"ID" INTEGER IDENTITY(1, 1) NOT NULL,
"NAME" VARCHAR(50),
"CODE" VARCHAR(50),
"PID" INTEGER DEFAULT 0,
"LEVEL" INTEGER DEFAULT 1,
CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_SYSTEM_CONF"
(
"ID" VARCHAR(50) DEFAULT 1,
"LINE_COLOR" VARCHAR(60),
"HIGHER_AREA" VARCHAR(60),
"POINT_OUT" VARCHAR(60),
"POINT_WAIT" VARCHAR(60),
"POINT_RUN" VARCHAR(60),
"POINT_COMPELETE" VARCHAR(60),
"CHARGE_UP" DECIMAL(4,2),
"CHARGE_DOWN" DECIMAL(4,2),
"GO_BACK" INT,
"DEVICE_URL" VARCHAR(384),
"DEVICE_STATUS" INT,
"CAR_IP" VARCHAR(60),
"SYS_VERSION" VARCHAR(60),
"THREE_TEM_X" DECIMAL(8,2),
"VIDEO_PATH" VARCHAR(384),
"PICTURE_PATH" VARCHAR(384),
"LIGHT_ON_TIME" TIME(0),
"LIGHT_OFF_TIME" TIME(0),
"LIGHT_STATUS" TINYINT DEFAULT 1,
"DEFAULT_ACTION" TINYINT DEFAULT 0,
"STATION_NAME" VARCHAR(192),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
"WR_PORT_NAME" VARCHAR(20),
"LIGHT_IP" VARCHAR(20),
"INFRARED_IP" VARCHAR(20)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_SYSTEM_CONF" IS '系统配置';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."CAR_IP" IS '巡检车IP';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."CHARGE_DOWN" IS '电量下限，要暂停任务，去充电';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."CHARGE_UP" IS '电量上限，可以去做任务';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."DEFAULT_ACTION" IS '标识任务暂停/任务终止且30分钟无操作后的行为';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."DEVICE_STATUS" IS 'Device.xml导入状态（0导入中（开始导入时置为0），1导入完成，2导入失败）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."DEVICE_URL" IS 'device.xml导入地址URL';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."GO_BACK" IS '一键返航点';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."HIGHER_AREA" IS '高级区域颜色';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."LIGHT_OFF_TIME" IS '关灯时间点';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."LIGHT_ON_TIME" IS '开灯时间点';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."LIGHT_STATUS" IS '自动开关灯使能状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."LINE_COLOR" IS '线颜色';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."PICTURE_PATH" IS '截图存储位置';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."POINT_COMPELETE" IS '完成点的颜色';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."POINT_OUT" IS '默认点颜色';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."POINT_RUN" IS '执行中点颜色';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."POINT_WAIT" IS '等待执行点的颜色';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."ROBOT_ID" IS '机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."STATION_NAME" IS '变电站名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."SYS_VERSION" IS '系统版本号，每次换包更新';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."THREE_TEM_X" IS '三项温差阈值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_SYSTEM_CONF"."VIDEO_PATH" IS '录像视频存储位置';


CREATE TABLE "MONITOR_VISUAL"."RT_TASK_DATA"
(
"TASK_ID" INT,
"TASK_DATE" TIMESTAMP(0),
"END_DATE" TIMESTAMP(0),
"DEVICE_TOTAL" INT,
"DEVICE_BUG" INT,
"DEVICE_EXC" INT,
"TASK_DURATION" DECIMAL(8,2),
"WR_TEM" DECIMAL(8,2),
"WR_HUMIDITY" DECIMAL(8,2),
"WR_WIND_SPEED" DECIMAL(8,2),
"WR_WIND_DIR" INT,
"TASK_RESULT" TINYINT,
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."DEVICE_BUG" IS '设备缺陷数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."DEVICE_EXC" IS '设备异常数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."DEVICE_TOTAL" IS '设备总数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."END_DATE" IS '任务结束时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."ID" IS '主键iD';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."TASK_DATE" IS '任务日期';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."TASK_DURATION" IS '任务持续时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."TASK_ID" IS '任务Id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."TASK_RESULT" IS '任务执行结果（0-未执行；1-执行完成；2-被终止；3-超期）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."WR_HUMIDITY" IS '湿度 （%RH）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."WR_TEM" IS '温度 （摄氏度）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."WR_WIND_DIR" IS '风向（90为正东，180为正南，270为正西，360为正北）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DATA"."WR_WIND_SPEED" IS '风速（m/s）';


CREATE TABLE "MONITOR_VISUAL"."RT_TASK_DETAIL"
(
"TASK_ID" INT,
"DEVICE_TAG" INT,
"TASK_SERIAL" INT DEFAULT 1,
"DETAIL_STATUS" INT DEFAULT 0,
"AUTHORIZEID" VARCHAR(200),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_TASK_DETAIL" IS '任务详细';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."DETAIL_STATUS" IS '执行状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."DEVICE_TAG" IS '设备标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."TASK_ID" IS '关联rt_task_plane中的task_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_DETAIL"."TASK_SERIAL" IS '任务计划顺序';


CREATE TABLE "MONITOR_VISUAL"."RT_TASK_ERROR_CODE"
(
"ID" INT,
"ERROR_CODE" INT,
"ERROR_MEANING" VARCHAR(150),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TASK_PAUSE"
(
"ID" VARCHAR(200) NOT NULL,
"TASK_ID" INT,
"START_TIME" TIMESTAMP(0),
"PAUSE_TIME" TIMESTAMP(0),
"DEVICE_BUG" INT,
"DEVICE_NUM" INT,
"DEVICE_EXC" INT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_TASK_PAUSE" IS '暂停任务';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."DEVICE_BUG" IS '暂停任务当前设备缺陷数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."DEVICE_EXC" IS '暂停任务当前检查设备数量';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."DEVICE_NUM" IS '当前设备异常数,包括缺陷';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."PAUSE_TIME" IS '暂停时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."ROBOT_ID" IS '机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."START_TIME" IS '开始时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PAUSE"."TASK_ID" IS '任务ID，关联rt_task_plane表中的task_id';


CREATE TABLE "MONITOR_VISUAL"."RT_TASK_PLANE"
(
"TASK_ID" INT,
"TASK_NAME" VARCHAR(384),
"TASK_STATUS" TINYINT DEFAULT 0,
"TASK_READY" TINYINT DEFAULT 0,
"TASK_TIME" TIME(0),
"REPEAT_TYPE" TINYINT,
"REPEAT_TAG" VARCHAR(144),
"DEVICE_TOTAL" INT DEFAULT 0,
"EXPECT_TIME" DECIMAL(8,2) DEFAULT 0.,
"IS_RECHECK" TINYINT DEFAULT 0,
"TASK_MARK" VARCHAR(768),
"EDIT_TIME" TIMESTAMP(0),
"TASK_TYPE" TINYINT,
"SUB_TYPE" VARCHAR(66),
"AUTHORIZEID" VARCHAR(200),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_TASK_PLANE" IS '巡检任务';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."DEVICE_TOTAL" IS '该任务包含的设备总数';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."EDIT_TIME" IS '最后一次编辑时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."EXPECT_TIME" IS '任务预计时间，单位为小时，如0.60小时';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."ID" IS 'ID主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."IS_RECHECK" IS '执行完任务是否执行缺陷设备巡检0：不执行 1：执行';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."REPEAT_TAG" IS '重复附加标记, Repeat_type为0或1时为空；';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."REPEAT_TYPE" IS '重复类型，0:单次; 1:每日重复;';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."SUB_TYPE" IS '任务小类型';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_ID" IS '自增主键,-10:缺陷追踪；-2:充电；-1:返航；0特巡；大于0:例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_MARK" IS '任务描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_NAME" IS '任务名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_READY" IS '排序状态（0未排序，1排序完）,当rt_task_detail中的顺序排好后，该值变为1';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_STATUS" IS '任务状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_TIME" IS '任务执行时间，对应界面“执行时间”选项，【立即执行】赋值当前时间，【定时执行】赋值填写的时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TASK_PLANE"."TASK_TYPE" IS '任务大类型';


CREATE TABLE "MONITOR_VISUAL"."RT_THERMAL_DEFECT"
(
"ALARM_ID" INT,
"DEVICE_TAG" INT,
"BURN_TYPE" INT,
"ALARM_DATE" TIMESTAMP(0),
"ALARM_VALUE" VARCHAR(180),
"DATA_UNIT" VARCHAR(279),
"ALARM_LEVEL" TINYINT,
"ALARM_STATUS" TINYINT DEFAULT 1,
"CANCEL_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."ALARM_DATE" IS '告警时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."ALARM_LEVEL" IS '告警等级1';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."ALARM_STATUS" IS '审核状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."ALARM_VALUE" IS '结果';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."BURN_TYPE" IS '热成像类别1：电流制热型，2：电压制热型';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."CANCEL_TIME" IS '审核时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."DATA_UNIT" IS '单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_THERMAL_DEFECT"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_THERMAL_LIMIT"
(
"DEVICE_TAG" INT,
"UPPER_LIMIT" DECIMAL(10,0),
"LIMIT_MARK" VARCHAR(1152),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE"
(
"TREE_ID" BIGINT,
"DEVICE_NAME" VARCHAR(384),
"DEVICE_TAG" INT,
"PID" BIGINT,
"TREE_LEVEL" TINYINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
CHECK(TREE_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL1"
(
"LEVEL1_ID" BIGINT,
"LEVEL1_NAME" VARCHAR(384),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
CHECK(LEVEL1_ID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TREE_LEVEL1"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TREE_LEVEL1"."ROBOT_ID" IS '机器人ID';


CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL2"
(
"LEVEL2_ID" BIGINT,
"LEVEL2_NAME" VARCHAR(384),
"PID" BIGINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" CHAR(10),
CHECK(LEVEL2_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL3"
(
"LEVEL3_ID" BIGINT,
"LEVEL3_NAME" VARCHAR(384),
"PID" BIGINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" CHAR(200),
CHECK(LEVEL3_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL4"
(
"LEVEL4_ID" BIGINT,
"LEVEL4_NAME" VARCHAR(384),
"PID" BIGINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" CHAR(200),
CHECK(LEVEL4_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL5"
(
"LEVEL5_ID" BIGINT,
"LEVEL5_NAME" VARCHAR(384),
"PID" BIGINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
CHECK(LEVEL5_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL6"
(
"LEVEL6_ID" BIGINT,
"LEVEL6_NAME" VARCHAR(384),
"PID" BIGINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
CHECK(LEVEL6_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TREE_LEVEL7"
(
"LEVEL7_ID" BIGINT,
"DEVICE_NAME" VARCHAR(384),
"DEVICE_TAG" INT,
"PID" BIGINT,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
CHECK(LEVEL7_ID >= 0)
,CHECK(PID >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."RT_TRIPHASE_TEM"
(
"ID" VARCHAR(200) NOT NULL,
"TASK_ID" INT DEFAULT 0,
"TASK_DATE" TIMESTAMP(0),
"DEVICE_TAG_S" INT DEFAULT 0,
"TAG_S_NAME" VARCHAR(384),
"TAG_S_VALUE" DECIMAL(8,2) DEFAULT 0.,
"TAG_S_URL" VARCHAR(384),
"DEVICE_TAG_E" INT DEFAULT 0,
"TAG_E_NAME" VARCHAR(384),
"TAG_E_VALUE" DECIMAL(8,2) DEFAULT 0.,
"TAG_E_URL" VARCHAR(384),
"DIFFER_VALUE" DECIMAL(8,2) DEFAULT 0.,
"DIFFER_STATUS" TINYINT DEFAULT 0,
"CANCEL_TIME" TIMESTAMP(0),
"MARK" VARCHAR(192),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_TRIPHASE_TEM" IS '三相温差对比记录';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."CANCEL_TIME" IS '取消告警时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."DEVICE_TAG_E" IS '被对比设备Tag（如：B相）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."DEVICE_TAG_S" IS '对比设备Tag';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."DIFFER_STATUS" IS '对比状态（0：正常，1告警，2对比设备异常，3被对比设备异常，4两个都异常）5.对比设备缺项';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."DIFFER_VALUE" IS '对比差值（可为正负）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."ID" IS 'ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."MARK" IS '描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TAG_E_NAME" IS '被对比设备名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TAG_E_URL" IS '被对比设备url';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TAG_E_VALUE" IS '被对比设备值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TAG_S_NAME" IS '对比设备名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TAG_S_URL" IS '对比设备url地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TAG_S_VALUE" IS '对比设备值';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TASK_DATE" IS '执行时间（记录时间）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_TRIPHASE_TEM"."TASK_ID" IS '任务ID';


CREATE TABLE "MONITOR_VISUAL"."RT_UNIT"
(
"ID" INT DEFAULT 1,
"UNIT_ADDR" VARCHAR(192),
"UNIT_TITLE" VARCHAR(384),
"UNIT_TYPE" TINYINT DEFAULT 1,
"UNIT_SIGN" INT,
"UNIT_VALUE" TINYINT DEFAULT 0,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_UNIT" IS '车体部件';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."UNIT_ADDR" IS '取值地址,车里面控制器的地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."UNIT_SIGN" IS '区域标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."UNIT_TITLE" IS '区域名称，车体的某个模块';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."UNIT_TYPE" IS '区域类型';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_UNIT"."UNIT_VALUE" IS '区域值（0,1）';


CREATE TABLE "MONITOR_VISUAL"."RT_WEATHER_INFO"
(
"WR_ID" INT DEFAULT 1,
"WR_TEM" DECIMAL(8,2),
"WR_HUMIDITY" DECIMAL(8,2),
"WR_WIND_DIR" DECIMAL(22,6),
"WR_WIND_SPEED" DECIMAL(8,2),
"WR_RAINFALL" DECIMAL(8,2),
"WR_AIR_PRE" DECIMAL(8,2),
"AUTHORIZEID" VARCHAR(200),
"ROBOT_ID" VARCHAR(200),
"ID" VARCHAR(50)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_WEATHER_INFO" IS '实时气象信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_AIR_PRE" IS '气压（hPa）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_HUMIDITY" IS '湿度 （%RH）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_ID" IS 'ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_RAINFALL" IS '雨量（mm）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_TEM" IS '温度 （摄氏度）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_WIND_DIR" IS '风向（90为正东，180为正南，270为正西，360为正北）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_INFO"."WR_WIND_SPEED" IS '风速（m/s）';


CREATE TABLE "MONITOR_VISUAL"."RT_WEATHER_RECORD"
(
"WR_ID" INT,
"WR_TEM" DECIMAL(8,2),
"WR_HUMIDITY" DECIMAL(8,2),
"WR_WIND_DIR" INT,
"WR_WIND_SPEED" DECIMAL(8,2),
"WR_RAINFALL" DECIMAL(8,2),
"WR_AIR_PRE" DECIMAL(8,2),
"WR_DATE" TIMESTAMP(0),
"MARK" VARCHAR(384),
"AUTHORIZEID" VARCHAR(600),
"ID" VARCHAR(200) NOT NULL,
"ROBOT_ID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."RT_WEATHER_RECORD" IS '历史气象信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."AUTHORIZEID" IS '站室标识符';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."MARK" IS '备注';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_AIR_PRE" IS '气压（hPa）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_DATE" IS '记录时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_HUMIDITY" IS '湿度 （%RH）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_ID" IS '气象标记';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_RAINFALL" IS '雨量（mm）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_TEM" IS '温度 （摄氏度）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_WIND_DIR" IS '风向（90为正东，180为正南，270为正西，360为正北）';
COMMENT ON COLUMN "MONITOR_VISUAL"."RT_WEATHER_RECORD"."WR_WIND_SPEED" IS '风速（m/s）';


CREATE TABLE "MONITOR_VISUAL"."SECURITYTABLE"
(
"S_ID" INT,
"S_TIME" DATETIME(0),
"ISSTANDARD" TINYINT,
"AUTHORIZEID" VARCHAR(100)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."SECURITYTABLE" IS '作业信息以及安全作业信息表单';


CREATE TABLE "MONITOR_VISUAL"."TB_ALARM_RBT_FAULT"
(
"ALARM_RBT_FAULT_ID" INT,
"ALARM_RBT_FAULT_ROBOT_ID" INT,
"ALARM_RBT_FAULT_DESC" VARCHAR(400),
"AUTHORIZEID" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_ROBOT_IP" VARCHAR(200) DEFAULT NULL,
"ALARM_RBT_MEAS_ALARM_DEVICEID" INT DEFAULT NULL,
"ALARM_RBT_MEAS_ALARM_UNITID" INT DEFAULT NULL) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"
(
"ALARM_RBT_MEAS_ID" INT,
"ALARM_RBT_MEAS_JOB_RESULT_ID" INT,
"ALARM_RBT_MEAS_ALARM_DESC_CONTENT" VARCHAR(400),
"ALARM_RBT_MEAS_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_TASKNAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_JOBRESULTJOBID" VARCHAR(100),
"ALARM_RBT_MEAS_ALARM_UNITNAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_STATIONNAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_UNITTYPEMEASUNIT" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_THRESHOLD_RANGE" VARCHAR(100),
"ALARM_RBT_MEAS_ALARM_THRESHOLD_SYMBOL" INT,
"ALARM_STATUS" INT DEFAULT 0,
"ALARM_RBT_MEAS_ALARM_ROBOT_IP" VARCHAR(128) DEFAULT NULL,
"ALARM_RBT_MEAS_ALARM_DEVICEID" INT DEFAULT NULL,
"ALARM_RBT_MEAS_ALARM_UNITID" INT DEFAULT NULL,
"ALARM_RBT_MEAS_DEVICE_CODE" VARCHAR(10),
"ALARM_RBT_MEAS_ALARM_UNIT_CODE" VARCHAR(10),
"ALARM_RBT_MEAS_RAW_DATA" VARCHAR(255),
"ALARM_RBT_JOB_RESULT_TIME" DATETIME(0),
"ALARM_RBT_MEANS_PROCESSING_RULES" INT,
"ALARM_RBT_MEANS_PROCESSING_DESCRIPTION" VARCHAR(200),
"ALARM_RBT_MEANS_PROCESSING_IMG" VARCHAR(300),
"ALARM_RBT_MEANS_ALARM_REAL_ITEM" VARCHAR(50),
"ALARM_RBT_MEANS_ALARM_LEVEL" CHAR(1),
"ALARM_RBT_MEANS_ALARM_THRESHOLD" VARCHAR(50)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_JOB_RESULT_TIME" IS '来自机器人侧巡检时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEANS_ALARM_LEVEL" IS '告警类型 1预警 2 一般 3 严重 4 危急';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEANS_ALARM_REAL_ITEM" IS '告警事项';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEANS_ALARM_THRESHOLD" IS '告警阈值标识 对应的报警级别的阈值标识 大于 10 、小于 1';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEANS_PROCESSING_DESCRIPTION" IS '处理描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEANS_PROCESSING_IMG" IS '处理告警图片上传路径';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEANS_PROCESSING_RULES" IS '处理规则 1 - 现场无异常 2 - 异常已处理 3 - 异常需要进一步跟踪 4 - 异常，但在允许范围内';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEAS_ALARM_UNIT_CODE" IS '巡检点code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEAS_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ALARM_RBT_MEAS"."ALARM_RBT_MEAS_RAW_DATA" IS '视觉拍照图片路径';


CREATE TABLE "MONITOR_VISUAL"."TB_APPROVE_RECORD"
(
"ID" VARCHAR(1200),
"USERID" VARCHAR(1200),
"TYPE" VARCHAR(1200),
"AUDITSTATUS" VARCHAR(1200),
"SUBMITPEOPLE" VARCHAR(1200),
"AUDITOR" VARCHAR(1200),
"AUDITOPINION" VARCHAR(1200),
"AUDITTIME" VARCHAR(1200),
"SUBMITTIME" VARCHAR(1200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_AUTHORITY"
(
"AUTHORITYID" VARCHAR(768) DEFAULT '',
"AUTHORITYNAME" VARCHAR(3900),
"DESCRIPTION" VARCHAR(3900),
"ISDISABLED" VARCHAR(3900)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_AUTHORITY_RESOURCE"
(
"ID" VARCHAR(768) DEFAULT '' NOT NULL,
"AUTHORITYID" VARCHAR(768),
"RESOURCEID" VARCHAR(768),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA"
(
"ID" INT,
"FACTORY" VARCHAR(150),
"IS_ROBOT_TYPE" INT DEFAULT 0,
"CAMERA_TYPE" INT DEFAULT 0,
"NAME" VARCHAR(384),
"IP" VARCHAR(45),
"PORT" INT,
"WEB_PORT" INT DEFAULT 80,
"IP_MAPPING" VARCHAR(45),
"PORT_MAPPING" INT,
"USER" VARCHAR(90),
"PWD" VARCHAR(90),
"RTSP_ADDR" VARCHAR(300),
"CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_CAMERA" IS '相机设备表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."CAMERA_TYPE" IS 'camera type, 0:可见光,1:红外';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."FACTORY" IS '相机厂家：1 - 海康 2 - 大华 3 - 宇视';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."ID" IS 'camera id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."IP" IS '相机设备的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."IP_MAPPING" IS '网关映射的相机设备的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."IS_ROBOT_TYPE" IS 'is_robot_type, 0:球机,1:机器人本体相机';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."NAME" IS '相机设备的名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."PORT" IS '相机设备的port';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."PORT_MAPPING" IS '网关映射的相机设备的port';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."PWD" IS '相机设备的密码';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."RTSP_ADDR" IS 'rtsp流地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."USER" IS '相机设备的用户名';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA"."WEB_PORT" IS '相机设备的web_port';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_ALARM_MEAS"
(
"ALARM_RBT_MEAS_ID" INT,
"ALARM_RBT_MEAS_JOB_RESULT_ID" INT,
"ALARM_RBT_MEAS_ALARM_DESC_CONTENT" VARCHAR(100),
"ALARM_RBT_MEAS_CREATED_TIME" TIMESTAMP(0),
"ALARM_RBT_MEAS_ALARM_TASKNAME" VARCHAR(100),
"ALARM_RBT_MEAS_ALARM_JOBRESULTJOBID" VARCHAR(10),
"ALARM_RBT_MEAS_ALARM_UNITNAME" VARCHAR(100),
"ALARM_RBT_MEAS_ALARM_STATIONNAME" VARCHAR(100),
"ALARM_RBT_MEAS_ALARM_UNITTYPEMEASUNIT" VARCHAR(100),
"ALARM_RBT_MEAS_ALARM_THRESHOLD_RANGE" VARCHAR(30),
"ALARM_RBT_MEAS_ALARM_THRESHOLD_SYMBOL" INT,
"ALARM_STATUS" INT,
"ALARM_RBT_MEAS_ALARM_CAMERA_IP" VARCHAR(20),
"ALARM_RBT_MEAS_DEVICE_CODE" VARCHAR(10),
"ALARM_RBT_MEAS_ALARM_DEVICEID" INT,
"ALARM_RBT_MEAS_ALARM_UNITID" INT,
"ALARM_RBT_MEAS_ALARM_UNIT_CODE" VARCHAR(10),
"ALARM_RBT_MEAS_RAW_DATA" VARCHAR(255),
"ALARM_RBT_JOB_RESULT_TIME" TIMESTAMP(0),
"ALARM_RBT_MEANS_PROCESSING_RULES" INT,
"ALARM_RBT_MEANS_PROCESSING_DESCRIPTION" VARCHAR(200),
"ALARM_RBT_MEANS_PROCESSING_IMG" VARCHAR(300),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_DEVICE"
(
"DEVICE_ID" INT,
"DEVICE_STATION_ID" INT,
"DEVICE_CODE" VARCHAR(30),
"DEVICE_NAME" VARCHAR(90),
"DEVICE_CAMERA_IP" VARCHAR(45),
"DEVICE_TYPE" VARCHAR(96),
"DEVICE_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"DEVICE_ABBR" VARCHAR(30),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_CAMERA_DEVICE" IS '相机设备表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_ABBR" IS '名称缩写';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_CAMERA_IP" IS '相机IP';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_CODE" IS '设备Code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_ID" IS 'ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_NAME" IS '设备名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_STATION_ID" IS 'station_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_DEVICE"."DEVICE_TYPE" IS '设备类型';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB"
(
"JOB_ID" INT,
"JOB_STATUS" INT,
"JOB_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_TASK_ID" INT,
"JOB_TASK_NAME" VARCHAR(240),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_MODE" IS '巡检模式: 
0 - 特巡  
1 - 定巡
2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_PRIORITY" IS 'Job的优先级';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_START" IS 'The start time of job';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_STATUS" IS 'The status of progress：0 - To be inspected 1 - Inspecting 2 - Inspected 3 - Cancel';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_STOP" IS 'The end time of job';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_TASK_ID" IS 'tb_task表的task id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB"."JOB_TASK_NAME" IS '任务名称';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_202004"
(
"JOB_ID" INT,
"JOB_STATUS" INT,
"JOB_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_TASK_ID" INT,
"JOB_TASK_NAME" VARCHAR(240),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_202009"
(
"JOB_ID" INT,
"JOB_STATUS" INT,
"JOB_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_CREATED_TIME" TIMESTAMP(0),
"JOB_TASK_ID" INT,
"JOB_TASK_NAME" VARCHAR(80),
"AUTHORIZEID" VARCHAR(200),
"JOB_TIME_LENGTH" VARCHAR(5)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_202010"
(
"JOB_ID" INT,
"JOB_STATUS" INT,
"JOB_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_CREATED_TIME" TIMESTAMP(0),
"JOB_TASK_ID" INT,
"JOB_TASK_NAME" VARCHAR(80),
"AUTHORIZEID" VARCHAR(200),
"JOB_TIME_LENGTH" VARCHAR(5)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_202011"
(
"JOB_ID" INT,
"JOB_STATUS" INT,
"JOB_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_CREATED_TIME" TIMESTAMP(0),
"JOB_TASK_ID" INT,
"JOB_TASK_NAME" VARCHAR(80),
"AUTHORIZEID" VARCHAR(200),
"JOB_TIME_LENGTH" VARCHAR(5)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"
(
"JOB_DYN_ID" INT,
"JOB_DYN_STATUS" INT,
"JOB_DYN_MODE" INT,
"JOB_DYN_PRIORITY" INT,
"JOB_DYN_START" TIMESTAMP(0),
"JOB_DYN_STOP" TIMESTAMP(0),
"JOB_DYN_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_DYN_TASK_ID" INT,
"JOB_DYN_TASK_NAME" VARCHAR(240),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_CREATED_TIME" IS '该记录入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_MODE" IS '巡检模式: 
0 - 特巡  
1 - 定巡
   2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_PRIORITY" IS 'Job dyn的优先级';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_START" IS '执行这条job dyn 的开始时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_STATUS" IS 'Job dyn的状态：
0–待检
 1– 检测中
 2–已检
 3-已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_STOP" IS '执行这条job dyn 的结束时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_TASK_ID" IS '对应tb_task表中的task_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_DYN"."JOB_DYN_TASK_NAME" IS '任务名称';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"
(
"JOB_RESULT_ID" INT,
"JOB_RESULT_JOB_ID" INT,
"JOB_RESULT_TASK_ITEM_ID" INT,
"JOB_RESULT_PROGRESS_STATUS" INT,
"JOB_RESULT_TIME" TIMESTAMP(0),
"JOB_RESULT_MEAS_UNIT" VARCHAR(30),
"JOB_RESULT_READING" VARCHAR(90),
"JOB_RESULT_RAW_DATA" VARCHAR(765),
"JOB_RESULT_STATUS" INT,
"JOB_RESULT_DESC" VARCHAR(90),
"JOB_RESULT_IS_DELETED" INT,
"JOB_RESULT_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_RESULT_CAMERA_IP" VARCHAR(45),
"JOB_RESULT_SYNC" INT DEFAULT 0,
"JOB_RESULT_TASK_ID" INT,
"JOB_RESULT_DEVICE_ID" INT,
"JOB_RESULT_UNIT_ID" INT,
"JOB_RESULT_THRESHOLD_RANGE" VARCHAR(90),
"JOB_RESULT_THRESHOLD_SYMBOL" INT DEFAULT 0,
"JOB_RESULT_TASK_NAME" VARCHAR(240),
"JOB_RESULT_UNIT_CODE" VARCHAR(30),
"JOB_RESULT_DEVICE_CODE" VARCHAR(30),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_CAMERA_IP" IS '相机ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_DESC" IS '巡检结果描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_IS_DELETED" IS '是否删除0=否 1=是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_JOB_ID" IS '在巡检队列中的作业ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_MEAS_UNIT" IS '巡检点的单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_PROGRESS_STATUS" IS '定义：
0：初始默认值或任务完成
1：摄像机初始化
2：摄像机抓取图片
3：温度传感器获取数据
4：湿度传感器获取数据
5：噪音传感器获取数据
6：臭氧传感器获取数据
7：红外传感器获取数据
8：超声波传感器获取数据
9：地电波传感器获取数据
10：超高频传感器获取数据
11：视觉识别
12：发送计划
13：接受计划
14：CH4传感器获取数据
15：CO2传感器获取数据
16：CO传感器获取数据
17：H2S传感器获取数据
18：O2传感器获取数据
19：SF6传感器获取数据
20：烟雾传感器获取数据';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_RAW_DATA" IS '视觉拍照图片路径';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_READING" IS '巡检结果的读数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_STATUS" IS 'Job result的状态 0: 待检 1: 检测中 2: 已检 3: 已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_SYNC" IS '该记录是否已经同步1是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_TASK_ITEM_ID" IS 'tb_task_item表的task_item_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_TASK_NAME" IS '任务名字';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_THRESHOLD_RANGE" IS '范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_THRESHOLD_SYMBOL" IS '当前阈值符号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_TIME" IS '来自机器人侧巡检时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT"."JOB_RESULT_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"
(
"JOB_RESULT_DYN_ID" INT,
"JOB_RESULT_DYN_JOB_DYN_ID" INT,
"JOB_RESULT_DYN_TASK_ITEM_ID" INT,
"JOB_RESULT_DYN_PROGRESS_STATUS" INT,
"JOB_RESULT_DYN_TIME" TIMESTAMP(0),
"JOB_RESULT_DYN_MEAS_UNIT" VARCHAR(30),
"JOB_RESULT_DYN_READING" VARCHAR(90),
"JOB_RESULT_DYN_RAW_DATA" VARCHAR(765),
"JOB_RESULT_DYN_STATUS" INT,
"JOB_RESULT_DYN_DESC" VARCHAR(90),
"JOB_RESULT_DYN_IS_DELETED" INT,
"JOB_RESULT_DYN_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_RESULT_DYN_CAMERA_IP" VARCHAR(45),
"JOB_RESULT_DYN_SYNC" INT,
"JOB_RESULT_DYN_TASK_ID" INT,
"JOB_RESULT_DYN_DEVICE_ID" INT,
"JOB_RESULT_DYN_UNIT_ID" INT,
"JOB_RESULT_DYN_THRESHOLD_RANGE" VARCHAR(90),
"JOB_RESULT_DYN_THRESHOLD_SYMBOL" INT DEFAULT 0,
"JOB_RESULT_DYN_TASK_NAME" VARCHAR(240),
"JOB_RESULT_DYN_UNIT_CODE" VARCHAR(30),
"JOB_RESULT_DYN_DEVICE_CODE" VARCHAR(30),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_CAMERA_IP" IS '相机ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_CREATED_TIME" IS '该记录入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_DESC" IS '巡检结果描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_JOB_DYN_ID" IS 'tb_job_dyn表的job_dyn_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_MEAS_UNIT" IS '巡检点的单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_PROGRESS_STATUS" IS '定义：
0：初始默认值或任务完成
1：摄像机初始化
2：摄像机抓取图片
3：温度传感器获取数据
4：湿度传感器获取数据 
5：噪音传感器获取数据 
6：臭氧传感器获取数据
7：红外传感器获取数据
8：超声波传感器获取数据
9：地电波传感器获取数据
10：超高频传感器获取数据
11：视觉识别
12：发送计划
13：接受计划
14：CH4传感器获取数据
15：CO2传感器获取数据
16：CO传感器获取数据
17：H2S传感器获取数据
18：O2传感器获取数据
19：SF6传感器获取数据
20：烟雾传感器获取数据';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_RAW_DATA" IS 'Raw data, 比如: 待识别的图片所在的路径名';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_READING" IS '巡检结果的读数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_STATUS" IS 'Job item的状态：
0: 待检
1: 检测中
2: 已检
3: 已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_SYNC" IS '该记录是否已经同步';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_TASK_ITEM_ID" IS 'tb_task_item表的task_item_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_TASK_NAME" IS '任务名字';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_THRESHOLD_RANGE" IS '范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_THRESHOLD_SYMBOL" IS '当前阈值符号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_TIME" IS '来自机器人侧巡检时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_JOB_RESULT_DYN"."JOB_RESULT_DYN_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_STATUS"
(
"ID" INT,
"CAMERA_IP" VARCHAR(45),
"CAMERA_STATUS" INT DEFAULT 0,
"ERROR_CODE" INT,
"ERROR_DESC" VARCHAR(150),
"CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_CAMERA_STATUS" IS '相机状态表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_STATUS"."CAMERA_IP" IS '相机设备的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_STATUS"."CAMERA_STATUS" IS '相机状态：0 - 正常 1 - 异常';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_STATUS"."ERROR_CODE" IS '相机设备的错误码';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_STATUS"."ERROR_DESC" IS '相机设备的错误描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_STATUS"."ID" IS 'id';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_TASK"
(
"TASK_ID" INT,
"TASK_STATION_ID" INT,
"TASK_NAME" VARCHAR(240),
"TASK_IS_DELETED" INT,
"TASK_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"TASK_MODE" INT,
"TASK_ENABLED" INT,
"TASK_DATETIME" TIMESTAMP(0),
"TASK_TIME" TIME(0),
"TASK_WEEKDAY" VARCHAR(21),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_CAMERA_TASK" IS '相机任务表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_DATETIME" IS '定巡的时间点';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_ENABLED" IS '任务状态 0 - 禁用 1 - 启用';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_ID" IS 'Task id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_IS_DELETED" IS '是否删除0=否 1=是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_MODE" IS '任务类型 0 - 特巡 1 - 定巡 2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_NAME" IS '名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_STATION_ID" IS '站室id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_TIME" IS '例巡的时间点';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK"."TASK_WEEKDAY" IS '星期几0-6';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"
(
"TASK_ITEM_ID" INT,
"TASK_ITEM_TASK_ID" INT,
"TASK_ITEM_STATION_ID" INT,
"TASK_ITEM_DEVICE_ID" INT,
"TASK_ITEM_DEVICE_CODE" VARCHAR(30),
"TASK_ITEM_UNIT_ID" INT,
"TASK_ITEM_UNIT_CODE" VARCHAR(30),
"TASK_ITEM_IS_DELETED" INT,
"TASK_ITEM_CAMERA_IP" VARCHAR(45),
"TASK_ITEM_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM" IS '相机任务点表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"."TASK_ITEM_CAMERA_IP" IS '相机的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"."TASK_ITEM_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"."TASK_ITEM_ID" IS 'Id of task item in a task.';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"."TASK_ITEM_IS_DELETED" IS '是否删除0=否 1=是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"."TASK_ITEM_STATION_ID" IS 'Station id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_TASK_ITEM"."TASK_ITEM_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_CAMERA_UNIT"
(
"UNIT_ID" INT,
"UNIT_CAMERA_IP" VARCHAR(45),
"UNIT_DEVICE_ID" INT,
"UNIT_DEVICE_CODE" VARCHAR(30),
"UNIT_CODE" VARCHAR(30),
"UNIT_NAME" VARCHAR(90),
"UNIT_TYPE" INT,
"UNIT_YAW" DOUBLE,
"UNIT_PITCH" DOUBLE,
"UNIT_THRESHOLD_ID" INT,
"UNIT_ZOOM" INT,
"UNIT_DESCRIPT" VARCHAR(600),
"UNIT_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"UNIT_FOCUS" INT,
"UNIT_MEAS_TYPE" VARCHAR(150),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_CAMERA_UNIT" IS '相机巡检点表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_CAMERA_IP" IS '所属相机的ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_CODE" IS '巡检点(检测项目)代号，由用户输入';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_DESCRIPT" IS '巡检点的描述信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_DEVICE_CODE" IS '机柜编号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_DEVICE_ID" IS '关联到tb_camera_device中的device_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_FOCUS" IS 'Camera焦距值';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_ID" IS 'Unit id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_MEAS_TYPE" IS '第三方需要的量测类型';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_NAME" IS 'Unit name';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_PITCH" IS 'Robot球体升降';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_THRESHOLD_ID" IS '关联到tb_threshold中的threshold_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_TYPE" IS 'The type of is inspected';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_YAW" IS 'Robot前进后退';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_CAMERA_UNIT"."UNIT_ZOOM" IS '巡检点Camera变焦';


CREATE TABLE "MONITOR_VISUAL"."TB_DEVICE"
(
"DEVICE_ID" INT,
"DEVICE_STATION_ID" INT,
"DEVICE_CODE" VARCHAR(20),
"DEVICE_NAME" VARCHAR(60),
"DEVICE_ROBOT_ID" INT,
"DEVICE_TYPE" VARCHAR(64) DEFAULT '',
"DEVICE_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"DEVICE_ABBR" VARCHAR(20),
"AUTHORIZEID" VARCHAR(100)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."AUTHORIZEID" IS '站室标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_ABBR" IS '名称缩写';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_CODE" IS '设备Code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_ID" IS 'ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_NAME" IS '设备名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_ROBOT_ID" IS '机器人ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_STATION_ID" IS 'station_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_DEVICE"."DEVICE_TYPE" IS '设备类型';


CREATE TABLE "MONITOR_VISUAL"."TB_ENV_POINT"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"NUMBER" INT,
"NAME" VARCHAR(300),
"TYPE" VARCHAR(50),
"COEFFICIENT" INTEGER,
"TABLE_FLAG" VARCHAR(50),
"DEVICECODE" VARCHAR(200),
CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_ENV_POINT" IS '环境检测点位信息表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."COEFFICIENT" IS '系数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."DEVICECODE" IS '设备编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."NAME" IS '点位名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."NUMBER" IS '序号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."TABLE_FLAG" IS '表标记，temp、env';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ENV_POINT"."TYPE" IS '点位类型：yc遥测，yx遥信';


CREATE TABLE "MONITOR_VISUAL"."TB_EXPERIENCE_SHARE"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_NAME" VARCHAR(400) DEFAULT '',
"REPORT_TYPE" INT,
"REPORT_DESC" VARCHAR(800),
"REPORT_ANAILSIS" VARCHAR(800),
"REPORT_SUMMARY" VARCHAR(800),
"REPORT_CONTENT" VARCHAR(800),
"REPORT_IMG_PATH" VARCHAR(2000),
"CREATED_TIME" TIMESTAMP(0),
"CREATEPEOPEL_NAME" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_JOB"
(
"JOB_ID" INT,
"JOB_ROBOT_ID" INT,
"JOB_STATUS" INT,
"JOB_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_TASK_ID" INT,
"JOB_TASK_NAME" VARCHAR(240),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_MODE" IS '巡检模式: 
0 - 特巡  
1 - 定巡
2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_PRIORITY" IS 'Job的优先级';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_ROBOT_ID" IS 'tb_robot 表的robot_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_START" IS 'The start time of job';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_STATUS" IS 'The status of progress：0 - To be inspected 1 - Inspecting 2 - Inspected 3 - Cancel';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_STOP" IS 'The end time of job';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_TASK_ID" IS 'tb_task表的task id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB"."JOB_TASK_NAME" IS '任务名称';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_DYN"
(
"JOB_DYN_ID" INT,
"JOB_DYN_ROBOT_ID" INT,
"JOB_DYN_STATUS" INT,
"JOB_DYN_MODE" INT,
"JOB_DYN_PRIORITY" INT,
"JOB_DYN_START" TIMESTAMP(0),
"JOB_DYN_STOP" TIMESTAMP(0),
"JOB_DYN_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_DYN_TASK_ID" INT DEFAULT NULL,
"JOB_DYN_TASK_NAME" VARCHAR(240) DEFAULT NULL,
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_CREATED_TIME" IS '该记录入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_MODE" IS '巡检模式: 
0 - 特巡  
1 - 定巡
   2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_PRIORITY" IS 'Job dyn的优先级';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_ROBOT_ID" IS 'tb_robot表的robot_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_START" IS '执行这条job dyn 的开始时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_STATUS" IS 'Job dyn的状态：
0–待检
 1– 检测中
 2–已检
 3-已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_STOP" IS '执行这条job dyn 的结束时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_TASK_ID" IS '对应tb_task表中的task_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_DYN"."JOB_DYN_TASK_NAME" IS '任务名称';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_PAUSE"
(
"JOB_PAUSE_ID" INT,
"JOB_PAUSE_ROBOT_ID" INT,
"JOB_PAUSE_STATUS" INT,
"JOB_PAUSE_MODE" INT,
"JOB_PAUSE_PRIORITY" INT,
"JOB_PAUSE_START" TIMESTAMP(0),
"JOB_PAUSE_STOP" TIMESTAMP(0),
"JOB_PAUSE_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_PAUSE_TASK_ID" INT DEFAULT NULL,
"JOB_PAUSE_TASK_NAME" VARCHAR(240) DEFAULT NULL,
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_MODE" IS '巡检模式: 
0 - 特巡  
1 - 定巡
2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_PRIORITY" IS 'Job的优先级';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_ROBOT_ID" IS 'tb_robot 表的robot_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_START" IS 'The start time of job';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_STATUS" IS 'The status of progress：0 - To be inspected 1 - Inspecting 2 - Inspected 3 - Cancel';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_STOP" IS 'The end time of job';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_TASK_ID" IS 'tb_task表的task id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_PAUSE"."JOB_PAUSE_TASK_NAME" IS '任务名称';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_RESULT"
(
"JOB_RESULT_ID" INT,
"JOB_RESULT_JOB_ID" INT,
"JOB_RESULT_TASK_ITEM_ID" INT,
"JOB_RESULT_PROGRESS_STATUS" INT,
"JOB_RESULT_TIME" TIMESTAMP(0),
"JOB_RESULT_MEAS_UNIT" VARCHAR(30),
"JOB_RESULT_READING" VARCHAR(90),
"JOB_RESULT_RAW_DATA" VARCHAR(765),
"JOB_RESULT_STATUS" INT,
"JOB_RESULT_DESC" VARCHAR(90),
"JOB_RESULT_IS_DELETED" INT,
"JOB_RESULT_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_RESULT_ROBOT_IP" VARCHAR(45),
"JOB_RESULT_SYNC" INT DEFAULT 0,
"JOB_RESULT_TASK_ID" INT,
"JOB_RESULT_DEVICE_ID" INT,
"JOB_RESULT_UNIT_ID" INT,
"JOB_RESULT_THRESHOLD_RANGE" VARCHAR(90),
"JOB_RESULT_THRESHOLD_SYMBOL" INT DEFAULT 0,
"JOB_RESULT_TASK_NAME" VARCHAR(240),
"JOB_RESULT_UNIT_CODE" VARCHAR(30),
"JOB_RESULT_DEVICE_CODE" VARCHAR(30),
"AUTHORIZEID" VARCHAR(150),
"JOB_RESULT_PENDING_TIME" TIMESTAMP(0),
"JOB_RESULT_INSPECTING_TIME" TIMESTAMP(0),
"JOB_RESULT_ALARM_STATUS" INT,
"JOB_RESULT_THRESHOLD_LIMIT" VARCHAR2(8188)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_ALARM_STATUS" IS '该结果是否报警：0 - 否 1 - 是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_CREATED_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_DESC" IS '巡检结果描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_INSPECTING_TIME" IS '检测中时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_IS_DELETED" IS '是否删除0=否 1=是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_JOB_ID" IS '在巡检队列中的作业ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_MEAS_UNIT" IS '巡检点的单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_PENDING_TIME" IS '待检测时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_PROGRESS_STATUS" IS '定义：
0：初始默认值或任务完成
1：摄像机初始化
2：摄像机抓取图片
3：温度传感器获取数据
4：湿度传感器获取数据
5：噪音传感器获取数据
6：臭氧传感器获取数据
7：红外传感器获取数据
8：超声波传感器获取数据
9：地电波传感器获取数据
10：超高频传感器获取数据
11：视觉识别
12：发送计划
13：接受计划
14：CH4传感器获取数据
15：CO2传感器获取数据
16：CO传感器获取数据
17：H2S传感器获取数据
18：O2传感器获取数据
19：SF6传感器获取数据
20：烟雾传感器获取数据';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_RAW_DATA" IS '视觉拍照图片路径';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_READING" IS '巡检结果的读数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_ROBOT_IP" IS '机器人ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_STATUS" IS 'Job result的状态 0: 待检 1: 检测中 2: 已检 3: 已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_SYNC" IS '该记录是否已经同步1是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_TASK_ITEM_ID" IS 'tb_task_item表的task_item_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_TASK_NAME" IS '任务名字';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_THRESHOLD_LIMIT" IS '阈值描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_THRESHOLD_RANGE" IS '范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_THRESHOLD_SYMBOL" IS '当前阈值符号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_TIME" IS '来自机器人侧巡检时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT"."JOB_RESULT_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"
(
"ID" INT,
"EARLY_WARNING_ID" INT,
"JOB_RESULT_ID" INT,
"UNIT_MEAS" VARCHAR(30),
"RESULT_READING" VARCHAR(90),
"UNIT_ID" INT,
"UNIT_CODE" VARCHAR(30),
"DEVICE_ID" INT,
"DEVICE_CODE" VARCHAR(30),
"THRESHOLD_RANGE" VARCHAR(90),
"THRESHOLD_SYMBOL" INT DEFAULT 0,
"ALARM_TYPE" INT DEFAULT 0,
"ALARM_STATUS" INT DEFAULT 0,
"ALARM_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"ROBOT_IP" VARCHAR(45),
"ALARM_CONTENT" VARCHAR(600),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM" IS '预测报警表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."ALARM_CONTENT" IS '报警内容描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."ALARM_STATUS" IS '预测报警状态 0-未处理 1-已处理';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."ALARM_TIME" IS '报警创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."ALARM_TYPE" IS '预测报警类型 0-模拟量 1-信号量';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."DEVICE_CODE" IS '设备代号，由用户输入';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."EARLY_WARNING_ID" IS '预测结果表id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."JOB_RESULT_ID" IS '巡检结果id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."RESULT_READING" IS '巡检结果的读数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."ROBOT_IP" IS '机器人ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."THRESHOLD_RANGE" IS '范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."THRESHOLD_SYMBOL" IS '当前阈值符号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."UNIT_CODE" IS '巡检点(检测项目)代号，由用户输入';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_ALARM"."UNIT_MEAS" IS '巡检点的单位';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"
(
"JOB_RESULT_DYN_ID" INT,
"JOB_RESULT_DYN_JOB_DYN_ID" INT,
"JOB_RESULT_DYN_TASK_ITEM_ID" INT,
"JOB_RESULT_DYN_PROGRESS_STATUS" INT,
"JOB_RESULT_DYN_TIME" TIMESTAMP(0),
"JOB_RESULT_DYN_MEAS_UNIT" VARCHAR(30),
"JOB_RESULT_DYN_READING" VARCHAR(90),
"JOB_RESULT_DYN_RAW_DATA" VARCHAR(765),
"JOB_RESULT_DYN_STATUS" INT,
"JOB_RESULT_DYN_DESC" VARCHAR(90),
"JOB_RESULT_DYN_IS_DELETED" INT,
"JOB_RESULT_DYN_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_RESULT_DYN_ROBOT_IP" VARCHAR(45),
"JOB_RESULT_DYN_SYNC" INT DEFAULT 0,
"JOB_RESULT_DYN_TASK_ID" INT,
"JOB_RESULT_DYN_DEVICE_ID" INT,
"JOB_RESULT_DYN_UNIT_ID" INT,
"JOB_RESULT_DYN_THRESHOLD_RANGE" VARCHAR(90),
"JOB_RESULT_DYN_THRESHOLD_SYMBOL" INT DEFAULT 0,
"JOB_RESULT_DYN_TASK_NAME" VARCHAR(240),
"JOB_RESULT_DYN_UNIT_CODE" VARCHAR(30),
"JOB_RESULT_DYN_DEVICE_CODE" VARCHAR(30),
"AUTHORIZEID" VARCHAR(150),
"JOB_RESULT_DYN_PENDING_TIME" TIMESTAMP(6),
"JOB_RESULT_DYN_INSPECTING_TIME" TIMESTAMP(6),
"JOB_RESULT_DYN_ALARM_STATUS" INT,
"JOB_RESULT_DYN_THRESHOLD_LIMIT" VARCHAR2(50)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_ALARM_STATUS" IS '该结果是否报警：0 - 否 1 - 是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_CREATED_TIME" IS '该记录入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_DESC" IS '巡检结果描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_INSPECTING_TIME" IS '检测中时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_JOB_DYN_ID" IS 'tb_job_dyn表的job_dyn_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_MEAS_UNIT" IS '巡检点的单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_PENDING_TIME" IS '待检测时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_PROGRESS_STATUS" IS '定义：
0：初始默认值或任务完成
1：摄像机初始化
2：摄像机抓取图片
3：温度传感器获取数据
4：湿度传感器获取数据 
5：噪音传感器获取数据 
6：臭氧传感器获取数据
7：红外传感器获取数据
8：超声波传感器获取数据
9：地电波传感器获取数据
10：超高频传感器获取数据
11：视觉识别
12：发送计划
13：接受计划
14：CH4传感器获取数据
15：CO2传感器获取数据
16：CO传感器获取数据
17：H2S传感器获取数据
18：O2传感器获取数据
19：SF6传感器获取数据
20：烟雾传感器获取数据';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_RAW_DATA" IS 'Raw data, 比如: 待识别的图片所在的路径名';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_READING" IS '巡检结果的读数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_ROBOT_IP" IS '机器人ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_STATUS" IS 'Job item的状态：
0: 待检
1: 检测中
2: 已检
3: 已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_SYNC" IS '该记录是否已经同步';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_TASK_ITEM_ID" IS 'tb_task_item表的task_item_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_TASK_NAME" IS '任务名字';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_THRESHOLD_LIMIT" IS '阈值描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_THRESHOLD_RANGE" IS '范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_THRESHOLD_SYMBOL" IS '当前阈值符号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_TIME" IS '来自机器人侧巡检时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_DYN"."JOB_RESULT_DYN_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_RESULT_MAP"
(
"JOB_RESULT_MAP_ID" INT,
"JOB_RESULT_MAP_METER_NAME" VARCHAR(192),
"JOB_RESULT_MAP_TEXT" VARCHAR(192),
"JOB_RESULT_MAP_VALUE" INT,
"JOB_RESULT_MAP_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_JOB_RESULT_MAP" IS '巡检结果映射表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_MAP"."JOB_RESULT_MAP_CREATED_TIME" IS '该记录入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_MAP"."JOB_RESULT_MAP_ID" IS 'job result map id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_MAP"."JOB_RESULT_MAP_TEXT" IS '表计设备的状态';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_MAP"."JOB_RESULT_MAP_VALUE" IS '该状态映射的值，画结果曲线使用该值';


CREATE TABLE "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"
(
"JOB_RESULT_PAUSE_ID" INT,
"JOB_RESULT_PAUSE_JOB_PAUSE_ID" INT,
"JOB_RESULT_PAUSE_TASK_ITEM_ID" INT,
"JOB_RESULT_PAUSE_PROGRESS_STATUS" INT,
"JOB_RESULT_PAUSE_TIME" TIMESTAMP(0),
"JOB_RESULT_PAUSE_MEAS_UNIT" VARCHAR(30),
"JOB_RESULT_PAUSE_READING" VARCHAR(90),
"JOB_RESULT_PAUSE_RAW_DATA" VARCHAR(765),
"JOB_RESULT_PAUSE_STATUS" INT,
"JOB_RESULT_PAUSE_DESC" VARCHAR(90),
"JOB_RESULT_PAUSE_IS_DELETED" INT,
"JOB_RESULT_PAUSE_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"JOB_RESULT_PAUSE_ROBOT_IP" VARCHAR(45),
"JOB_RESULT_PAUSE_SYNC" INT DEFAULT 0,
"JOB_RESULT_PAUSE_TASK_ID" INT,
"JOB_RESULT_PAUSE_DEVICE_ID" INT,
"JOB_RESULT_PAUSE_UNIT_ID" INT,
"JOB_RESULT_PAUSE_THRESHOLD_RANGE" VARCHAR(90),
"JOB_RESULT_PAUSE_THRESHOLD_SYMBOL" INT DEFAULT 0,
"JOB_RESULT_PAUSE_TASK_NAME" VARCHAR(240),
"JOB_RESULT_PAUSE_UNIT_CODE" VARCHAR(30),
"JOB_RESULT_PAUSE_DEVICE_CODE" VARCHAR(30),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_CREATED_TIME" IS '该记录入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_DESC" IS '巡检结果描述';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_JOB_PAUSE_ID" IS 'tb_job_pause表的job_pause_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_MEAS_UNIT" IS '巡检点的单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_PROGRESS_STATUS" IS '定义：
0：初始默认值或任务完成
1：摄像机初始化
2：摄像机抓取图片
3：温度传感器获取数据
4：湿度传感器获取数据 
5：噪音传感器获取数据 
6：臭氧传感器获取数据
7：红外传感器获取数据
8：超声波传感器获取数据
9：地电波传感器获取数据
10：超高频传感器获取数据
11：视觉识别
12：发送计划
13：接受计划
14：CH4传感器获取数据
15：CO2传感器获取数据
16：CO传感器获取数据
17：H2S传感器获取数据
18：O2传感器获取数据
19：SF6传感器获取数据
20：烟雾传感器获取数据';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_RAW_DATA" IS 'Raw data, 比如: 待识别的图片所在的路径名';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_READING" IS '巡检结果的读数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_ROBOT_IP" IS '机器人ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_STATUS" IS 'Job item的状态：
0: 待检
1: 检测中
2: 已检
3: 已取消';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_SYNC" IS '该记录是否已经同步';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_TASK_ITEM_ID" IS 'tb_task_item表的task_item_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_TASK_NAME" IS '任务名字';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_THRESHOLD_RANGE" IS '范围';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_THRESHOLD_SYMBOL" IS '当前阈值符号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_TIME" IS '来自机器人侧巡检时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_JOB_RESULT_PAUSE"."JOB_RESULT_PAUSE_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_LOG"
(
"ID" VARCHAR(384) DEFAULT '' NOT NULL,
"IPADDRESS" VARCHAR(3060),
"LOGOUTTIME" VARCHAR(3060),
"MODULENAME" VARCHAR(3060),
"OPERATOR" VARCHAR(3060),
"OPRCONTENT" VARCHAR(3060),
"OPRTIME" TIMESTAMP(0),
"OPRTYPE" VARCHAR(3060),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_MQ_MESSAGE"
(
"ID" INTEGER IDENTITY(1, 1) NOT NULL,
"SQL" LONGVARCHAR,
"TYPE" VARCHAR(10),
"CREATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIME,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NR_SUMMARY"
(
"ID" INT,
"ALARM_TYPE" VARCHAR(200),
"ALARM_COUNT" INT,
"AUTHORIZEID" VARCHAR(200),
"HEALTH_DEGREE" VARCHAR(6) DEFAULT '100') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_ALARM_RBT_FAULT"
(
"ALARM_RBT_FAULT_ID" INT,
"ALARM_RBT_FAULT_ROBOT_ID" INT,
"ALARM_RBT_FAULT_DESC" VARCHAR(400),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_ALARM_RBT_MEAS"
(
"ALARM_RBT_MEAS_ID" INT,
"ALARM_RBT_MEAS_JOB_RESULT_ID" INT,
"ALARM_RBT_MEAS_ALARM_DESC_CONTENT" VARCHAR(400),
"ALARM_RBT_MEAS_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200),
"ALARM_STATUS" INT DEFAULT 0,
"ALARM_RBT_MEAS_ALARM_TASKNAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_JOBRESULTJOBID" INT,
"ALARM_RBT_MEAS_ALARM_UNITNAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_STATIONNAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_UNITTYPEMEASUNIT" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_SCHEDULENAME" VARCHAR(200),
"ALARM_RBT_MEAS_ALARM_THRESHOLD_RANGE" VARCHAR(60),
"ALARM_RBT_MEAS_ALARM_THRESHOLD_SYMBOL" INT,
"ALARM_RBT_MEAS_ALARM_ROBOT_IP" VARCHAR(128) DEFAULT NULL,
"ALARM_RBT_MEAS_ALARM_DEVICEID" INT DEFAULT NULL,
"ALARM_RBT_MEAS_ALARM_UNITID" INT DEFAULT NULL) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_DEVICE"
(
"DEVICE_ID" INT,
"DEVICE_STATION_ID" INT,
"DEVICE_ROBOT_ID" INT,
"DEVICE_CODE" VARCHAR(128),
"DEVICE_NAME" VARCHAR(128),
"DEVICE_TYPE" VARCHAR(128) DEFAULT '',
"DEVICE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_JOB"
(
"JOB_ID" INT,
"JOB_TASK_ID" INT,
"JOB_START" TIMESTAMP(0),
"JOB_STOP" TIMESTAMP(0),
"JOB_STATUS" INT,
"JOB_INSERT_MODE" INT,
"JOB_PRIORITY" INT,
"JOB_ROBOT_ID" INT,
"JOB_QUEUE_ID" INT,
"JOB_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200),
"JOB_TASK_NAME" VARCHAR(80) DEFAULT NULL) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_JOB_RESULT"
(
"JOB_RESULT_ID" INT,
"JOB_RESULT_JOB_ID" INT,
"JOB_RESULT_STATUS" INT,
"JOB_RESULT_TIME" TIMESTAMP(0),
"JOB_RESULT_RESULT" VARCHAR(1024),
"JOB_RESULT_CONDITION" INT,
"JOB_RESULT_READING" VARCHAR(1024),
"JOB_RESULT_STATION_ID" INT,
"JOB_RESULT_DEVICE_ID" INT,
"JOB_RESULT_UNIT_ID" INT,
"JOB_RESULT_TASK_ID" INT,
"JOB_RESULT_SYNC" INT DEFAULT 0,
"JOB_RESULT_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"JOB_RESULT_THRESHOLD_SYMBOL" INT,
"JOB_RESULT_THRESHOLD_RANGE" VARCHAR(100),
"JOB_RESULT_SCHEDULE_NAME" VARCHAR(160),
"JOB_RESULT_TASK_NAME" VARCHAR(160)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_RBT_POS"
(
"RBT_POS_ID" INT,
"RBT_POS_ROBOT_IP" VARCHAR(60),
"RBT_POS_SLIDE" INT,
"RBT_POS_RISE" INT,
"RBT_POS_STRETCH_L" INT,
"RBT_POS_STRETCH_R" INT,
"RBT_POS_ZOOM_C" INT,
"RBT_POS_ZOOM_T" INT,
"RBT_POS_ROLL" INT,
"RBT_POS_PITCH" INT,
"RBT_POS_YAW" INT,
"RBT_POS_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_RBT_STATUS"
(
"RBT_STATUS_ID" INT,
"RBT_STATUS_ROBOT_IP" VARCHAR(60),
"RBT_STATUS_DISCHARGE_SENSOR" INT,
"RBT_STATUS_TEMP_SENSOR" INT,
"RBT_STATUS_NOISE_SENSOR" INT,
"RBT_STATUS_CAMERA" INT,
"RBT_STATUS_THERMAL" INT,
"RBT_STATUS_SLIDE_DRIVER" INT,
"RBT_STATUS_RISE_DRIVER" INT,
"RBT_STATUS_STRETCH_L_DRIVER" INT,
"RBT_STATUS_STRETCH_R_DRIVER" INT,
"RBT_STATUS_RISE_CODER" INT,
"RBT_STATUS_WIRELESS_ROUTER" INT,
"RBT_STATUS_DC_POWER_VOLTAGE" INT,
"RBT_STATUS_BATTERY" INT,
"RBT_STATUS_CHARGER" INT,
"RBT_STATUS_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_ROBOT"
(
"ROBOT_ID" INT,
"ROBOT_CODE" VARCHAR(40),
"ROBOT_NAME" VARCHAR(128),
"ROBOT_VERSION" VARCHAR(64),
"ROBOT_STATION_ID" INT,
"ROBOT_IP" VARCHAR(128),
"ROBOT_CAMERA_PORT" INT DEFAULT 0,
"ROBOT_CAMERA_USR" VARCHAR(128) DEFAULT '',
"ROBOT_CAMERA_PWD" VARCHAR(128) DEFAULT '',
"ROBOT_INFRARED_PORT" INT DEFAULT 0,
"ROBOT_INFRARED_TOKEN" VARCHAR(128),
"ROBOT_TYPE" INT,
"ROBOT_GCS_IP" VARCHAR(60),
"ROBOT_GCS_PORT" INT,
"ROBOT_PORT" INT,
"ROBOT_ENABLE" INT,
"ROBOT_CAMERA_WEB_PORT" INT,
"ROBOT_CREATED_TIME" TIMESTAMP(0),
"ROBOT_CAMERA_IP" VARCHAR(60),
"ROBOT_INFRARED_IP" VARCHAR(60),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_ROBOT_CAMERA_IP"
(
"ROBOT_CAMERA_PORT" INT DEFAULT 0,
"ROBOT_CAMERA_USR" VARCHAR(384) DEFAULT '',
"ROBOT_CAMERA_PWD" VARCHAR(384) DEFAULT '',
"ROBOT_INFRARED_PORT" INT DEFAULT 0,
"ROBOT_INFRARED_TOKEN" VARCHAR(384),
"ROBOT_CAMERA_WEB_PORT" INT,
"ROBOT_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"ROBOT_CAMERA_IP" VARCHAR(180),
"ROBOT_INFRARED_IP" VARCHAR(180),
"AUTHORIZEID" VARCHAR(600),
"ROBOT_INFRARED_FACTORY" INT,
"ROBOT_INFRARED_RTSP_ADDR" VARCHAR(128),
"ROBOT_SUPPORTED_GAS" VARCHAR(800),
"ENABLE" INT,
"ROBOT_IP" VARCHAR(128) DEFAULT NULL,
"ROBOT_ID" INT,
"MAPPING_CAMERA_IP" VARCHAR(50),
"MAPPING_CAMERA_PORT" VARCHAR(50),
"MAPPING_INFRARED_IP" VARCHAR(50),
"MAPPING_INFRARED_PORT" VARCHAR(50),
"GZ_INFRARED_PORT" VARCHAR(50)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_SCHEDULE"
(
"SCHEDULE_ID" INT,
"SCHEDULE_ROBOT_ID" INT,
"SCHEDULE_NAME" VARCHAR(320),
"SCHEDULE_MODE" INT,
"SCHEDULE_DATETIME" TIMESTAMP(0),
"SCHEDULE_TIME" TIME(0),
"SCHEDULE_WEEKDAY" VARCHAR(28),
"SCHEDULE_PRIORITY" INT,
"SCHEDULE_ENABLED" INT,
"SCHEDULE_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_SCHEDULE_ITEM"
(
"SCHEDULE_ITEM_ID" INT,
"SCHEDULE_ITEM_SCHEDULE_ID" INT,
"SCHEDULE_ITEM_NUMBER" INT,
"SCHEDULE_ITEM_TASK_ID" INT,
"SCHEDULE_ITEM_IS_DELETED" INT,
"SCHEDULE_ITEM_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_TASK"
(
"TASK_ID" INT,
"TASK_STATION_ID" INT,
"TASK_ROBOT_ID" INT,
"TASK_NAME" VARCHAR(320),
"TASK_IS_DELETED" INT,
"TASK_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_TASK_ITEM"
(
"TASK_ITEM_ID" INT,
"TASK_ITEM_TASK_ID" INT,
"TASK_ITEM_NUMBER" INT,
"TASK_ITEM_DEVICE_ID" INT,
"TASK_ITEM_UNIT_ID" INT,
"TASK_ITEM_STATION_ID" INT,
"TASK_ITEM_ROBOT_ID" INT,
"TASK_ITEM_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_THRESHOLD"
(
"THRESHOLD_ID" INT,
"THRESHOLD_UNIT_TYPE_ID" INT,
"THRESHOLD_NAME" VARCHAR(120),
"THRESHOLD_RANGE" VARCHAR(120),
"THRESHOLD_SYMBOL" INT,
"THRESHOLD_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_UNIT"
(
"UNIT_ID" INT,
"UNIT_DEVICE_ID" INT,
"UNIT_CODE" VARCHAR(128),
"UNIT_NUMBER" INT,
"UNIT_NAME" VARCHAR(128),
"UNIT_TYPE" INT,
"UNIT_TRUST" DOUBLE,
"UNIT_SLIDE" DOUBLE,
"UNIT_RISE" DOUBLE,
"UNIT_STRETCH" DOUBLE,
"UNIT_ZOOM_C" DOUBLE,
"UNIT_ZOOM_T" DOUBLE,
"UNIT_DESCRIPT" VARCHAR(800),
"UNIT_ROLL" DOUBLE,
"UNIT_PITCH" DOUBLE,
"UNIT_YAW" DOUBLE,
"UNIT_THRESHOLD_ID" INT,
"UNIT_CREATED_TIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_NT_UNIT_TYPE"
(
"UNIT_TYPE_ID" INT,
"UNIT_TYPE_NAME" VARCHAR(200),
"UNIT_MEAS_UNIT" VARCHAR(40),
"UNIT_TYPE_CREATED_TIME" TIMESTAMP(0),
"UNIT_TYPE_ICON" VARCHAR(1020),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_OVERHAUL"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"DEVICE_CODE" VARCHAR(200),
"DEVICE_NAME" VARCHAR(200),
"DEVICE_CLASS" INT,
"CREATE_TIME" TIMESTAMP(0),
"LAST_TIME" TIMESTAMP(0),
"THIS_TIME" TIMESTAMP(0),
"NEXT_TIME" TIMESTAMP(0),
"MAINTENANCE" VARCHAR(200),
"PHONE" VARCHAR(200),
"PROPOSAL" VARCHAR(200),
"DEVICE_TYPE" INT,
"CABINET_CODE" VARCHAR(200),
"AUTHORIZEID" VARCHAR(200),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"AUTHORIZEID" VARCHAR(200),
"ROBOT_CODE" VARCHAR(50),
"ROBOT_FACTORY" VARCHAR(50),
"MAINTENANCE_INFO" VARCHAR(500),
"MAINTENANCE_TIME" DATETIME(0),
"CREATE_USER" VARCHAR(50),
"CREATE_TIME" DATETIME(0),
"UPDATE_USER" VARCHAR(50),
"UPDATE_TIME" DATETIME(0),
"IS_DELETED" CHAR(1) DEFAULT 0,
"REMARK" VARCHAR(50),
"STATION_NAME" VARCHAR(50),
"ALARM_ID" VARCHAR(50),
CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE" IS '专业检修维护表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."ALARM_ID" IS '关联的机器缺陷报警id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."AUTHORIZEID" IS '主站标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."CREATE_USER" IS '创建者';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."ID" IS '主键id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."IS_DELETED" IS '是否删除';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."MAINTENANCE_INFO" IS '维护信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."MAINTENANCE_TIME" IS '维护时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."REMARK" IS '备用字段';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."ROBOT_CODE" IS '机器标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."ROBOT_FACTORY" IS '机器厂家';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."STATION_NAME" IS '站室名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_PROFESSIONAL_MAINTENANCE"."UPDATE_USER" IS '更新者';


CREATE TABLE "MONITOR_VISUAL"."TB_QUARTZ_JOB"
(
"ID" INTEGER IDENTITY(1, 1) NOT NULL,
"JOB_NAME" VARCHAR(100),
"JOB_GROUP" VARCHAR(100),
"JOB_CLASS_NAME" VARCHAR(200),
"CRON_EXPRESSION" VARCHAR(50),
"TRIGGER_STATE" VARCHAR(50),
"OLD_JOB_NAME" VARCHAR(150),
"OLD_JOB_GROUP" VARCHAR(150),
"DESCRIPTION" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_RBT_ME_STATUS"
(
"RBT_STATUS_ID" INT,
"RBT_STATUS_ROBOT_IP" VARCHAR(45),
"RBT_STATUS_SLIDE_DRIVER" INT,
"RBT_STATUS_RISE_DRIVER" INT,
"RBT_STATUS_STRETCH_L_DRIVER" INT,
"RBT_STATUS_STRETCH_R_DRIVER" INT,
"RBT_STATUS_YAW_DRIVER" INT,
"RBT_STATUS_PITCH_L_DRIVER" INT,
"RBT_STATUS_PITCH_R_DRIVER" INT,
"RBT_STATUS_SICK_SENSOR" INT,
"RBT_STATUS_SLIDE_COMM" INT,
"RBT_STATUS_ROTATION_COMM" INT,
"RBT_STATUS_OFFLINE" INT,
"RBT_STATUS_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_RBT_ME_STATUS" IS '描述机器人本体故障报警信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_CREATED_TIME" IS '入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_ID" IS '状态ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_OFFLINE" IS '机器人离线';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_PITCH_L_DRIVER" IS '左俯仰驱动器';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_PITCH_R_DRIVER" IS '右俯仰驱动器';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_RISE_DRIVER" IS '升降驱动器';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_ROBOT_IP" IS 'Robot的ip地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_ROTATION_COMM" IS 'rotation通信';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_SICK_SENSOR" IS 'sick扫码枪';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_SLIDE_COMM" IS 'slide通信';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_SLIDE_DRIVER" IS '行走驱动器';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_STRETCH_L_DRIVER" IS '左手臂驱动器';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_STRETCH_R_DRIVER" IS '右手臂驱动器';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_ME_STATUS"."RBT_STATUS_YAW_DRIVER" IS '旋转驱动器';


CREATE TABLE "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"
(
"RBT_STATUS_ID" INT,
"RBT_STATUS_ROBOT_IP" VARCHAR(45),
"RBT_STATUS_RADAR_L" INT,
"RBT_STATUS_RADAR_R" INT,
"RBT_STATUS_RADAR_DOWN" INT,
"RBT_STATUS_INIT" INT,
"RBT_STATUS_RISE_INIT" INT,
"RBT_STATUS_YAW_INIT" INT,
"RBT_STATUS_STRETCH_L_INIT" INT,
"RBT_STATUS_STRETCH_R_INIT" INT,
"RBT_STATUS_PITCH_L_INIT" INT,
"RBT_STATUS_PITCH_R_INIT" INT,
"RBT_STATUS_BAR_CODE" INT,
"RBT_STATUS_SLIDE_STALL" INT,
"RBT_STATUS_RISE_STALL" INT,
"RBT_STATUS_YAW_STALL" INT,
"RBT_STATUS_INVALID_POS" INT,
"RBT_STATUS_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS" IS '描述机器人运行时故障报警信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_BAR_CODE" IS '条形码故障';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_CREATED_TIME" IS '入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_ID" IS '状态ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_INIT" IS '整体归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_INVALID_POS" IS '非法位置';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_PITCH_L_INIT" IS '左俯仰归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_PITCH_R_INIT" IS '右俯仰归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_RADAR_DOWN" IS '下方雷达';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_RADAR_L" IS '左侧雷达';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_RADAR_R" IS '右侧雷达';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_RISE_INIT" IS '升降归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_RISE_STALL" IS '升降堵转';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_ROBOT_IP" IS 'Robot的ip地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_SLIDE_STALL" IS '水平堵转';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_STRETCH_L_INIT" IS '左手臂归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_STRETCH_R_INIT" IS '右手臂归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_YAW_INIT" IS '旋转归零';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_RUNTIME_STATUS"."RBT_STATUS_YAW_STALL" IS '旋转堵转';


CREATE TABLE "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"
(
"RBT_STATUS_ID" INT,
"RBT_STATUS_ROBOT_IP" VARCHAR(45),
"RBT_STATUS_CAMERA" INT,
"RBT_STATUS_THERMAL" INT,
"RBT_STATUS_GROUND_DISCHARGE_SENSOR" INT,
"RBT_STATUS_ULTRA_DISCHARGE_SENSOR" INT,
"RBT_STATUS_O2_SENSOR" INT,
"RBT_STATUS_O3_SENSOR" INT,
"RBT_STATUS_CO2_SENSOR" INT,
"RBT_STATUS_NOISE_SENSOR" INT,
"RBT_STATUS_ENV_TEMP_SENSOR" INT,
"RBT_STATUS_ENV_HUMI_SENSOR" INT,
"RBT_STATUS_BOARD_TEMP_SENSOR" INT,
"RBT_STATUS_BOARD_HUMI_SENSOR" INT,
"RBT_STATUS_SMOKE_SENSOR" INT,
"RBT_STATUS_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS" IS '描述机器人传感器故障报警信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_BOARD_HUMI_SENSOR" IS '核心板湿度';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_BOARD_TEMP_SENSOR" IS '核心板温度';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_CAMERA" IS '高清相机';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_CO2_SENSOR" IS '二氧化碳';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_CREATED_TIME" IS '入库时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_ENV_HUMI_SENSOR" IS '环境湿度';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_ENV_TEMP_SENSOR" IS '环境温度';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_GROUND_DISCHARGE_SENSOR" IS '局放地电波';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_ID" IS '状态ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_NOISE_SENSOR" IS '噪音';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_O2_SENSOR" IS '氧气';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_O3_SENSOR" IS '臭氧';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_ROBOT_IP" IS 'Robot的ip地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_SMOKE_SENSOR" IS '烟雾';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_THERMAL" IS '红外相机';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_RBT_SENSOR_STATUS"."RBT_STATUS_ULTRA_DISCHARGE_SENSOR" IS '局放超声波';


CREATE TABLE "MONITOR_VISUAL"."TB_RBT_STATUS"
(
"RBT_STATUS_ID" INT,
"RBT_STATUS_ROBOT_IP" VARCHAR(30),
"RBT_STATUS_SICK_SENSOR" INT,
"RBT_STATUS_O2_SENSOR" INT,
"RBT_STATUS_O3_SENSOR" INT,
"RBT_STATUS_CH4_SENSOR" INT,
"RBT_STATUS_CO_SENSOR" INT,
"RBT_STATUS_CO2_SENSOR" INT,
"RBT_STATUS_H2S_SENSOR" INT,
"RBT_STATUS_SF6_SENSOR" INT,
"RBT_STATUS_DISCHARGE_SENSOR" INT,
"RBT_STATUS_TEMP_SENSOR" INT,
"RBT_STATUS_NOISE_SENSOR" INT,
"RBT_STATUS_CAMERA" INT,
"RBT_STATUS_THERMAL" INT,
"RBT_STATUS_SLIDE_DRIVER" INT,
"RBT_STATUS_RISE_DRIVER" INT,
"RBT_STATUS_STRETCH_L_DRIVER" INT,
"RBT_STATUS_STRETCH_R_DRIVER" INT,
"RBT_STATUS_RISE_CODER" INT,
"RBT_STATUS_WIRELESS_ROUTER" INT,
"RBT_STATUS_DC_POWER_VOLTAGE" INT,
"RBT_STATUS_BATTERY" INT,
"RBT_STATUS_CHARGER" INT,
"RBT_STATUS_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(400)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_RESOURCE"
(
"RESOURCEID" VARCHAR(600) DEFAULT '',
"DESCRIPTION" VARCHAR(600),
"FUNCS" VARCHAR(600),
"ISDISABLED" VARCHAR(600),
"ISMENU" VARCHAR(600),
"PARENTID" VARCHAR(3900),
"RESOURCENAME" VARCHAR(3900),
"RESOURCEURL" VARCHAR(600),
"SORTS" DECIMAL(11,0),
"RESOURCE_TYPE" VARCHAR(600),
"TYPE" CHAR(48),
"STATE" CHAR(48)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ROBOT"
(
"ROBOT_ID" INT,
"ROBOT_CODE" VARCHAR(30),
"ROBOT_NAME" VARCHAR(90),
"ROBOT_STATION_ID" INT,
"ROBOT_IP" VARCHAR(45),
"ROBOT_PORT" INT,
"ROBOT_CAMERA_PORT" INT DEFAULT 0,
"ROBOT_TYPE" INT,
"ROBOT_CAMERA_USR" VARCHAR(90) DEFAULT '',
"ROBOT_CAMERA_PWD" VARCHAR(90) DEFAULT '',
"ROBOT_INFRARED_PORT" INT DEFAULT 0,
"ROBOT_INFRARED_TOKEN" VARCHAR(96),
"ROBOT_VERSION" VARCHAR(48),
"ROBOT_GCS_IP" VARCHAR(45),
"ROBOT_GCS_PORT" INT,
"ROBOT_CAMERA_WEB_PORT" INT,
"ROBOT_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"ROBOT_CAMERA_IP" VARCHAR(45),
"ROBOT_INFRARED_IP" VARCHAR(45),
"ROBOT_INFRARED_FACTORY" INT,
"ROBOT_INFRARED_RTSP_ADDR" VARCHAR(192),
"ROBOT_CAMERA_RTSP_ADDR" VARCHAR(300),
"ROBOT_SUPPORTED_GAS" VARCHAR(1500),
"ROBOT_RISE_WARING_THRESHOLD" INT DEFAULT 40000,
"ROBOT_RISE_FATAL_THRESHOLD" INT DEFAULT 45000,
"ROBOT_RISE_COUNT" INT DEFAULT 0,
"ROBOT_RISE_PARAGRAPHS_STATISTICS" VARCHAR(765) DEFAULT NULL,
"ROBOT_RESERVE1" VARCHAR(90) DEFAULT NULL,
"ROBOT_RESERVE2" VARCHAR(90) DEFAULT NULL,
"ROBOT_RESERVE3" VARCHAR(90) DEFAULT NULL,
"AUTHORIZEID" VARCHAR(150),
"CHARGE_DOWN" INT) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_ROBOT" IS '机器人管理表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."CHARGE_DOWN" IS '低电量阈值';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CAMERA_IP" IS '机器人监控ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CAMERA_PORT" IS 'Robot port for Camera';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CAMERA_PWD" IS '机器人监控登录密码';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CAMERA_RTSP_ADDR" IS '相机rtsp流地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CAMERA_USR" IS '机器人监控登录名';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CAMERA_WEB_PORT" IS '机器人监控端口用于web插件';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_CODE" IS '机器人代号，由用户输入';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_ID" IS 'Robot id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_INFRARED_FACTORY" IS '红外设备的厂商0:Magnity 1:Flir';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_INFRARED_IP" IS '机器人红外ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_INFRARED_PORT" IS '机器人红外端口';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_INFRARED_RTSP_ADDR" IS '红外rtsp流地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_INFRARED_TOKEN" IS '机器人红外密钥';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_IP" IS 'Robot ip';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_NAME" IS 'Robot name';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_PORT" IS '机器人端口';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RESERVE1" IS '保留字段1';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RESERVE2" IS '保留字段2';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RESERVE3" IS '保留字段3';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RISE_COUNT" IS '机器人升降次数';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RISE_FATAL_THRESHOLD" IS '升降次数严重告警阈值';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RISE_PARAGRAPHS_STATISTICS" IS '机器人升降次数各段统计';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_RISE_WARING_THRESHOLD" IS '升降次数一般告警阈值';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_STATION_ID" IS '机器人所在站室ID';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_SUPPORTED_GAS" IS '支持的气体种类';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_TYPE" IS 'Robot type';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROBOT"."ROBOT_VERSION" IS '机器人版本';


CREATE TABLE "MONITOR_VISUAL"."TB_ROBOT_ALARM"
(
"ALARM_ID" INT,
"ALARM_ROBOT_IP" VARCHAR(15),
"ALARM_TYPE" INT,
"ALARM_NAME" VARCHAR(30),
"ALARM_STATUS" INT,
"ALARM_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ROLE"
(
"ID" VARCHAR(1152) DEFAULT '',
"BEWRITE" VARCHAR(3900),
"NAME" VARCHAR(3900),
"TYPE" VARCHAR(48)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ROLE_AUTHORITY"
(
"ID" VARCHAR(768) DEFAULT '' NOT NULL,
"AUTHORITYID" VARCHAR(768),
"ROLEID" VARCHAR(768),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ROLE_ORGAN"
(
"ID" VARCHAR(768) DEFAULT '' NOT NULL,
"USER_ID" VARCHAR(768),
"ORG_ID" VARCHAR(768),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ROLE_RESOURCE"
(
"ID" VARCHAR(768) DEFAULT '' NOT NULL,
"RESOURCE_ID" VARCHAR(768),
"ROLE_ID" VARCHAR(768),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_ROUTINE_PLAN"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"AUTHORIZEID" VARCHAR(200),
"PLAN_INFO" VARCHAR(1000),
"PLAN_TIME" DATETIME(0),
"PLAN_PEOPLE" VARCHAR(100),
"IS_DEFEND" CHAR(1),
"CREATE_USER" VARCHAR(50),
"CREATE_TIME" DATETIME(0),
"UPDATE_USER" VARCHAR(50),
"UPDATE_TIME" DATETIME(0),
"IS_DELETED" CHAR(1) DEFAULT 0,
"REMARK" VARCHAR(50),
"RECORD_INFO" VARCHAR(1000),
"RECORD_TIME" DATETIME(0),
"RECORD_PEOPLE" VARCHAR(100),
CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_ROUTINE_PLAN" IS '例行维护表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."AUTHORIZEID" IS '主站标识';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."CREATE_USER" IS '创建者';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."IS_DEFEND" IS '是否已维护 0 未维护 1已维护';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."IS_DELETED" IS '是否删除 0未删除 1已删除';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."PLAN_INFO" IS '维护计划信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."PLAN_PEOPLE" IS '维护人员';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."PLAN_TIME" IS '维护计划时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."RECORD_INFO" IS '维护记录信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."RECORD_PEOPLE" IS '维护记录人员';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."RECORD_TIME" IS '维护记录时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."REMARK" IS '备用字段';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_ROUTINE_PLAN"."UPDATE_USER" IS '更新者';


CREATE TABLE "MONITOR_VISUAL"."TB_SCHEDULE"
(
"SCHEDULE_ID" INT,
"SCHEDULE_NAME" VARCHAR(320),
"SCHEDULE_MODE" INT,
"SCHEDULE_DATETIME" TIMESTAMP(0),
"SCHEDULE_TIME" TIME(0),
"SCHEDULE_WEEKDAY" VARCHAR(28),
"SCHEDULE_PRIORITY" INT,
"SCHEDULE_ENABLED" INT,
"SCHEDULE_IS_DELETED" INT,
"SCHEDULE_ROBOT_ID" INT,
"SCHEDULE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SCHEDULE_ITEM"
(
"SCHEDULE_ITEM_ID" INT,
"SCHEDULE_ITEM_SCHEDULE_ID" INT,
"SCHEDULE_ITEM_TASK_ID" INT,
"SCHEDULE_ITEM_IS_DELETED" INT,
"SCHEDULE_ITEM_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SECRETKEY"
(
"ID" VARCHAR(1200),
"KEYALIAS" VARCHAR(1536),
"VALUEALIAS" VARCHAR(3900),
"ALIAS" VARCHAR(1536)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_CONFIG_NEW"
(
"ID" VARCHAR(1200),
"USERID" VARCHAR(1200),
"USERACCESSSTARTTIME" VARCHAR(2400),
"USERACCESSSTOPTIME" VARCHAR(2400),
"USERLOGINIP" VARCHAR(3900),
"USERLOGINFAILURES" VARCHAR(1200),
"MAXLOGSCOUNT" VARCHAR(1200),
"HISTORYREPETITIONS" VARCHAR(1200),
"MAXONLINEUSERS" VARCHAR(1200),
"PASSWORDTIMEOUT" VARCHAR(1200),
"LOCKTIME" VARCHAR(1200),
"SESSIONTIME" VARCHAR(1200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_LOGS"
(
"ID" VARCHAR(1200),
"USERID" VARCHAR(1200),
"IP" VARCHAR(1200),
"MAC" VARCHAR(1200),
"OPERATIONTYPE" CHAR(240),
"MODULENAME" VARCHAR(1200),
"METHOD" VARCHAR(3900),
"METHODENG" VARCHAR(1200),
"RESULTSTATUS" CHAR(240),
"CREATETIME" TIMESTAMP(0),
"MODULECLASS" VARCHAR(3900),
"CONTENT" VARCHAR(3900),
"BACKUPSTATUS" CHAR(240) DEFAULT '1',
"OPERATOR" VARCHAR(1200),
"NOAUTHORITY" VARCHAR(48) DEFAULT '1') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_LOGS_BAK"
(
"ID" VARCHAR(1200),
"USERID" VARCHAR(1200),
"IP" VARCHAR(1200),
"MAC" VARCHAR(1200),
"OPERATIONTYPE" CHAR(240),
"MODULENAME" VARCHAR(1200),
"METHOD" VARCHAR(1200),
"METHODENG" VARCHAR(1200),
"RESULTSTATUS" CHAR(240),
"CREATETIME" TIMESTAMP(0),
"MODULECLASS" VARCHAR(1200),
"CONTENT" VARCHAR(1200),
"BACKUPSTATUS" CHAR(240) DEFAULT '1',
"OPERATOR" VARCHAR(1200),
"BACKUPTIME" CHAR(100),
"NOAUTHORITY" VARCHAR(48) DEFAULT '1') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT"
(
"ID" VARCHAR(400) NOT NULL,
"REPORT_NAME" VARCHAR(800) DEFAULT '',
"REPORT_TYPE" INT,
"PRODUCE_TIME" TIMESTAMP(0),
"REPORT_ADVISE" VARCHAR(1600),
"STATION_AUTHORIZEID" VARCHAR(400) DEFAULT '',
"CREATED_TIME" TIMESTAMP(0),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_BASEINFO"
(
"ID" VARCHAR(400) NOT NULL,
"STATION_NAME" VARCHAR(800) DEFAULT '',
"REPORT_MECHANICAL_REGULAR_COUNTS" INT,
"REPORT_MECHANICAL_UNUSUAL_COUNTS" INT,
"REPORT_DISCHARGE_REGULAR_COUNTS" INT,
"REPORT_DISCHARGE_UNUSUAL_COUNTS" INT,
"REPORT_CAMERA_REGULAR_COUNTS" INT,
"REPORT_CAMERA_UNUSUAL_COUNTS" INT,
"REPORT_TEMP_REGULAR_COUNTS" INT,
"REPORT_TEMP_UNUSUAL_COUNTS" INT,
"REPORT_ROBOT_REGULAR_COUNTS" INT,
"REPORT_ROBOT_UNUSUAL_COUNTS" INT,
"REPORT_ENVIRON_REGULAR_COUNTS" INT,
"REPORT_ENVIRON_UNUSUAL_COUNTS" INT,
"SYSTEM_REPORT_ID" VARCHAR(400),
"CREATED_TIME" TIMESTAMP(0),
"REPORT_TEMP_HUMI_REGULAR_COUNTS" INT,
"REPORT_TEMP_HUMI_UNUSUAL_COUNTS" INT,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_CAMERA"
(
"ID" VARCHAR(400) NOT NULL,
"REPORT_CAMERA_UNIT_NAME" VARCHAR(800),
"REPORT_CAMERA_UNIT_TYPE" VARCHAR(400),
"REPORT_CAMERA_RESULT_READING" VARCHAR(400),
"REPORT_CAMERA_DEVICE_NAME" VARCHAR(400),
"REPORT_CAMERA_THRESHOLD_VALUE" VARCHAR(240),
"REPORT_CAMERA_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(400),
"CREATED_TIME" TIMESTAMP(0),
"REPORT_CAMERA_UNIT_TYPE_ID" INT,
"REPORT_CAMERA_JOB_RESULT_ID" INT,
"REPORT_CAMERA_LAST_RESULT_READING" VARCHAR(400),
"REPORT_CAMERA_IP" VARCHAR(256) DEFAULT NULL,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_DISCHARGE"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_DISCHARGE_NAME" VARCHAR(400),
"REPORT_DISCHARGE_MAGNITUDE" VARCHAR(200),
"REPORT_DISCHARGE_CABINET_NAME" VARCHAR(200),
"REPORT_DISCHARGE_THRESHOLD_LOW" VARCHAR(120),
"REPORT_DISCHARGE_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(200),
"CREATED_TIME" TIMESTAMP(0),
"DEVICE_CODE" VARCHAR(384),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_ENVIRON"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_ENVIRON_NAME" VARCHAR(400),
"REPORT_ENVIRON_TYPE" VARCHAR(200),
"REPORT_ENVIRON_RESULT_READING" VARCHAR(200),
"REPORT_ENVIRON__NAME2" VARCHAR(200),
"REPORT_ENVIRON_THRESHOLD_VALUE" VARCHAR(120),
"REPORT_ENVIRON_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(200),
"CREATED_TIME" TIMESTAMP(0),
"REPORT_ENVIRON_THRESHOLD_COMPARE" VARCHAR(80),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_MECHANICAL"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_MECHANICAL_NAME" VARCHAR(400),
"REPORT_MECHANICAL_HEALTH_SCORES" VARCHAR(200),
"REPORT_MECHANICAL_CABINET_NAME" VARCHAR(200),
"REPORT_MECHANICAL_LIFE_ANALYSIS" VARCHAR(200),
"REPORT_MECHANICAL_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(200),
"CREATED_TIME" TIMESTAMP(0),
"DEVICE_CODE" VARCHAR(384),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_ROBOT"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_ROBOT_UNIT_NAME" VARCHAR(400),
"REPORT_ROBOT_UNIT_TYPE" VARCHAR(200),
"REPORT_ROBOT_RESULT_READING" VARCHAR(200),
"REPORT_ROBOT_DEVICE_NAME" VARCHAR(200),
"REPORT_ROBOT_THRESHOLD_VALUE" VARCHAR(120),
"REPORT_ROBOT_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(200),
"CREATED_TIME" TIMESTAMP(0),
"REPORT_ROBOT_UNIT_TYPE_ID" INT,
"REPORT_ROBOT_JOB_RESULT_ID" INT,
"REPORT_ROBOT_LAST_RESULT_READING" VARCHAR(200),
"REPORT_ROBOT_IP" VARCHAR(128) DEFAULT NULL,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_TEMP"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_TEMP_NAME" VARCHAR(400),
"REPORT_TEMP_RESULT_READING" VARCHAR(200),
"REPORT_TEMP_CABINET_NAME" VARCHAR(200),
"REPORT_TEMP_THRESHOLD_LOW" VARCHAR(120),
"REPORT_TEMP_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(200),
"CREATED_TIME" TIMESTAMP(0),
"DEVICE_CODE" VARCHAR(384),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_SYSTEM_REPORT_TEMP_HUMI"
(
"ID" VARCHAR(200) NOT NULL,
"REPORT_TEMP_NAME" VARCHAR(400),
"REPORT_TEMP_RESULT_READING" VARCHAR(200),
"REPORT_HUMI_RESULT_READING" VARCHAR(200),
"REPORT_TEMP_CABINET_NAME" VARCHAR(200),
"REPORT_TEMP_THRESHOLD" VARCHAR(120),
"REPORT_HUMI_THRESHOLD" VARCHAR(120),
"REPORT_TEMP_STATUS" INT,
"SYSTEM_REPORT_ID" VARCHAR(200),
"CREATED_TIME" TIMESTAMP(0),
"DEVICE_CODE" VARCHAR(384),
"REPORT_HUMI_STATUS" INT,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_TASK"
(
"TASK_ID" INT,
"TASK_STATION_ID" INT,
"TASK_ROBOT_ID" INT,
"TASK_NAME" VARCHAR(240),
"TASK_IS_DELETED" INT,
"TASK_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"TASK_MODE" INT,
"TASK_ENABLED" INT,
"TASK_DATETIME" TIMESTAMP(0),
"TASK_TIME" TIME(0),
"TASK_WEEKDAY" VARCHAR(21),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_DATETIME" IS '定巡的时间点';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_ENABLED" IS '任务状态 0 - 禁用 1 - 启用';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_ID" IS 'Task id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_IS_DELETED" IS '是否删除0=否 1=是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_MODE" IS '任务类型 0 - 特巡 1 - 定巡 2 - 例巡';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_NAME" IS '名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_ROBOT_ID" IS 'Robot id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_STATION_ID" IS '站室id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_TIME" IS '例巡的时间点';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK"."TASK_WEEKDAY" IS '星期几0-6';


CREATE TABLE "MONITOR_VISUAL"."TB_TASK_ITEM"
(
"TASK_ITEM_ID" INT,
"TASK_ITEM_TASK_ID" INT,
"TASK_ITEM_STATION_ID" INT,
"TASK_ITEM_DEVICE_ID" INT,
"TASK_ITEM_DEVICE_CODE" VARCHAR(30),
"TASK_ITEM_UNIT_ID" INT,
"TASK_ITEM_UNIT_CODE" VARCHAR(30),
"TASK_ITEM_IS_DELETED" INT,
"TASK_ITEM_ROBOT_ID" INT,
"TASK_ITEM_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK_ITEM"."TASK_ITEM_DEVICE_CODE" IS '机柜code';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK_ITEM"."TASK_ITEM_ID" IS 'Id of task item in a task.';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK_ITEM"."TASK_ITEM_IS_DELETED" IS '是否删除0=否 1=是';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK_ITEM"."TASK_ITEM_ROBOT_ID" IS '机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK_ITEM"."TASK_ITEM_STATION_ID" IS 'Station id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_TASK_ITEM"."TASK_ITEM_UNIT_CODE" IS '巡检点code';


CREATE TABLE "MONITOR_VISUAL"."TB_THRESHOLD"
(
"THRESHOLD_ID" INT,
"THRESHOLD_UNIT_TYPE_ID" INT,
"THRESHOLD_NAME" VARCHAR(120),
"THRESHOLD_RANGE" VARCHAR(120),
"THRESHOLD_SYMBOL" INT,
"THRESHOLD_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_THRESHOLD_LIMIT"
(
"ID" INT,
"UPPER_LIMIT" VARCHAR(20),
"UPPER_ENABLE" CHAR(1),
"LOWER_LIMIT" VARCHAR(20),
"LOWER_ENABLE" CHAR(1),
"COMMON_UPPER_LIMIT" VARCHAR(20),
"COMMON_UPPER_ENABLE" CHAR(1),
"COMMON_LOWER_LIMIT" VARCHAR(20),
"COMMON_LOWER_ENABLE" CHAR(1),
"SERIOUS_UPPER_LIMIT" VARCHAR(20),
"SERIOUS_UPPER_ENABLE" CHAR(1),
"SERIOUS_LOWER_LIMIT" VARCHAR(20),
"SERIOUS_LOWER_ENABLE" CHAR(1),
"CRITICAL_UPPER_LIMIT" VARCHAR(20),
"CRITICAL_UPPER_ENABLE" CHAR(1),
"CRITICAL_LOWER_LIMIT" VARCHAR(20),
"CRITICAL_LOWER_ENABLE" CHAR(1),
"THRESHOLD_UNIT_TYPE_ID" INT,
"THRESHOLD_NAME" VARCHAR(50),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_UNIT"
(
"UNIT_ID" INT,
"UNIT_ROBOT_ID" INT,
"UNIT_DEVICE_ID" VARCHAR(30),
"UNIT_DEVICE_CODE" VARCHAR(30),
"UNIT_CODE" VARCHAR(30),
"UNIT_NAME" VARCHAR(90),
"UNIT_TRUST" DOUBLE,
"UNIT_YAW" DOUBLE,
"UNIT_TYPE" INT,
"UNIT_SLIDE" DOUBLE,
"UNIT_RISE" DOUBLE,
"UNIT_ROLL" DOUBLE,
"UNIT_PITCH" DOUBLE,
"UNIT_THRESHOLD_ID" INT,
"UNIT_STRETCH_L" DOUBLE,
"UNIT_STRETCH_R" DOUBLE,
"UNIT_ZOOM_C" INT,
"UNIT_ZOOM_T" INT,
"UNIT_DESCRIPT" VARCHAR(600),
"UNIT_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"UNIT_FOCUS" INT,
"UNIT_MEAS_TYPE" VARCHAR(150),
"UNIT_LEFT_PITCH" DOUBLE DEFAULT NULL,
"UNIT_RIGHT_PITCH" DOUBLE DEFAULT NULL,
"AUTHORIZEID" VARCHAR(150)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."TB_UNIT" IS '机器人巡检点表';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_CODE" IS '巡检点(检测项目)代号，由用户输入';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_DESCRIPT" IS '巡检点的描述信息';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_DEVICE_CODE" IS '机柜编号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_DEVICE_ID" IS '关联到tb_device中的device_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_FOCUS" IS 'Camera焦距值';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_ID" IS 'Unit id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_LEFT_PITCH" IS 'Robot左侧手臂俯仰，新五代机用';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_MEAS_TYPE" IS '第三方需要的量测类型';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_NAME" IS 'Unit name';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_PITCH" IS 'Robot云台俯仰';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_RIGHT_PITCH" IS 'Robot右侧手臂俯仰，新五代机用';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_RISE" IS 'Robot球体升降';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_ROBOT_ID" IS '所属机器人id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_ROLL" IS 'Robot翻滚(Reserved)';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_SLIDE" IS 'Robot前进后退';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_STRETCH_L" IS 'Robot左手臂伸展收缩';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_STRETCH_R" IS 'Robot右手臂伸展收缩';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_THRESHOLD_ID" IS '关联到tb_threshold中的threshold_id';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_TRUST" IS 'Robot的油门推力';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_TYPE" IS 'The type of is inspected';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_YAW" IS 'Robot云台左右航向';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_ZOOM_C" IS '巡检点Camera变焦';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT"."UNIT_ZOOM_T" IS '巡检点红外变焦';


CREATE TABLE "MONITOR_VISUAL"."TB_UNIT_TYPE"
(
"UNIT_TYPE_ID" INT,
"UNIT_TYPE_NAME" VARCHAR(200),
"UNIT_MEAS_UNIT" VARCHAR(40),
"UNIT_TYPE_CREATED_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"UNIT_TYPE_ICON" VARCHAR(1020),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT_TYPE"."UNIT_MEAS_UNIT" IS '测量单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT_TYPE"."UNIT_TYPE_ICON" IS '巡检类型的icon地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT_TYPE"."UNIT_TYPE_ID" IS '巡检点类型编号';
COMMENT ON COLUMN "MONITOR_VISUAL"."TB_UNIT_TYPE"."UNIT_TYPE_NAME" IS '巡检点类型名称';


CREATE TABLE "MONITOR_VISUAL"."TB_USER"
(
"ID" VARCHAR(400) DEFAULT '',
"USERNAME" VARCHAR(1200),
"PASSWORD" VARCHAR(1200),
"SEX" VARCHAR(144),
"CITYID" VARCHAR(1200),
"COUNTYID" VARCHAR(1200),
"TOWNID" VARCHAR(1200),
"ISSPECIALITY" VARCHAR(1200),
"CTIME" TIMESTAMP(0),
"CUSER" VARCHAR(1200),
"LTIME" TIMESTAMP(0),
"LUSER" VARCHAR(1200),
"TYPE" VARCHAR(1200),
"STATUS" VARCHAR(288),
"REALNAME" VARCHAR(1200),
"MOBILE" VARCHAR(1200),
"TOKEN" VARCHAR(1200),
"TIPS" VARCHAR(1200),
"COMPANYID" VARCHAR(1200),
"LAST_LOGIN_DATETIME" TIMESTAMP(0),
"ACTIVATETIME" VARCHAR(1200),
"DORMANTTIME" VARCHAR(1200),
"CANCELTIME" VARCHAR(1200),
"IDCARD" VARCHAR(1200) DEFAULT '0',
"ACCOUNTTYPE" VARCHAR(1200),
"ISFIRST" VARCHAR(48) DEFAULT '0',
"LOCKENDTIME" VARCHAR(1200),
"FAILURETIME" VARCHAR(1200),
"ORGANID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_USER_PASS_HISTORY"
(
"ID" VARCHAR(3900),
"USER_ID" VARCHAR(3900),
"PASSWORD" VARCHAR(3900),
"CREATETIME" TIMESTAMP(0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_USER_ROLE"
(
"ID" VARCHAR(3900) DEFAULT '',
"ROLE_ID" VARCHAR(3900),
"USER_ID" VARCHAR(3900)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_USER_STATUS"
(
"ID" VARCHAR(1200),
"USERID" VARCHAR(1200),
"LASTLOGINOUTTIME" VARCHAR(1200),
"CURRENTLOGINTIME" VARCHAR(1200),
"CURRENTONLINESTATUS" VARCHAR(1200),
"LOGINFAILURESNUMBER" INT,
"CREATETIME" VARCHAR(1200),
"LOGINSESSIONID" VARCHAR(1200),
"MAXONLINEUSERS" VARCHAR(1200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."TB_USER_TIME_WARNING"
(
"ID" VARCHAR(1200),
"USERID" VARCHAR(1200),
"READFLAG" VARCHAR(48),
"READER" VARCHAR(1200),
"COMMENTS" VARCHAR(3900),
"READTIME" VARCHAR(1200),
"CREATETIME" VARCHAR(1200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ATLAS_CONTRAST"
(
"ID" VARCHAR(200),
"REPORT_NUMBER" VARCHAR(200),
"AUTHORIZEID" VARCHAR(200),
"DEVICE_CODE" VARCHAR(200),
"CREATE_TIME" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_CAR_AUTHORIZEID"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"CARCODE" VARCHAR(200),
"AUTHORIZEID" VARCHAR(200),
"MANAGECODE" VARCHAR(50),
"ADDR" VARCHAR(50),
CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."T_CAR_AUTHORIZEID" IS '车与站室ID关联表';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_CAR_AUTHORIZEID"."ADDR" IS '设备地址';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_CAR_AUTHORIZEID"."AUTHORIZEID" IS '站室编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_CAR_AUTHORIZEID"."CARCODE" IS '车编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_CAR_AUTHORIZEID"."ID" IS '主键';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_CAR_AUTHORIZEID"."MANAGECODE" IS '管理机编码';


CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_ALARM"
(
"ID" INT,
"STATION_CODE" INT,
"CABINET_CODE" VARCHAR(40),
"DEVICE_CODE" VARCHAR(120),
"ALARM_GENERATED_TIME" TIMESTAMP(0),
"ALARM_PRPD" VARCHAR(120),
"ALARM_AMPLITUDE" VARCHAR(120),
"ALARM_THRESHOLD" VARCHAR(120),
"ALARM_LEVEL" INT,
"ALARM_STATUS" INT DEFAULT 0,
"ALARM_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_ALARM_COMPARE"
(
"ID" BIGINT IDENTITY(25, 1) NOT NULL,
"AUTHORIZEID" VARCHAR(200),
"DEVICECODE" VARCHAR(200),
"DATAID" VARCHAR(200),
"CREATETIME" VARCHAR(200),
"USERID" VARCHAR(200),
CONSTRAINT "ID_268304618106990" UNIQUE("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_ALARM_EXPERTS"
(
"ID" BIGINT IDENTITY(18, 1) NOT NULL,
"NAME" VARCHAR(2000),
"DATAID" VARCHAR(200),
"CREATE_TIME" VARCHAR(200),
"DEVICE_CODE" VARCHAR(200),
"AUTHORIZEID" VARCHAR(400),
CONSTRAINT "ID_268304665288513" UNIQUE("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_ALARM_FILE"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"FILE_GENERATED_TIME" TIMESTAMP(0),
"FILE_CONTENT" CLOB,
"FILE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_ALARM_FILE_PEAK"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"PEAK_GENERATED_TIME" TIMESTAMP(0),
"PEAK_PRPD" VARCHAR(120),
"PEAK_AMPLITUDE" VARCHAR(120),
"PEAK_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_DATA_FILE"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"FILE_GENERATED_TIME" TIMESTAMP(0),
"FILE_CONTENT" CLOB,
"FILE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"FILE_DATA" VARCHAR(120)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_DEVICE"
(
"ID" INT,
"STATION_CODE" INT,
"CABINET_CODE" VARCHAR(40),
"DEVICE_NAME" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"DEVICE_STATE" INT,
"DEVICE_RESERVED" VARCHAR(128),
"DEVICE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"ISALARM" VARCHAR(50) DEFAULT '0') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DISCHARGE_THRESHOLD"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"THRESHOLD_NAME" VARCHAR(120),
"THRESHOLD_PC_LOW" VARCHAR(40),
"THRESHOLD_PC_MEDIUM" VARCHAR(40),
"THRESHOLD_PC_HIGH" VARCHAR(40),
"THRESHOLD_PULSE_COUNT" VARCHAR(40),
"THRESHOLD_50HZ_RELATIVITY" VARCHAR(40),
"THRESHOLD_100HZ_RELATIVITY" VARCHAR(40),
"THRESHOLD_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DOOR"
(
"DOOR_ID" INT,
"DOOR_DEVICE_ID" INT,
"DOOR_NO" INT,
"DOOR_NAME" VARCHAR(200),
"DOOR_OPENDOOR" INT,
"DOOR_PERIODDOOR" INT,
"DOOR_LOCK_DELAY" INT,
"DOOR_SENSOR_DELAY" INT,
"DOOR_TYPE" INT,
"DOOR_READER_TYPE" INT,
"DOOR_STATE" INT,
"DOOR_STATION_ID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_DOOR_DEVICE"
(
"DOOR_DEVICE_ID" INT,
"DOOR_DEVICE_DEVICENAME" VARCHAR(600),
"DOOR_DEVICE_CONNECTTYPE" INT,
"DOOR_DEVICE_IP" VARCHAR(80),
"DOOR_DEVICE_PORT" INT,
"DOOR_DEVICE_PASSWORD" VARCHAR(40),
"DOOR_DEVICE_BAUDRATE" INT,
"DOOR_DEVICE_MACHINEADDRESS" INT,
"DOOR_DEVICE_SERIALPORT" INT,
"DOOR_DEVICE_SYNDEVICETIME" INT,
"DOOR_DEVICE_DELDEVICEDATA" INT,
"DOOR_DEVICE_USERCOUNT" INT,
"DOOR_DEVICE_FINGERCOUNT" INT,
"DOOR_DEVICE_SECRETCOUNT" INT,
"DOOR_DEVICE_MANAGERCOUNT" INT,
"DOOR_DEVICE_AREAID" INT,
"DOOR_DEVICE_FIRMWAREVERSION" VARCHAR(200),
"DOOR_DEVICE_STATE" INT,
"DOOR_DEVICE_CONTROLTYPE" INT,
"DOOR_DEVICE_STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_EFFECTIVE_TIME"
(
"EFFECTIVE_TIME_ID" INT,
"EFFECTIVE_TIME_TIMESEG_NAME" VARCHAR(200),
"EFFECTIVE_TIME_MEMO" VARCHAR(1020),
"EFFECTIVE_TIME_MON_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_MON_END" TIMESTAMP(0),
"EFFECTIVE_TIME_TUE_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_TUE_END" TIMESTAMP(0),
"EFFECTIVE_TIME_WED_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_WED_END" TIMESTAMP(0),
"EFFECTIVE_TIME_THU_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_THU_END" TIMESTAMP(0),
"EFFECTIVE_TIME_FRI_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_FRI_END" TIMESTAMP(0),
"EFFECTIVE_TIME_SAT_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_SAT_END" TIMESTAMP(0),
"EFFECTIVE_TIME_SUN_BEG" TIMESTAMP(0),
"EFFECTIVE_TIME_SUN_END" TIMESTAMP(0),
"EFFECTIVE_TIME_UPDATETIME" TIMESTAMP(0),
"EFFECTIVE_TIME_CREATEDTIME" TIMESTAMP(0),
"EFFECTIVE_TIME_STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ENVIRON_ALARM"
(
"ID" VARCHAR(200),
"EDEVCODE" VARCHAR(200),
"EDEVTYPE" VARCHAR(4),
"ALARM_DESC_CONTENT" VARCHAR(1200),
"STATIONID" INT,
"CREATETIME" TIMESTAMP(0),
"STATUS" INT DEFAULT 0,
"AUTHORIZEID" VARCHAR(200),
"PARAMCODE" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "ID_INDEX" ON "MONITOR_VISUAL"."T_ENVIRON_ALARM"("ID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ENVIRON_DATA"
(
"ID" INT,
"EDEVCODE" VARCHAR(200),
"PARAMCODE" VARCHAR(2000),
"NAME" VARCHAR(2000),
"VAL" VARCHAR(3900),
"DESCRIPTION" VARCHAR(2000),
"COLLECTTIME" TIMESTAMP(0),
"STYPE" INT,
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "INDEX30021394360484" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("ID" ASC,"EDEVCODE" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "INDEX_ENVIRON_DATA" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("EDEVCODE" ASC,"PARAMCODE" ASC,"COLLECTTIME" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "INDEX_ENVIRON_DATA1" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("ID" ASC,"EDEVCODE" ASC,"PARAMCODE" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "dataSpaceIndex" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("EDEVCODE" ASC,"PARAMCODE" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "index_1" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("ID" ASC,"EDEVCODE" ASC,"AUTHORIZEID" ASC,"COLLECTTIME" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "index_2" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("EDEVCODE" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "index_3" ON "MONITOR_VISUAL"."T_ENVIRON_DATA"("EDEVCODE" ASC,"PARAMCODE" ASC,"AUTHORIZEID" ASC,"ID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ENVIRON_DEVICECLASS"
(
"ID" INT,
"DEVCLASSCODE" VARCHAR(200),
"NAME" VARCHAR(2000),
"CLASSICOID" INT,
"STATUS" INT,
"CREATETIME" TIMESTAMP(0),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200),
"ISALARM" VARCHAR(50) DEFAULT '0') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ENVIRON_DEVICEPARAMES"
(
"ID" INT,
"NAME" VARCHAR(2000),
"PARAMCODE" VARCHAR(200),
"DEVCLASSID" INT,
"CONTROLTYPE" INT,
"PARAMTYPE" INT,
"STYPE" INT,
"PARAMUNIT" INT,
"CLASSICOID" INT,
"PARAMCOMPARE" VARCHAR(80),
"PARAMTHRESHOLD" VARCHAR(200),
"LINKAGEALARMID" INT,
"STATUS" INT,
"SHOWTOPO" INT,
"CREATETIME" TIMESTAMP(0),
"INSTRUCT" VARCHAR(80),
"PARM0" VARCHAR(80),
"PARM1" VARCHAR(80),
"CONTROLSERVERID" INT,
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ENVIRON_DEVICES"
(
"ID" INT,
"EDEVCODE" VARCHAR(200),
"STATIONID" INT,
"DEVCLASSID" INT,
"NAME" VARCHAR(2000),
"CHANNELNUMBER" VARCHAR(40),
"STATUS" INT,
"DESCRIPTION" VARCHAR(2000),
"CREATETIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"
(
"HOUR" VARCHAR(50),
"PARAMCODE" VARCHAR(50),
"AUTHORIZEID" VARCHAR(50),
"DEVCLASSCODE" VARCHAR(50),
"VAL" VARCHAR(50),
"DEVNAME" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."T_ENV_ECHART_TEMP" IS '环境数据echart图表展示数据临时表';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"."AUTHORIZEID" IS '站室编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"."DEVCLASSCODE" IS '点位类型编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"."DEVNAME" IS '设备名称';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"."HOUR" IS '小时';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"."PARAMCODE" IS '点位编码';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_ENV_ECHART_TEMP"."VAL" IS '小时最大值';


CREATE TABLE "MONITOR_VISUAL"."T_EXPERT_LIBRARY"
(
"ID" VARCHAR(200),
"REPORT_NUMBER" VARCHAR(200),
"EXPERT_LIBRARY_NAME" VARCHAR(2000),
"CREATE_TIME" VARCHAR(200),
"AUTHORIZEID" VARCHAR(200),
"SYS_CODE" VARCHAR(200),
"DEVICE_CODE" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_MECHANICAL_ALARM"
(
"ID" INT,
"ALARM_NUMBER" VARCHAR(120),
"REPORT_NUMBER" VARCHAR(320),
"SYS_CODE" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"ALARM_LEVEL" INT,
"ALARM_CONTENT" VARCHAR(80),
"ALARM_TIME" TIMESTAMP(0),
"ALARM_STATUS" INT,
"CREATE_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_MECHANICAL_DEVICE"
(
"ID" INT,
"SYS_CODE" VARCHAR(120),
"DEVICE_NAME" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"DEVICE_RESERVED" VARCHAR(128),
"DELIVERY_TIME" TIMESTAMP(0),
"MAINTENANCE_TIME" TIMESTAMP(0),
"REPLACEMENT_TIME" TIMESTAMP(0),
"HEALTH_DEGREE" VARCHAR(16),
"LIFE_ANALYSIS" VARCHAR(16),
"DEVICE_STATUS" INT,
"CREATE_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"ISALARM" VARCHAR(50) DEFAULT '0') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_MECHANICAL_INDIVIDUALIZED"
(
"ID" INT,
"SYS_CODE" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"CONTROL_VOLTAGE" VARCHAR(40),
"SLUICE_RESISTANCE" VARCHAR(40),
"CLOSE_RESISTANCE" VARCHAR(40),
"CREATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_MECHANICAL_REPORT"
(
"ID" INT,
"REPORT_NUMBER" VARCHAR(320),
"SYS_CODE" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"REPORT_TYPE" INT,
"REPORT_TIME" TIMESTAMP(0),
"FRACTURE_MAP" CLOB,
"STANDARD_MAP" CLOB,
"CURRENT_MAP" CLOB,
"MAP_ADDRESS" VARCHAR(600),
"ACTION_TYPE" INT,
"ALARM_TYPE" INT,
"CHARACTERISTIC_VALUE" VARCHAR(40),
"REPORT_VALUE1" VARCHAR(40),
"REPORT_VALUE2" VARCHAR(40),
"REPORT_VALUE3" VARCHAR(40),
"REPORT_VALUE4" VARCHAR(40),
"REPORT_VALUE5" VARCHAR(40),
"REPORT_VALUE6" VARCHAR(40),
"REPORT_VALUE7" INT,
"REPORT_VALUE8" VARCHAR(40),
"REPORT_VALUE9" VARCHAR(40),
"HEALTH_DEGREE" VARCHAR(24),
"CREATE_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_MECHANICAL_STANDARD"
(
"ID" INT,
"SYS_CODE" VARCHAR(120),
"STANDARD_VALUE1" VARCHAR(40),
"STANDARD_VALUE2" VARCHAR(40),
"STANDARD_VALUE3" VARCHAR(40),
"STANDARD_VALUE4" VARCHAR(40),
"CREATE_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_ROOM"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"ROOM_CODE" VARCHAR(20),
"ROOM_NAME" VARCHAR(50),
"CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"KEY_CIRCUIT" INT DEFAULT 1,
"ROOM_WEIGHT" DECIMAL(22,2) DEFAULT 1,
"DEVICE_WEIGHT" VARCHAR(50) DEFAULT '{"R1":1,"R2":1,"R3":1,"R4":1}',
"DEVICE_CIRCUIT" VARCHAR(50) DEFAULT '{"K1":1,"K2":1,"K3":1,"K4":1}',
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_STATION"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"STATION_ID" VARCHAR(200),
"STATION_NAME" VARCHAR(400),
"COMPANY" VARCHAR(200),
"STATION_URL" VARCHAR(2000),
"STATION_LONGITUDE" VARCHAR(200),
"STATION_LATITUDE" VARCHAR(200),
"PERSON_LIABLE" VARCHAR(200),
"TELEPHONE" VARCHAR(200),
"CREATE_TIME" VARCHAR(200),
"AUTHORIZEID" VARCHAR(200),
"LIFEURL" VARCHAR(300) DEFAULT NULL,
"LIFEUP" INT DEFAULT NULL,
"LEFEWEEKDEVICEURL" VARCHAR(300) DEFAULT NULL,
"ENVIRONUP" INT DEFAULT NULL,
"VIDEOMANAGERURL" VARCHAR(300) DEFAULT NULL,
"VIDEOMANAGER" INT DEFAULT NULL,
"SECURITYTOOLURL" VARCHAR(300) DEFAULT NULL,
"SECURITYTOOL" INT DEFAULT NULL,
"SECURITYSPECIFICATIONURL" VARCHAR(300) DEFAULT NULL,
"SECURITYSPECIFICATION" INT DEFAULT NULL,
"LIFECDSURL" VARCHAR(300) DEFAULT NULL,
"LIFECDS" INT DEFAULT NULL,
"UNITIDS" VARCHAR(300) DEFAULT NULL,
"TYPE" TINYINT,
"LONGITUDE" DOUBLE,
"LATITUDE" DOUBLE,
"LINE_ID" INT,
"STATION_LINE" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."T_STATION"."LATITUDE" IS '纬度';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_STATION"."LINE_ID" IS '站室所属线路';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_STATION"."LONGITUDE" IS '经度';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_STATION"."STATION_LINE" IS '站室所属线路';


CREATE TABLE "MONITOR_VISUAL"."T_STATION_LINE"
(
"ID" VARCHAR(128) DEFAULT '',
"LINE_NAME" VARCHAR(10),
"LINE_IP" VARCHAR(200),
"LINE_CREATED_TIME" TIMESTAMP(0)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_STATION_THRESHOLD_VAL"
(
"ID" VARCHAR(100) NOT NULL,
"NAME" VARCHAR(100),
"COMPARE" VARCHAR(100),
"VAL" VARCHAR(100),
"LEVEL" VARCHAR(100),
"UNIT_TYPE" VARCHAR(100),
"TYPE" INT,
"CODE" CHAR(20),
"DEVICE_CODE" VARCHAR(100),
"SUCCESS_FLAG" INT,
"ROBOTTYPE" INT,
"CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(100),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_STATION_VAL_CONFIG"
(
"ID" VARCHAR(200),
"NAME" VARCHAR(200),
"COMPARE" VARCHAR(200),
"VAL" VARCHAR(200),
"LEVEL" VARCHAR(200),
"UNIT_TYPE" VARCHAR(200),
"TYPE" INT,
"CODE" CHAR(40),
"ROBOTTYPE" INT) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_ALARM"
(
"ID" INT,
"STATION_CODE" INT,
"CABINET_CODE" VARCHAR(40),
"DEVICE_CODE" VARCHAR(120),
"ALARM_PHRASE_TYPE" INT,
"ALARM_READING" VARCHAR(120),
"ALARM_THRESHOLD" VARCHAR(120),
"ALARM_LEVEL" INT,
"ALARM_STATUS" INT,
"ALARM_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_DEVICE"
(
"ID" INT,
"STATION_CODE" INT,
"CABINET_CODE" VARCHAR(40),
"DEVICE_NAME" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"DEVICE_PHRASE_TYPE" INT,
"DEVICE_STATE" INT,
"DEVICE_RESERVED" VARCHAR(128),
"DEVICE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"GROUP_DETAIL" VARCHAR(100),
"ISALARM" VARCHAR(50) DEFAULT '0') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_HUMI_ALARM"
(
"ID" INT,
"STATION_CODE" INT,
"CABINET_CODE" VARCHAR(40),
"DEVICE_CODE" VARCHAR(120),
"ALARM_TYPE" INT,
"ALARM_READING" VARCHAR(120),
"ALARM_THRESHOLD" VARCHAR(120),
"ALARM_LEVEL" INT,
"ALARM_STATUS" INT,
"ALARM_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_HUMI_DEVICE"
(
"ID" INT,
"STATION_CODE" INT,
"CABINET_CODE" VARCHAR(40),
"DEVICE_NAME" VARCHAR(120),
"DEVICE_CODE" VARCHAR(120),
"DEVICE_STATE" INT,
"DEVICE_RESERVED" VARCHAR(128),
"DEVICE_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200),
"ISALARM" VARCHAR(50) DEFAULT '0') STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_HUMI_RESULT"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"TEMP_RESULT_READING" VARCHAR(120),
"HUMI_RESULT_READING" VARCHAR(120),
"RESULT_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "humi_11" ON "MONITOR_VISUAL"."T_TEMP_HUMI_RESULT"("DEVICE_CODE" ASC,"TEMP_RESULT_READING" ASC,"RESULT_CREATED_TIME" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "humi_22" ON "MONITOR_VISUAL"."T_TEMP_HUMI_RESULT"("DEVICE_CODE" ASC,"HUMI_RESULT_READING" ASC,"RESULT_CREATED_TIME" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_HUMI_THRESHOLD"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"THRESHOLD_NAME" VARCHAR(120),
"THRESHOLD_LOW" VARCHAR(40),
"THRESHOLD_MEDIUM" VARCHAR(40),
"THRESHOLD_HIGH" VARCHAR(40),
"DEVICE_TYPE" INT,
"THRESHOLD_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_RESULT"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"RESULT_READING" VARCHAR(120),
"RESULT_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE  INDEX "tempx_11" ON "MONITOR_VISUAL"."T_TEMP_RESULT"("DEVICE_CODE" ASC,"RESULT_CREATED_TIME" ASC,"AUTHORIZEID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_TEMP_THRESHOLD"
(
"ID" INT,
"DEVICE_CODE" VARCHAR(120),
"THRESHOLD_NAME" VARCHAR(120),
"THRESHOLD_LOW" VARCHAR(40),
"THRESHOLD_MEDIUM" VARCHAR(40),
"THRESHOLD_HIGH" VARCHAR(40),
"THRESHOLD_CREATED_TIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_UNIT_TABLE"
(
"ID" INT IDENTITY(40, 1) NOT NULL,
"IEC104ID" INT,
"UNIT_NAME" VARCHAR(120),
"IEC104TYPE" INT,
"UNIT_MEAS" VARCHAR(60),
"REMARKS" VARCHAR(120),
"IEC104SORT" INT,
"MARKID" VARCHAR(180),
"AUTHORIZEID" VARCHAR(180),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "MONITOR_VISUAL"."T_UNIT_TABLE"."IEC104SORT" IS '点位所属设备(环境,局放,机械特性,机器人巡检点)';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_UNIT_TABLE"."IEC104TYPE" IS '信号类型(遥测,遥信)';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_UNIT_TABLE"."REMARKS" IS '备注(针对遥信)';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_UNIT_TABLE"."UNIT_MEAS" IS '单位';
COMMENT ON COLUMN "MONITOR_VISUAL"."T_UNIT_TABLE"."UNIT_NAME" IS '点位名称';


CREATE TABLE "MONITOR_VISUAL"."T_USER_DEVICE"
(
"USER_DEVICE_ID" INT,
"USER_DEVICE_USER_INFO_ID" INT,
"USER_DEVICE_DEVICE_ID" INT,
"USER_DEVICE_UPDATETIME" TIMESTAMP(0),
"USER_DEVICE_STATION_ID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_USER_DOOR"
(
"USER_DOOR_ID" INT,
"USER_DOOR_USER_ID" INT,
"USER_DOOR_DOOR_DEVICE_ID" INT,
"USER_DOOR_DOOR_ID" INT,
"USER_DOOR_STATION_ID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_USER_INFO"
(
"USER_INFO_ID" INT,
"USER_INFO_NAME" VARCHAR(200),
"USER_INFO_NUMBER" VARCHAR(80),
"USER_INFO_CARDNUMBER" VARCHAR(80),
"USER_INFO_PASSWORD" VARCHAR(200),
"USER_INFO_GENDER" INT,
"USER_INFO_PHONE" VARCHAR(44),
"USER_INFO_EMAIL" VARCHAR(200),
"USER_INFO_STATE" INT,
"USER_INFO_UPDATETIME" TIMESTAMP(0),
"USER_INFO_CREATEDTIME" TIMESTAMP(0),
"USER_INFO_FINGERPRINT" VARCHAR(400),
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_USER_LOG"
(
"USER_LOG_ID" INT,
"USER_LOG_STATE" INT,
"USER_LOG_EVENTTYPE" INT,
"USER_LOG_CREATEDTIME" TIMESTAMP(0),
"USER_LOG_DOOR_DEVICE_ID" INT,
"USER_LOG_USER_INFO_ID" INT,
"USER_LOG_DOOR_READER_TYPE" INT,
"STATIONID" INT,
"AUTHORIZEID" VARCHAR(200)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."T_VIDEO_DEVMANAGER"
(
"ID" INT,
"DEVCODE" VARCHAR(160),
"STATIONID" INT,
"DEVTYPEID" INT,
"ENCODERTYPE" INT,
"DEVNAME" VARCHAR(160),
"DEVPASSWORD" VARCHAR(160),
"DEVLONGITUDE" VARCHAR(800),
"DEVLATITUDE" VARCHAR(800),
"IP" VARCHAR(160),
"PORT" VARCHAR(160),
"DEVDESC" VARCHAR(800),
"DEVSTATUS" VARCHAR(160),
"CREATETIME" TIMESTAMP(0),
"STATUS" INT,
"DEVUSER" VARCHAR(200),
"AUTHORIZEID" VARCHAR(200),
"MAPPRING_IP" VARCHAR(50),
"MAPPING_PORT" VARCHAR(50),
"RTMPTYPE" INT,
"RTMPURL" VARCHAR(500)) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "MONITOR_VISUAL"."WORKTABLE"
(
"W_ID" INT,
"OPERATIONTIME" TIMESTAMP(0),
"AUTHORIZEID" VARCHAR(100)) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON TABLE "MONITOR_VISUAL"."WORKTABLE" IS '操作票信息表单';