/* Navicat Premium Data Transfer Source Server : 192.168.2.15 Source Server Type : PostgreSQL Source Server Version : 100000 (100000) Source Host : 192.168.2.15:5432 Source Catalog : ry-vue Source Schema : public Target Server Type : PostgreSQL Target Server Version : 100000 (100000) File Encoding : 65001 Date: 15/07/2024 16:24:22 */ -- ---------------------------- -- 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 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,0), "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 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 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_alarm_super_brain -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_alarm_super_brain"; CREATE TABLE "public"."ard_alarm_super_brain" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "alarm_name" varchar(255) COLLATE "pg_catalog"."default", "alarm_type" varchar(100) COLLATE "pg_catalog"."default", "alarm_time" timestamp(6), "device_id" varchar(255) COLLATE "pg_catalog"."default", "device_name" varchar(255) COLLATE "pg_catalog"."default", "chan_no" int2, "longitude" float8, "latitude" float8, "altitude" float8, "pic_url" varchar(255) COLLATE "pg_catalog"."default", "face_url" varchar(255) COLLATE "pg_catalog"."default", "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_super_brain"."id" IS '报警主键'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."alarm_name" IS '报警名称'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."alarm_type" IS '报警类型'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."alarm_time" IS '报警时间'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."device_id" IS '设备id'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."device_name" IS '设备名称'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."chan_no" IS '通道号'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."altitude" IS '高层'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."pic_url" IS '图片url'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."face_url" IS '人脸图片url'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."ard_alarm_super_brain"."view_time" IS '查看时间'; COMMENT ON TABLE "public"."ard_alarm_super_brain" 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_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 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_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", "menu_name_i18n" varchar(50) 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 COLUMN "public"."sys_menu"."menu_name_i18n" IS '菜单名称i18n'; COMMENT ON TABLE "public"."sys_menu" 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 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", "dict_label_i18n" varchar(255) 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 COLUMN "public"."sys_dict_data"."dict_label_i18n" IS '字典标签i18n'; COMMENT ON TABLE "public"."sys_dict_data" 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_url" 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, "update_time" timestamp(6), "guide_time" timestamp(6) ) ; 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_url" IS '引导录像'; 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"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."ard_alarm_radar_pump"."guide_time" IS '引导时间'; COMMENT ON TABLE "public"."ard_alarm_radar_pump" 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 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", "config_name_i18n" varchar(255) 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 COLUMN "public"."sys_config"."config_name_i18n" IS '参数名称i18n'; COMMENT ON TABLE "public"."sys_config" 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", "dict_name_i18n" varchar(255) 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 COLUMN "public"."sys_dict_type"."dict_name_i18n" IS '字典名称i18n'; COMMENT ON TABLE "public"."sys_dict_type" 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 vtdu -- ---------------------------- DROP TABLE IF EXISTS "public"."vtdu"; CREATE TABLE "public"."vtdu" ( "name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "rtsp_source" varchar(255) COLLATE "pg_catalog"."default", "is_code" varchar(1) COLLATE "pg_catalog"."default", "mode" varchar(1) COLLATE "pg_catalog"."default", "camera_id" varchar(255) COLLATE "pg_catalog"."default", "rtsp_url" varchar(255) COLLATE "pg_catalog"."default", "rtmp_url" varchar(255) COLLATE "pg_catalog"."default", "webrtc_url" varchar(255) COLLATE "pg_catalog"."default", "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(6), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(6), "id1" int8, "name1" varchar(20) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."vtdu"."name" IS '名称'; COMMENT ON COLUMN "public"."vtdu"."rtsp_source" IS 'rtsp拉流地址'; COMMENT ON COLUMN "public"."vtdu"."is_code" IS '是否转码'; COMMENT ON COLUMN "public"."vtdu"."mode" IS '编解码模式'; COMMENT ON COLUMN "public"."vtdu"."camera_id" IS '相机ID'; COMMENT ON COLUMN "public"."vtdu"."rtsp_url" IS 'rtsp源地址'; COMMENT ON COLUMN "public"."vtdu"."rtmp_url" IS 'rtmp拉流地址'; COMMENT ON COLUMN "public"."vtdu"."webrtc_url" IS 'webrtc拉流地址'; COMMENT ON COLUMN "public"."vtdu"."name1" IS '字段备注'; COMMENT ON TABLE "public"."vtdu" IS '流媒体管理表'; -- ---------------------------- -- Table structure for ard_alarm_filter -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_alarm_filter"; CREATE TABLE "public"."ard_alarm_filter" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "user_id" varchar(255) COLLATE "pg_catalog"."default", "name" varchar(255) COLLATE "pg_catalog"."default", "alarm_type" varchar(64) COLLATE "pg_catalog"."default", "begin_time" timestamp(6), "end_time" timestamp(6), "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(6), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(6) ) ; COMMENT ON COLUMN "public"."ard_alarm_filter"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_alarm_filter"."user_id" IS '用户id'; COMMENT ON COLUMN "public"."ard_alarm_filter"."name" IS '名称'; COMMENT ON COLUMN "public"."ard_alarm_filter"."alarm_type" IS '报警类型'; COMMENT ON COLUMN "public"."ard_alarm_filter"."begin_time" IS '开始时间'; COMMENT ON COLUMN "public"."ard_alarm_filter"."end_time" IS '结束时间'; COMMENT ON COLUMN "public"."ard_alarm_filter"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_alarm_filter"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_alarm_filter"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_alarm_filter"."update_time" IS '更新时间'; COMMENT ON TABLE "public"."ard_alarm_filter" 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) ) ; 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 TABLE "public"."ard_alarmpoints_well" 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 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_alarm_digitization3 -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_alarm_digitization3"; CREATE TABLE "public"."ard_alarm_digitization3" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "xmmc" varchar(255) COLLATE "pg_catalog"."default", "f_key" varchar(255) COLLATE "pg_catalog"."default", "f_name" varchar(255) COLLATE "pg_catalog"."default", "well_no" varchar(255) COLLATE "pg_catalog"."default", "alarm_time" timestamp(6), "alarm_type" varchar(255) COLLATE "pg_catalog"."default", "longitude" float8, "latitude" float8, "altitude" float8, "create_time" timestamp(6), "view_time" timestamp(6) ) ; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."id" IS 'ID'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."xmmc" IS '项目名称'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."f_key" IS '外键'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."f_name" IS '字段名称'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."well_no" IS '井号'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."alarm_time" IS '报警时间'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."alarm_type" IS '报警内容'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."altitude" IS '高层'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_alarm_digitization3"."view_time" IS '查看时间'; COMMENT ON TABLE "public"."ard_alarm_digitization3" 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_camera_user_postion -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_camera_user_postion"; CREATE TABLE "public"."ard_camera_user_postion" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "camera_id" varchar COLLATE "pg_catalog"."default", "chan_no" int2, "user_id" varchar COLLATE "pg_catalog"."default", "position" varchar(255) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_camera_user_postion"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_camera_user_postion"."camera_id" IS '相机ID'; COMMENT ON COLUMN "public"."ard_camera_user_postion"."chan_no" IS '通道号'; COMMENT ON COLUMN "public"."ard_camera_user_postion"."user_id" IS '用户ID'; COMMENT ON COLUMN "public"."ard_camera_user_postion"."position" IS '位置标识'; COMMENT ON TABLE "public"."ard_camera_user_postion" 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,0), "cam_alarm_guide_enable" int2, "state" varchar(1) COLLATE "pg_catalog"."default", "factory" varchar(10) COLLATE "pg_catalog"."default", "start_chan" 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 COLUMN "public"."ard_cameras"."state" IS '在线状态'; COMMENT ON COLUMN "public"."ard_cameras"."factory" IS '厂商'; COMMENT ON COLUMN "public"."ard_cameras"."start_chan" IS '起始通道'; COMMENT ON TABLE "public"."ard_cameras" 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_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 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_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 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 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_url" 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, "update_time" timestamp(6), "guide_time" timestamp(6) ) ; 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_url" IS '引导录像'; 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"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."ard_alarm_radar_fire"."guide_time" IS '引导时间'; COMMENT ON TABLE "public"."ard_alarm_radar_fire" 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 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_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, "name" varchar(64) 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", "longitude" float8, "latitude" float8, "altitude" float8, "radar_date" timestamp(6), "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", "user_id" varchar(64) COLLATE "pg_catalog"."default", "dept_id" int8, "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", "state" varchar(1) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_equip_radar"."id" IS 'id'; COMMENT ON COLUMN "public"."ard_equip_radar"."name" 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"."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"."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"."user_id" IS '用户id'; COMMENT ON COLUMN "public"."ard_equip_radar"."dept_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"."state" IS '在线状态'; COMMENT ON TABLE "public"."ard_equip_radar" IS '雷达管理表'; -- ---------------------------- -- Table structure for ard_camera_no_guide_zone -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_camera_no_guide_zone"; CREATE TABLE "public"."ard_camera_no_guide_zone" ( "id" varchar(250) COLLATE "pg_catalog"."default" NOT NULL, "name" varchar(255) COLLATE "pg_catalog"."default", "poi" varchar(25500) COLLATE "pg_catalog"."default", "camera_id" varchar(64) COLLATE "pg_catalog"."default", "enabled" varchar(1) COLLATE "pg_catalog"."default", "dept_id" int4, "user_id" varchar COLLATE "pg_catalog"."default", "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(0), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(0) ) ; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."id" IS 'id'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."name" IS '名称'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."poi" IS '范围'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."camera_id" IS '相机ID'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."enabled" IS '是否启用'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."dept_id" IS '部门ID'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."user_id" IS '用户ID'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."update_by" IS '修改者'; COMMENT ON COLUMN "public"."ard_camera_no_guide_zone"."update_time" IS '修改时间'; COMMENT ON TABLE "public"."ard_camera_no_guide_zone" IS '禁引可视域管理表'; -- ---------------------------- -- 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_well_guide_camera -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_well_guide_camera"; CREATE TABLE "public"."ard_well_guide_camera" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "camera_id" varchar(255) COLLATE "pg_catalog"."default", "p1" numeric, "t1" numeric, "z1" numeric, "p2" numeric, "t2" numeric, "z2" numeric, "well_id" varchar(64) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_well_guide_camera"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."camera_id" IS '相机ID'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."p1" IS '可见光p值'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."t1" IS '可见光t值'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."z1" IS '可见光z值'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."p2" IS '热红外p值'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."t2" IS '热红外t值'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."z2" IS '热红外z值'; COMMENT ON COLUMN "public"."ard_well_guide_camera"."well_id" IS '井ID'; COMMENT ON TABLE "public"."ard_well_guide_camera" IS '井关联引导相机'; -- ---------------------------- -- Table structure for ard_uwb -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_uwb"; CREATE TABLE "public"."ard_uwb" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "name" varchar(45) COLLATE "pg_catalog"."default" NOT NULL, "device_id" varchar(45) COLLATE "pg_catalog"."default" NOT NULL, "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_uwb"."id" IS 'id'; COMMENT ON COLUMN "public"."ard_uwb"."name" IS '名称'; COMMENT ON COLUMN "public"."ard_uwb"."device_id" IS '卡片ID'; COMMENT ON COLUMN "public"."ard_uwb"."user_id" IS '用户ID'; COMMENT ON COLUMN "public"."ard_uwb"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_uwb"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_uwb"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_uwb"."update_time" IS '更新时间'; COMMENT ON TABLE "public"."ard_uwb" IS 'uwb管理表'; -- ---------------------------- -- 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_oil_wall -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_oil_wall"; CREATE TABLE "public"."ard_oil_wall" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "name" varchar(255) COLLATE "pg_catalog"."default", "coord" varchar(25500) COLLATE "pg_catalog"."default", "type" varchar(2) 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_oil_wall"."name" IS '名称'; COMMENT ON COLUMN "public"."ard_oil_wall"."coord" IS '范围'; COMMENT ON COLUMN "public"."ard_oil_wall"."type" IS '类型'; COMMENT ON COLUMN "public"."ard_oil_wall"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_oil_wall"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_oil_wall"."update_by" IS '修改者'; COMMENT ON COLUMN "public"."ard_oil_wall"."update_time" IS '修改时间'; -- ---------------------------- -- Table structure for ard_camera_pitch_point -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_camera_pitch_point"; CREATE TABLE "public"."ard_camera_pitch_point" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "longitude" numeric, "latitude" numeric, "altitude" numeric, "difference" numeric, "camera_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_camera_pitch_point"."id" IS 'id'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."altitude" IS '高层'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."difference" IS '差值'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."camera_id" IS '相机id'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_camera_pitch_point"."update_time" IS '更新时间'; COMMENT ON TABLE "public"."ard_camera_pitch_point" 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_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 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 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 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_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_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_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 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 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 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_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_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_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_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_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_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_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_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_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 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 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 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_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_terrain_mark -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_terrain_mark"; CREATE TABLE "public"."ard_terrain_mark" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "camera_id" varchar(255) COLLATE "pg_catalog"."default", "longitude" numeric, "latitude" numeric, "altitude" numeric, "t" numeric, "dept_id" int4, "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_terrain_mark"."id" IS 'ID主键'; COMMENT ON COLUMN "public"."ard_terrain_mark"."camera_id" IS '相机ID'; COMMENT ON COLUMN "public"."ard_terrain_mark"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_terrain_mark"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_terrain_mark"."altitude" IS '高层'; COMMENT ON COLUMN "public"."ard_terrain_mark"."t" IS '俯仰'; COMMENT ON COLUMN "public"."ard_terrain_mark"."dept_id" IS '所属部门'; COMMENT ON COLUMN "public"."ard_terrain_mark"."user_id" IS '所属用户'; COMMENT ON COLUMN "public"."ard_terrain_mark"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_terrain_mark"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_terrain_mark"."update_by" IS '修改者'; COMMENT ON COLUMN "public"."ard_terrain_mark"."update_time" IS '修改时间'; COMMENT ON TABLE "public"."ard_terrain_mark" IS '地形标定管理表'; -- ---------------------------- -- Table structure for ard_tank_wall_temporary -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_wall_temporary"; CREATE TABLE "public"."ard_tank_wall_temporary" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "wall_name" varchar(255) COLLATE "pg_catalog"."default", "longitude" numeric, "latitude" numeric, "distance" int4, "interval" varchar(50) COLLATE "pg_catalog"."default", "process_time" varchar(100) COLLATE "pg_catalog"."default", "process_mark" varchar(10) COLLATE "pg_catalog"."default", "user_id" varchar(64) COLLATE "pg_catalog"."default", "user_name" varchar(255) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."wall_name" IS '围栏名称'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."distance" IS '距离'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."interval" IS '时长'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."process_time" IS '操作时间'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."process_mark" IS '1为生效，0为失效，-1为到期'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."user_id" IS '用户主键'; COMMENT ON COLUMN "public"."ard_tank_wall_temporary"."user_name" IS '用户名称'; -- ---------------------------- -- Table structure for ard_tank_wall_lock_temporary -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_wall_lock_temporary"; CREATE TABLE "public"."ard_tank_wall_lock_temporary" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "wall_id" varchar(64) COLLATE "pg_catalog"."default", "lock_id" varchar(64) COLLATE "pg_catalog"."default", "process_type" varchar(10) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_wall_lock_temporary"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_wall_lock_temporary"."wall_id" IS '围栏主键'; COMMENT ON COLUMN "public"."ard_tank_wall_lock_temporary"."lock_id" IS '锁主键'; COMMENT ON COLUMN "public"."ard_tank_wall_lock_temporary"."process_type" IS '操作类型'; -- ---------------------------- -- Table structure for ard_tank_wall_lock -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_wall_lock"; CREATE TABLE "public"."ard_tank_wall_lock" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "wall_id" varchar(64) COLLATE "pg_catalog"."default", "lock_id" varchar(64) COLLATE "pg_catalog"."default", "process_type" varchar(10) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_wall_lock"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_wall_lock"."wall_id" IS '电子围栏主键'; COMMENT ON COLUMN "public"."ard_tank_wall_lock"."lock_id" IS '锁主键'; COMMENT ON COLUMN "public"."ard_tank_wall_lock"."process_type" IS '操作类型'; -- ---------------------------- -- Table structure for ard_tank_wall -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_wall"; CREATE TABLE "public"."ard_tank_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" ) ; COMMENT ON COLUMN "public"."ard_tank_wall"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_wall"."wall_name" IS '电子围栏名称'; COMMENT ON COLUMN "public"."ard_tank_wall"."wall_poi" IS '电子围栏范围'; -- ---------------------------- -- Table structure for ard_tank_lock_state -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_lock_state"; CREATE TABLE "public"."ard_tank_lock_state" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "lock_id" varchar(64) COLLATE "pg_catalog"."default", "lock_num" varchar(20) COLLATE "pg_catalog"."default", "lock_state" varchar(10) COLLATE "pg_catalog"."default", "lock_position_state" varchar(10) COLLATE "pg_catalog"."default", "lock_shell_state" varchar(10) COLLATE "pg_catalog"."default", "restart_state" varchar(10) COLLATE "pg_catalog"."default", "batter_voltage" varchar(20) COLLATE "pg_catalog"."default", "power_voltage" varchar(20) COLLATE "pg_catalog"."default", "upload_time" varchar(50) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_lock_state"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."lock_id" IS '锁主键'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."lock_num" IS '锁编号'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."lock_state" IS '锁状态'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."lock_position_state" IS '位置状态'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."lock_shell_state" IS '外壳状态'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."restart_state" IS '重启状态：开或关'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."batter_voltage" IS '电池电压'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."power_voltage" IS '电源电压'; COMMENT ON COLUMN "public"."ard_tank_lock_state"."upload_time" IS '上传时间'; COMMENT ON TABLE "public"."ard_tank_lock_state" IS '罐车锁状态'; -- ---------------------------- -- Table structure for ard_tank_lock_process_log -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_lock_process_log"; CREATE TABLE "public"."ard_tank_lock_process_log" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "lock_id" varchar(64) COLLATE "pg_catalog"."default", "lock_num" varchar(20) COLLATE "pg_catalog"."default", "car_id" varchar(50) COLLATE "pg_catalog"."default", "car_plate" varchar(255) COLLATE "pg_catalog"."default", "user_id" varchar(64) COLLATE "pg_catalog"."default", "user_name" varchar(30) COLLATE "pg_catalog"."default", "process" varchar(10) COLLATE "pg_catalog"."default", "process_reason" varchar(500) COLLATE "pg_catalog"."default", "longitude" varchar(255) COLLATE "pg_catalog"."default", "latitude" varchar(255) COLLATE "pg_catalog"."default", "process_time" varchar(100) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."lock_id" IS '锁主键'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."lock_num" IS '锁编号'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."car_id" IS '三一车辆主键'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."car_plate" IS '车牌号'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."user_id" IS '操作用户主键'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."user_name" IS '操作用户账号'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."process" IS '操作'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."process_reason" IS '操作原因'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_tank_lock_process_log"."process_time" IS '操作时间'; COMMENT ON TABLE "public"."ard_tank_lock_process_log" IS '罐车锁操控日志'; -- ---------------------------- -- Table structure for ard_tank_lock_password -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_lock_password"; CREATE TABLE "public"."ard_tank_lock_password" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "lock_id" varchar(64) COLLATE "pg_catalog"."default", "password" varchar(20) COLLATE "pg_catalog"."default", "no" int4, "create_time" varchar(50) COLLATE "pg_catalog"."default", "use_time" varchar(50) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_lock_password"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_lock_password"."lock_id" IS '锁主键'; COMMENT ON COLUMN "public"."ard_tank_lock_password"."password" IS '密码'; COMMENT ON COLUMN "public"."ard_tank_lock_password"."no" IS '编号'; COMMENT ON COLUMN "public"."ard_tank_lock_password"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_tank_lock_password"."use_time" IS '使用时间'; COMMENT ON TABLE "public"."ard_tank_lock_password" IS '罐车锁密码'; -- ---------------------------- -- Table structure for ard_tank_lock -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_lock"; CREATE TABLE "public"."ard_tank_lock" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "lock_num" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "lock_name" varchar(255) COLLATE "pg_catalog"."default", "img_position_top" varchar(1000) COLLATE "pg_catalog"."default", "img_position_left" varchar(1000) COLLATE "pg_catalog"."default", "car_id" varchar(50) COLLATE "pg_catalog"."default", "enable" varchar(10) COLLATE "pg_catalog"."default", "restart_state" varchar(10) COLLATE "pg_catalog"."default", "online_time" varchar(30) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_lock"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_lock"."lock_num" IS '锁编号'; COMMENT ON COLUMN "public"."ard_tank_lock"."lock_name" IS '锁名称'; COMMENT ON COLUMN "public"."ard_tank_lock"."img_position_top" IS '顶部位置'; COMMENT ON COLUMN "public"."ard_tank_lock"."img_position_left" IS '右侧位置'; COMMENT ON COLUMN "public"."ard_tank_lock"."car_id" IS '三一车辆主键'; COMMENT ON COLUMN "public"."ard_tank_lock"."enable" IS '使能'; COMMENT ON COLUMN "public"."ard_tank_lock"."restart_state" IS '重启状态：开或关'; COMMENT ON COLUMN "public"."ard_tank_lock"."online_time" IS '在线时间'; COMMENT ON TABLE "public"."ard_tank_lock" IS '罐车锁'; -- ---------------------------- -- Table structure for ard_tank_abnormal_park_alarm -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_tank_abnormal_park_alarm"; CREATE TABLE "public"."ard_tank_abnormal_park_alarm" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "car_id" varchar(10) COLLATE "pg_catalog"."default", "car_name" varchar(255) COLLATE "pg_catalog"."default", "longitude" numeric, "latitude" numeric, "begin_time" varchar(60) COLLATE "pg_catalog"."default", "end_time" varchar(60) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."car_id" IS '三一车辆主键'; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."car_name" IS '三一车辆名称'; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."longitude" IS '经度'; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."latitude" IS '纬度'; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."begin_time" IS '开始时间'; COMMENT ON COLUMN "public"."ard_tank_abnormal_park_alarm"."end_time" IS '结束时间'; -- ---------------------------- -- Table structure for ard_sy_car_rtu -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_sy_car_rtu"; CREATE TABLE "public"."ard_sy_car_rtu" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "car_id" varchar(64) COLLATE "pg_catalog"."default", "topic_subscribe" varchar(255) COLLATE "pg_catalog"."default", "topic_publish" varchar(255) COLLATE "pg_catalog"."default", "install_type" int2, "unload_type" int2 ) ; COMMENT ON COLUMN "public"."ard_sy_car_rtu"."install_type" IS '装油点 0施封 1解封'; COMMENT ON COLUMN "public"."ard_sy_car_rtu"."unload_type" IS '卸油点 0施封 1解封'; -- ---------------------------- -- Table structure for ard_sy_car_lock -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_sy_car_lock"; CREATE TABLE "public"."ard_sy_car_lock" ( "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "rtu_id" varchar(64) COLLATE "pg_catalog"."default", "lock_name" varchar(255) COLLATE "pg_catalog"."default", "img_position_top" varchar(255) COLLATE "pg_catalog"."default", "img_position_left" varchar(255) COLLATE "pg_catalog"."default", "relay" varchar(255) COLLATE "pg_catalog"."default", "relay_info" int4, "current_info" float8, "currents" varchar(255) COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- 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 'rtu'; 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_rong_group_user -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_rong_group_user"; CREATE TABLE "public"."ard_rong_group_user" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "group_id" varchar(255) COLLATE "pg_catalog"."default", "user_id" varchar(255) COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Table structure for ard_rong_group -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_rong_group"; CREATE TABLE "public"."ard_rong_group" ( "group_id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "group_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "create_name" varchar(255) COLLATE "pg_catalog"."default", "create_time" date ) ; -- ---------------------------- -- 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_pump_status -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_pump_status"; CREATE TABLE "public"."ard_pump_status" ( "target_id" int8, "name" varchar(255) COLLATE "pg_catalog"."default", "alarm_type" varchar(255) COLLATE "pg_catalog"."default", "alarm_time" varchar(255) COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- 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_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_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" varchar(16) COLLATE "pg_catalog"."default", "factory" varchar(16) COLLATE "pg_catalog"."default", "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_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, "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_eplan -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_eplan"; CREATE TABLE "public"."ard_eplan" ( "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "name" varchar(255) COLLATE "pg_catalog"."default", "time" varchar(100) COLLATE "pg_catalog"."default", "info" varchar(5000000) COLLATE "pg_catalog"."default", "user_id" varchar(50) COLLATE "pg_catalog"."default", "dept_id" int8, "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" ) ; COMMENT ON COLUMN "public"."ard_eplan"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_eplan"."name" IS '预案名称'; COMMENT ON COLUMN "public"."ard_eplan"."time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_eplan"."info" IS '预案详情'; COMMENT ON COLUMN "public"."ard_eplan"."user_id" IS '创建人'; COMMENT ON COLUMN "public"."ard_eplan"."dept_id" IS '部门主键'; COMMENT ON COLUMN "public"."ard_eplan"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_eplan"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_eplan"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_eplan"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."ard_eplan"."del_flag" IS '删除标记'; COMMENT ON TABLE "public"."ard_eplan" 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_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_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 ''::character varying, "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_call_unread_messages -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_call_unread_messages"; CREATE TABLE "public"."ard_call_unread_messages" ( "user_id" varchar(255) COLLATE "pg_catalog"."default", "session_id" varchar(255) COLLATE "pg_catalog"."default", "unread_count" int4 ) ; COMMENT ON COLUMN "public"."ard_call_unread_messages"."user_id" IS '用户id'; COMMENT ON COLUMN "public"."ard_call_unread_messages"."session_id" IS '会话id'; COMMENT ON COLUMN "public"."ard_call_unread_messages"."unread_count" IS '未读数量'; COMMENT ON TABLE "public"."ard_call_unread_messages" IS '未读消息表'; -- ---------------------------- -- Table structure for ard_call_session_user -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_call_session_user"; CREATE TABLE "public"."ard_call_session_user" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "session_id" varchar(255) COLLATE "pg_catalog"."default", "type" varchar(64) COLLATE "pg_catalog"."default", "user_id" varchar(64) COLLATE "pg_catalog"."default", "target_id" varchar(64) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_call_session_user"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_call_session_user"."session_id" IS '会话id'; COMMENT ON COLUMN "public"."ard_call_session_user"."type" IS '会话类型'; COMMENT ON COLUMN "public"."ard_call_session_user"."user_id" IS '当前成员id'; COMMENT ON COLUMN "public"."ard_call_session_user"."target_id" IS '目标成员id'; COMMENT ON TABLE "public"."ard_call_session_user" IS '会话用户中间表'; -- ---------------------------- -- Table structure for ard_call_session -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_call_session"; CREATE TABLE "public"."ard_call_session" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "type" varchar(64) COLLATE "pg_catalog"."default", "user_id" varchar(64) COLLATE "pg_catalog"."default", "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(6), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(6) ) ; COMMENT ON COLUMN "public"."ard_call_session"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_call_session"."type" IS '会话类型'; COMMENT ON COLUMN "public"."ard_call_session"."user_id" IS '发送者ID'; COMMENT ON COLUMN "public"."ard_call_session"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_call_session"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_call_session"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_call_session"."update_time" IS '更新时间'; COMMENT ON TABLE "public"."ard_call_session" IS '会话表'; -- ---------------------------- -- Table structure for ard_call_history -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_call_history"; CREATE TABLE "public"."ard_call_history" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "type" varchar(64) COLLATE "pg_catalog"."default", "content" varchar(255) COLLATE "pg_catalog"."default", "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(6), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(6), "session_id" varchar(64) COLLATE "pg_catalog"."default", "user_id" varchar(64) COLLATE "pg_catalog"."default", "is_read" int2, "target_id" varchar(255) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."ard_call_history"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_call_history"."type" IS '消息类型'; COMMENT ON COLUMN "public"."ard_call_history"."content" IS '消息内容'; COMMENT ON COLUMN "public"."ard_call_history"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_call_history"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_call_history"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_call_history"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."ard_call_history"."session_id" IS '会话ID'; COMMENT ON COLUMN "public"."ard_call_history"."user_id" IS '用户ID'; COMMENT ON COLUMN "public"."ard_call_history"."is_read" IS '已读标记 0-未读 1-已读'; COMMENT ON COLUMN "public"."ard_call_history"."target_id" IS '目标id '; COMMENT ON TABLE "public"."ard_call_history" IS '会话消息表'; -- ---------------------------- -- Table structure for ard_call_group_user -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_call_group_user"; CREATE TABLE "public"."ard_call_group_user" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "group_id" varchar(255) COLLATE "pg_catalog"."default", "user_id" varchar(255) COLLATE "pg_catalog"."default", "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(6), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(6) ) ; COMMENT ON COLUMN "public"."ard_call_group_user"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_call_group_user"."group_id" IS '群组ID'; COMMENT ON COLUMN "public"."ard_call_group_user"."user_id" IS '用户ID'; COMMENT ON COLUMN "public"."ard_call_group_user"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_call_group_user"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_call_group_user"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_call_group_user"."update_time" IS '更新时间'; COMMENT ON TABLE "public"."ard_call_group_user" IS '群组用户中间表'; -- ---------------------------- -- Table structure for ard_call_group -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_call_group"; CREATE TABLE "public"."ard_call_group" ( "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "name" varchar(255) COLLATE "pg_catalog"."default", "create_by" varchar(255) COLLATE "pg_catalog"."default", "create_time" timestamp(6), "update_by" varchar(255) COLLATE "pg_catalog"."default", "update_time" timestamp(6) ) ; COMMENT ON COLUMN "public"."ard_call_group"."id" IS '主键'; COMMENT ON COLUMN "public"."ard_call_group"."name" IS '群名称'; COMMENT ON COLUMN "public"."ard_call_group"."create_by" IS '创建者'; COMMENT ON COLUMN "public"."ard_call_group"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."ard_call_group"."update_by" IS '更新者'; COMMENT ON COLUMN "public"."ard_call_group"."update_time" IS '更新时间'; COMMENT ON TABLE "public"."ard_call_group" IS '会话群组表'; -- ---------------------------- -- 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_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_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_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 -- ---------------------------- 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_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, "del" int2 ) ; 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单兵端用户主键'; COMMENT ON COLUMN "public"."ard_app_patroluser"."del" 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", "del" inet ) ; 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 '巡检图片'; COMMENT ON COLUMN "public"."ard_app_patrolpoint_record_img"."del" 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, "del" int2 ) ; 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 '巡检点主键'; COMMENT ON COLUMN "public"."ard_app_patrolpoint_record"."del" 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", "del" int2 ) ; 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 '类型'; COMMENT ON COLUMN "public"."ard_app_patrolpoint"."del" 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_application -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_app_application"; CREATE TABLE "public"."ard_app_application" ( "application_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "commander_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "soilder_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "reason" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "application_type" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "begin" varchar(64) COLLATE "pg_catalog"."default" NOT NULL, "state" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "soilder_check" varchar(20) COLLATE "pg_catalog"."default" NOT NULL ) ; COMMENT ON COLUMN "public"."ard_app_application"."application_id" IS '申请主键'; COMMENT ON COLUMN "public"."ard_app_application"."commander_id" IS '指挥端或PC端主键'; COMMENT ON COLUMN "public"."ard_app_application"."soilder_id" IS '单兵端主键'; COMMENT ON COLUMN "public"."ard_app_application"."reason" IS '申请原因'; COMMENT ON COLUMN "public"."ard_app_application"."application_type" IS '申请类型'; COMMENT ON COLUMN "public"."ard_app_application"."begin" IS '审批同意时间戳'; COMMENT ON COLUMN "public"."ard_app_application"."state" IS '审批状态'; COMMENT ON COLUMN "public"."ard_app_application"."soilder_check" IS '单兵端查看标记'; COMMENT ON TABLE "public"."ard_app_application" 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_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_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_url" 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, "update_time" timestamp(6), "guide_time" timestamp(6) ) ; 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_url" IS '引导录像'; 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"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."ard_alarm_radar_move"."guide_time" IS '引导时间'; COMMENT ON TABLE "public"."ard_alarm_radar_move" 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_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 ''::character varying, "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_access_num -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_access_num"; CREATE TABLE "public"."ard_access_num" ( "carousel" int4 DEFAULT 0, "call" int4 DEFAULT 0, "alarm" int4 DEFAULT 0 ) ; -- ---------------------------- -- Table structure for ard_access_fence -- ---------------------------- DROP TABLE IF EXISTS "public"."ard_access_fence"; CREATE TABLE "public"."ard_access_fence" ( "id" varchar COLLATE "pg_catalog"."default" NOT NULL, "car_id" varchar(64) COLLATE "pg_catalog"."default", "car_name" varchar(255) COLLATE "pg_catalog"."default", "dept_id" varchar(64) COLLATE "pg_catalog"."default", "dept_name" varchar(255) COLLATE "pg_catalog"."default", "lng" varchar(255) COLLATE "pg_catalog"."default", "lat" varchar(255) COLLATE "pg_catalog"."default", "into_shipment_id" varchar(64) COLLATE "pg_catalog"."default", "into_shipment_time" varchar(64) COLLATE "pg_catalog"."default", "into_unload_id" varchar(64) COLLATE "pg_catalog"."default", "into_unload_time" varchar(64) COLLATE "pg_catalog"."default", "out_shipment_id" varchar(64) COLLATE "pg_catalog"."default", "out_shipment_time" varchar(64) COLLATE "pg_catalog"."default", "last_time" varchar(64) COLLATE "pg_catalog"."default", "now_wall_name" varchar(255) COLLATE "pg_catalog"."default", "alarm_lng" varchar(255) COLLATE "pg_catalog"."default", "alarm_lat" varchar(255) COLLATE "pg_catalog"."default", "car_model" varchar(255) COLLATE "pg_catalog"."default", "is_warning" int2, "drct" int4, "is_alarm" int2 ) ; COMMENT ON COLUMN "public"."ard_access_fence"."into_shipment_id" IS '进入装油点围栏ID'; COMMENT ON COLUMN "public"."ard_access_fence"."into_shipment_time" IS '进入装油点时间'; COMMENT ON COLUMN "public"."ard_access_fence"."into_unload_id" IS '进入卸油点围栏ID'; COMMENT ON COLUMN "public"."ard_access_fence"."into_unload_time" IS '进入卸油点时间'; COMMENT ON COLUMN "public"."ard_access_fence"."out_shipment_id" IS '开出装油点围栏ID'; COMMENT ON COLUMN "public"."ard_access_fence"."out_shipment_time" IS '开出装油点时间'; COMMENT ON COLUMN "public"."ard_access_fence"."last_time" IS '最后坐标更新时间'; COMMENT ON COLUMN "public"."ard_access_fence"."now_wall_name" IS '所在围栏名称'; COMMENT ON COLUMN "public"."ard_access_fence"."alarm_lng" IS '报警经度'; COMMENT ON COLUMN "public"."ard_access_fence"."alarm_lat" IS '报警纬度'; COMMENT ON COLUMN "public"."ard_access_fence"."is_warning" IS '是否报警'; COMMENT ON COLUMN "public"."ard_access_fence"."drct" IS '朝向'; COMMENT ON COLUMN "public"."ard_access_fence"."is_alarm" IS '手动添加车辆是否报警 0为自动添加车辆 1是无需报警 2是可以有报警'; -- ---------------------------- -- Primary Key structure for table sys_oper_log -- ---------------------------- ALTER TABLE "public"."sys_oper_log" ADD CONSTRAINT "sys_oper_log_pkey" PRIMARY KEY ("oper_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 sys_logininfor -- ---------------------------- ALTER TABLE "public"."sys_logininfor" ADD CONSTRAINT "sys_logininfor_pkey" PRIMARY KEY ("info_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_alarm_super_brain -- ---------------------------- ALTER TABLE "public"."ard_alarm_super_brain" ADD CONSTRAINT "ard_alarm_super_brain_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_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 sys_menu -- ---------------------------- ALTER TABLE "public"."sys_menu" ADD CONSTRAINT "sys_menu_pkey" PRIMARY KEY ("menu_id"); -- ---------------------------- -- Primary Key structure for table sys_dict_data -- ---------------------------- ALTER TABLE "public"."sys_dict_data" ADD CONSTRAINT "sys_dict_data_pkey" PRIMARY KEY ("dict_code"); -- ---------------------------- -- 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_camera -- ---------------------------- ALTER TABLE "public"."ard_alarm_camera" ADD CONSTRAINT "ard_alarm_camera_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table sys_config -- ---------------------------- ALTER TABLE "public"."sys_config" ADD CONSTRAINT "sys_config_pkey" PRIMARY KEY ("config_id"); -- ---------------------------- -- Primary Key structure for table sys_dict_type -- ---------------------------- ALTER TABLE "public"."sys_dict_type" ADD CONSTRAINT "sys_dict_type_pkey" PRIMARY KEY ("dict_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 vtdu -- ---------------------------- ALTER TABLE "public"."vtdu" ADD CONSTRAINT "media_code_pkey" PRIMARY KEY ("name"); -- ---------------------------- -- Primary Key structure for table ard_alarm_filter -- ---------------------------- ALTER TABLE "public"."ard_alarm_filter" ADD CONSTRAINT "ard_alarm_filter_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 sys_job -- ---------------------------- ALTER TABLE "public"."sys_job" ADD CONSTRAINT "sys_job_pkey" PRIMARY KEY ("job_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_alarm_digitization3 -- ---------------------------- ALTER TABLE "public"."ard_alarm_digitization3" ADD CONSTRAINT "ard_alarm_digitization3_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_camera_user_postion -- ---------------------------- ALTER TABLE "public"."ard_camera_user_postion" ADD CONSTRAINT "ard_camera_user_postion_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 sys_user -- ---------------------------- ALTER TABLE "public"."sys_user" ADD CONSTRAINT "sys_user_pkey" PRIMARY KEY ("user_id"); -- ---------------------------- -- Primary Key structure for table sys_post -- ---------------------------- ALTER TABLE "public"."sys_post" ADD CONSTRAINT "sys_post_pkey" PRIMARY KEY ("post_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_tiles3d -- ---------------------------- ALTER TABLE "public"."ard_tiles3d" ADD CONSTRAINT "ard_tiles3d_pkey" PRIMARY KEY ("tiles_id"); -- ---------------------------- -- Primary Key structure for table sys_role -- ---------------------------- ALTER TABLE "public"."sys_role" ADD CONSTRAINT "sys_role_pkey" PRIMARY KEY ("role_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 sys_notice -- ---------------------------- ALTER TABLE "public"."sys_notice" ADD CONSTRAINT "sys_notice_pkey" PRIMARY KEY ("notice_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_equip_radar -- ---------------------------- ALTER TABLE "public"."ard_equip_radar" ADD CONSTRAINT "ard_equip_radar_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_camera_no_guide_zone -- ---------------------------- ALTER TABLE "public"."ard_camera_no_guide_zone" ADD CONSTRAINT "ard_camera_no_guide_zone_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- 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_well_guide_camera -- ---------------------------- ALTER TABLE "public"."ard_well_guide_camera" ADD CONSTRAINT "ard_well_guide_camera_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_uwb -- ---------------------------- ALTER TABLE "public"."ard_uwb" ADD CONSTRAINT "ard_uwb_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_oil_wall -- ---------------------------- ALTER TABLE "public"."ard_oil_wall" ADD CONSTRAINT "oil_wall_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_camera_pitch_point -- ---------------------------- ALTER TABLE "public"."ard_camera_pitch_point" ADD CONSTRAINT "pk_ard_camera_pitch_point" 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_apponekey -- ---------------------------- ALTER TABLE "public"."ard_alarm_apponekey" ADD CONSTRAINT "ard_alarm_apponekey_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table tiles3d -- ---------------------------- ALTER TABLE "public"."tiles3d" ADD CONSTRAINT "tiles3d_pkey" PRIMARY KEY ("tiles_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 storage_minio_event -- ---------------------------- ALTER TABLE "public"."storage_minio_event" ADD CONSTRAINT "storage_minio_event_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 ard_wall -- ---------------------------- ALTER TABLE "public"."ard_wall" ADD CONSTRAINT "ard_wall_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_terrain_mark -- ---------------------------- ALTER TABLE "public"."ard_terrain_mark" ADD CONSTRAINT "ard_terrain_mark_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_wall_temporary -- ---------------------------- ALTER TABLE "public"."ard_tank_wall_temporary" ADD CONSTRAINT "ard_tank_wall_temporary_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_wall_lock_temporary -- ---------------------------- ALTER TABLE "public"."ard_tank_wall_lock_temporary" ADD CONSTRAINT "ard_tank_wall_lock_copy_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_wall_lock -- ---------------------------- ALTER TABLE "public"."ard_tank_wall_lock" ADD CONSTRAINT "ard_tank_wall_lock_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_wall -- ---------------------------- ALTER TABLE "public"."ard_tank_wall" ADD CONSTRAINT "ard_tank_wall_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_lock_state -- ---------------------------- ALTER TABLE "public"."ard_tank_lock_state" ADD CONSTRAINT "ard_tank_lock_state_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_lock_process_log -- ---------------------------- ALTER TABLE "public"."ard_tank_lock_process_log" ADD CONSTRAINT "ard_tank_lock_process_log_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_lock_password -- ---------------------------- ALTER TABLE "public"."ard_tank_lock_password" ADD CONSTRAINT "ard_tank_lock_password_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_lock -- ---------------------------- ALTER TABLE "public"."ard_tank_lock" ADD CONSTRAINT "ard_ele_lock_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_tank_abnormal_park_alarm -- ---------------------------- ALTER TABLE "public"."ard_tank_abnormal_park_alarm" ADD CONSTRAINT "ard_tank_abnormal_park_alarm_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_sy_car_rtu -- ---------------------------- ALTER TABLE "public"."ard_sy_car_rtu" ADD CONSTRAINT "ard_sy_car_rtu_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_sy_car_lock -- ---------------------------- ALTER TABLE "public"."ard_sy_car_lock" ADD CONSTRAINT "ard_sy_car_lock_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_rong_group_user -- ---------------------------- ALTER TABLE "public"."ard_rong_group_user" ADD CONSTRAINT "ard_rong_group_user_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_rong_group -- ---------------------------- ALTER TABLE "public"."ard_rong_group" ADD CONSTRAINT "ard_rong_group_pkey" PRIMARY KEY ("group_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_pull_stream -- ---------------------------- ALTER TABLE "public"."ard_pull_stream" ADD CONSTRAINT "ard_pull_stream_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_equip_external -- ---------------------------- ALTER TABLE "public"."ard_equip_external" ADD CONSTRAINT "ard_equip_external_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_eplan -- ---------------------------- ALTER TABLE "public"."ard_eplan" ADD CONSTRAINT "ard_eplan_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_camera_priority -- ---------------------------- ALTER TABLE "public"."ard_camera_priority" ADD CONSTRAINT "ard_cameras_priority_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Uniques structure for table ard_call_unread_messages -- ---------------------------- ALTER TABLE "public"."ard_call_unread_messages" ADD CONSTRAINT "unique" UNIQUE ("user_id", "session_id"); -- ---------------------------- -- Primary Key structure for table ard_call_session_user -- ---------------------------- ALTER TABLE "public"."ard_call_session_user" ADD CONSTRAINT "ard_call_session_user_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_call_session -- ---------------------------- ALTER TABLE "public"."ard_call_session" ADD CONSTRAINT "ard_call_session_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_call_history -- ---------------------------- ALTER TABLE "public"."ard_call_history" ADD CONSTRAINT "ard_call_history_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_call_group_user -- ---------------------------- ALTER TABLE "public"."ard_call_group_user" ADD CONSTRAINT "ard_call_group_user_pkey" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table ard_call_group -- ---------------------------- ALTER TABLE "public"."ard_call_group" ADD CONSTRAINT "ard_call_group_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_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_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_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 -- ---------------------------- ALTER TABLE "public"."ard_app_task" ADD CONSTRAINT "ard_app_task_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_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_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 -- ---------------------------- ALTER TABLE "public"."ard_app_patrolpoint" ADD CONSTRAINT "ard_app_patrolpoint_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_application -- ---------------------------- ALTER TABLE "public"."ard_app_application" ADD CONSTRAINT "ard_app_application_pkey" PRIMARY KEY ("application_id"); -- ---------------------------- -- Primary Key structure for table ard_alarm_wall -- ---------------------------- ALTER TABLE "public"."ard_alarm_wall" ADD CONSTRAINT "ard_alarm_wall_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_external -- ---------------------------- ALTER TABLE "public"."ard_alarm_external" ADD CONSTRAINT "ard_alarm_external_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_access_fence -- ---------------------------- ALTER TABLE "public"."ard_access_fence" ADD CONSTRAINT "ard_access_fence_pkey" PRIMARY KEY ("id");