/*
|
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 '报警区id';
|
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 '子系统ID';
|
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 '操作员ID';
|
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 '所属设备id';
|
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 '报警区id';
|
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 '塔id';
|
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 '操作员id';
|
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 '井id';
|
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表trigger_name的外键';
|
COMMENT ON COLUMN "public"."qrtz_blob_triggers"."trigger_group" IS 'qrtz_triggers表trigger_group的外键';
|
COMMENT ON COLUMN "public"."qrtz_blob_triggers"."blob_data" IS '存放持久化Trigger对象';
|
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 '存放持久化calendar对象';
|
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表trigger_name的外键';
|
COMMENT ON COLUMN "public"."qrtz_cron_triggers"."trigger_group" IS 'qrtz_triggers表trigger_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 '调度器实例id';
|
COMMENT ON COLUMN "public"."qrtz_fired_triggers"."trigger_name" IS 'qrtz_triggers表trigger_name的外键';
|
COMMENT ON COLUMN "public"."qrtz_fired_triggers"."trigger_group" IS 'qrtz_triggers表trigger_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 '存放持久化job对象';
|
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表trigger_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表trigger_name的外键';
|
COMMENT ON COLUMN "public"."qrtz_simple_triggers"."trigger_group" IS 'qrtz_triggers表trigger_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表trigger_name的外键';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."trigger_group" IS 'qrtz_triggers表trigger_group的外键';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."str_prop_1" IS 'String类型的trigger的第一个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."str_prop_2" IS 'String类型的trigger的第二个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."str_prop_3" IS 'String类型的trigger的第三个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."int_prop_1" IS 'int类型的trigger的第一个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."int_prop_2" IS 'int类型的trigger的第二个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."long_prop_1" IS 'long类型的trigger的第一个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."long_prop_2" IS 'long类型的trigger的第二个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."dec_prop_1" IS 'decimal类型的trigger的第一个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."dec_prop_2" IS 'decimal类型的trigger的第二个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."bool_prop_1" IS 'Boolean类型的trigger的第一个参数';
|
COMMENT ON COLUMN "public"."qrtz_simprop_triggers"."bool_prop_2" IS 'Boolean类型的trigger的第二个参数';
|
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表job_name的外键';
|
COMMENT ON COLUMN "public"."qrtz_triggers"."job_group" IS 'qrtz_job_details表job_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 '存放持久化job对象';
|
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 '系统内置（Y是 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 '父部门id';
|
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 '是否默认（Y是 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 '父菜单ID';
|
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 '菜单类型（M目录 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 '最后登录IP';
|
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");
|
