From 5fd7178b33e698997eab4256b023afa30091f56b Mon Sep 17 00:00:00 2001
From: ‘liusuyi’ <1951119284@qq.com>
Date: 星期二, 05 九月 2023 14:00:34 +0800
Subject: [PATCH] 优化
---
ard-work/src/main/java/com/ruoyi/utils/mqtt/MqttConsumer.java | 2
ard-work/src/main/resources/templates/test.html | 3
ard-work/src/main/java/com/ruoyi/media/service/impl/MediaServiceImpl.java | 27
sql/20230905public.sql | 3337 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4 files changed, 3,356 insertions(+), 13 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/media/service/impl/MediaServiceImpl.java b/ard-work/src/main/java/com/ruoyi/media/service/impl/MediaServiceImpl.java
index bd0b588..e27adb7 100644
--- a/ard-work/src/main/java/com/ruoyi/media/service/impl/MediaServiceImpl.java
+++ b/ard-work/src/main/java/com/ruoyi/media/service/impl/MediaServiceImpl.java
@@ -36,12 +36,13 @@
**/
@Service
@Slf4j(topic = "cmd")
-@Order(1)
+@Order(2)
public class MediaServiceImpl implements IMediaService, ApplicationRunner {
@Resource
VtduMapper vtduMapper;
@Resource
MediaClient mediaClient;
+
@Value("${mediamtx.host}")
String mediamtxHost;
@Value("${mediamtx.enabled}")
@@ -51,18 +52,22 @@
String processName = "mediamtx.exe";
-
@Override
- public void run(ApplicationArguments args) throws Exception {
- log.info("寮�濮嬪姞杞芥祦濯掍綋鍒楄〃");
- List<StreamInfo> paths = paths();
- for(StreamInfo path:paths)
- {
- mediaClient.removePath(path.getName());
+ public void run(ApplicationArguments args){
+ try {
+ log.info("寮�濮嬪姞杞芥祦濯掍綋鍒楄〃");
+ List<StreamInfo> paths = paths();
+ for (StreamInfo path : paths) {
+ mediaClient.removePath(path.getName());
+ }
+ List<Vtdu> vtduList = vtduMapper.selectVtduList(new Vtdu());
+ for (Vtdu v : vtduList) {
+ addPath(v.getName(), v.getRtspUrl(), v.getCodeType(), v.getIsCode());
+ }
}
- List<Vtdu> vtduList = vtduMapper.selectVtduList(new Vtdu());
- for (Vtdu v : vtduList) {
- addPath(v.getName(), v.getRtspUrl(), v.getCodeType(), v.getIsCode());
+ catch (Exception ex)
+ {
+ log.error("鍔犺浇娴佸獟浣撳垪琛ㄥ紓甯�:"+ex.getMessage());
}
}
@PostConstruct
diff --git a/ard-work/src/main/java/com/ruoyi/utils/mqtt/MqttConsumer.java b/ard-work/src/main/java/com/ruoyi/utils/mqtt/MqttConsumer.java
index 80d69ed..35b6dad 100644
--- a/ard-work/src/main/java/com/ruoyi/utils/mqtt/MqttConsumer.java
+++ b/ard-work/src/main/java/com/ruoyi/utils/mqtt/MqttConsumer.java
@@ -18,7 +18,7 @@
**/
@Component
@Slf4j(topic = "mqtt")
-@Order(2)
+@Order(1)
public class MqttConsumer implements ApplicationRunner {
@Value("${mqtt.enabled}")
diff --git a/ard-work/src/main/resources/templates/test.html b/ard-work/src/main/resources/templates/test.html
index 3c125fa..25cbd19 100644
--- a/ard-work/src/main/resources/templates/test.html
+++ b/ard-work/src/main/resources/templates/test.html
@@ -789,7 +789,8 @@
//棰勮娴峰悍鐩告満
function realViewHik(serverip, elem, username, password, ipaddr, port) {
- webRtcServer = new WebRtcStreamer(elem, "http://" + serverip + ":8000");
+ // webRtcServer = new WebRtcStreamer(elem, "http://" + serverip + ":8000");
+ webRtcServer = new WebRtcStreamer(elem, "http://192.168.1.227:9000");
let rtspUrl = "rtsp://" + username + ":" + password + "@" + ipaddr + ":" + port + "/ch1/main/av_stream";
let option = "rtptransport=tcp";
console.log("rtsp鍦板潃锛�" + rtspUrl);
diff --git a/sql/20230905public.sql b/sql/20230905public.sql
new file mode 100644
index 0000000..53f0fd7
--- /dev/null
+++ b/sql/20230905public.sql
@@ -0,0 +1,3337 @@
+/*
+ Navicat Premium Data Transfer
+
+ Source Server : 112.98.126.2(35432)
+ Source Server Type : PostgreSQL
+ Source Server Version : 100003
+ Source Host : 112.98.126.2:35432
+ Source Catalog : ry-vue
+ Source Schema : public
+
+ Target Server Type : PostgreSQL
+ Target Server Version : 100003
+ File Encoding : 65001
+
+ Date: 05/09/2023 10:46:45
+*/
+
+
+-- ----------------------------
+-- Sequence structure for dict_code_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."dict_code_seq";
+CREATE SEQUENCE "public"."dict_code_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 34
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for gen_table_column_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."gen_table_column_id_seq";
+CREATE SEQUENCE "public"."gen_table_column_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 1
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for gen_table_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."gen_table_id_seq";
+CREATE SEQUENCE "public"."gen_table_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 200
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_config_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_config_id_seq";
+CREATE SEQUENCE "public"."sys_config_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 27
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_dept_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_dept_id_seq";
+CREATE SEQUENCE "public"."sys_dept_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 110
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_dict_type_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_dict_type_id_seq";
+CREATE SEQUENCE "public"."sys_dict_type_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 11
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_job_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_job_id_seq";
+CREATE SEQUENCE "public"."sys_job_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 6
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_job_log_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_job_log_id_seq";
+CREATE SEQUENCE "public"."sys_job_log_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 1
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_logininfor_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_logininfor_id_seq";
+CREATE SEQUENCE "public"."sys_logininfor_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 200
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_menu_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_menu_id_seq";
+CREATE SEQUENCE "public"."sys_menu_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 1075
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_notice_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_notice_id_seq";
+CREATE SEQUENCE "public"."sys_notice_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 3
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_oper_log_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_oper_log_id_seq";
+CREATE SEQUENCE "public"."sys_oper_log_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 200
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_post_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_post_id_seq";
+CREATE SEQUENCE "public"."sys_post_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 5
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_role_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_role_id_seq";
+CREATE SEQUENCE "public"."sys_role_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 7
+CACHE 1;
+
+-- ----------------------------
+-- Sequence structure for sys_user_id_seq
+-- ----------------------------
+DROP SEQUENCE IF EXISTS "public"."sys_user_id_seq";
+CREATE SEQUENCE "public"."sys_user_id_seq"
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 99999999
+START 3
+CACHE 1;
+
+-- ----------------------------
+-- Table structure for ard_alarm_access
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_access";
+CREATE TABLE "public"."ard_alarm_access" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "serial_no" varchar(64) COLLATE "pg_catalog"."default",
+ "acs_id" varchar(64) COLLATE "pg_catalog"."default",
+ "acs_name" varchar(64) COLLATE "pg_catalog"."default",
+ "defense_type" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "door_no" int8,
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "pic_url" varchar(255) COLLATE "pg_catalog"."default",
+ "record_url" varchar(255) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "dept_id" int8,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_access"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_alarm_access"."serial_no" IS '浜嬩欢娴佹按鍙�';
+COMMENT ON COLUMN "public"."ard_alarm_access"."acs_id" IS '闂ㄧ涓绘満ID';
+COMMENT ON COLUMN "public"."ard_alarm_access"."acs_name" IS '闂ㄧ涓绘満鍚嶇О';
+COMMENT ON COLUMN "public"."ard_alarm_access"."defense_type" IS '闃插尯绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_access"."alarm_type" IS '鎶ヨ绫诲埆';
+COMMENT ON COLUMN "public"."ard_alarm_access"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_access"."door_no" IS '闂ㄧ紪鍙�';
+COMMENT ON COLUMN "public"."ard_alarm_access"."longitude" IS '闂ㄧ涓绘満缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_access"."latitude" IS '闂ㄧ涓绘満绾害';
+COMMENT ON COLUMN "public"."ard_alarm_access"."altitude" IS '闂ㄧ涓绘満楂樺眰';
+COMMENT ON COLUMN "public"."ard_alarm_access"."pic_url" IS '浜嬩欢鍥剧墖url';
+COMMENT ON COLUMN "public"."ard_alarm_access"."record_url" IS '寮曞褰曞儚url';
+COMMENT ON COLUMN "public"."ard_alarm_access"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_access"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_access"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_access"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_access"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON TABLE "public"."ard_alarm_access" IS '闂ㄧ鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_apponekey
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_apponekey";
+CREATE TABLE "public"."ard_alarm_apponekey" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "user_id" varchar(255) COLLATE "pg_catalog"."default",
+ "name" varchar(255) COLLATE "pg_catalog"."default",
+ "longitude" float8,
+ "latitude" float8,
+ "altitude" float8,
+ "record_url" varchar(255) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "view_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."user_id" IS 'app鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."name" IS 'app鐢ㄦ埛濮撳悕';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."record_url" IS '褰曞儚url';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_apponekey"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON TABLE "public"."ard_alarm_apponekey" IS 'app涓�閿姤璀�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_areas
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_areas";
+CREATE TABLE "public"."ard_alarm_areas" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL DEFAULT replace(((uuid_generate_v4())::character varying)::text, '-'::text, ''::text),
+ "name" varchar(64) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_areas"."id" IS '鎶ヨ鍖篿d';
+COMMENT ON COLUMN "public"."ard_alarm_areas"."name" IS '鎶ヨ鍖哄悕绉�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_camera
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_camera";
+CREATE TABLE "public"."ard_alarm_camera" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "camera_id" varchar(45) COLLATE "pg_catalog"."default",
+ "camera_name" varchar(45) COLLATE "pg_catalog"."default",
+ "camera_channel" varchar(45) COLLATE "pg_catalog"."default",
+ "camera_type" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "rule_id" int4,
+ "pic_url" varchar(255) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "create_by" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_camera"."id" IS '璁板綍ID';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."camera_id" IS '鐩告満id';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."camera_name" IS '鐩告満鍚嶇О';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."camera_channel" IS '鐩告満閫氶亾';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."camera_type" IS '鐩告満绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."rule_id" IS '瑙勫垯id';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."pic_url" IS '鍥剧墖url';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_camera"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON TABLE "public"."ard_alarm_camera" IS '閫氱敤鍏夌數鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_external
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_external";
+CREATE TABLE "public"."ard_alarm_external" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "alarm_id" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_name" varchar(64) COLLATE "pg_catalog"."default",
+ "defense_id" int8,
+ "defense_name" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "record_url" varchar(255) COLLATE "pg_catalog"."default",
+ "sub_sys_no" int8,
+ "alarm_host_id" varchar(64) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "dept_id" int8,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_external"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_alarm_external"."alarm_id" IS '鎶ヨID';
+COMMENT ON COLUMN "public"."ard_alarm_external"."alarm_name" IS '鎶ヨ鍚嶇О';
+COMMENT ON COLUMN "public"."ard_alarm_external"."defense_id" IS '闃插尯ID';
+COMMENT ON COLUMN "public"."ard_alarm_external"."defense_name" IS '闃插尯鍚嶇О';
+COMMENT ON COLUMN "public"."ard_alarm_external"."alarm_type" IS '鎶ヨ绫诲埆';
+COMMENT ON COLUMN "public"."ard_alarm_external"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_external"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_external"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_external"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_alarm_external"."record_url" IS '寮曞褰曞儚url';
+COMMENT ON COLUMN "public"."ard_alarm_external"."sub_sys_no" IS '瀛愮郴缁烮D';
+COMMENT ON COLUMN "public"."ard_alarm_external"."alarm_host_id" IS '鎶ヨ涓绘満ID';
+COMMENT ON COLUMN "public"."ard_alarm_external"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_external"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_external"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_external"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_external"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON TABLE "public"."ard_alarm_external" IS '澶栬仈鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_radar
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_radar";
+CREATE TABLE "public"."ard_alarm_radar" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "target_id" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "record_url1" varchar(300) COLLATE "pg_catalog"."default",
+ "record_url2" varchar(300) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "create_by" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "guide_flag" int4
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_radar"."id" IS '璁板綍ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."name" IS '鍏磋叮鐐瑰悕绉�';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."target_id" IS '鐩爣ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."record_url1" IS '寮曞褰曞儚2';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar"."guide_flag" IS '寮曞鏍囪';
+COMMENT ON TABLE "public"."ard_alarm_radar" IS '闆疯揪鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_radar_fire
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_radar_fire";
+CREATE TABLE "public"."ard_alarm_radar_fire" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "target_id" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "record_url1" varchar(300) COLLATE "pg_catalog"."default",
+ "record_url2" varchar(300) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "create_by" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "guide_flag" int4
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."id" IS '璁板綍ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."name" IS '鍏磋叮鐐瑰悕绉�';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."target_id" IS '鐩爣ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."record_url1" IS '寮曞褰曞儚2';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."guide_flag" IS '寮曞鏍囪';
+COMMENT ON TABLE "public"."ard_alarm_radar_fire" IS '闆疯揪闃茬伀鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_radar_move
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_radar_move";
+CREATE TABLE "public"."ard_alarm_radar_move" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "target_id" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "record_url1" varchar(300) COLLATE "pg_catalog"."default",
+ "record_url2" varchar(300) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "create_by" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "guide_flag" int4
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."id" IS '璁板綍ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."name" IS '鍏磋叮鐐瑰悕绉�';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."target_id" IS '鐩爣ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."record_url1" IS '寮曞褰曞儚1';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."record_url2" IS '寮曞褰曞儚2';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_move"."guide_flag" IS '寮曞鏍囪';
+COMMENT ON TABLE "public"."ard_alarm_radar_move" IS '闆疯揪绉诲姩鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_radar_pump
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_radar_pump";
+CREATE TABLE "public"."ard_alarm_radar_pump" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "target_id" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(45) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "record_url1" varchar(300) COLLATE "pg_catalog"."default",
+ "record_url2" varchar(300) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "create_by" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "guide_flag" int4
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."id" IS '璁板綍ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."name" IS '鍏磋叮鐐瑰悕绉�';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."target_id" IS '鐩爣ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."record_url1" IS '寮曞褰曞儚2';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."guide_flag" IS '寮曞鏍囪';
+COMMENT ON TABLE "public"."ard_alarm_radar_pump" IS '闆疯揪鎶芥补鏈哄仠鏈烘姤璀﹁〃';
+
+-- ----------------------------
+-- Table structure for ard_alarm_stealelec
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_stealelec";
+CREATE TABLE "public"."ard_alarm_stealelec" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "command" int4,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "describe" varchar(45) COLLATE "pg_catalog"."default",
+ "catalog_text" varchar(45) COLLATE "pg_catalog"."default",
+ "description" varchar(45) COLLATE "pg_catalog"."default",
+ "start_time" timestamp(6),
+ "end_time" timestamp(6),
+ "longitude" numeric,
+ "latitude" numeric,
+ "view_time" timestamp(6),
+ "create_by" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "altitude" numeric(64),
+ "record_url" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."id" IS '璁板綍ID';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."command" IS '鍛戒护鍊�';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."name" IS '娌逛簳浠ｇ爜';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."describe" IS '浜曞彿';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."catalog_text" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."description" IS '鎶ヨ鍊�';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."start_time" IS '鎶ヨ寮�濮嬫椂闂�';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."end_time" IS '鎶ヨ缁撴潫鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_alarm_stealelec"."record_url" IS '寮曞褰曞儚url';
+COMMENT ON TABLE "public"."ard_alarm_stealelec" IS '鐩楃數鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_tube
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_tube";
+CREATE TABLE "public"."ard_alarm_tube" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "host" varchar(64) COLLATE "pg_catalog"."default",
+ "tube_id" int8,
+ "tube_name" varchar(64) COLLATE "pg_catalog"."default",
+ "tube_type" varchar(50) COLLATE "pg_catalog"."default",
+ "pipe_diameter" numeric,
+ "color" varchar(20) COLLATE "pg_catalog"."default",
+ "position" int4,
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "type" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(64) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "watcher" varchar(45) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "view_time" timestamp(6),
+ "record_url" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_tube"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."host" IS '鎶ヨ涓绘満';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."tube_id" IS '绠＄嚎id';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."tube_name" IS '绠＄嚎鍚嶇О';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."tube_type" IS '绠＄嚎绫诲瀷-娌圭-姘寸';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."pipe_diameter" IS '绠″緞';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."color" IS '棰滆壊';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."position" IS '浣嶇疆';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."type" IS '绫诲瀷GXALARM';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."alarm_type" IS '绫诲瀷涓枃';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."watcher" IS '鐢ㄦ埛鍚�';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_tube"."record_url" IS '寮曞褰曞儚url';
+COMMENT ON TABLE "public"."ard_alarm_tube" IS '绠＄嚎娉勯湶鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_type_user
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_type_user";
+CREATE TABLE "public"."ard_alarm_type_user" (
+ "command" int2,
+ "alarm_type" varchar(45) COLLATE "pg_catalog"."default",
+ "user_id" varchar(45) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_type_user"."command" IS '鎶ヨ浠ｇ爜';
+COMMENT ON COLUMN "public"."ard_alarm_type_user"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_type_user"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON TABLE "public"."ard_alarm_type_user" IS '鎶ヨ绫诲瀷鐢ㄦ埛鍏宠仈琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarm_wall
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarm_wall";
+CREATE TABLE "public"."ard_alarm_wall" (
+ "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
+ "wall_id" varchar(255) COLLATE "pg_catalog"."default",
+ "wall_name" varchar(255) COLLATE "pg_catalog"."default",
+ "user_id" varchar(255) COLLATE "pg_catalog"."default",
+ "alarm_type" varchar(1) COLLATE "pg_catalog"."default",
+ "alarm_time" timestamp(6),
+ "longitude" float8,
+ "latitude" float8,
+ "altitude" float8,
+ "create_by" varchar(255) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(255) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "view_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_alarm_wall"."id" IS '鎶ヨ涓婚敭';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."wall_id" IS '鍥存爮id';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."wall_name" IS '鍥存爮鍚嶇О';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."user_id" IS '鎶ヨ鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."alarm_type" IS '鎶ヨ绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."alarm_time" IS '鎶ヨ鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarm_wall"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON TABLE "public"."ard_alarm_wall" IS '鐢靛瓙鍥存爮鎶ヨ琛�';
+
+-- ----------------------------
+-- Table structure for ard_alarmpoints
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarmpoints";
+CREATE TABLE "public"."ard_alarmpoints" (
+ "id" int4 NOT NULL,
+ "regionid" int4 NOT NULL,
+ "name" varchar(40) COLLATE "pg_catalog"."default" NOT NULL,
+ "typename" varchar(40) COLLATE "pg_catalog"."default" NOT NULL,
+ "altitude" float8 NOT NULL,
+ "geo" bytea,
+ "geosize" int4,
+ "spatialtype" int4,
+ "longitude" float8,
+ "latitude" float8,
+ "employee" varchar(45) COLLATE "pg_catalog"."default",
+ "ip" varchar(45) COLLATE "pg_catalog"."default",
+ "port" int4
+)
+;
+COMMENT ON TABLE "public"."ard_alarmpoints" IS '鎶ヨ鐐�';
+
+-- ----------------------------
+-- Table structure for ard_alarmpoints_well
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_alarmpoints_well";
+CREATE TABLE "public"."ard_alarmpoints_well" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "well_id" varchar(45) COLLATE "pg_catalog"."default",
+ "well_number" varchar(45) COLLATE "pg_catalog"."default",
+ "oil_production" varchar(45) COLLATE "pg_catalog"."default",
+ "well_block" varchar(45) COLLATE "pg_catalog"."default",
+ "production_date" timestamp(6),
+ "displacement_mode" varchar(45) COLLATE "pg_catalog"."default",
+ "surrounding_environment" varchar(45) COLLATE "pg_catalog"."default",
+ "well_type" varchar(45) COLLATE "pg_catalog"."default",
+ "installed_load" varchar(45) COLLATE "pg_catalog"."default",
+ "metering_station" varchar(45) COLLATE "pg_catalog"."default",
+ "transfer_station" varchar(45) COLLATE "pg_catalog"."default",
+ "dehydration_station" varchar(45) COLLATE "pg_catalog"."default",
+ "run_status" varchar(45) COLLATE "pg_catalog"."default",
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "camera_id" varchar(45) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."well_id" IS '浜曞彿';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."well_number" IS '浜曞彿缂栫爜';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."oil_production" IS '閲囨补鏂瑰紡';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."well_block" IS '杩涙墍灞炲尯鍧�';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."production_date" IS '鎶曚骇鏃ユ湡';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."displacement_mode" IS '椹辨浛鏂瑰紡';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."surrounding_environment" IS '鍛ㄨ竟鐜';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."well_type" IS '娌逛簳绫诲瀷';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."installed_load" IS '瑁呰浇璐熻嵎';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."metering_station" IS '鎵�灞炶閲忕珯鎴栭榾缁勫悕绉�';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."transfer_station" IS '鎵�灞炶浆鎺ョ珯';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."dehydration_station" IS '鎵�灞炶劚姘寸珯';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."run_status" IS '杩愯鐘舵��';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."altitude" IS '娴锋嫈';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_alarmpoints_well"."camera_id" IS '鍏宠仈鐩告満';
+COMMENT ON TABLE "public"."ard_alarmpoints_well" IS '浜曠鐞嗚〃';
+
+-- ----------------------------
+-- Table structure for ard_app_patrolplan
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_patrolplan";
+CREATE TABLE "public"."ard_app_patrolplan" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "plan_name" varchar(255) COLLATE "pg_catalog"."default",
+ "patro_begin_time" varchar(100) COLLATE "pg_catalog"."default",
+ "patro_end_time" varchar(100) COLLATE "pg_catalog"."default",
+ "user_id" varchar(50) COLLATE "pg_catalog"."default",
+ "cycle" varchar(10) COLLATE "pg_catalog"."default",
+ "create_time" varchar(100) COLLATE "pg_catalog"."default",
+ "del_name" varchar(255) COLLATE "pg_catalog"."default",
+ "del_time" varchar(255) COLLATE "pg_catalog"."default",
+ "son" varchar(50) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."plan_name" IS '宸℃璁″垝鍚嶇О';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."patro_begin_time" IS '寮�濮嬫椂闂�(姣忓ぉ涓烘椂鍒嗙锛屼粎涓�娆′负骞存湀鏃ユ椂鍒嗙)';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."patro_end_time" IS '缁撴潫鏃堕棿(姣忓ぉ涓烘椂鍒嗙锛屼粎涓�娆′负骞存湀鏃ユ椂鍒嗙)';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."user_id" IS '鍒跺畾浜轰富閿�';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."cycle" IS '鍛ㄦ湡(day,once)';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."del_name" IS '鍒犻櫎浜�';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."del_time" IS '鍒犻櫎鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_patrolplan"."son" IS '鏄惁閫氱煡';
+
+-- ----------------------------
+-- Table structure for ard_app_patrolpoint
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_patrolpoint";
+CREATE TABLE "public"."ard_app_patrolpoint" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "patrolplan_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "alarmpoints_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "type" varchar(50) COLLATE "pg_catalog"."default",
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_patrolpoint"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint"."patrolplan_id" IS '宸℃涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint"."alarmpoints_id" IS '鍏磋叮鐐逛富閿�';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint"."type" IS '绫诲瀷';
+
+-- ----------------------------
+-- Table structure for ard_app_patrolpoint_record
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_patrolpoint_record";
+CREATE TABLE "public"."ard_app_patrolpoint_record" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "remark" varchar(500) COLLATE "pg_catalog"."default",
+ "longitude" varchar(255) COLLATE "pg_catalog"."default",
+ "latitude" varchar(255) COLLATE "pg_catalog"."default",
+ "user_id" varchar(50) COLLATE "pg_catalog"."default",
+ "record_time" varchar(100) COLLATE "pg_catalog"."default",
+ "app_patrolpoints_id" varchar(50) COLLATE "pg_catalog"."default",
+ "plan_id" varchar(255) COLLATE "pg_catalog"."default",
+ "record_img" varchar(255) COLLATE "pg_catalog"."default",
+ "plan_name" varchar(255) COLLATE "pg_catalog"."default",
+ "user_name" varchar(255) COLLATE "pg_catalog"."default",
+ "app_patrolpoints_name" varchar(255) COLLATE "pg_catalog"."default",
+ "points_num" int4
+)
+;
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."remark" IS '鏂囧瓧璇存槑';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."user_id" IS '鎵撳崱浜轰富閿�';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."record_time" IS '鎵撳崱鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."app_patrolpoints_id" IS '宸℃鐐逛富閿�';
+
+-- ----------------------------
+-- Table structure for ard_app_patrolpoint_record_img
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_patrolpoint_record_img";
+CREATE TABLE "public"."ard_app_patrolpoint_record_img" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "app_patrolponit_record_id" varchar(50) COLLATE "pg_catalog"."default",
+ "img" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record_img"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record_img"."app_patrolponit_record_id" IS '宸℃璁板綍涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patrolpoint_record_img"."img" IS '宸℃鍥剧墖';
+
+-- ----------------------------
+-- Table structure for ard_app_patroluser
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_patroluser";
+CREATE TABLE "public"."ard_app_patroluser" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "patrolplan_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "app_user_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_patroluser"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patroluser"."patrolplan_id" IS '宸℃涓婚敭';
+COMMENT ON COLUMN "public"."ard_app_patroluser"."app_user_id" IS 'app鍗曞叺绔敤鎴蜂富閿�';
+
+-- ----------------------------
+-- Table structure for ard_app_position
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_position";
+CREATE TABLE "public"."ard_app_position" (
+ "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "longitude" float8,
+ "latitude" float8,
+ "altitude" float8,
+ "speed" float8,
+ "bearing" float8,
+ "create_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_app_position"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_app_position"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_app_position"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_app_position"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_app_position"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_app_position"."speed" IS '閫熷害';
+COMMENT ON COLUMN "public"."ard_app_position"."bearing" IS '鏂瑰悜瑙�';
+COMMENT ON COLUMN "public"."ard_app_position"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON TABLE "public"."ard_app_position" IS 'app浣嶇疆琛�';
+
+-- ----------------------------
+-- Table structure for ard_app_task
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_task";
+CREATE TABLE "public"."ard_app_task" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(64) COLLATE "pg_catalog"."default",
+ "text" varchar(1000) COLLATE "pg_catalog"."default",
+ "voice" varchar(255) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "user_id" varchar(32) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "type" varchar(1) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_task"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_app_task"."name" IS '浠诲姟鍚嶇О';
+COMMENT ON COLUMN "public"."ard_app_task"."text" IS '浠诲姟鏂囨湰';
+COMMENT ON COLUMN "public"."ard_app_task"."voice" IS '浠诲姟璇煶';
+COMMENT ON COLUMN "public"."ard_app_task"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_app_task"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_app_task"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_app_task"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_task"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_app_task"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_task"."type" IS '浠诲姟绫诲瀷0-鏅�氫换鍔� 1-鎶ヨ浠诲姟';
+COMMENT ON TABLE "public"."ard_app_task" IS 'app浠诲姟绠＄悊琛�';
+
+-- ----------------------------
+-- Table structure for ard_app_task_detail
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_task_detail";
+CREATE TABLE "public"."ard_app_task_detail" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(255) COLLATE "pg_catalog"."default",
+ "longitude" float8,
+ "latitude" float8,
+ "altitude" float8,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "text" varchar(1000) COLLATE "pg_catalog"."default",
+ "voice" varchar(255) COLLATE "pg_catalog"."default",
+ "task_id" varchar(64) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "clock_in_pic_url" varchar(255) COLLATE "pg_catalog"."default",
+ "view_time" timestamp(6),
+ "view_position" varchar(255) COLLATE "pg_catalog"."default",
+ "clock_in_time" timestamp(6),
+ "view_flag" char(1) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_task_detail"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."name" IS '鍏磋叮鐐瑰悕绉�';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."longitude" IS '鍏磋叮鐐圭粡搴�';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."latitude" IS '鍏磋叮鐐圭含搴�';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."altitude" IS '鍏磋叮鐐归珮灞�';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."user_id" IS '鍏宠仈鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."text" IS '浠诲姟鎻忚堪鏂囨湰';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."voice" IS '浠诲姟鎻忚堪璇煶';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."task_id" IS '浠诲姟ID';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."status" IS '鐘舵��(0鏈畬鎴� 1宸插畬鎴�)';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."clock_in_pic_url" IS '鎵撳崱鍥剧墖url';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."view_time" IS '鏌ョ湅鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."view_position" IS '鏌ョ湅浣嶇疆';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."clock_in_time" IS '鎵撳崱鏃堕棿';
+COMMENT ON COLUMN "public"."ard_app_task_detail"."view_flag" IS '寮圭獥鏍囪';
+COMMENT ON TABLE "public"."ard_app_task_detail" IS 'app浠诲姟璇︽儏琛�';
+
+-- ----------------------------
+-- Table structure for ard_app_task_detail_pic
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_task_detail_pic";
+CREATE TABLE "public"."ard_app_task_detail_pic" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "task_detail_id" varchar(64) COLLATE "pg_catalog"."default",
+ "pic_url" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_task_detail_pic"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_app_task_detail_pic"."task_detail_id" IS 'app浠诲姟璇︽儏ID';
+COMMENT ON COLUMN "public"."ard_app_task_detail_pic"."pic_url" IS 'app浠诲姟鍥剧墖url';
+COMMENT ON TABLE "public"."ard_app_task_detail_pic" IS 'app浠诲姟璇︽儏鍥剧墖琛�';
+
+-- ----------------------------
+-- Table structure for ard_app_task_pic
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_task_pic";
+CREATE TABLE "public"."ard_app_task_pic" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "task_id" varchar(64) COLLATE "pg_catalog"."default",
+ "pic_url" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_task_pic"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_app_task_pic"."task_id" IS 'app浠诲姟ID';
+COMMENT ON COLUMN "public"."ard_app_task_pic"."pic_url" IS 'app浠诲姟鍥剧墖url';
+COMMENT ON TABLE "public"."ard_app_task_pic" IS 'app浠诲姟鍥剧墖琛�';
+
+-- ----------------------------
+-- Table structure for ard_app_task_text
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_app_task_text";
+CREATE TABLE "public"."ard_app_task_text" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "text" varchar(1000) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_app_task_text"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_app_task_text"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_app_task_text"."text" IS 'app浠诲姟鎻忚堪';
+COMMENT ON TABLE "public"."ard_app_task_text" IS 'app浠诲姟鎻忚堪琛�';
+
+-- ----------------------------
+-- Table structure for ard_camera_priority
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_camera_priority";
+CREATE TABLE "public"."ard_camera_priority" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL DEFAULT replace(((uuid_generate_v4())::character varying)::text, '-'::text, ''::text),
+ "operator_id" varchar(45) COLLATE "pg_catalog"."default" NOT NULL,
+ "operator_name" varchar(20) COLLATE "pg_catalog"."default",
+ "priority_level" int4,
+ "dept_id" int4,
+ "user_id" varchar(32) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_camera_priority"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_camera_priority"."operator_id" IS '鎿嶄綔鍛業D';
+COMMENT ON COLUMN "public"."ard_camera_priority"."operator_name" IS '鎿嶄綔鍛樺鍚�';
+COMMENT ON COLUMN "public"."ard_camera_priority"."priority_level" IS '浼樺厛绛夌骇';
+COMMENT ON COLUMN "public"."ard_camera_priority"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_camera_priority"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_camera_priority"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_camera_priority"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_camera_priority"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_camera_priority"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."ard_camera_priority" IS '鐩告満鎿嶆帶浼樺厛绾ц〃';
+
+-- ----------------------------
+-- Table structure for ard_cameras
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_cameras";
+CREATE TABLE "public"."ard_cameras" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default" NOT NULL,
+ "ip" varchar(45) COLLATE "pg_catalog"."default" NOT NULL,
+ "port" int8,
+ "username" varchar(20) COLLATE "pg_catalog"."default",
+ "password" varchar(20) COLLATE "pg_catalog"."default",
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "gdtype" varchar(20) COLLATE "pg_catalog"."default",
+ "channel" int4,
+ "dept_id" int4,
+ "user_id" varchar(32) COLLATE "pg_catalog"."default",
+ "login_id" int4,
+ "cam_fov" numeric,
+ "cam_heading" numeric,
+ "cam_pitch" numeric,
+ "cam_roll" numeric,
+ "cam_near" numeric,
+ "cam_far" numeric,
+ "cam_aspectratio" numeric,
+ "cam_depth" numeric,
+ "tower_id" varchar(64) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "operator_id" varchar(32) COLLATE "pg_catalog"."default",
+ "operator_expired" timestamp(6),
+ "rtsp_port" int4,
+ "cam_max_visible_distance" numeric(32),
+ "cam_alarm_guide_enable" int2
+)
+;
+COMMENT ON COLUMN "public"."ard_cameras"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_cameras"."name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."ard_cameras"."ip" IS 'ip';
+COMMENT ON COLUMN "public"."ard_cameras"."port" IS '绔彛';
+COMMENT ON COLUMN "public"."ard_cameras"."username" IS '鐢ㄦ埛鍚�';
+COMMENT ON COLUMN "public"."ard_cameras"."password" IS '瀵嗙爜';
+COMMENT ON COLUMN "public"."ard_cameras"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_cameras"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_cameras"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_cameras"."gdtype" IS '鍏夌數绫诲瀷';
+COMMENT ON COLUMN "public"."ard_cameras"."channel" IS '閫氶亾鍙�';
+COMMENT ON COLUMN "public"."ard_cameras"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_cameras"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_cameras"."login_id" IS '鐧诲綍ID';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_fov" IS '瑙嗗満瑙�';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_heading" IS '鏂逛綅瑙�';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_pitch" IS '淇话瑙�';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_roll" IS '鏃嬭浆瑙�';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_near" IS '璁惧鐒﹁窛';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_far" IS '鎷嶆憚璺濈';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_aspectratio" IS '瀹介珮姣�';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_depth" IS '铻嶅悎娣卞害';
+COMMENT ON COLUMN "public"."ard_cameras"."tower_id" IS '鎵�灞炲ID';
+COMMENT ON COLUMN "public"."ard_cameras"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_cameras"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_cameras"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_cameras"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_cameras"."operator_id" IS '鐩告満鎿嶄綔鑰�';
+COMMENT ON COLUMN "public"."ard_cameras"."operator_expired" IS '鐩告満鎿嶄綔鏈夋晥鏈�';
+COMMENT ON COLUMN "public"."ard_cameras"."rtsp_port" IS 'rtsp绔彛';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_max_visible_distance" IS '鏈�澶у彲瑙嗚窛绂�';
+COMMENT ON COLUMN "public"."ard_cameras"."cam_alarm_guide_enable" IS '鐩告満鎶ヨ寮曞寮�鍏�';
+COMMENT ON TABLE "public"."ard_cameras" IS '鐩告満璁惧琛�';
+
+-- ----------------------------
+-- Table structure for ard_channel
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_channel";
+CREATE TABLE "public"."ard_channel" (
+ "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(255) COLLATE "pg_catalog"."default",
+ "chan_no" int4,
+ "device_id" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_channel"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_channel"."name" IS '閫氶亾鍚嶇О';
+COMMENT ON COLUMN "public"."ard_channel"."chan_no" IS '閫氶亾鍙�';
+COMMENT ON COLUMN "public"."ard_channel"."device_id" IS '鎵�灞炶澶噄d';
+COMMENT ON TABLE "public"."ard_channel" IS '閫氶亾琛�';
+
+-- ----------------------------
+-- Table structure for ard_dispatch_police
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_dispatch_police";
+CREATE TABLE "public"."ard_dispatch_police" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(64) COLLATE "pg_catalog"."default",
+ "text" varchar(1000) COLLATE "pg_catalog"."default",
+ "longitude" float8,
+ "latitude" float8,
+ "dept_id" int4,
+ "user_id" varchar(32) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_dispatch_police"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."name" IS '娲捐鍚嶇О';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."text" IS '鎻忚堪';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_dispatch_police"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."ard_dispatch_police" IS '娲捐绠＄悊琛�';
+
+-- ----------------------------
+-- Table structure for ard_dispatch_police_user
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_dispatch_police_user";
+CREATE TABLE "public"."ard_dispatch_police_user" (
+ "dispatch_id" varchar(64) COLLATE "pg_catalog"."default",
+ "user_id" varchar(32) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_dispatch_police_user"."dispatch_id" IS '娲捐ID';
+COMMENT ON COLUMN "public"."ard_dispatch_police_user"."user_id" IS '鍏宠仈鐢ㄦ埛ID';
+COMMENT ON TABLE "public"."ard_dispatch_police_user" IS '娲捐鍏宠仈鐢ㄦ埛琛�';
+
+-- ----------------------------
+-- Table structure for ard_equip_alarm_areas
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_equip_alarm_areas";
+CREATE TABLE "public"."ard_equip_alarm_areas" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL DEFAULT replace(((uuid_generate_v4())::character varying)::text, '-'::text, ''::text),
+ "region_id" varchar(64) COLLATE "pg_catalog"."default",
+ "equip_id" varchar(64) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_equip_alarm_areas"."region_id" IS '鎶ヨ鍖篿d';
+COMMENT ON COLUMN "public"."ard_equip_alarm_areas"."equip_id" IS '瀵瑰簲澶栬仈璁惧id';
+
+-- ----------------------------
+-- Table structure for ard_equip_external
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_equip_external";
+CREATE TABLE "public"."ard_equip_external" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(64) COLLATE "pg_catalog"."default",
+ "type" int2,
+ "factory" int2,
+ "ip" varchar(24) COLLATE "pg_catalog"."default",
+ "port" int2,
+ "username" varchar(64) COLLATE "pg_catalog"."default",
+ "password" varchar(64) COLLATE "pg_catalog"."default",
+ "longitude" float8,
+ "latitude" float8,
+ "altitude" float8,
+ "dept_id" int8,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_equip_external"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_equip_external"."name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."ard_equip_external"."type" IS '璁惧绫诲瀷';
+COMMENT ON COLUMN "public"."ard_equip_external"."factory" IS '鍘傚晢';
+COMMENT ON COLUMN "public"."ard_equip_external"."ip" IS 'ip';
+COMMENT ON COLUMN "public"."ard_equip_external"."port" IS '绔彛';
+COMMENT ON COLUMN "public"."ard_equip_external"."username" IS '鐢ㄦ埛鍚�';
+COMMENT ON COLUMN "public"."ard_equip_external"."password" IS '瀵嗙爜';
+COMMENT ON COLUMN "public"."ard_equip_external"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_equip_external"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_equip_external"."altitude" IS '瀹夎楂樺害';
+COMMENT ON COLUMN "public"."ard_equip_external"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_equip_external"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_equip_external"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_equip_external"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_equip_external"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_equip_external"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."ard_equip_external" IS '澶栬仈璁惧绠＄悊琛�';
+
+-- ----------------------------
+-- Table structure for ard_equip_radar
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_equip_radar";
+CREATE TABLE "public"."ard_equip_radar" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "del_flag" char(1) COLLATE "pg_catalog"."default",
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "longitude" float8,
+ "latitude" float8,
+ "altitude" float8,
+ "radar_date" timestamp(6),
+ "dept_id" int8,
+ "pitch" varchar(24) COLLATE "pg_catalog"."default",
+ "tower_id" varchar(64) COLLATE "pg_catalog"."default",
+ "image_width" varchar(24) COLLATE "pg_catalog"."default",
+ "image_height" varchar(24) COLLATE "pg_catalog"."default",
+ "type" varchar(64) COLLATE "pg_catalog"."default",
+ "ip" varchar(24) COLLATE "pg_catalog"."default",
+ "port" varchar(12) COLLATE "pg_catalog"."default",
+ "operate" varchar(64) COLLATE "pg_catalog"."default",
+ "name" varchar(64) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_equip_radar"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_equip_radar"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_equip_radar"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_equip_radar"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_equip_radar"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_equip_radar"."del_flag" IS '鍒犻櫎鏍囪';
+COMMENT ON COLUMN "public"."ard_equip_radar"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_equip_radar"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_equip_radar"."latitude" IS '缁村害';
+COMMENT ON COLUMN "public"."ard_equip_radar"."altitude" IS '楂樼▼';
+COMMENT ON COLUMN "public"."ard_equip_radar"."radar_date" IS '瀹夎鏃堕棿';
+COMMENT ON COLUMN "public"."ard_equip_radar"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_equip_radar"."pitch" IS '淇话瑙�';
+COMMENT ON COLUMN "public"."ard_equip_radar"."tower_id" IS '濉攊d';
+COMMENT ON COLUMN "public"."ard_equip_radar"."image_width" IS '鍥惧儚瀹藉害';
+COMMENT ON COLUMN "public"."ard_equip_radar"."image_height" IS '鍥惧儚楂樺害';
+COMMENT ON COLUMN "public"."ard_equip_radar"."type" IS '鍨嬪彿';
+COMMENT ON COLUMN "public"."ard_equip_radar"."ip" IS 'ip';
+COMMENT ON COLUMN "public"."ard_equip_radar"."port" IS '绔彛';
+COMMENT ON COLUMN "public"."ard_equip_radar"."operate" IS '鎿嶄綔鍛榠d';
+COMMENT ON COLUMN "public"."ard_equip_radar"."name" IS '鍚嶇О';
+COMMENT ON TABLE "public"."ard_equip_radar" IS '闆疯揪绠＄悊琛�';
+
+-- ----------------------------
+-- Table structure for ard_police_room
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_police_room";
+CREATE TABLE "public"."ard_police_room" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_police_room"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_police_room"."name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."ard_police_room"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_police_room"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_police_room"."altitude" IS '楂樼▼';
+COMMENT ON COLUMN "public"."ard_police_room"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_police_room"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_police_room"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_police_room"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_police_room"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_police_room"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."ard_police_room" IS '璀﹀姟瀹ょ鐞嗚〃';
+
+-- ----------------------------
+-- Table structure for ard_pull_stream
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_pull_stream";
+CREATE TABLE "public"."ard_pull_stream" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "rtsp_url" varchar(64) COLLATE "pg_catalog"."default",
+ "protocol" varchar(64) COLLATE "pg_catalog"."default",
+ "up_traffic" varchar(64) COLLATE "pg_catalog"."default",
+ "down_traffic" varchar(64) COLLATE "pg_catalog"."default",
+ "beginTime" timestamp(6),
+ "name" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_pull_stream"."id" IS '浼氳瘽id';
+COMMENT ON COLUMN "public"."ard_pull_stream"."rtsp_url" IS 'rtsp鎾斁鍦板潃';
+COMMENT ON COLUMN "public"."ard_pull_stream"."protocol" IS '浼犺緭鍗忚';
+COMMENT ON COLUMN "public"."ard_pull_stream"."up_traffic" IS '涓婅娴侀噺';
+COMMENT ON COLUMN "public"."ard_pull_stream"."down_traffic" IS '涓嬭娴侀噺';
+COMMENT ON COLUMN "public"."ard_pull_stream"."beginTime" IS '寮�濮嬫帹娴佹椂闂�';
+COMMENT ON COLUMN "public"."ard_pull_stream"."name" IS '鍚嶇О';
+COMMENT ON TABLE "public"."ard_pull_stream" IS '娴佸獟浣撴媺娴佽〃';
+
+-- ----------------------------
+-- Table structure for ard_push_stream
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_push_stream";
+CREATE TABLE "public"."ard_push_stream" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "rtsp_source" varchar(64) COLLATE "pg_catalog"."default",
+ "rtsp_url" varchar(64) COLLATE "pg_catalog"."default",
+ "protocol" varchar(64) COLLATE "pg_catalog"."default",
+ "up_traffic" varchar(64) COLLATE "pg_catalog"."default",
+ "down_traffic" varchar(64) COLLATE "pg_catalog"."default",
+ "num" int4,
+ "beginTime" timestamp(6),
+ "name" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_push_stream"."id" IS '浼氳瘽ID';
+COMMENT ON COLUMN "public"."ard_push_stream"."rtsp_source" IS 'rtsp婧愬湴鍧�';
+COMMENT ON COLUMN "public"."ard_push_stream"."rtsp_url" IS 'rtsp鎾斁鍦板潃';
+COMMENT ON COLUMN "public"."ard_push_stream"."protocol" IS '浼犺緭鍗忚';
+COMMENT ON COLUMN "public"."ard_push_stream"."up_traffic" IS '涓婅娴侀噺';
+COMMENT ON COLUMN "public"."ard_push_stream"."down_traffic" IS '涓嬭娴侀噺';
+COMMENT ON COLUMN "public"."ard_push_stream"."num" IS '鎷夋祦鏁伴噺';
+COMMENT ON COLUMN "public"."ard_push_stream"."beginTime" IS '寮�濮嬫帹娴佹椂闂�';
+COMMENT ON COLUMN "public"."ard_push_stream"."name" IS '鍚嶇О';
+COMMENT ON TABLE "public"."ard_push_stream" IS '娴佸獟浣撴帹娴佽〃';
+
+-- ----------------------------
+-- Table structure for ard_sy_car
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_sy_car";
+CREATE TABLE "public"."ard_sy_car" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "car_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "car_model" varchar(500) COLLATE "pg_catalog"."default",
+ "car_type" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "car_brand" varchar(50) COLLATE "pg_catalog"."default",
+ "dept_id" int8 NOT NULL,
+ "car_picture" varchar(500) COLLATE "pg_catalog"."default",
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_2" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_3" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_sy_car"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_sy_car"."car_id" IS '杞﹁締涓婚敭';
+COMMENT ON COLUMN "public"."ard_sy_car"."car_model" IS '杞﹁締妯″瀷';
+COMMENT ON COLUMN "public"."ard_sy_car"."car_type" IS '杞﹁締绫诲瀷';
+COMMENT ON COLUMN "public"."ard_sy_car"."car_brand" IS '杞﹁締鍝佺墝';
+COMMENT ON COLUMN "public"."ard_sy_car"."dept_id" IS '鎵�灞為儴闂ㄤ富閿�';
+COMMENT ON COLUMN "public"."ard_sy_car"."car_picture" IS '杞﹁締鍥剧墖';
+COMMENT ON COLUMN "public"."ard_sy_car"."reserved_1" IS '棰勭暀1';
+COMMENT ON COLUMN "public"."ard_sy_car"."reserved_2" IS '棰勭暀2';
+COMMENT ON COLUMN "public"."ard_sy_car"."reserved_3" IS '棰勭暀3';
+COMMENT ON TABLE "public"."ard_sy_car" IS '涓変竴杞﹁締';
+
+-- ----------------------------
+-- Table structure for ard_sy_car_day
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_sy_car_day";
+CREATE TABLE "public"."ard_sy_car_day" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "car_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "day" varchar(255) COLLATE "pg_catalog"."default",
+ "first_time" varchar(50) COLLATE "pg_catalog"."default",
+ "end_time" varchar(50) COLLATE "pg_catalog"."default",
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_sy_car_day"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_sy_car_day"."car_id" IS '杞﹁締涓婚敭';
+COMMENT ON COLUMN "public"."ard_sy_car_day"."day" IS '涓婃姤鏃ワ紙骞存湀鏃ワ級';
+COMMENT ON COLUMN "public"."ard_sy_car_day"."first_time" IS '棣栨涓婃姤鏃堕棿';
+COMMENT ON COLUMN "public"."ard_sy_car_day"."end_time" IS '鏈�鍚庝笂鎶ユ椂闂�';
+
+-- ----------------------------
+-- Table structure for ard_sy_user
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_sy_user";
+CREATE TABLE "public"."ard_sy_user" (
+ "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "sys_user_id" varchar(50) COLLATE "pg_catalog"."default",
+ "user_id" varchar(50) COLLATE "pg_catalog"."default",
+ "password" varchar(50) COLLATE "pg_catalog"."default",
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_2" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_sy_user"."id" IS '涓婚敭';
+COMMENT ON COLUMN "public"."ard_sy_user"."sys_user_id" IS '鐢ㄦ埛涓婚敭';
+COMMENT ON COLUMN "public"."ard_sy_user"."user_id" IS '涓変竴鐢ㄦ埛璐﹀彿';
+COMMENT ON COLUMN "public"."ard_sy_user"."password" IS '涓変竴鐢ㄦ埛瀵嗙爜';
+COMMENT ON COLUMN "public"."ard_sy_user"."reserved_1" IS '棰勭暀1';
+COMMENT ON COLUMN "public"."ard_sy_user"."reserved_2" IS '棰勭暀2';
+COMMENT ON TABLE "public"."ard_sy_user" IS '涓変竴杞﹁締鐢ㄦ埛';
+
+-- ----------------------------
+-- Table structure for ard_tiles3d
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_tiles3d";
+CREATE TABLE "public"."ard_tiles3d" (
+ "tiles_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "tiles_name" varchar(500) COLLATE "pg_catalog"."default",
+ "tiles_url" varchar(500) COLLATE "pg_catalog"."default",
+ "tiles_type" varchar(500) COLLATE "pg_catalog"."default",
+ "tiles_x" int4,
+ "tiles_y" int4,
+ "tiles_z" int4,
+ "cam_poi" varchar(500) COLLATE "pg_catalog"."default",
+ "cam_heading" numeric,
+ "cam_pitch" numeric,
+ "maximum_screen_space_error" int4,
+ "maximum_memory_usage" int4,
+ "cull_requests_while_moving_multiplier" numeric,
+ "dynamic_screen_space_error_density" numeric,
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_2" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_3" varchar(255) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "user_id" varchar(32) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_name" IS '瀹炴櫙涓夌淮鍚嶇О';
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_url" IS '瀹炴櫙涓夌淮璺緞';
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_type" IS '鏄惁榛樿鍔犺浇ff榛樿鍒濆鍖�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_x" IS 'x杞村亸绉�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_y" IS 'y杞村亸绉�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."tiles_z" IS 'z杞村亸绉�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."cam_poi" IS '鐩告満鍧愭爣';
+COMMENT ON COLUMN "public"."ard_tiles3d"."cam_heading" IS '鐩告満鏂逛綅';
+COMMENT ON COLUMN "public"."ard_tiles3d"."cam_pitch" IS '鐩告満淇话';
+COMMENT ON COLUMN "public"."ard_tiles3d"."maximum_screen_space_error" IS '灞忓箷绌洪棿璇樊';
+COMMENT ON COLUMN "public"."ard_tiles3d"."maximum_memory_usage" IS '鍐呭瓨鏈�澶т娇鐢ㄩ噺';
+COMMENT ON COLUMN "public"."ard_tiles3d"."cull_requests_while_moving_multiplier" IS '鑷姩瓒呮竻鍖栨ā鍨�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."dynamic_screen_space_error_density" IS '妯″瀷鍔犺浇閫熷害';
+COMMENT ON COLUMN "public"."ard_tiles3d"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_tiles3d"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_tiles3d"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_tiles3d"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_tiles3d"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."ard_tiles3d" IS '涓夌淮瀹炴櫙琛�';
+
+-- ----------------------------
+-- Table structure for ard_towers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_towers";
+CREATE TABLE "public"."ard_towers" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "direction" varchar(255) COLLATE "pg_catalog"."default",
+ "tower_scale" varchar(255) COLLATE "pg_catalog"."default",
+ "tower_path" varchar(255) COLLATE "pg_catalog"."default",
+ "pe_offset" varchar(255) COLLATE "pg_catalog"."default",
+ "pe_scale" varchar(255) COLLATE "pg_catalog"."default",
+ "pe_path" varchar(255) COLLATE "pg_catalog"."default",
+ "radar_offset" varchar(255) COLLATE "pg_catalog"."default",
+ "radar_scale" varchar(255) COLLATE "pg_catalog"."default",
+ "radar_path" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_towers"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_towers"."name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."ard_towers"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_towers"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_towers"."altitude" IS '楂樼▼';
+COMMENT ON COLUMN "public"."ard_towers"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_towers"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_towers"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_towers"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_towers"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_towers"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_towers"."direction" IS '濉旀柟浣嶈';
+COMMENT ON COLUMN "public"."ard_towers"."tower_scale" IS '濉旀瘮渚�';
+COMMENT ON COLUMN "public"."ard_towers"."tower_path" IS '濉旀ā鍨�';
+COMMENT ON COLUMN "public"."ard_towers"."pe_offset" IS '鍏夌數鍋忕Щ';
+COMMENT ON COLUMN "public"."ard_towers"."pe_scale" IS '鍏夌數姣斾緥';
+COMMENT ON COLUMN "public"."ard_towers"."pe_path" IS '鍏夌數妯″瀷';
+COMMENT ON COLUMN "public"."ard_towers"."radar_offset" IS '闆疯揪鍋忕Щ';
+COMMENT ON COLUMN "public"."ard_towers"."radar_scale" IS '闆疯揪缂╂斁';
+COMMENT ON COLUMN "public"."ard_towers"."radar_path" IS '闆疯揪妯″瀷';
+COMMENT ON TABLE "public"."ard_towers" IS '濉旂鐞嗚〃';
+
+-- ----------------------------
+-- Table structure for ard_tubes
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_tubes";
+CREATE TABLE "public"."ard_tubes" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(45) COLLATE "pg_catalog"."default",
+ "type" varchar(45) COLLATE "pg_catalog"."default",
+ "pipe_diameter" varchar(45) COLLATE "pg_catalog"."default",
+ "color" varchar(45) COLLATE "pg_catalog"."default",
+ "child_count" int4,
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_tubes"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_tubes"."name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."ard_tubes"."type" IS '绫诲瀷';
+COMMENT ON COLUMN "public"."ard_tubes"."pipe_diameter" IS '绠″緞';
+COMMENT ON COLUMN "public"."ard_tubes"."color" IS '棰滆壊';
+COMMENT ON COLUMN "public"."ard_tubes"."child_count" IS '瀛愮绾挎暟閲�';
+COMMENT ON COLUMN "public"."ard_tubes"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_tubes"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_tubes"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_tubes"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_tubes"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_tubes"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."ard_tubes" IS '绠＄嚎绠＄悊琛�';
+
+-- ----------------------------
+-- Table structure for ard_tubes_details
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_tubes_details";
+CREATE TABLE "public"."ard_tubes_details" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "reel_number" varchar(45) COLLATE "pg_catalog"."default",
+ "inflection_point_number" varchar(45) COLLATE "pg_catalog"."default",
+ "longitude" numeric,
+ "latitude" numeric,
+ "altitude" numeric,
+ "depth" numeric,
+ "tube_id" varchar(45) COLLATE "pg_catalog"."default",
+ "user_id" varchar(45) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_tubes_details"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_tubes_details"."reel_number" IS '鍗峰彿';
+COMMENT ON COLUMN "public"."ard_tubes_details"."inflection_point_number" IS '鎷愮偣缂栧彿';
+COMMENT ON COLUMN "public"."ard_tubes_details"."longitude" IS '缁忓害';
+COMMENT ON COLUMN "public"."ard_tubes_details"."latitude" IS '绾害';
+COMMENT ON COLUMN "public"."ard_tubes_details"."altitude" IS '楂樺眰';
+COMMENT ON COLUMN "public"."ard_tubes_details"."depth" IS '娣卞害';
+COMMENT ON COLUMN "public"."ard_tubes_details"."tube_id" IS '绠＄嚎ID';
+COMMENT ON COLUMN "public"."ard_tubes_details"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_tubes_details"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_tubes_details"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_tubes_details"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_tubes_details"."update_by" IS '淇敼鑰�';
+COMMENT ON COLUMN "public"."ard_tubes_details"."update_time" IS '淇敼鏃堕棿';
+COMMENT ON TABLE "public"."ard_tubes_details" IS '绠＄嚎璇︾粏琛�';
+
+-- ----------------------------
+-- Table structure for ard_video_inspect_record
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_video_inspect_record";
+CREATE TABLE "public"."ard_video_inspect_record" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "start_time" varchar(64) COLLATE "pg_catalog"."default",
+ "end_time" varchar(64) COLLATE "pg_catalog"."default",
+ "record_file_path" varchar(200) COLLATE "pg_catalog"."default",
+ "step_id" varchar(64) COLLATE "pg_catalog"."default",
+ "dept_id" varchar(64) COLLATE "pg_catalog"."default",
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "well_name" varchar(64) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."start_time" IS '宸℃寮�濮嬫椂闂�';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."end_time" IS '宸℃缁撴潫鏃堕棿';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."record_file_path" IS '褰曞儚鏂囦欢璺緞';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."step_id" IS '姝ラid';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_video_inspect_record"."well_name" IS '浜曞悕绉�';
+COMMENT ON TABLE "public"."ard_video_inspect_record" IS '瑙嗛宸℃璁板綍';
+
+-- ----------------------------
+-- Table structure for ard_video_inspect_task
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_video_inspect_task";
+CREATE TABLE "public"."ard_video_inspect_task" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "task_name" varchar(200) COLLATE "pg_catalog"."default",
+ "start_time" varchar(64) COLLATE "pg_catalog"."default",
+ "end_time" varchar(64) COLLATE "pg_catalog"."default",
+ "repeat_period" varchar(64) COLLATE "pg_catalog"."default",
+ "inspect_mode" varchar(64) COLLATE "pg_catalog"."default",
+ "menual_switch" varchar(64) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "camera_id" varchar(64) COLLATE "pg_catalog"."default",
+ "channel" int8,
+ "dept_id" varchar(64) COLLATE "pg_catalog"."default",
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "current_step_id" varchar(64) COLLATE "pg_catalog"."default",
+ "current_step_start_time" varchar(64) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."task_name" IS '浠诲姟鍚嶇О';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."start_time" IS '寮�濮嬫椂闂�';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."end_time" IS '缁撴潫鏃堕棿';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."repeat_period" IS '閲嶅鍛ㄦ湡';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."inspect_mode" IS '宸℃妯″紡';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."menual_switch" IS '鎵嬪姩寮�鍏�';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."camera_id" IS '鐩告満id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."channel" IS '閫氶亾鍙�';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."current_step_id" IS '褰撳墠姝ラ';
+COMMENT ON COLUMN "public"."ard_video_inspect_task"."current_step_start_time" IS '褰撳墠姝ラ寮�濮嬫椂闂�';
+COMMENT ON TABLE "public"."ard_video_inspect_task" IS '瑙嗛宸℃浠诲姟';
+
+-- ----------------------------
+-- Table structure for ard_video_inspect_task_step
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_video_inspect_task_step";
+CREATE TABLE "public"."ard_video_inspect_task_step" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "order_number" int8,
+ "recording_time" int8,
+ "well_id" varchar(64) COLLATE "pg_catalog"."default",
+ "task_id" varchar(64) COLLATE "pg_catalog"."default",
+ "dept_id" varchar(64) COLLATE "pg_catalog"."default",
+ "user_id" varchar(64) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."id" IS 'id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."order_number" IS '鎺掑簭';
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."recording_time" IS '褰曞埗鏃堕棿';
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."well_id" IS '浜昳d';
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."task_id" IS '浠诲姟id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."ard_video_inspect_task_step"."user_id" IS '鐢ㄦ埛id';
+COMMENT ON TABLE "public"."ard_video_inspect_task_step" IS '瑙嗛宸℃姝ラ';
+
+-- ----------------------------
+-- Table structure for ard_wall
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_wall";
+CREATE TABLE "public"."ard_wall" (
+ "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "wall_name" varchar(255) COLLATE "pg_catalog"."default",
+ "wall_poi" varchar(25500) COLLATE "pg_catalog"."default",
+ "type" varchar(2) COLLATE "pg_catalog"."default",
+ "color" varchar(20) COLLATE "pg_catalog"."default",
+ "dept_id" int4,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "create_by" varchar(255) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."ard_wall"."id" IS 'ID';
+COMMENT ON COLUMN "public"."ard_wall"."wall_name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."ard_wall"."wall_poi" IS '鑼冨洿';
+COMMENT ON COLUMN "public"."ard_wall"."type" IS '绫诲瀷';
+COMMENT ON COLUMN "public"."ard_wall"."color" IS '棰滆壊';
+COMMENT ON COLUMN "public"."ard_wall"."dept_id" IS '鎵�灞為儴闂�';
+COMMENT ON COLUMN "public"."ard_wall"."user_id" IS '鎵�灞炵敤鎴�';
+COMMENT ON COLUMN "public"."ard_wall"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."ard_wall"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."ard_wall"."update_by" IS '淇敼鑰�';
+COMMENT ON COLUMN "public"."ard_wall"."update_time" IS '淇敼鏃堕棿';
+COMMENT ON TABLE "public"."ard_wall" IS '鐢靛瓙鍥存爮绠＄悊琛�';
+
+-- ----------------------------
+-- Table structure for ard_wall_user
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."ard_wall_user";
+CREATE TABLE "public"."ard_wall_user" (
+ "wall_id" varchar(255) COLLATE "pg_catalog"."default",
+ "user_id" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON TABLE "public"."ard_wall_user" IS '鐢靛瓙鍥存爮鍏宠仈鐢ㄦ埛琛�';
+
+-- ----------------------------
+-- Table structure for gen_table
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."gen_table";
+CREATE TABLE "public"."gen_table" (
+ "table_id" int8 NOT NULL DEFAULT nextval('gen_table_id_seq'::regclass),
+ "table_name" varchar(200) COLLATE "pg_catalog"."default",
+ "table_comment" varchar(500) COLLATE "pg_catalog"."default",
+ "sub_table_name" varchar(64) COLLATE "pg_catalog"."default",
+ "sub_table_fk_name" varchar(64) COLLATE "pg_catalog"."default",
+ "class_name" varchar(100) COLLATE "pg_catalog"."default",
+ "tpl_category" varchar(200) COLLATE "pg_catalog"."default",
+ "package_name" varchar(100) COLLATE "pg_catalog"."default",
+ "module_name" varchar(30) COLLATE "pg_catalog"."default",
+ "business_name" varchar(30) COLLATE "pg_catalog"."default",
+ "function_name" varchar(50) COLLATE "pg_catalog"."default",
+ "function_author" varchar(50) COLLATE "pg_catalog"."default",
+ "gen_type" char(1) COLLATE "pg_catalog"."default",
+ "gen_path" varchar(200) COLLATE "pg_catalog"."default",
+ "options" varchar(1000) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."gen_table"."table_id" IS '缂栧彿';
+COMMENT ON COLUMN "public"."gen_table"."table_name" IS '琛ㄥ悕绉�';
+COMMENT ON COLUMN "public"."gen_table"."table_comment" IS '琛ㄦ弿杩�';
+COMMENT ON COLUMN "public"."gen_table"."sub_table_name" IS '鍏宠仈瀛愯〃鐨勮〃鍚�';
+COMMENT ON COLUMN "public"."gen_table"."sub_table_fk_name" IS '瀛愯〃鍏宠仈鐨勫閿悕';
+COMMENT ON COLUMN "public"."gen_table"."class_name" IS '瀹炰綋绫诲悕绉�';
+COMMENT ON COLUMN "public"."gen_table"."tpl_category" IS '浣跨敤鐨勬ā鏉匡紙crud鍗曡〃鎿嶄綔 tree鏍戣〃鎿嶄綔锛�';
+COMMENT ON COLUMN "public"."gen_table"."package_name" IS '鐢熸垚鍖呰矾寰�';
+COMMENT ON COLUMN "public"."gen_table"."module_name" IS '鐢熸垚妯″潡鍚�';
+COMMENT ON COLUMN "public"."gen_table"."business_name" IS '鐢熸垚涓氬姟鍚�';
+COMMENT ON COLUMN "public"."gen_table"."function_name" IS '鐢熸垚鍔熻兘鍚�';
+COMMENT ON COLUMN "public"."gen_table"."function_author" IS '鐢熸垚鍔熻兘浣滆��';
+COMMENT ON COLUMN "public"."gen_table"."gen_type" IS '鐢熸垚浠ｇ爜鏂瑰紡锛�0zip鍘嬬缉鍖� 1鑷畾涔夎矾寰勶級';
+COMMENT ON COLUMN "public"."gen_table"."gen_path" IS '鐢熸垚璺緞锛堜笉濉粯璁ら」鐩矾寰勶級';
+COMMENT ON COLUMN "public"."gen_table"."options" IS '鍏跺畠鐢熸垚閫夐」';
+COMMENT ON COLUMN "public"."gen_table"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."gen_table"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."gen_table"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."gen_table"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."gen_table"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."gen_table" IS '浠ｇ爜鐢熸垚涓氬姟琛�';
+
+-- ----------------------------
+-- Table structure for gen_table_column
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."gen_table_column";
+CREATE TABLE "public"."gen_table_column" (
+ "column_id" int8 NOT NULL DEFAULT nextval('gen_table_column_id_seq'::regclass),
+ "table_id" int8,
+ "column_name" varchar(200) COLLATE "pg_catalog"."default",
+ "column_comment" varchar(500) COLLATE "pg_catalog"."default",
+ "column_type" varchar(100) COLLATE "pg_catalog"."default",
+ "java_type" varchar(500) COLLATE "pg_catalog"."default",
+ "java_field" varchar(200) COLLATE "pg_catalog"."default",
+ "is_pk" char(1) COLLATE "pg_catalog"."default",
+ "is_increment" char(1) COLLATE "pg_catalog"."default",
+ "is_required" char(1) COLLATE "pg_catalog"."default",
+ "is_insert" char(1) COLLATE "pg_catalog"."default",
+ "is_edit" char(1) COLLATE "pg_catalog"."default",
+ "is_list" char(1) COLLATE "pg_catalog"."default",
+ "is_query" char(1) COLLATE "pg_catalog"."default",
+ "query_type" varchar(200) COLLATE "pg_catalog"."default",
+ "html_type" varchar(200) COLLATE "pg_catalog"."default",
+ "dict_type" varchar(200) COLLATE "pg_catalog"."default",
+ "sort" int4,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."gen_table_column"."column_id" IS '缂栧彿';
+COMMENT ON COLUMN "public"."gen_table_column"."table_id" IS '褰掑睘琛ㄧ紪鍙�';
+COMMENT ON COLUMN "public"."gen_table_column"."column_name" IS '鍒楀悕绉�';
+COMMENT ON COLUMN "public"."gen_table_column"."column_comment" IS '鍒楁弿杩�';
+COMMENT ON COLUMN "public"."gen_table_column"."column_type" IS '鍒楃被鍨�';
+COMMENT ON COLUMN "public"."gen_table_column"."java_type" IS 'JAVA绫诲瀷';
+COMMENT ON COLUMN "public"."gen_table_column"."java_field" IS 'JAVA瀛楁鍚�';
+COMMENT ON COLUMN "public"."gen_table_column"."is_pk" IS '鏄惁涓婚敭锛�1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."is_increment" IS '鏄惁鑷锛�1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."is_required" IS '鏄惁蹇呭～锛�1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."is_insert" IS '鏄惁涓烘彃鍏ュ瓧娈碉紙1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."is_edit" IS '鏄惁缂栬緫瀛楁锛�1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."is_list" IS '鏄惁鍒楄〃瀛楁锛�1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."is_query" IS '鏄惁鏌ヨ瀛楁锛�1鏄級';
+COMMENT ON COLUMN "public"."gen_table_column"."query_type" IS '鏌ヨ鏂瑰紡锛堢瓑浜庛�佷笉绛変簬銆佸ぇ浜庛�佸皬浜庛�佽寖鍥达級';
+COMMENT ON COLUMN "public"."gen_table_column"."html_type" IS '鏄剧ず绫诲瀷锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佹棩鏈熸帶浠讹級';
+COMMENT ON COLUMN "public"."gen_table_column"."dict_type" IS '瀛楀吀绫诲瀷';
+COMMENT ON COLUMN "public"."gen_table_column"."sort" IS '鎺掑簭';
+COMMENT ON COLUMN "public"."gen_table_column"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."gen_table_column"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."gen_table_column"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."gen_table_column"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."gen_table_column" IS '浠ｇ爜鐢熸垚涓氬姟琛ㄥ瓧娈�';
+
+-- ----------------------------
+-- Table structure for qrtz_blob_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_blob_triggers";
+CREATE TABLE "public"."qrtz_blob_triggers" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "blob_data" bytea
+)
+;
+COMMENT ON COLUMN "public"."qrtz_blob_triggers"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_blob_triggers"."trigger_name" IS 'qrtz_triggers琛╰rigger_name鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_blob_triggers"."trigger_group" IS 'qrtz_triggers琛╰rigger_group鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_blob_triggers"."blob_data" IS '瀛樻斁鎸佷箙鍖朤rigger瀵硅薄';
+COMMENT ON TABLE "public"."qrtz_blob_triggers" IS 'Blob绫诲瀷鐨勮Е鍙戝櫒琛�';
+
+-- ----------------------------
+-- Table structure for qrtz_calendars
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_calendars";
+CREATE TABLE "public"."qrtz_calendars" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "calendar_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "calendar" bytea NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."qrtz_calendars"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_calendars"."calendar_name" IS '鏃ュ巻鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_calendars"."calendar" IS '瀛樻斁鎸佷箙鍖朿alendar瀵硅薄';
+COMMENT ON TABLE "public"."qrtz_calendars" IS '鏃ュ巻淇℃伅琛�';
+
+-- ----------------------------
+-- Table structure for qrtz_cron_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_cron_triggers";
+CREATE TABLE "public"."qrtz_cron_triggers" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "cron_expression" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "time_zone_id" varchar(80) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."qrtz_cron_triggers"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_cron_triggers"."trigger_name" IS 'qrtz_triggers琛╰rigger_name鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_cron_triggers"."trigger_group" IS 'qrtz_triggers琛╰rigger_group鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_cron_triggers"."cron_expression" IS 'cron琛ㄨ揪寮�';
+COMMENT ON COLUMN "public"."qrtz_cron_triggers"."time_zone_id" IS '鏃跺尯';
+COMMENT ON TABLE "public"."qrtz_cron_triggers" IS 'Cron绫诲瀷鐨勮Е鍙戝櫒琛�';
+
+-- ----------------------------
+-- Table structure for qrtz_fired_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_fired_triggers";
+CREATE TABLE "public"."qrtz_fired_triggers" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "entry_id" varchar(95) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "instance_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "fired_time" int8 NOT NULL,
+ "sched_time" int8 NOT NULL,
+ "priority" int4 NOT NULL,
+ "state" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_name" varchar(200) COLLATE "pg_catalog"."default",
+ "job_group" varchar(200) COLLATE "pg_catalog"."default",
+ "is_nonconcurrent" varchar(1) COLLATE "pg_catalog"."default",
+ "requests_recovery" varchar(1) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."entry_id" IS '璋冨害鍣ㄥ疄渚媔d';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."trigger_name" IS 'qrtz_triggers琛╰rigger_name鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."trigger_group" IS 'qrtz_triggers琛╰rigger_group鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."instance_name" IS '璋冨害鍣ㄥ疄渚嬪悕';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."fired_time" IS '瑙﹀彂鐨勬椂闂�';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."sched_time" IS '瀹氭椂鍣ㄥ埗瀹氱殑鏃堕棿';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."priority" IS '浼樺厛绾�';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."state" IS '鐘舵��';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."job_name" IS '浠诲姟鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."job_group" IS '浠诲姟缁勫悕';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."is_nonconcurrent" IS '鏄惁骞跺彂';
+COMMENT ON COLUMN "public"."qrtz_fired_triggers"."requests_recovery" IS '鏄惁鎺ュ彈鎭㈠鎵ц';
+COMMENT ON TABLE "public"."qrtz_fired_triggers" IS '宸茶Е鍙戠殑瑙﹀彂鍣ㄨ〃';
+
+-- ----------------------------
+-- Table structure for qrtz_job_details
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_job_details";
+CREATE TABLE "public"."qrtz_job_details" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "description" varchar(250) COLLATE "pg_catalog"."default",
+ "job_class_name" varchar(250) COLLATE "pg_catalog"."default" NOT NULL,
+ "is_durable" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
+ "is_nonconcurrent" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
+ "is_update_data" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
+ "requests_recovery" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_data" bytea
+)
+;
+COMMENT ON COLUMN "public"."qrtz_job_details"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_job_details"."job_name" IS '浠诲姟鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_job_details"."job_group" IS '浠诲姟缁勫悕';
+COMMENT ON COLUMN "public"."qrtz_job_details"."description" IS '鐩稿叧浠嬬粛';
+COMMENT ON COLUMN "public"."qrtz_job_details"."job_class_name" IS '鎵ц浠诲姟绫诲悕绉�';
+COMMENT ON COLUMN "public"."qrtz_job_details"."is_durable" IS '鏄惁鎸佷箙鍖�';
+COMMENT ON COLUMN "public"."qrtz_job_details"."is_nonconcurrent" IS '鏄惁骞跺彂';
+COMMENT ON COLUMN "public"."qrtz_job_details"."is_update_data" IS '鏄惁鏇存柊鏁版嵁';
+COMMENT ON COLUMN "public"."qrtz_job_details"."requests_recovery" IS '鏄惁鎺ュ彈鎭㈠鎵ц';
+COMMENT ON COLUMN "public"."qrtz_job_details"."job_data" IS '瀛樻斁鎸佷箙鍖杍ob瀵硅薄';
+COMMENT ON TABLE "public"."qrtz_job_details" IS '浠诲姟璇︾粏淇℃伅琛�';
+
+-- ----------------------------
+-- Table structure for qrtz_locks
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_locks";
+CREATE TABLE "public"."qrtz_locks" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "lock_name" varchar(40) COLLATE "pg_catalog"."default" NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."qrtz_locks"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_locks"."lock_name" IS '鎮茶閿佸悕绉�';
+COMMENT ON TABLE "public"."qrtz_locks" IS '瀛樺偍鐨勬偛瑙傞攣淇℃伅琛�';
+
+-- ----------------------------
+-- Table structure for qrtz_paused_trigger_grps
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_paused_trigger_grps";
+CREATE TABLE "public"."qrtz_paused_trigger_grps" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."qrtz_paused_trigger_grps"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_paused_trigger_grps"."trigger_group" IS 'qrtz_triggers琛╰rigger_group鐨勫閿�';
+COMMENT ON TABLE "public"."qrtz_paused_trigger_grps" IS '鏆傚仠鐨勮Е鍙戝櫒琛�';
+
+-- ----------------------------
+-- Table structure for qrtz_scheduler_state
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_scheduler_state";
+CREATE TABLE "public"."qrtz_scheduler_state" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "instance_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "last_checkin_time" int8 NOT NULL,
+ "checkin_interval" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."qrtz_scheduler_state"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_scheduler_state"."instance_name" IS '瀹炰緥鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_scheduler_state"."last_checkin_time" IS '涓婃妫�鏌ユ椂闂�';
+COMMENT ON COLUMN "public"."qrtz_scheduler_state"."checkin_interval" IS '妫�鏌ラ棿闅旀椂闂�';
+COMMENT ON TABLE "public"."qrtz_scheduler_state" IS '璋冨害鍣ㄧ姸鎬佽〃';
+
+-- ----------------------------
+-- Table structure for qrtz_simple_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_simple_triggers";
+CREATE TABLE "public"."qrtz_simple_triggers" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "repeat_count" int8 NOT NULL,
+ "repeat_interval" int8 NOT NULL,
+ "times_triggered" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."qrtz_simple_triggers"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_simple_triggers"."trigger_name" IS 'qrtz_triggers琛╰rigger_name鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_simple_triggers"."trigger_group" IS 'qrtz_triggers琛╰rigger_group鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_simple_triggers"."repeat_count" IS '閲嶅鐨勬鏁扮粺璁�';
+COMMENT ON COLUMN "public"."qrtz_simple_triggers"."repeat_interval" IS '閲嶅鐨勯棿闅旀椂闂�';
+COMMENT ON COLUMN "public"."qrtz_simple_triggers"."times_triggered" IS '宸茬粡瑙﹀彂鐨勬鏁�';
+COMMENT ON TABLE "public"."qrtz_simple_triggers" IS '绠�鍗曡Е鍙戝櫒鐨勪俊鎭〃';
+
+-- ----------------------------
+-- Table structure for qrtz_simprop_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_simprop_triggers";
+CREATE TABLE "public"."qrtz_simprop_triggers" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "str_prop_1" varchar(512) COLLATE "pg_catalog"."default",
+ "str_prop_2" varchar(512) COLLATE "pg_catalog"."default",
+ "str_prop_3" varchar(512) COLLATE "pg_catalog"."default",
+ "int_prop_1" int4,
+ "int_prop_2" int4,
+ "long_prop_1" int8,
+ "long_prop_2" int8,
+ "dec_prop_1" numeric(13,4),
+ "dec_prop_2" numeric(13,4),
+ "bool_prop_1" varchar(1) COLLATE "pg_catalog"."default",
+ "bool_prop_2" varchar(1) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."trigger_name" IS 'qrtz_triggers琛╰rigger_name鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."trigger_group" IS 'qrtz_triggers琛╰rigger_group鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."str_prop_1" IS 'String绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."str_prop_2" IS 'String绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."str_prop_3" IS 'String绫诲瀷鐨則rigger鐨勭涓変釜鍙傛暟';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."int_prop_1" IS 'int绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."int_prop_2" IS 'int绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."long_prop_1" IS 'long绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."long_prop_2" IS 'long绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."dec_prop_1" IS 'decimal绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."dec_prop_2" IS 'decimal绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."bool_prop_1" IS 'Boolean绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�';
+COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."bool_prop_2" IS 'Boolean绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟';
+COMMENT ON TABLE "public"."qrtz_simprop_triggers" IS '鍚屾鏈哄埗鐨勮閿佽〃';
+
+-- ----------------------------
+-- Table structure for qrtz_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."qrtz_triggers";
+CREATE TABLE "public"."qrtz_triggers" (
+ "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
+ "description" varchar(250) COLLATE "pg_catalog"."default",
+ "next_fire_time" int8,
+ "prev_fire_time" int8,
+ "priority" int4,
+ "trigger_state" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
+ "trigger_type" varchar(8) COLLATE "pg_catalog"."default" NOT NULL,
+ "start_time" int8 NOT NULL,
+ "end_time" int8,
+ "calendar_name" varchar(200) COLLATE "pg_catalog"."default",
+ "misfire_instr" int2,
+ "job_data" bytea
+)
+;
+COMMENT ON COLUMN "public"."qrtz_triggers"."sched_name" IS '璋冨害鍚嶇О';
+COMMENT ON COLUMN "public"."qrtz_triggers"."trigger_name" IS '瑙﹀彂鍣ㄧ殑鍚嶅瓧';
+COMMENT ON COLUMN "public"."qrtz_triggers"."trigger_group" IS '瑙﹀彂鍣ㄦ墍灞炵粍鐨勫悕瀛�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."job_name" IS 'qrtz_job_details琛╦ob_name鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."job_group" IS 'qrtz_job_details琛╦ob_group鐨勫閿�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."description" IS '鐩稿叧浠嬬粛';
+COMMENT ON COLUMN "public"."qrtz_triggers"."next_fire_time" IS '涓婁竴娆¤Е鍙戞椂闂达紙姣锛�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."prev_fire_time" IS '涓嬩竴娆¤Е鍙戞椂闂达紙榛樿涓�-1琛ㄧず涓嶈Е鍙戯級';
+COMMENT ON COLUMN "public"."qrtz_triggers"."priority" IS '浼樺厛绾�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."trigger_state" IS '瑙﹀彂鍣ㄧ姸鎬�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."trigger_type" IS '瑙﹀彂鍣ㄧ殑绫诲瀷';
+COMMENT ON COLUMN "public"."qrtz_triggers"."start_time" IS '寮�濮嬫椂闂�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."end_time" IS '缁撴潫鏃堕棿';
+COMMENT ON COLUMN "public"."qrtz_triggers"."calendar_name" IS '鏃ョ▼琛ㄥ悕绉�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."misfire_instr" IS '琛ュ伩鎵ц鐨勭瓥鐣�';
+COMMENT ON COLUMN "public"."qrtz_triggers"."job_data" IS '瀛樻斁鎸佷箙鍖杍ob瀵硅薄';
+COMMENT ON TABLE "public"."qrtz_triggers" IS '瑙﹀彂鍣ㄨ缁嗕俊鎭〃';
+
+-- ----------------------------
+-- Table structure for storage_minio_event
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."storage_minio_event";
+CREATE TABLE "public"."storage_minio_event" (
+ "id" varchar COLLATE "pg_catalog"."default" NOT NULL,
+ "event_type" varchar(255) COLLATE "pg_catalog"."default",
+ "bucket_name" varchar(255) COLLATE "pg_catalog"."default",
+ "event_time" timestamp(6),
+ "host" varchar(255) COLLATE "pg_catalog"."default",
+ "user_name" varchar(255) COLLATE "pg_catalog"."default",
+ "endpoint" varchar(255) COLLATE "pg_catalog"."default",
+ "object_name" varchar(255) COLLATE "pg_catalog"."default",
+ "object_type" varchar(255) COLLATE "pg_catalog"."default",
+ "object_size" int4,
+ "create_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."storage_minio_event"."id" IS 'ID';
+COMMENT ON COLUMN "public"."storage_minio_event"."event_type" IS '浜嬩欢绫诲瀷';
+COMMENT ON COLUMN "public"."storage_minio_event"."bucket_name" IS '妗跺悕绉�';
+COMMENT ON COLUMN "public"."storage_minio_event"."event_time" IS '浜嬩欢鏃堕棿';
+COMMENT ON COLUMN "public"."storage_minio_event"."host" IS '璇锋眰涓绘満';
+COMMENT ON COLUMN "public"."storage_minio_event"."user_name" IS '璇锋眰鐢ㄦ埛';
+COMMENT ON COLUMN "public"."storage_minio_event"."endpoint" IS '璇锋眰鍦板潃';
+COMMENT ON COLUMN "public"."storage_minio_event"."object_name" IS '瀵硅薄鍚嶇О';
+COMMENT ON COLUMN "public"."storage_minio_event"."object_type" IS '瀵硅薄绫诲瀷';
+COMMENT ON COLUMN "public"."storage_minio_event"."object_size" IS '瀵硅薄澶у皬';
+COMMENT ON COLUMN "public"."storage_minio_event"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON TABLE "public"."storage_minio_event" IS '瀛樺偍minio浜嬩欢琛�';
+
+-- ----------------------------
+-- Table structure for sys_config
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_config";
+CREATE TABLE "public"."sys_config" (
+ "config_id" int4 NOT NULL DEFAULT nextval('sys_config_id_seq'::regclass),
+ "config_name" varchar(100) COLLATE "pg_catalog"."default",
+ "config_key" varchar(100) COLLATE "pg_catalog"."default",
+ "config_value" varchar(500) COLLATE "pg_catalog"."default",
+ "config_type" char(1) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_config"."config_id" IS '鍙傛暟涓婚敭';
+COMMENT ON COLUMN "public"."sys_config"."config_name" IS '鍙傛暟鍚嶇О';
+COMMENT ON COLUMN "public"."sys_config"."config_key" IS '鍙傛暟閿悕';
+COMMENT ON COLUMN "public"."sys_config"."config_value" IS '鍙傛暟閿��';
+COMMENT ON COLUMN "public"."sys_config"."config_type" IS '绯荤粺鍐呯疆锛圷鏄� N鍚︼級';
+COMMENT ON COLUMN "public"."sys_config"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_config"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_config"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_config"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_config"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_config" IS '鍙傛暟閰嶇疆琛�';
+
+-- ----------------------------
+-- Table structure for sys_dept
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_dept";
+CREATE TABLE "public"."sys_dept" (
+ "dept_id" int8 NOT NULL DEFAULT nextval('sys_dept_id_seq'::regclass),
+ "parent_id" int8,
+ "ancestors" varchar(50) COLLATE "pg_catalog"."default",
+ "dept_name" varchar(30) COLLATE "pg_catalog"."default",
+ "order_num" int4,
+ "leader" varchar(20) COLLATE "pg_catalog"."default",
+ "phone" varchar(11) COLLATE "pg_catalog"."default",
+ "email" varchar(50) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "del_flag" char(1) COLLATE "pg_catalog"."default" DEFAULT '0'::character varying,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."sys_dept"."dept_id" IS '閮ㄩ棬id';
+COMMENT ON COLUMN "public"."sys_dept"."parent_id" IS '鐖堕儴闂╥d';
+COMMENT ON COLUMN "public"."sys_dept"."ancestors" IS '绁栫骇鍒楄〃';
+COMMENT ON COLUMN "public"."sys_dept"."dept_name" IS '閮ㄩ棬鍚嶇О';
+COMMENT ON COLUMN "public"."sys_dept"."order_num" IS '鏄剧ず椤哄簭';
+COMMENT ON COLUMN "public"."sys_dept"."leader" IS '璐熻矗浜�';
+COMMENT ON COLUMN "public"."sys_dept"."phone" IS '鑱旂郴鐢佃瘽';
+COMMENT ON COLUMN "public"."sys_dept"."email" IS '閭';
+COMMENT ON COLUMN "public"."sys_dept"."status" IS '閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_dept"."del_flag" IS '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�';
+COMMENT ON COLUMN "public"."sys_dept"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_dept"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_dept"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_dept"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON TABLE "public"."sys_dept" IS '閮ㄩ棬琛�';
+
+-- ----------------------------
+-- Table structure for sys_dict_data
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_dict_data";
+CREATE TABLE "public"."sys_dict_data" (
+ "dict_code" int8 NOT NULL DEFAULT nextval('dict_code_seq'::regclass),
+ "dict_sort" int4,
+ "dict_label" varchar(100) COLLATE "pg_catalog"."default",
+ "dict_value" varchar(100) COLLATE "pg_catalog"."default",
+ "dict_type" varchar(100) COLLATE "pg_catalog"."default",
+ "css_class" varchar(100) COLLATE "pg_catalog"."default",
+ "list_class" varchar(100) COLLATE "pg_catalog"."default",
+ "is_default" char(1) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_dict_data"."dict_code" IS '瀛楀吀缂栫爜';
+COMMENT ON COLUMN "public"."sys_dict_data"."dict_sort" IS '瀛楀吀鎺掑簭';
+COMMENT ON COLUMN "public"."sys_dict_data"."dict_label" IS '瀛楀吀鏍囩';
+COMMENT ON COLUMN "public"."sys_dict_data"."dict_value" IS '瀛楀吀閿��';
+COMMENT ON COLUMN "public"."sys_dict_data"."dict_type" IS '瀛楀吀绫诲瀷';
+COMMENT ON COLUMN "public"."sys_dict_data"."css_class" IS '鏍峰紡灞炴�э紙鍏朵粬鏍峰紡鎵╁睍锛�';
+COMMENT ON COLUMN "public"."sys_dict_data"."list_class" IS '琛ㄦ牸鍥炴樉鏍峰紡';
+COMMENT ON COLUMN "public"."sys_dict_data"."is_default" IS '鏄惁榛樿锛圷鏄� N鍚︼級';
+COMMENT ON COLUMN "public"."sys_dict_data"."status" IS '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_dict_data"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_dict_data"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_dict_data"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_dict_data"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_dict_data"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_dict_data" IS '瀛楀吀鏁版嵁琛�';
+
+-- ----------------------------
+-- Table structure for sys_dict_type
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_dict_type";
+CREATE TABLE "public"."sys_dict_type" (
+ "dict_id" int8 NOT NULL DEFAULT nextval('sys_dict_type_id_seq'::regclass),
+ "dict_name" varchar(100) COLLATE "pg_catalog"."default",
+ "dict_type" varchar(100) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_dict_type"."dict_id" IS '瀛楀吀涓婚敭';
+COMMENT ON COLUMN "public"."sys_dict_type"."dict_name" IS '瀛楀吀鍚嶇О';
+COMMENT ON COLUMN "public"."sys_dict_type"."dict_type" IS '瀛楀吀绫诲瀷';
+COMMENT ON COLUMN "public"."sys_dict_type"."status" IS '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_dict_type"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_dict_type"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_dict_type"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_dict_type"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_dict_type"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_dict_type" IS '瀛楀吀绫诲瀷琛�';
+
+-- ----------------------------
+-- Table structure for sys_job
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_job";
+CREATE TABLE "public"."sys_job" (
+ "job_id" int8 NOT NULL DEFAULT nextval('sys_job_id_seq'::regclass),
+ "job_name" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_group" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "invoke_target" varchar(500) COLLATE "pg_catalog"."default" NOT NULL,
+ "cron_expression" varchar(255) COLLATE "pg_catalog"."default",
+ "misfire_policy" varchar(20) COLLATE "pg_catalog"."default",
+ "concurrent" char(1) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_job"."job_id" IS '浠诲姟ID';
+COMMENT ON COLUMN "public"."sys_job"."job_name" IS '浠诲姟鍚嶇О';
+COMMENT ON COLUMN "public"."sys_job"."job_group" IS '浠诲姟缁勫悕';
+COMMENT ON COLUMN "public"."sys_job"."invoke_target" IS '璋冪敤鐩爣瀛楃涓�';
+COMMENT ON COLUMN "public"."sys_job"."cron_expression" IS 'cron鎵ц琛ㄨ揪寮�';
+COMMENT ON COLUMN "public"."sys_job"."misfire_policy" IS '璁″垝鎵ц閿欒绛栫暐锛�1绔嬪嵆鎵ц 2鎵ц涓�娆� 3鏀惧純鎵ц锛�';
+COMMENT ON COLUMN "public"."sys_job"."concurrent" IS '鏄惁骞跺彂鎵ц锛�0鍏佽 1绂佹锛�';
+COMMENT ON COLUMN "public"."sys_job"."status" IS '鐘舵�侊紙0姝ｅ父 1鏆傚仠锛�';
+COMMENT ON COLUMN "public"."sys_job"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_job"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_job"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_job"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_job"."remark" IS '澶囨敞淇℃伅';
+COMMENT ON TABLE "public"."sys_job" IS '瀹氭椂浠诲姟璋冨害琛�';
+
+-- ----------------------------
+-- Table structure for sys_job_log
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_job_log";
+CREATE TABLE "public"."sys_job_log" (
+ "job_log_id" int8 NOT NULL DEFAULT nextval('sys_job_log_id_seq'::regclass),
+ "job_name" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_group" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "invoke_target" varchar(500) COLLATE "pg_catalog"."default" NOT NULL,
+ "job_message" varchar(500) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "exception_info" varchar(2000) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."sys_job_log"."job_log_id" IS '浠诲姟鏃ュ織ID';
+COMMENT ON COLUMN "public"."sys_job_log"."job_name" IS '浠诲姟鍚嶇О';
+COMMENT ON COLUMN "public"."sys_job_log"."job_group" IS '浠诲姟缁勫悕';
+COMMENT ON COLUMN "public"."sys_job_log"."invoke_target" IS '璋冪敤鐩爣瀛楃涓�';
+COMMENT ON COLUMN "public"."sys_job_log"."job_message" IS '鏃ュ織淇℃伅';
+COMMENT ON COLUMN "public"."sys_job_log"."status" IS '鎵ц鐘舵�侊紙0姝ｅ父 1澶辫触锛�';
+COMMENT ON COLUMN "public"."sys_job_log"."exception_info" IS '寮傚父淇℃伅';
+COMMENT ON COLUMN "public"."sys_job_log"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON TABLE "public"."sys_job_log" IS '瀹氭椂浠诲姟璋冨害鏃ュ織琛�';
+
+-- ----------------------------
+-- Table structure for sys_logininfor
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_logininfor";
+CREATE TABLE "public"."sys_logininfor" (
+ "info_id" int8 NOT NULL DEFAULT nextval('sys_logininfor_id_seq'::regclass),
+ "user_name" varchar(50) COLLATE "pg_catalog"."default",
+ "ipaddr" varchar(128) COLLATE "pg_catalog"."default",
+ "login_location" varchar(255) COLLATE "pg_catalog"."default",
+ "browser" varchar(50) COLLATE "pg_catalog"."default",
+ "os" varchar(50) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "msg" varchar(255) COLLATE "pg_catalog"."default",
+ "login_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."sys_logininfor"."info_id" IS '璁块棶ID';
+COMMENT ON COLUMN "public"."sys_logininfor"."user_name" IS '鐢ㄦ埛璐﹀彿';
+COMMENT ON COLUMN "public"."sys_logininfor"."ipaddr" IS '鐧诲綍IP鍦板潃';
+COMMENT ON COLUMN "public"."sys_logininfor"."login_location" IS '鐧诲綍鍦扮偣';
+COMMENT ON COLUMN "public"."sys_logininfor"."browser" IS '娴忚鍣ㄧ被鍨�';
+COMMENT ON COLUMN "public"."sys_logininfor"."os" IS '鎿嶄綔绯荤粺';
+COMMENT ON COLUMN "public"."sys_logininfor"."status" IS '鐧诲綍鐘舵�侊紙0鎴愬姛 1澶辫触锛�';
+COMMENT ON COLUMN "public"."sys_logininfor"."msg" IS '鎻愮ず娑堟伅';
+COMMENT ON COLUMN "public"."sys_logininfor"."login_time" IS '璁块棶鏃堕棿';
+COMMENT ON TABLE "public"."sys_logininfor" IS '绯荤粺璁块棶璁板綍';
+
+-- ----------------------------
+-- Table structure for sys_menu
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_menu";
+CREATE TABLE "public"."sys_menu" (
+ "menu_id" int8 NOT NULL DEFAULT nextval('sys_menu_id_seq'::regclass),
+ "menu_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "parent_id" int8 NOT NULL DEFAULT 0,
+ "order_num" int4,
+ "path" varchar(200) COLLATE "pg_catalog"."default",
+ "component" varchar(255) COLLATE "pg_catalog"."default",
+ "query" varchar(255) COLLATE "pg_catalog"."default",
+ "is_frame" varchar(32) COLLATE "pg_catalog"."default",
+ "is_cache" varchar(32) COLLATE "pg_catalog"."default",
+ "menu_type" char(1) COLLATE "pg_catalog"."default",
+ "visible" char(1) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "perms" varchar(100) COLLATE "pg_catalog"."default",
+ "icon" varchar(100) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_menu"."menu_id" IS '鑿滃崟ID';
+COMMENT ON COLUMN "public"."sys_menu"."menu_name" IS '鑿滃崟鍚嶇О';
+COMMENT ON COLUMN "public"."sys_menu"."parent_id" IS '鐖惰彍鍗旾D';
+COMMENT ON COLUMN "public"."sys_menu"."order_num" IS '鏄剧ず椤哄簭';
+COMMENT ON COLUMN "public"."sys_menu"."path" IS '璺敱鍦板潃';
+COMMENT ON COLUMN "public"."sys_menu"."component" IS '缁勪欢璺緞';
+COMMENT ON COLUMN "public"."sys_menu"."query" IS '璺敱鍙傛暟';
+COMMENT ON COLUMN "public"."sys_menu"."is_frame" IS '鏄惁涓哄閾撅紙0鏄� 1鍚︼級';
+COMMENT ON COLUMN "public"."sys_menu"."is_cache" IS '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級';
+COMMENT ON COLUMN "public"."sys_menu"."menu_type" IS '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�';
+COMMENT ON COLUMN "public"."sys_menu"."visible" IS '鑿滃崟鐘舵�侊紙0鏄剧ず 1闅愯棌锛�';
+COMMENT ON COLUMN "public"."sys_menu"."status" IS '鑿滃崟鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_menu"."perms" IS '鏉冮檺鏍囪瘑';
+COMMENT ON COLUMN "public"."sys_menu"."icon" IS '鑿滃崟鍥炬爣';
+COMMENT ON COLUMN "public"."sys_menu"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_menu"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_menu"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_menu"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_menu"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_menu" IS '鑿滃崟鏉冮檺琛�';
+
+-- ----------------------------
+-- Table structure for sys_notice
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_notice";
+CREATE TABLE "public"."sys_notice" (
+ "notice_id" int4 NOT NULL DEFAULT nextval('sys_notice_id_seq'::regclass),
+ "notice_title" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "notice_type" char(1) COLLATE "pg_catalog"."default" NOT NULL,
+ "notice_content" varchar(500) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_notice"."notice_id" IS '鍏憡ID';
+COMMENT ON COLUMN "public"."sys_notice"."notice_title" IS '鍏憡鏍囬';
+COMMENT ON COLUMN "public"."sys_notice"."notice_type" IS '鍏憡绫诲瀷锛�1閫氱煡 2鍏憡锛�';
+COMMENT ON COLUMN "public"."sys_notice"."notice_content" IS '鍏憡鍐呭';
+COMMENT ON COLUMN "public"."sys_notice"."status" IS '鍏憡鐘舵�侊紙0姝ｅ父 1鍏抽棴锛�';
+COMMENT ON COLUMN "public"."sys_notice"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_notice"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_notice"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_notice"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_notice"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_notice" IS '閫氱煡鍏憡琛�';
+
+-- ----------------------------
+-- Table structure for sys_oper_log
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_oper_log";
+CREATE TABLE "public"."sys_oper_log" (
+ "oper_id" int8 NOT NULL DEFAULT nextval('sys_oper_log_id_seq'::regclass),
+ "title" varchar(50) COLLATE "pg_catalog"."default",
+ "business_type" int4,
+ "method" varchar(100) COLLATE "pg_catalog"."default",
+ "request_method" varchar(10) COLLATE "pg_catalog"."default",
+ "operator_type" int4,
+ "oper_name" varchar(50) COLLATE "pg_catalog"."default",
+ "dept_name" varchar(50) COLLATE "pg_catalog"."default",
+ "oper_url" varchar(255) COLLATE "pg_catalog"."default",
+ "oper_ip" varchar(128) COLLATE "pg_catalog"."default",
+ "oper_location" varchar(255) COLLATE "pg_catalog"."default",
+ "oper_param" varchar(2000) COLLATE "pg_catalog"."default",
+ "json_result" varchar(2000) COLLATE "pg_catalog"."default",
+ "status" int4,
+ "error_msg" varchar(2000) COLLATE "pg_catalog"."default",
+ "oper_time" timestamp(6)
+)
+;
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_id" IS '鏃ュ織涓婚敭';
+COMMENT ON COLUMN "public"."sys_oper_log"."title" IS '妯″潡鏍囬';
+COMMENT ON COLUMN "public"."sys_oper_log"."business_type" IS '涓氬姟绫诲瀷锛�0鍏跺畠 1鏂板 2淇敼 3鍒犻櫎锛�';
+COMMENT ON COLUMN "public"."sys_oper_log"."method" IS '鏂规硶鍚嶇О';
+COMMENT ON COLUMN "public"."sys_oper_log"."request_method" IS '璇锋眰鏂瑰紡';
+COMMENT ON COLUMN "public"."sys_oper_log"."operator_type" IS '鎿嶄綔绫诲埆锛�0鍏跺畠 1鍚庡彴鐢ㄦ埛 2鎵嬫満绔敤鎴凤級';
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_name" IS '鎿嶄綔浜哄憳';
+COMMENT ON COLUMN "public"."sys_oper_log"."dept_name" IS '閮ㄩ棬鍚嶇О';
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_url" IS '璇锋眰URL';
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_ip" IS '涓绘満鍦板潃';
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_location" IS '鎿嶄綔鍦扮偣';
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_param" IS '璇锋眰鍙傛暟';
+COMMENT ON COLUMN "public"."sys_oper_log"."json_result" IS '杩斿洖鍙傛暟';
+COMMENT ON COLUMN "public"."sys_oper_log"."status" IS '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�';
+COMMENT ON COLUMN "public"."sys_oper_log"."error_msg" IS '閿欒娑堟伅';
+COMMENT ON COLUMN "public"."sys_oper_log"."oper_time" IS '鎿嶄綔鏃堕棿';
+COMMENT ON TABLE "public"."sys_oper_log" IS '鎿嶄綔鏃ュ織璁板綍';
+
+-- ----------------------------
+-- Table structure for sys_post
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_post";
+CREATE TABLE "public"."sys_post" (
+ "post_id" int8 NOT NULL DEFAULT nextval('sys_post_id_seq'::regclass),
+ "post_code" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "post_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "post_sort" int4 NOT NULL,
+ "status" char(1) COLLATE "pg_catalog"."default" NOT NULL,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_post"."post_id" IS '宀椾綅ID';
+COMMENT ON COLUMN "public"."sys_post"."post_code" IS '宀椾綅缂栫爜';
+COMMENT ON COLUMN "public"."sys_post"."post_name" IS '宀椾綅鍚嶇О';
+COMMENT ON COLUMN "public"."sys_post"."post_sort" IS '鏄剧ず椤哄簭';
+COMMENT ON COLUMN "public"."sys_post"."status" IS '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_post"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_post"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_post"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_post"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_post"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_post" IS '宀椾綅淇℃伅琛�';
+
+-- ----------------------------
+-- Table structure for sys_role
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_role";
+CREATE TABLE "public"."sys_role" (
+ "role_id" int8 NOT NULL DEFAULT nextval('sys_role_id_seq'::regclass),
+ "role_name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
+ "role_key" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
+ "role_sort" int4 NOT NULL,
+ "data_scope" char(1) COLLATE "pg_catalog"."default",
+ "menu_check_strictly" bool,
+ "dept_check_strictly" bool,
+ "status" char(1) COLLATE "pg_catalog"."default" NOT NULL,
+ "del_flag" char(1) COLLATE "pg_catalog"."default" DEFAULT '0'::character varying,
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_role"."role_id" IS '瑙掕壊ID';
+COMMENT ON COLUMN "public"."sys_role"."role_name" IS '瑙掕壊鍚嶇О';
+COMMENT ON COLUMN "public"."sys_role"."role_key" IS '瑙掕壊鏉冮檺瀛楃涓�';
+COMMENT ON COLUMN "public"."sys_role"."role_sort" IS '鏄剧ず椤哄簭';
+COMMENT ON COLUMN "public"."sys_role"."data_scope" IS '鏁版嵁鑼冨洿锛�1锛氬叏閮ㄦ暟鎹潈闄� 2锛氳嚜瀹氭暟鎹潈闄� 3锛氭湰閮ㄩ棬鏁版嵁鏉冮檺 4锛氭湰閮ㄩ棬鍙婁互涓嬫暟鎹潈闄愶級';
+COMMENT ON COLUMN "public"."sys_role"."menu_check_strictly" IS '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�';
+COMMENT ON COLUMN "public"."sys_role"."dept_check_strictly" IS '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�';
+COMMENT ON COLUMN "public"."sys_role"."status" IS '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_role"."del_flag" IS '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�';
+COMMENT ON COLUMN "public"."sys_role"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_role"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_role"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_role"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_role"."remark" IS '澶囨敞';
+COMMENT ON TABLE "public"."sys_role" IS '瑙掕壊淇℃伅琛�';
+
+-- ----------------------------
+-- Table structure for sys_role_dept
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_role_dept";
+CREATE TABLE "public"."sys_role_dept" (
+ "role_id" int8 NOT NULL,
+ "dept_id" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."sys_role_dept"."role_id" IS '瑙掕壊ID';
+COMMENT ON COLUMN "public"."sys_role_dept"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON TABLE "public"."sys_role_dept" IS '瑙掕壊鍜岄儴闂ㄥ叧鑱旇〃';
+
+-- ----------------------------
+-- Table structure for sys_role_menu
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_role_menu";
+CREATE TABLE "public"."sys_role_menu" (
+ "role_id" int8 NOT NULL,
+ "menu_id" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."sys_role_menu"."role_id" IS '瑙掕壊ID';
+COMMENT ON COLUMN "public"."sys_role_menu"."menu_id" IS '鑿滃崟ID';
+COMMENT ON TABLE "public"."sys_role_menu" IS '瑙掕壊鍜岃彍鍗曞叧鑱旇〃';
+
+-- ----------------------------
+-- Table structure for sys_user
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_user";
+CREATE TABLE "public"."sys_user" (
+ "user_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "dept_id" int8,
+ "user_name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
+ "nick_name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
+ "user_type" varchar(2) COLLATE "pg_catalog"."default",
+ "email" varchar(50) COLLATE "pg_catalog"."default",
+ "phonenumber" varchar(11) COLLATE "pg_catalog"."default",
+ "sex" char(1) COLLATE "pg_catalog"."default",
+ "avatar" varchar(100) COLLATE "pg_catalog"."default",
+ "password" varchar(100) COLLATE "pg_catalog"."default",
+ "status" char(1) COLLATE "pg_catalog"."default",
+ "del_flag" char(1) COLLATE "pg_catalog"."default" DEFAULT '0'::character varying,
+ "login_ip" varchar(128) COLLATE "pg_catalog"."default",
+ "login_date" timestamp(6),
+ "create_by" varchar(64) COLLATE "pg_catalog"."default",
+ "create_time" timestamp(6),
+ "update_by" varchar(64) COLLATE "pg_catalog"."default",
+ "update_time" timestamp(6),
+ "remark" varchar(500) COLLATE "pg_catalog"."default",
+ "camera_priority" varchar(10) COLLATE "pg_catalog"."default",
+ "rong_cloud_token" varchar(255) COLLATE "pg_catalog"."default",
+ "app_user_type" char(1) COLLATE "pg_catalog"."default",
+ "app_online_state" char(1) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."sys_user"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."sys_user"."dept_id" IS '閮ㄩ棬ID';
+COMMENT ON COLUMN "public"."sys_user"."user_name" IS '鐢ㄦ埛璐﹀彿';
+COMMENT ON COLUMN "public"."sys_user"."nick_name" IS '鐢ㄦ埛鏄电О';
+COMMENT ON COLUMN "public"."sys_user"."user_type" IS '鐢ㄦ埛绫诲瀷锛�00绯荤粺鐢ㄦ埛锛�';
+COMMENT ON COLUMN "public"."sys_user"."email" IS '鐢ㄦ埛閭';
+COMMENT ON COLUMN "public"."sys_user"."phonenumber" IS '鎵嬫満鍙风爜';
+COMMENT ON COLUMN "public"."sys_user"."sex" IS '鐢ㄦ埛鎬у埆锛�0鐢� 1濂� 2鏈煡锛�';
+COMMENT ON COLUMN "public"."sys_user"."avatar" IS '澶村儚鍦板潃';
+COMMENT ON COLUMN "public"."sys_user"."password" IS '瀵嗙爜';
+COMMENT ON COLUMN "public"."sys_user"."status" IS '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."sys_user"."del_flag" IS '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�';
+COMMENT ON COLUMN "public"."sys_user"."login_ip" IS '鏈�鍚庣櫥褰旾P';
+COMMENT ON COLUMN "public"."sys_user"."login_date" IS '鏈�鍚庣櫥褰曟椂闂�';
+COMMENT ON COLUMN "public"."sys_user"."create_by" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."sys_user"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."sys_user"."update_by" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."sys_user"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."sys_user"."remark" IS '澶囨敞';
+COMMENT ON COLUMN "public"."sys_user"."camera_priority" IS '鐩告満鎿嶆帶绛夌骇';
+COMMENT ON COLUMN "public"."sys_user"."rong_cloud_token" IS '铻嶄簯token';
+COMMENT ON COLUMN "public"."sys_user"."app_user_type" IS 'app鐢ㄦ埛绫诲瀷0-app鎸囨尌绔�1-app鍗曞叺绔� 绌�-pc绔�';
+COMMENT ON COLUMN "public"."sys_user"."app_online_state" IS 'app鐢ㄦ埛鍦ㄧ嚎鐘舵��0-绂荤嚎 1-鍦ㄧ嚎';
+COMMENT ON TABLE "public"."sys_user" IS '鐢ㄦ埛淇℃伅琛�';
+
+-- ----------------------------
+-- Table structure for sys_user_post
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_user_post";
+CREATE TABLE "public"."sys_user_post" (
+ "user_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "post_id" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."sys_user_post"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."sys_user_post"."post_id" IS '宀椾綅ID';
+COMMENT ON TABLE "public"."sys_user_post" IS '鐢ㄦ埛涓庡矖浣嶅叧鑱旇〃';
+
+-- ----------------------------
+-- Table structure for sys_user_role
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."sys_user_role";
+CREATE TABLE "public"."sys_user_role" (
+ "user_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "role_id" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "public"."sys_user_role"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."sys_user_role"."role_id" IS '瑙掕壊ID';
+COMMENT ON TABLE "public"."sys_user_role" IS '鐢ㄦ埛鍜岃鑹插叧鑱旇〃';
+
+-- ----------------------------
+-- Table structure for teacher
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."teacher";
+CREATE TABLE "public"."teacher" (
+ "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT replace(((uuid_generate_v4())::character varying)::text, '-'::text, ''::text),
+ "name" varchar(255) COLLATE "pg_catalog"."default",
+ "phone" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."teacher"."id" IS 'id';
+COMMENT ON COLUMN "public"."teacher"."name" IS '鏁欏笀濮撳悕';
+COMMENT ON COLUMN "public"."teacher"."phone" IS '鏁欏笀鐢佃瘽';
+COMMENT ON TABLE "public"."teacher" IS '鏁欏笀琛�';
+
+-- ----------------------------
+-- Table structure for tiles3d
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."tiles3d";
+CREATE TABLE "public"."tiles3d" (
+ "tiles_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
+ "tiles_name" varchar(500) COLLATE "pg_catalog"."default",
+ "tiles_url" varchar(500) COLLATE "pg_catalog"."default",
+ "tiles_type" varchar(500) COLLATE "pg_catalog"."default",
+ "tiles_x" varchar(255) COLLATE "pg_catalog"."default",
+ "tiles_y" varchar(255) COLLATE "pg_catalog"."default",
+ "tiles_z" varchar(255) COLLATE "pg_catalog"."default",
+ "cam_poi" varchar(500) COLLATE "pg_catalog"."default",
+ "cam_heading" varchar(255) COLLATE "pg_catalog"."default",
+ "cam_pitch" varchar(255) COLLATE "pg_catalog"."default",
+ "maximum_screen_space_error" varchar(10) COLLATE "pg_catalog"."default",
+ "maximum_memory_usage" varchar(10) COLLATE "pg_catalog"."default",
+ "cull_requests_while_moving_multiplier" varchar(10) COLLATE "pg_catalog"."default",
+ "dynamic_screen_space_error_density" varchar(10) COLLATE "pg_catalog"."default",
+ "reserved_1" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_2" varchar(255) COLLATE "pg_catalog"."default",
+ "reserved_3" varchar(255) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."tiles3d"."tiles_id" IS 'ID';
+COMMENT ON COLUMN "public"."tiles3d"."tiles_name" IS '瀹炴櫙涓夌淮鍚嶇О';
+COMMENT ON COLUMN "public"."tiles3d"."tiles_url" IS '瀹炴櫙涓夌淮璺緞';
+COMMENT ON COLUMN "public"."tiles3d"."tiles_type" IS '鏄惁榛樿鍔犺浇ff榛樿鍒濆鍖�';
+COMMENT ON COLUMN "public"."tiles3d"."tiles_x" IS 'x杞村亸绉�';
+COMMENT ON COLUMN "public"."tiles3d"."tiles_y" IS 'y杞村亸绉�';
+COMMENT ON COLUMN "public"."tiles3d"."tiles_z" IS 'z杞村亸绉�';
+COMMENT ON COLUMN "public"."tiles3d"."cam_poi" IS '鐩告満鍧愭爣';
+COMMENT ON COLUMN "public"."tiles3d"."cam_heading" IS '鐩告満鏂逛綅';
+COMMENT ON COLUMN "public"."tiles3d"."cam_pitch" IS '鐩告満淇话';
+COMMENT ON COLUMN "public"."tiles3d"."maximum_screen_space_error" IS '娓呮櫚搴�1';
+COMMENT ON COLUMN "public"."tiles3d"."maximum_memory_usage" IS '娓呮櫚搴�2';
+COMMENT ON COLUMN "public"."tiles3d"."cull_requests_while_moving_multiplier" IS '娓呮櫚搴�3';
+COMMENT ON COLUMN "public"."tiles3d"."dynamic_screen_space_error_density" IS '娓呮櫚搴�4';
+COMMENT ON TABLE "public"."tiles3d" IS '3D鐡︾墖琛�';
+
+-- ----------------------------
+-- Table structure for vtdu
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."vtdu";
+CREATE TABLE "public"."vtdu" (
+ "name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
+ "rtsp_url" varchar(255) COLLATE "pg_catalog"."default",
+ "is_code" varchar(1) COLLATE "pg_catalog"."default",
+ "code_type" varchar(1) COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."vtdu"."name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."vtdu"."rtsp_url" IS 'rtsp婧愬湴鍧�';
+COMMENT ON COLUMN "public"."vtdu"."is_code" IS '鏄惁杞爜';
+COMMENT ON COLUMN "public"."vtdu"."code_type" IS '杞爜妯″紡';
+COMMENT ON TABLE "public"."vtdu" IS '娴佸獟浣撶鐞嗚〃';
+
+-- ----------------------------
+-- Function structure for armor
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."armor"(bytea);
+CREATE OR REPLACE FUNCTION "public"."armor"(bytea)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pg_armor'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for crypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."crypt"(text, text);
+CREATE OR REPLACE FUNCTION "public"."crypt"(text, text)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pg_crypt'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for dearmor
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."dearmor"(text);
+CREATE OR REPLACE FUNCTION "public"."dearmor"(text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_dearmor'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for decrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."decrypt"(bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."decrypt"(bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_decrypt'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for decrypt_iv
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."decrypt_iv"(bytea, bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."decrypt_iv"(bytea, bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_decrypt_iv'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for digest
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."digest"(text, text);
+CREATE OR REPLACE FUNCTION "public"."digest"(text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_digest'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for digest
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."digest"(bytea, text);
+CREATE OR REPLACE FUNCTION "public"."digest"(bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_digest'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for encrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."encrypt"(bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."encrypt"(bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_encrypt'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for encrypt_iv
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."encrypt_iv"(bytea, bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."encrypt_iv"(bytea, bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_encrypt_iv'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for gen_random_bytes
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."gen_random_bytes"(int4);
+CREATE OR REPLACE FUNCTION "public"."gen_random_bytes"(int4)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_random_bytes'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for gen_salt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."gen_salt"(text, int4);
+CREATE OR REPLACE FUNCTION "public"."gen_salt"(text, int4)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pg_gen_salt_rounds'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for gen_salt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."gen_salt"(text);
+CREATE OR REPLACE FUNCTION "public"."gen_salt"(text)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pg_gen_salt'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for hmac
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."hmac"(bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."hmac"(bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_hmac'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for hmac
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."hmac"(text, text, text);
+CREATE OR REPLACE FUNCTION "public"."hmac"(text, text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pg_hmac'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_key_id
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_key_id"(bytea);
+CREATE OR REPLACE FUNCTION "public"."pgp_key_id"(bytea)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pgp_key_id_w'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_decrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_decrypt"(bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_decrypt"(bytea, bytea, text)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_decrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_decrypt"(bytea, bytea, text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_decrypt"(bytea, bytea, text, text)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_decrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_decrypt"(bytea, bytea);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_decrypt"(bytea, bytea)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_decrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_decrypt_bytea"(bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_decrypt_bytea"(bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_decrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_decrypt_bytea"(bytea, bytea);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_decrypt_bytea"(bytea, bytea)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_decrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_decrypt_bytea"(bytea, bytea, text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_decrypt_bytea"(bytea, bytea, text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_encrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_encrypt"(text, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_encrypt"(text, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_encrypt_text'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_encrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_encrypt"(text, bytea);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_encrypt"(text, bytea)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_encrypt_text'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_encrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_encrypt_bytea"(bytea, bytea);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_encrypt_bytea"(bytea, bytea)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_encrypt_bytea'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_pub_encrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_pub_encrypt_bytea"(bytea, bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_pub_encrypt_bytea"(bytea, bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_pub_encrypt_bytea'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_decrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_decrypt"(bytea, text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_decrypt"(bytea, text, text)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pgp_sym_decrypt_text'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_decrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_decrypt"(bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_decrypt"(bytea, text)
+ RETURNS "pg_catalog"."text" AS '$libdir/pgcrypto', 'pgp_sym_decrypt_text'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_decrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_decrypt_bytea"(bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_decrypt_bytea"(bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_sym_decrypt_bytea'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_decrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_decrypt_bytea"(bytea, text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_decrypt_bytea"(bytea, text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_sym_decrypt_bytea'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_encrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_encrypt"(text, text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_encrypt"(text, text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_sym_encrypt_text'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_encrypt
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_encrypt"(text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_encrypt"(text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_sym_encrypt_text'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_encrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_encrypt_bytea"(bytea, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_encrypt_bytea"(bytea, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_sym_encrypt_bytea'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for pgp_sym_encrypt_bytea
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."pgp_sym_encrypt_bytea"(bytea, text, text);
+CREATE OR REPLACE FUNCTION "public"."pgp_sym_encrypt_bytea"(bytea, text, text)
+ RETURNS "pg_catalog"."bytea" AS '$libdir/pgcrypto', 'pgp_sym_encrypt_bytea'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_generate_v1
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_generate_v1"();
+CREATE OR REPLACE FUNCTION "public"."uuid_generate_v1"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_generate_v1'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_generate_v1mc
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_generate_v1mc"();
+CREATE OR REPLACE FUNCTION "public"."uuid_generate_v1mc"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_generate_v1mc'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_generate_v3
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_generate_v3"("namespace" uuid, "name" text);
+CREATE OR REPLACE FUNCTION "public"."uuid_generate_v3"("namespace" uuid, "name" text)
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_generate_v3'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_generate_v4
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_generate_v4"();
+CREATE OR REPLACE FUNCTION "public"."uuid_generate_v4"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_generate_v4'
+ LANGUAGE c VOLATILE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_generate_v5
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_generate_v5"("namespace" uuid, "name" text);
+CREATE OR REPLACE FUNCTION "public"."uuid_generate_v5"("namespace" uuid, "name" text)
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_generate_v5'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_nil
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_nil"();
+CREATE OR REPLACE FUNCTION "public"."uuid_nil"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_nil'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_ns_dns
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_ns_dns"();
+CREATE OR REPLACE FUNCTION "public"."uuid_ns_dns"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_ns_dns'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_ns_oid
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_ns_oid"();
+CREATE OR REPLACE FUNCTION "public"."uuid_ns_oid"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_ns_oid'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_ns_url
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_ns_url"();
+CREATE OR REPLACE FUNCTION "public"."uuid_ns_url"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_ns_url'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Function structure for uuid_ns_x500
+-- ----------------------------
+DROP FUNCTION IF EXISTS "public"."uuid_ns_x500"();
+CREATE OR REPLACE FUNCTION "public"."uuid_ns_x500"()
+ RETURNS "pg_catalog"."uuid" AS '$libdir/uuid-ossp', 'uuid_ns_x500'
+ LANGUAGE c IMMUTABLE STRICT
+ COST 1;
+
+-- ----------------------------
+-- Alter sequences owned by
+-- ----------------------------
+SELECT setval('"public"."dict_code_seq"', 94, true);
+SELECT setval('"public"."gen_table_column_id_seq"', 545, true);
+SELECT setval('"public"."gen_table_id_seq"', 242, true);
+SELECT setval('"public"."sys_config_id_seq"', 32, true);
+SELECT setval('"public"."sys_dept_id_seq"', 118, true);
+SELECT setval('"public"."sys_dict_type_id_seq"', 29, true);
+SELECT setval('"public"."sys_job_id_seq"', 15, true);
+SELECT setval('"public"."sys_job_log_id_seq"', 1, true);
+SELECT setval('"public"."sys_logininfor_id_seq"', 3763, true);
+SELECT setval('"public"."sys_menu_id_seq"', 1172, true);
+SELECT setval('"public"."sys_notice_id_seq"', 4, false);
+SELECT setval('"public"."sys_oper_log_id_seq"', 1, true);
+SELECT setval('"public"."sys_post_id_seq"', 6, false);
+SELECT setval('"public"."sys_role_id_seq"', 11, true);
+SELECT setval('"public"."sys_user_id_seq"', 4, false);
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_access
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_access" ADD CONSTRAINT "ard_alarm_access_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_apponekey
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_apponekey" ADD CONSTRAINT "ard_alarm_apponekey_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_areas
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_areas" ADD CONSTRAINT "ard_alarm_areas_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_camera
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_camera" ADD CONSTRAINT "ard_alarm_camera_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_external
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_external" ADD CONSTRAINT "ard_alarm_external_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_radar
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_radar" ADD CONSTRAINT "ard_alarm_radar_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_radar_fire
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_radar_fire" ADD CONSTRAINT "ard_alarm_radar_fire_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_radar_move
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_radar_move" ADD CONSTRAINT "ard_alarm_radar_move_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_radar_pump
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_radar_pump" ADD CONSTRAINT "ard_alarm_radar_pump_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_stealelec
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_stealelec" ADD CONSTRAINT "ard_alarm_stealelec_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_tube
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_tube" ADD CONSTRAINT "ard_alarm_tube_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarm_wall
+-- ----------------------------
+ALTER TABLE "public"."ard_alarm_wall" ADD CONSTRAINT "ard_alarm_wall_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table ard_alarmpoints
+-- ----------------------------
+CREATE INDEX "fk_ap_typename_idx" ON "public"."ard_alarmpoints" USING btree (
+ "typename" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
+);
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarmpoints
+-- ----------------------------
+ALTER TABLE "public"."ard_alarmpoints" ADD CONSTRAINT "ard_alarmpoints_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_alarmpoints_well
+-- ----------------------------
+ALTER TABLE "public"."ard_alarmpoints_well" ADD CONSTRAINT "ard_alarmpoints_well_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_patrolplan
+-- ----------------------------
+ALTER TABLE "public"."ard_app_patrolplan" ADD CONSTRAINT "ard_app_patrolplan_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_patrolpoint
+-- ----------------------------
+ALTER TABLE "public"."ard_app_patrolpoint" ADD CONSTRAINT "ard_app_patrolpoint_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_patrolpoint_record
+-- ----------------------------
+ALTER TABLE "public"."ard_app_patrolpoint_record" ADD CONSTRAINT "ard_app_patrolpoint_record_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_patrolpoint_record_img
+-- ----------------------------
+ALTER TABLE "public"."ard_app_patrolpoint_record_img" ADD CONSTRAINT "ard_app_patrolpoint_record_img_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_patroluser
+-- ----------------------------
+ALTER TABLE "public"."ard_app_patroluser" ADD CONSTRAINT "ard_app_patroluser_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_position
+-- ----------------------------
+ALTER TABLE "public"."ard_app_position" ADD CONSTRAINT "ard_app_position_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_task
+-- ----------------------------
+ALTER TABLE "public"."ard_app_task" ADD CONSTRAINT "ard_app_task_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_task_detail
+-- ----------------------------
+ALTER TABLE "public"."ard_app_task_detail" ADD CONSTRAINT "ard_app_task_detail_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_task_detail_pic
+-- ----------------------------
+ALTER TABLE "public"."ard_app_task_detail_pic" ADD CONSTRAINT "ard_app_task_detail_pic_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_task_pic
+-- ----------------------------
+ALTER TABLE "public"."ard_app_task_pic" ADD CONSTRAINT "ard_app_task_pic_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_app_task_text
+-- ----------------------------
+ALTER TABLE "public"."ard_app_task_text" ADD CONSTRAINT "ard_app_task_text_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_camera_priority
+-- ----------------------------
+ALTER TABLE "public"."ard_camera_priority" ADD CONSTRAINT "ard_cameras_priority_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_cameras
+-- ----------------------------
+ALTER TABLE "public"."ard_cameras" ADD CONSTRAINT "ard_cameras_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_channel
+-- ----------------------------
+ALTER TABLE "public"."ard_channel" ADD CONSTRAINT "ard_cameras_channel_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_dispatch_police
+-- ----------------------------
+ALTER TABLE "public"."ard_dispatch_police" ADD CONSTRAINT "ard_dispatch_police_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_equip_alarm_areas
+-- ----------------------------
+ALTER TABLE "public"."ard_equip_alarm_areas" ADD CONSTRAINT "ard_equip_alarm_areas_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_equip_external
+-- ----------------------------
+ALTER TABLE "public"."ard_equip_external" ADD CONSTRAINT "ard_equip_external_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_equip_radar
+-- ----------------------------
+ALTER TABLE "public"."ard_equip_radar" ADD CONSTRAINT "ard_equip_radar_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_police_room
+-- ----------------------------
+ALTER TABLE "public"."ard_police_room" ADD CONSTRAINT "ard_police_room_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_pull_stream
+-- ----------------------------
+ALTER TABLE "public"."ard_pull_stream" ADD CONSTRAINT "ard_pull_stream_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_push_stream
+-- ----------------------------
+ALTER TABLE "public"."ard_push_stream" ADD CONSTRAINT "ard_push_stream_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_sy_car
+-- ----------------------------
+ALTER TABLE "public"."ard_sy_car" ADD CONSTRAINT "ard_sy_car_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_sy_car_day
+-- ----------------------------
+ALTER TABLE "public"."ard_sy_car_day" ADD CONSTRAINT "ard_sy_car_day_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_sy_user
+-- ----------------------------
+ALTER TABLE "public"."ard_sy_user" ADD CONSTRAINT "ard_sy_user_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_tiles3d
+-- ----------------------------
+ALTER TABLE "public"."ard_tiles3d" ADD CONSTRAINT "tiles3d_pkey" PRIMARY KEY ("tiles_id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_towers
+-- ----------------------------
+ALTER TABLE "public"."ard_towers" ADD CONSTRAINT "ard_towers_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_tubes
+-- ----------------------------
+ALTER TABLE "public"."ard_tubes" ADD CONSTRAINT "ard_tubes_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_tubes_details
+-- ----------------------------
+ALTER TABLE "public"."ard_tubes_details" ADD CONSTRAINT "ard_tubes_details_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_video_inspect_record
+-- ----------------------------
+ALTER TABLE "public"."ard_video_inspect_record" ADD CONSTRAINT "pk_ard_video_inspect_record" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_video_inspect_task
+-- ----------------------------
+ALTER TABLE "public"."ard_video_inspect_task" ADD CONSTRAINT "pk_ard_video_inspect_task" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_video_inspect_task_step
+-- ----------------------------
+ALTER TABLE "public"."ard_video_inspect_task_step" ADD CONSTRAINT "pk_ard_video_inspect_task_step" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table ard_wall
+-- ----------------------------
+ALTER TABLE "public"."ard_wall" ADD CONSTRAINT "ard_wall_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table qrtz_job_details
+-- ----------------------------
+ALTER TABLE "public"."qrtz_job_details" ADD CONSTRAINT "qrtz_job_details_pkey" PRIMARY KEY ("sched_name", "job_name", "job_group");
+
+-- ----------------------------
+-- Primary Key structure for table storage_minio_event
+-- ----------------------------
+ALTER TABLE "public"."storage_minio_event" ADD CONSTRAINT "storage_minio_event_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Primary Key structure for table sys_job
+-- ----------------------------
+ALTER TABLE "public"."sys_job" ADD CONSTRAINT "sys_job_pkey" PRIMARY KEY ("job_id");
+
+-- ----------------------------
+-- Primary Key structure for table sys_job_log
+-- ----------------------------
+ALTER TABLE "public"."sys_job_log" ADD CONSTRAINT "sys_job_log_pkey" PRIMARY KEY ("job_log_id");
+
+-- ----------------------------
+-- Primary Key structure for table sys_logininfor
+-- ----------------------------
+ALTER TABLE "public"."sys_logininfor" ADD CONSTRAINT "sys_logininfor_pkey" PRIMARY KEY ("info_id");
+
+-- ----------------------------
+-- Primary Key structure for table sys_user
+-- ----------------------------
+ALTER TABLE "public"."sys_user" ADD CONSTRAINT "sys_user_pkey" PRIMARY KEY ("user_id");
+
+-- ----------------------------
+-- Primary Key structure for table vtdu
+-- ----------------------------
+ALTER TABLE "public"."vtdu" ADD CONSTRAINT "media_code_pkey" PRIMARY KEY ("name");
--
Gitblit v1.9.3