2821 lines
125 KiB
PL/PgSQL
2821 lines
125 KiB
PL/PgSQL
--
|
||
-- PostgreSQL database dump
|
||
--
|
||
|
||
-- Dumped from database version 17.5 (Homebrew)
|
||
-- Dumped by pg_dump version 17.5 (Homebrew)
|
||
|
||
SET statement_timeout = 0;
|
||
SET lock_timeout = 0;
|
||
SET idle_in_transaction_session_timeout = 0;
|
||
SET transaction_timeout = 0;
|
||
SET client_encoding = 'UTF8';
|
||
SET standard_conforming_strings = on;
|
||
SELECT pg_catalog.set_config('search_path', '', false);
|
||
SET check_function_bodies = false;
|
||
SET xmloption = content;
|
||
SET client_min_messages = warning;
|
||
SET row_security = off;
|
||
-- Name: topology; Type: SCHEMA; Schema: -; Owner:
|
||
CREATE SCHEMA topology;
|
||
|
||
-- Name: SCHEMA topology; Type: COMMENT; Schema: -; Owner:
|
||
COMMENT ON SCHEMA topology IS 'PostGIS Topology schema';
|
||
|
||
-- Name: postgis; Type: EXTENSION; Schema: -; Owner:
|
||
CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;
|
||
|
||
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner:
|
||
COMMENT ON EXTENSION postgis IS 'PostGIS geometry and geography spatial types and functions';
|
||
|
||
-- Name: postgis_topology; Type: EXTENSION; Schema: -; Owner:
|
||
CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology;
|
||
|
||
-- Name: EXTENSION postgis_topology; Type: COMMENT; Schema: -; Owner:
|
||
COMMENT ON EXTENSION postgis_topology IS 'PostGIS topology spatial types and functions';
|
||
|
||
-- Name: find_in_set(bigint, character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.find_in_set(bigint, character varying) RETURNS boolean
|
||
LANGUAGE plpgsql
|
||
AS $_$
|
||
DECLARE
|
||
STR ALIAS FOR $1;
|
||
STRS ALIAS FOR $2;
|
||
POS INTEGER;
|
||
STATUS BOOLEAN;
|
||
BEGIN
|
||
SELECT POSITION( ','||STR||',' IN ','||STRS||',') INTO POS;
|
||
IF POS > 0 THEN
|
||
STATUS = TRUE;
|
||
ELSE
|
||
STATUS = FALSE;
|
||
END IF;
|
||
RETURN STATUS;
|
||
END;
|
||
$_$;
|
||
|
||
-- Name: get_child_types_by_code(character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.get_child_types_by_code(p_parent_code character varying) RETURNS TABLE(type_code character varying, type_name character varying, display_name_cn character varying)
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
RETURN QUERY
|
||
SELECT vt.type_code, vt.type_name, vt.display_name_cn
|
||
FROM sys_vehicle_type vt
|
||
WHERE vt.parent_code = p_parent_code
|
||
AND vt.enabled = true
|
||
ORDER BY vt.sort_order, vt.type_code;
|
||
END;
|
||
$$;
|
||
|
||
-- Name: get_parent_type_by_code(character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.get_parent_type_by_code(type_code character varying) RETURNS character varying
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
DECLARE
|
||
parent_code VARCHAR(30);
|
||
dot_pos INTEGER;
|
||
BEGIN
|
||
-- 找到点的位置
|
||
dot_pos := POSITION('.' IN type_code);
|
||
|
||
IF dot_pos > 0 THEN
|
||
-- 提取父路径编码（点之前的部分）
|
||
parent_code := LEFT(type_code, dot_pos - 1);
|
||
RETURN parent_code;
|
||
ELSE
|
||
-- 一级分类没有父级
|
||
RETURN NULL;
|
||
END IF;
|
||
END;
|
||
$$;
|
||
|
||
-- Name: get_top_level_type(character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.get_top_level_type(type_code character varying) RETURNS character varying
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
DECLARE
|
||
dot_pos INTEGER;
|
||
BEGIN
|
||
-- 找到点的位置
|
||
dot_pos := POSITION('.' IN type_code);
|
||
|
||
IF dot_pos > 0 THEN
|
||
-- 返回点之前的部分（一级分类）
|
||
RETURN LEFT(type_code, dot_pos - 1);
|
||
ELSE
|
||
-- 本身就是一级分类
|
||
RETURN type_code;
|
||
END IF;
|
||
END;
|
||
$$;
|
||
|
||
-- Name: get_type_hierarchy(character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.get_type_hierarchy(target_code character varying) RETURNS TABLE(level_num integer, type_code character varying, display_name_cn character varying)
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
RETURN QUERY
|
||
WITH RECURSIVE type_hierarchy AS (
|
||
-- 基础案例：目标类型
|
||
SELECT
|
||
vt.path_level as level_num,
|
||
vt.type_code,
|
||
vt.display_name_cn,
|
||
vt.parent_code
|
||
FROM sys_vehicle_type_new vt
|
||
WHERE vt.type_code = target_code
|
||
|
||
UNION ALL
|
||
|
||
-- 递归案例：查找父级类型
|
||
SELECT
|
||
vt.path_level as level_num,
|
||
vt.type_code,
|
||
vt.display_name_cn,
|
||
vt.parent_code
|
||
FROM sys_vehicle_type_new vt
|
||
INNER JOIN type_hierarchy th ON vt.type_code = th.parent_code
|
||
)
|
||
SELECT th.level_num, th.type_code, th.display_name_cn
|
||
FROM type_hierarchy th
|
||
ORDER BY th.level_num;
|
||
END;
|
||
$$;
|
||
|
||
-- Name: is_special_vehicle(character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.is_special_vehicle(type_code character varying) RETURNS boolean
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
RETURN get_top_level_type(type_code) = 'SP';
|
||
END;
|
||
$$;
|
||
|
||
-- Name: is_unmanned_vehicle(character varying); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.is_unmanned_vehicle(type_code character varying) RETURNS boolean
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
RETURN get_top_level_type(type_code) = 'UV';
|
||
END;
|
||
$$;
|
||
|
||
-- Name: show_migration_plan(); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.show_migration_plan() RETURNS TABLE(vehicle_id bigint, license_plate character varying, old_type_id bigint, old_type_name character varying, new_type_code character varying, new_type_id bigint, new_display_name character varying)
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
RETURN QUERY
|
||
SELECT
|
||
vi.vehicle_id,
|
||
vi.license_plate,
|
||
vi.type_id as old_type_id,
|
||
vt_old.type_name as old_type_name,
|
||
vm.new_type_code,
|
||
vtn.id as new_type_id,
|
||
vtn.display_name_cn as new_display_name
|
||
FROM sys_vehicle_info vi
|
||
LEFT JOIN sys_vehicle_type vt_old ON vi.type_id = vt_old.type_id
|
||
LEFT JOIN vehicle_type_migration_mapping vm ON vi.type_id = vm.old_type_id
|
||
LEFT JOIN sys_vehicle_type_new vtn ON vm.new_type_code = vtn.type_code
|
||
ORDER BY vi.vehicle_id;
|
||
END;
|
||
$$;
|
||
|
||
-- Name: substring_index(character varying, character varying, integer); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.substring_index(character varying, character varying, integer) RETURNS character varying
|
||
LANGUAGE plpgsql IMMUTABLE STRICT
|
||
AS $_$
|
||
DECLARE
|
||
tokens varchar[];
|
||
length integer ;
|
||
indexnum integer;
|
||
BEGIN
|
||
tokens := pg_catalog.string_to_array($1, $2);
|
||
length := pg_catalog.array_upper(tokens, 1);
|
||
indexnum := length - ($3 * -1) + 1;
|
||
IF $3 >= 0 THEN
|
||
RETURN pg_catalog.array_to_string(tokens[1:$3], $2);
|
||
ELSE
|
||
RETURN pg_catalog.array_to_string(tokens[indexnum:length], $2);
|
||
END IF;
|
||
END;
|
||
$_$;
|
||
|
||
-- Name: update_sys_vehicle_id(); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.update_sys_vehicle_id() RETURNS void
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
-- 更新vehicle_locations表
|
||
UPDATE vehicle_locations vl
|
||
SET sys_vehicle_id = vi.vehicle_id
|
||
FROM sys_vehicle_info vi
|
||
WHERE vl.license_plate = vi.license_plate_number
|
||
AND vl.sys_vehicle_id IS NULL;
|
||
|
||
-- 更新vehicle_trajectories表
|
||
UPDATE vehicle_trajectories vt
|
||
SET sys_vehicle_id = vi.vehicle_id
|
||
FROM sys_vehicle_info vi
|
||
WHERE vt.license_plate = vi.license_plate_number
|
||
AND vt.sys_vehicle_id IS NULL;
|
||
|
||
-- 更新vehicle_commands表
|
||
UPDATE vehicle_commands vc
|
||
SET sys_vehicle_id = vi.vehicle_id
|
||
FROM sys_vehicle_info vi
|
||
WHERE vc.license_plate = vi.license_plate_number
|
||
AND vc.sys_vehicle_id IS NULL;
|
||
|
||
-- 更新rule_violation_events表
|
||
UPDATE rule_violation_events rve
|
||
SET sys_vehicle_id = vi.vehicle_id
|
||
FROM sys_vehicle_info vi
|
||
WHERE rve.license_plate = vi.license_plate_number
|
||
AND rve.sys_vehicle_id IS NULL
|
||
AND rve.subject_type = 'VEHICLE';
|
||
|
||
RAISE NOTICE '车辆ID同步完成（包含vehicle_commands表）';
|
||
END;
|
||
$$;
|
||
|
||
-- Name: update_timestamp_column(); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.update_timestamp_column() RETURNS trigger
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
NEW.updated_at = CURRENT_TIMESTAMP;
|
||
RETURN NEW;
|
||
END;
|
||
$$;
|
||
|
||
-- Name: update_updated_at_column(); Type: FUNCTION; Schema: public; Owner:
|
||
CREATE FUNCTION public.update_updated_at_column() RETURNS trigger
|
||
LANGUAGE plpgsql
|
||
AS $$
|
||
BEGIN
|
||
NEW.updated_at = CURRENT_TIMESTAMP;
|
||
RETURN NEW;
|
||
END;
|
||
$$;
|
||
|
||
|
||
SET default_tablespace = '';
|
||
|
||
SET default_table_access_method = heap;
|
||
-- Name: airport_areas; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.airport_areas (
|
||
id bigint NOT NULL,
|
||
area_id character varying(50) NOT NULL,
|
||
name character varying(100) NOT NULL,
|
||
type character varying(30) NOT NULL,
|
||
boundary public.geometry(Polygon,4326) NOT NULL,
|
||
description character varying(500),
|
||
active_time timestamp with time zone,
|
||
expiry_time timestamp with time zone,
|
||
enabled boolean DEFAULT true,
|
||
priority integer DEFAULT 1,
|
||
area_sqm double precision,
|
||
functional_category character varying(50),
|
||
parent_area_id character varying(50),
|
||
created_at timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
|
||
updated_at timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
|
||
version bigint DEFAULT 0
|
||
);
|
||
|
||
-- Name: TABLE airport_areas; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.airport_areas IS '机场区域信息表 - 支持电子围栏功能';
|
||
|
||
-- Name: COLUMN airport_areas.id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.id IS '主键ID';
|
||
|
||
-- Name: COLUMN airport_areas.area_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.area_id IS '区域标识符';
|
||
|
||
-- Name: COLUMN airport_areas.name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.name IS '区域名称';
|
||
|
||
-- Name: COLUMN airport_areas.type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.type IS '区域类型（RUNWAY、TAXIWAY、APRON等）';
|
||
|
||
-- Name: COLUMN airport_areas.boundary; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.boundary IS '区域几何边界（PostGIS多边形）';
|
||
|
||
-- Name: COLUMN airport_areas.description; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.description IS '区域描述';
|
||
|
||
-- Name: COLUMN airport_areas.active_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.active_time IS '生效时间（用于临时区域）';
|
||
|
||
-- Name: COLUMN airport_areas.expiry_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.expiry_time IS '失效时间（用于临时区域）';
|
||
|
||
-- Name: COLUMN airport_areas.enabled; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.enabled IS '是否启用';
|
||
|
||
-- Name: COLUMN airport_areas.priority; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.priority IS '优先级（数值越高优先级越高）';
|
||
|
||
-- Name: COLUMN airport_areas.area_sqm; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.area_sqm IS '区域面积（平方米）';
|
||
|
||
-- Name: COLUMN airport_areas.functional_category; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.functional_category IS '功能分类';
|
||
|
||
-- Name: COLUMN airport_areas.parent_area_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.parent_area_id IS '父区域ID';
|
||
|
||
-- Name: COLUMN airport_areas.version; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.airport_areas.version IS '数据版本号（用于乐观锁）';
|
||
|
||
-- Name: airport_areas_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.airport_areas_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: airport_areas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.airport_areas_id_seq OWNED BY public.airport_areas.id;
|
||
|
||
-- Name: conflict_alert_logs; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.conflict_alert_logs (
|
||
id bigint NOT NULL,
|
||
alert_type character varying(20) NOT NULL,
|
||
alert_level character varying(20) NOT NULL,
|
||
alert_message text NOT NULL,
|
||
object1_distance double precision,
|
||
object2_distance double precision,
|
||
minimum_distance double precision,
|
||
alert_time timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
|
||
CONSTRAINT conflict_alert_logs_alert_level_check CHECK (((alert_level)::text = ANY ((ARRAY['WARNING'::character varying, 'CRITICAL'::character varying, 'EMERGENCY'::character varying])::text[]))),
|
||
CONSTRAINT conflict_alert_logs_alert_type_check CHECK (((alert_type)::text = ANY ((ARRAY['CONFLICT_WARNING'::character varying, 'CONFLICT_ALERT'::character varying])::text[])))
|
||
);
|
||
|
||
-- Name: TABLE conflict_alert_logs; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.conflict_alert_logs IS '冲突预警告警记录表 - 记录发送的所有预警和告警消息';
|
||
|
||
-- Name: conflict_alert_logs_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.conflict_alert_logs_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: conflict_alert_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.conflict_alert_logs_id_seq OWNED BY public.conflict_alert_logs.id;
|
||
|
||
-- Name: flyway_schema_history; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.flyway_schema_history (
|
||
installed_rank integer NOT NULL,
|
||
version character varying(50),
|
||
description character varying(200) NOT NULL,
|
||
type character varying(20) NOT NULL,
|
||
script character varying(1000) NOT NULL,
|
||
checksum integer,
|
||
installed_by character varying(100) NOT NULL,
|
||
installed_on timestamp without time zone DEFAULT now() NOT NULL,
|
||
execution_time integer NOT NULL,
|
||
success boolean NOT NULL
|
||
);
|
||
|
||
-- Name: gen_table; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.gen_table (
|
||
table_id bigint NOT NULL,
|
||
table_name character varying(200),
|
||
table_comment character varying(500),
|
||
sub_table_name character varying(64),
|
||
sub_table_fk_name character varying(64),
|
||
class_name character varying(100),
|
||
tpl_category character varying(200),
|
||
tpl_web_type character varying(30),
|
||
package_name character varying(100),
|
||
module_name character varying(30),
|
||
business_name character varying(30),
|
||
function_name character varying(50),
|
||
function_author character varying(50),
|
||
gen_type character(1),
|
||
gen_path character varying(200),
|
||
options character varying(1000),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE gen_table; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.gen_table IS '代码生成业务表';
|
||
|
||
-- Name: COLUMN gen_table.table_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.table_id IS '编号';
|
||
|
||
-- Name: COLUMN gen_table.table_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.table_name IS '表名称';
|
||
|
||
-- Name: COLUMN gen_table.table_comment; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.table_comment IS '表描述';
|
||
|
||
-- Name: COLUMN gen_table.sub_table_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.sub_table_name IS '关联子表的表名';
|
||
|
||
-- Name: COLUMN gen_table.sub_table_fk_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.sub_table_fk_name IS '子表关联的外键名';
|
||
|
||
-- Name: COLUMN gen_table.class_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.class_name IS '实体类名称';
|
||
|
||
-- Name: COLUMN gen_table.tpl_category; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.tpl_category IS '使用的模板（crud单表操作 tree树表操作）';
|
||
|
||
-- Name: COLUMN gen_table.tpl_web_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.tpl_web_type IS '前端模板类型（element-ui模版 element-plus模版）';
|
||
|
||
-- Name: COLUMN gen_table.package_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.package_name IS '生成包路径';
|
||
|
||
-- Name: COLUMN gen_table.module_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.module_name IS '生成模块名';
|
||
|
||
-- Name: COLUMN gen_table.business_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.business_name IS '生成业务名';
|
||
|
||
-- Name: COLUMN gen_table.function_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.function_name IS '生成功能名';
|
||
|
||
-- Name: COLUMN gen_table.function_author; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.function_author IS '生成功能作者';
|
||
|
||
-- Name: COLUMN gen_table.gen_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.gen_type IS '生成代码方式（0zip压缩包 1自定义路径）';
|
||
|
||
-- Name: COLUMN gen_table.gen_path; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.gen_path IS '生成路径（不填默认项目路径）';
|
||
|
||
-- Name: COLUMN gen_table.options; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.options IS '其它生成选项';
|
||
|
||
-- Name: COLUMN gen_table.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN gen_table.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN gen_table.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN gen_table.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN gen_table.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table.remark IS '备注';
|
||
|
||
-- Name: gen_table_column; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.gen_table_column (
|
||
column_id bigint NOT NULL,
|
||
table_id character varying(64),
|
||
column_name character varying(200),
|
||
column_comment character varying(500),
|
||
column_type character varying(100),
|
||
java_type character varying(500),
|
||
java_field character varying(200),
|
||
is_pk character(1),
|
||
is_increment character(1),
|
||
is_required character(1),
|
||
is_insert character(1),
|
||
is_edit character(1),
|
||
is_list character(1),
|
||
is_query character(1),
|
||
query_type character varying(200),
|
||
html_type character varying(200),
|
||
dict_type character varying(200) DEFAULT ''::character varying,
|
||
sort integer,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone
|
||
);
|
||
|
||
-- Name: TABLE gen_table_column; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.gen_table_column IS '代码生成业务表字段';
|
||
|
||
-- Name: COLUMN gen_table_column.column_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.column_id IS '编号';
|
||
|
||
-- Name: COLUMN gen_table_column.table_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.table_id IS '归属表编号';
|
||
|
||
-- Name: COLUMN gen_table_column.column_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.column_name IS '列名称';
|
||
|
||
-- Name: COLUMN gen_table_column.column_comment; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.column_comment IS '列描述';
|
||
|
||
-- Name: COLUMN gen_table_column.column_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.column_type IS '列类型';
|
||
|
||
-- Name: COLUMN gen_table_column.java_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.java_type IS 'JAVA类型';
|
||
|
||
-- Name: COLUMN gen_table_column.java_field; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.java_field IS 'JAVA字段名';
|
||
|
||
-- Name: COLUMN gen_table_column.is_pk; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_pk IS '是否主键（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.is_increment; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_increment IS '是否自增（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.is_required; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_required IS '是否必填（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.is_insert; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_insert IS '是否为插入字段（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.is_edit; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_edit IS '是否编辑字段（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.is_list; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_list IS '是否列表字段（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.is_query; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.is_query IS '是否查询字段（1是）';
|
||
|
||
-- Name: COLUMN gen_table_column.query_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.query_type IS '查询方式（等于、不等于、大于、小于、范围）';
|
||
|
||
-- Name: COLUMN gen_table_column.html_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.html_type IS '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';
|
||
|
||
-- Name: COLUMN gen_table_column.dict_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.dict_type IS '字典类型';
|
||
|
||
-- Name: COLUMN gen_table_column.sort; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.sort IS '排序';
|
||
|
||
-- Name: COLUMN gen_table_column.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN gen_table_column.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN gen_table_column.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN gen_table_column.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.gen_table_column.update_time IS '更新时间';
|
||
|
||
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.gen_table_column_column_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.gen_table_column_column_id_seq OWNED BY public.gen_table_column.column_id;
|
||
|
||
-- Name: gen_table_table_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.gen_table_table_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: gen_table_table_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.gen_table_table_id_seq OWNED BY public.gen_table.table_id;
|
||
|
||
-- Name: geofence_events; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.geofence_events (
|
||
id bigint NOT NULL,
|
||
alert_level character varying(20) NOT NULL,
|
||
created_at timestamp(6) with time zone NOT NULL,
|
||
event_attributes jsonb,
|
||
event_id character varying(50) NOT NULL,
|
||
event_location public.geometry(Point,4326) NOT NULL,
|
||
event_message character varying(500),
|
||
event_time timestamp(6) with time zone NOT NULL,
|
||
event_type character varying(20) NOT NULL,
|
||
fence_id character varying(50) NOT NULL,
|
||
license_plate character varying(50) NOT NULL,
|
||
processed boolean NOT NULL,
|
||
processed_at timestamp(6) with time zone,
|
||
processed_by character varying(100),
|
||
response_action character varying(30),
|
||
response_result character varying(100),
|
||
response_sent boolean NOT NULL,
|
||
response_time timestamp(6) with time zone,
|
||
rule_id character varying(50),
|
||
vehicle_heading double precision,
|
||
vehicle_id bigint NOT NULL,
|
||
vehicle_speed double precision,
|
||
CONSTRAINT geofence_events_alert_level_check CHECK (((alert_level)::text = ANY ((ARRAY['INFO'::character varying, 'WARNING'::character varying, 'CRITICAL'::character varying, 'EMERGENCY'::character varying])::text[]))),
|
||
CONSTRAINT geofence_events_event_type_check CHECK (((event_type)::text = ANY ((ARRAY['ENTER'::character varying, 'EXIT'::character varying, 'VIOLATION'::character varying, 'DWELL_ALERT'::character varying, 'SPEED_ALERT'::character varying])::text[])))
|
||
);
|
||
|
||
-- Name: geofence_events_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
ALTER TABLE public.geofence_events ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
|
||
SEQUENCE NAME public.geofence_events_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1
|
||
);
|
||
|
||
-- Name: list_column; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.list_column AS
|
||
SELECT c.relname AS table_name,
|
||
a.attname AS column_name,
|
||
d.description AS column_comment,
|
||
CASE
|
||
WHEN (a.attnotnull AND (con.conname IS NULL)) THEN 1
|
||
ELSE 0
|
||
END AS is_required,
|
||
CASE
|
||
WHEN (con.conname IS NOT NULL) THEN 1
|
||
ELSE 0
|
||
END AS is_pk,
|
||
a.attnum AS sort,
|
||
CASE
|
||
WHEN ("position"(pg_get_expr(ad.adbin, ad.adrelid), ((((c.relname)::text || '_'::text) || (a.attname)::text) || '_seq'::text)) > 0) THEN 1
|
||
ELSE 0
|
||
END AS is_increment,
|
||
btrim(
|
||
CASE
|
||
WHEN ((t.typelem <> (0)::oid) AND (t.typlen = '-1'::integer)) THEN 'ARRAY'::text
|
||
ELSE
|
||
CASE
|
||
WHEN (t.typtype = 'd'::"char") THEN format_type(t.typbasetype, NULL::integer)
|
||
ELSE format_type(a.atttypid, NULL::integer)
|
||
END
|
||
END, '"'::text) AS column_type
|
||
FROM (((((pg_attribute a
|
||
JOIN (pg_class c
|
||
JOIN pg_namespace n ON ((c.relnamespace = n.oid))) ON ((a.attrelid = c.oid)))
|
||
LEFT JOIN pg_description d ON (((d.objoid = c.oid) AND (a.attnum = d.objsubid))))
|
||
LEFT JOIN pg_constraint con ON (((con.conrelid = c.oid) AND (a.attnum = ANY (con.conkey)))))
|
||
LEFT JOIN pg_attrdef ad ON (((a.attrelid = ad.adrelid) AND (a.attnum = ad.adnum))))
|
||
LEFT JOIN pg_type t ON ((a.atttypid = t.oid)))
|
||
WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (a.attnum > 0) AND (n.nspname = 'public'::name) AND (NOT a.attisdropped))
|
||
ORDER BY c.relname, a.attnum;
|
||
|
||
-- Name: list_table; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.list_table AS
|
||
SELECT c.relname AS table_name,
|
||
obj_description(c.oid) AS table_comment,
|
||
CURRENT_TIMESTAMP AS create_time,
|
||
CURRENT_TIMESTAMP AS update_time
|
||
FROM (pg_class c
|
||
LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))
|
||
WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (c.relname !~~ 'spatial_%'::text) AND (n.nspname = 'public'::name) AND (n.nspname <> ''::name));
|
||
|
||
-- Name: object_route_assignments; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.object_route_assignments (
|
||
id bigint NOT NULL,
|
||
object_type character varying(20) NOT NULL,
|
||
object_name character varying(100) NOT NULL,
|
||
assigned_route_id bigint NOT NULL,
|
||
assigned_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
|
||
CONSTRAINT object_route_assignments_object_type_check CHECK (((object_type)::text = ANY ((ARRAY['UNMANNED_VEHICLE'::character varying, 'AIRCRAFT'::character varying, 'SPECIAL_VEHICLE'::character varying, 'NORMAL_VEHICLE'::character varying])::text[])))
|
||
);
|
||
|
||
-- Name: TABLE object_route_assignments; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.object_route_assignments IS '实时对象路径分配表 - 跟踪对象当前使用的路径';
|
||
|
||
-- Name: object_route_assignments_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.object_route_assignments_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: object_route_assignments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.object_route_assignments_id_seq OWNED BY public.object_route_assignments.id;
|
||
|
||
-- Name: qrtz_blob_triggers; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_blob_triggers (
|
||
sched_name character varying(120) NOT NULL,
|
||
trigger_name character varying(200) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL,
|
||
blob_data bytea
|
||
);
|
||
|
||
-- Name: qrtz_calendars; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_calendars (
|
||
sched_name character varying(120) NOT NULL,
|
||
calendar_name character varying(200) NOT NULL,
|
||
calendar bytea NOT NULL
|
||
);
|
||
|
||
-- Name: qrtz_cron_triggers; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_cron_triggers (
|
||
sched_name character varying(120) NOT NULL,
|
||
trigger_name character varying(200) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL,
|
||
cron_expression character varying(200) NOT NULL,
|
||
time_zone_id character varying(80)
|
||
);
|
||
|
||
-- Name: qrtz_fired_triggers; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_fired_triggers (
|
||
sched_name character varying(120) NOT NULL,
|
||
entry_id character varying(95) NOT NULL,
|
||
trigger_name character varying(200) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL,
|
||
instance_name character varying(200) NOT NULL,
|
||
fired_time bigint NOT NULL,
|
||
sched_time bigint NOT NULL,
|
||
priority integer NOT NULL,
|
||
state character varying(16) NOT NULL,
|
||
job_name character varying(200),
|
||
job_group character varying(200),
|
||
is_nonconcurrent character varying(20),
|
||
requests_recovery character varying(20)
|
||
);
|
||
|
||
-- Name: qrtz_job_details; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_job_details (
|
||
sched_name character varying(120) NOT NULL,
|
||
job_name character varying(200) NOT NULL,
|
||
job_group character varying(200) NOT NULL,
|
||
description character varying(250),
|
||
job_class_name character varying(250) NOT NULL,
|
||
is_durable character varying(50) NOT NULL,
|
||
is_nonconcurrent character varying(50) NOT NULL,
|
||
is_update_data character varying(50) NOT NULL,
|
||
requests_recovery character varying(50) NOT NULL,
|
||
job_data bytea
|
||
);
|
||
|
||
-- Name: qrtz_locks; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_locks (
|
||
sched_name character varying(120) NOT NULL,
|
||
lock_name character varying(40) NOT NULL
|
||
);
|
||
|
||
-- Name: qrtz_paused_trigger_grps; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_paused_trigger_grps (
|
||
sched_name character varying(120) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL
|
||
);
|
||
|
||
-- Name: qrtz_scheduler_state; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_scheduler_state (
|
||
sched_name character varying(120) NOT NULL,
|
||
instance_name character varying(200) NOT NULL,
|
||
last_checkin_time bigint NOT NULL,
|
||
checkin_interval bigint NOT NULL
|
||
);
|
||
|
||
-- Name: qrtz_simple_triggers; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_simple_triggers (
|
||
sched_name character varying(120) NOT NULL,
|
||
trigger_name character varying(200) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL,
|
||
repeat_count bigint NOT NULL,
|
||
repeat_interval bigint NOT NULL,
|
||
times_triggered bigint NOT NULL
|
||
);
|
||
|
||
-- Name: qrtz_simprop_triggers; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_simprop_triggers (
|
||
sched_name character varying(120) NOT NULL,
|
||
trigger_name character varying(200) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL,
|
||
str_prop_1 character varying(512),
|
||
str_prop_2 character varying(512),
|
||
str_prop_3 character varying(512),
|
||
int_prop_1 integer,
|
||
int_prop_2 integer,
|
||
long_prop_1 bigint,
|
||
long_prop_2 bigint,
|
||
dec_prop_1 numeric(13,4),
|
||
dec_prop_2 numeric(13,4),
|
||
bool_prop_1 character varying(2),
|
||
bool_prop_2 character varying(2)
|
||
);
|
||
|
||
-- Name: qrtz_triggers; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.qrtz_triggers (
|
||
sched_name character varying(120) NOT NULL,
|
||
trigger_name character varying(200) NOT NULL,
|
||
trigger_group character varying(200) NOT NULL,
|
||
job_name character varying(200) NOT NULL,
|
||
job_group character varying(200) NOT NULL,
|
||
description character varying(250),
|
||
next_fire_time bigint,
|
||
prev_fire_time bigint,
|
||
priority integer,
|
||
trigger_state character varying(16) NOT NULL,
|
||
trigger_type character varying(8) NOT NULL,
|
||
start_time bigint NOT NULL,
|
||
end_time bigint,
|
||
calendar_name character varying(200),
|
||
misfire_instr smallint,
|
||
job_data bytea
|
||
);
|
||
|
||
-- Name: spatial_rule_vehicle_types; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.spatial_rule_vehicle_types (
|
||
rule_id character varying(50) NOT NULL,
|
||
vehicle_type character varying(30) NOT NULL
|
||
);
|
||
|
||
-- Name: TABLE spatial_rule_vehicle_types; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.spatial_rule_vehicle_types IS '空间规则允许的车辆类型表';
|
||
|
||
-- Name: spatial_rules; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.spatial_rules (
|
||
rule_id character varying(50) NOT NULL,
|
||
rule_name character varying(200) NOT NULL,
|
||
description text,
|
||
rule_category character varying(50) NOT NULL,
|
||
status character varying(20) NOT NULL,
|
||
priority integer NOT NULL,
|
||
spatial_object_type character varying(30) NOT NULL,
|
||
spatial_object_id character varying(50),
|
||
rule_parameters jsonb,
|
||
alert_level character varying(20) NOT NULL,
|
||
alert_message character varying(500),
|
||
effective_start_time timestamp(6) without time zone,
|
||
effective_end_time timestamp(6) without time zone,
|
||
daily_start_time time without time zone,
|
||
daily_end_time time without time zone,
|
||
weekday_pattern integer,
|
||
time_patterns jsonb,
|
||
created_at timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
updated_at timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
created_by character varying(100),
|
||
updated_by character varying(100),
|
||
version bigint DEFAULT 0,
|
||
custom_geometry public.geometry
|
||
);
|
||
|
||
-- Name: TABLE spatial_rules; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.spatial_rules IS '空间安全规则表';
|
||
|
||
-- Name: speed_limit_areas; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.speed_limit_areas AS
|
||
SELECT aa.area_id,
|
||
aa.name AS area_name,
|
||
aa.type AS area_type,
|
||
aa.boundary,
|
||
sr.rule_id,
|
||
sr.rule_name,
|
||
((sr.rule_parameters ->> 'maxSpeed'::text))::double precision AS max_speed_kmh,
|
||
((sr.rule_parameters ->> 'warningThreshold'::text))::double precision AS warning_threshold,
|
||
sr.alert_level,
|
||
array_agg(DISTINCT vt.vehicle_type) AS applicable_vehicle_types
|
||
FROM ((public.airport_areas aa
|
||
JOIN public.spatial_rules sr ON (((aa.area_id)::text = (sr.spatial_object_id)::text)))
|
||
JOIN public.spatial_rule_vehicle_types vt ON (((sr.rule_id)::text = (vt.rule_id)::text)))
|
||
WHERE (((sr.rule_category)::text = 'SPEED_LIMIT'::text) AND ((sr.status)::text = 'ACTIVE'::text) AND (aa.enabled = true))
|
||
GROUP BY aa.area_id, aa.name, aa.type, aa.boundary, sr.rule_id, sr.rule_name, sr.rule_parameters, sr.alert_level;
|
||
|
||
-- Name: sys_config; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_config (
|
||
config_id bigint NOT NULL,
|
||
config_name character varying(100),
|
||
config_key character varying(100),
|
||
config_value character varying(500),
|
||
config_type character(1),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_config; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_config IS '参数配置表';
|
||
|
||
-- Name: COLUMN sys_config.config_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.config_id IS '参数主键';
|
||
|
||
-- Name: COLUMN sys_config.config_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.config_name IS '参数名称';
|
||
|
||
-- Name: COLUMN sys_config.config_key; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.config_key IS '参数键名';
|
||
|
||
-- Name: COLUMN sys_config.config_value; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.config_value IS '参数键值';
|
||
|
||
-- Name: COLUMN sys_config.config_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.config_type IS '系统内置（Y是 N否）';
|
||
|
||
-- Name: COLUMN sys_config.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_config.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_config.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_config.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_config.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_config.remark IS '备注';
|
||
|
||
-- Name: sys_config_config_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_config_config_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_config_config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_config_config_id_seq OWNED BY public.sys_config.config_id;
|
||
|
||
-- Name: sys_dept; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_dept (
|
||
dept_id bigint NOT NULL,
|
||
parent_id bigint DEFAULT 0,
|
||
ancestors character varying(50),
|
||
dept_name character varying(30),
|
||
order_num integer,
|
||
leader character varying(20),
|
||
phone character varying(11),
|
||
email character varying(50),
|
||
status character(1),
|
||
del_flag character(1) DEFAULT 0,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone
|
||
);
|
||
|
||
-- Name: TABLE sys_dept; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_dept IS '部门表';
|
||
|
||
-- Name: COLUMN sys_dept.dept_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.dept_id IS '部门id';
|
||
|
||
-- Name: COLUMN sys_dept.parent_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.parent_id IS '父部门id';
|
||
|
||
-- Name: COLUMN sys_dept.ancestors; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.ancestors IS '祖级列表';
|
||
|
||
-- Name: COLUMN sys_dept.dept_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.dept_name IS '部门名称';
|
||
|
||
-- Name: COLUMN sys_dept.order_num; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.order_num IS '显示顺序';
|
||
|
||
-- Name: COLUMN sys_dept.leader; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.leader IS '负责人';
|
||
|
||
-- Name: COLUMN sys_dept.phone; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.phone IS '联系电话';
|
||
|
||
-- Name: COLUMN sys_dept.email; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.email IS '邮箱';
|
||
|
||
-- Name: COLUMN sys_dept.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.status IS '部门状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_dept.del_flag; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.del_flag IS '删除标志（0代表存在 2代表删除）';
|
||
|
||
-- Name: COLUMN sys_dept.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_dept.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_dept.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_dept.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dept.update_time IS '更新时间';
|
||
|
||
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_dept_dept_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_dept_dept_id_seq OWNED BY public.sys_dept.dept_id;
|
||
|
||
-- Name: sys_dict_data; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_dict_data (
|
||
dict_code bigint NOT NULL,
|
||
dict_sort integer,
|
||
dict_label character varying(100),
|
||
dict_value character varying(100),
|
||
dict_type character varying(100),
|
||
css_class character varying(100),
|
||
list_class character varying(100),
|
||
is_default character(1),
|
||
status character(1),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_dict_data; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_dict_data IS '字典数据表';
|
||
|
||
-- Name: COLUMN sys_dict_data.dict_code; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.dict_code IS '字典编码';
|
||
|
||
-- Name: COLUMN sys_dict_data.dict_sort; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.dict_sort IS '字典排序';
|
||
|
||
-- Name: COLUMN sys_dict_data.dict_label; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.dict_label IS '字典标签';
|
||
|
||
-- Name: COLUMN sys_dict_data.dict_value; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.dict_value IS '字典键值';
|
||
|
||
-- Name: COLUMN sys_dict_data.dict_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.dict_type IS '字典类型';
|
||
|
||
-- Name: COLUMN sys_dict_data.css_class; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.css_class IS '样式属性（其他样式扩展）';
|
||
|
||
-- Name: COLUMN sys_dict_data.list_class; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.list_class IS '表格回显样式';
|
||
|
||
-- Name: COLUMN sys_dict_data.is_default; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.is_default IS '是否默认（Y是 N否）';
|
||
|
||
-- Name: COLUMN sys_dict_data.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.status IS '状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_dict_data.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_dict_data.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_dict_data.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_dict_data.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_dict_data.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_data.remark IS '备注';
|
||
|
||
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_dict_data_dict_code_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_dict_data_dict_code_seq OWNED BY public.sys_dict_data.dict_code;
|
||
|
||
-- Name: sys_dict_type; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_dict_type (
|
||
dict_id bigint NOT NULL,
|
||
dict_name character varying(100),
|
||
dict_type character varying(100),
|
||
status character(1),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_dict_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_dict_type IS '字典类型表';
|
||
|
||
-- Name: COLUMN sys_dict_type.dict_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.dict_id IS '字典主键';
|
||
|
||
-- Name: COLUMN sys_dict_type.dict_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.dict_name IS '字典名称';
|
||
|
||
-- Name: COLUMN sys_dict_type.dict_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.dict_type IS '字典类型';
|
||
|
||
-- Name: COLUMN sys_dict_type.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.status IS '状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_dict_type.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_dict_type.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_dict_type.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_dict_type.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_dict_type.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_dict_type.remark IS '备注';
|
||
|
||
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_dict_type_dict_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_dict_type_dict_id_seq OWNED BY public.sys_dict_type.dict_id;
|
||
|
||
-- Name: sys_driver_info; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_driver_info (
|
||
user_id bigint NOT NULL,
|
||
license_type character varying(50) NOT NULL,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_driver_info; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_driver_info IS '驾驶员信息表';
|
||
|
||
-- Name: COLUMN sys_driver_info.user_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.user_id IS '用户ID';
|
||
|
||
-- Name: COLUMN sys_driver_info.license_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.license_type IS '驾驶证类型';
|
||
|
||
-- Name: COLUMN sys_driver_info.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_driver_info.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_driver_info.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_driver_info.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_driver_info.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_driver_info.remark IS '备注';
|
||
|
||
-- Name: sys_job; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_job (
|
||
job_id bigint NOT NULL,
|
||
job_name character varying(64) NOT NULL,
|
||
job_group character varying(64) NOT NULL,
|
||
invoke_target character varying(500) NOT NULL,
|
||
cron_expression character varying(255),
|
||
misfire_policy character varying(20),
|
||
concurrent character(1),
|
||
status character(1),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_job; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_job IS '定时任务调度表';
|
||
|
||
-- Name: COLUMN sys_job.job_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.job_id IS '任务ID';
|
||
|
||
-- Name: COLUMN sys_job.job_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.job_name IS '任务名称';
|
||
|
||
-- Name: COLUMN sys_job.job_group; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.job_group IS '任务组名';
|
||
|
||
-- Name: COLUMN sys_job.invoke_target; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.invoke_target IS '调用目标字符串';
|
||
|
||
-- Name: COLUMN sys_job.cron_expression; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.cron_expression IS 'cron执行表达式';
|
||
|
||
-- Name: COLUMN sys_job.misfire_policy; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.misfire_policy IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';
|
||
|
||
-- Name: COLUMN sys_job.concurrent; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.concurrent IS '是否并发执行（0允许 1禁止）';
|
||
|
||
-- Name: COLUMN sys_job.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.status IS '状态（0正常 1暂停）';
|
||
|
||
-- Name: COLUMN sys_job.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_job.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_job.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_job.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_job.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job.remark IS '备注信息';
|
||
|
||
-- Name: sys_job_job_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_job_job_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_job_job_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_job_job_id_seq OWNED BY public.sys_job.job_id;
|
||
|
||
-- Name: sys_job_log; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_job_log (
|
||
job_log_id bigint NOT NULL,
|
||
job_name character varying(64) NOT NULL,
|
||
job_group character varying(64) NOT NULL,
|
||
invoke_target character varying(500) NOT NULL,
|
||
job_message character varying(500),
|
||
status character(1),
|
||
exception_info character varying(2000),
|
||
create_time timestamp(6) without time zone
|
||
);
|
||
|
||
-- Name: TABLE sys_job_log; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_job_log IS '定时任务调度日志表';
|
||
|
||
-- Name: COLUMN sys_job_log.job_log_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.job_log_id IS '任务日志ID';
|
||
|
||
-- Name: COLUMN sys_job_log.job_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.job_name IS '任务名称';
|
||
|
||
-- Name: COLUMN sys_job_log.job_group; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.job_group IS '任务组名';
|
||
|
||
-- Name: COLUMN sys_job_log.invoke_target; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.invoke_target IS '调用目标字符串';
|
||
|
||
-- Name: COLUMN sys_job_log.job_message; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.job_message IS '日志信息';
|
||
|
||
-- Name: COLUMN sys_job_log.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.status IS '执行状态（0正常 1失败）';
|
||
|
||
-- Name: COLUMN sys_job_log.exception_info; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.exception_info IS '异常信息';
|
||
|
||
-- Name: COLUMN sys_job_log.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_job_log.create_time IS '创建时间';
|
||
|
||
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_job_log_job_log_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_job_log_job_log_id_seq OWNED BY public.sys_job_log.job_log_id;
|
||
|
||
-- Name: sys_logininfor; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_logininfor (
|
||
info_id bigint NOT NULL,
|
||
user_name character varying(50),
|
||
ipaddr character varying(128),
|
||
login_location character varying(255),
|
||
browser character varying(50),
|
||
os character varying(50),
|
||
status character(1),
|
||
msg character varying(255),
|
||
login_time timestamp(6) without time zone
|
||
);
|
||
|
||
-- Name: TABLE sys_logininfor; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_logininfor IS '系统访问记录';
|
||
|
||
-- Name: COLUMN sys_logininfor.info_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.info_id IS '访问ID';
|
||
|
||
-- Name: COLUMN sys_logininfor.user_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.user_name IS '用户账号';
|
||
|
||
-- Name: COLUMN sys_logininfor.ipaddr; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.ipaddr IS '登录IP地址';
|
||
|
||
-- Name: COLUMN sys_logininfor.login_location; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.login_location IS '登录地点';
|
||
|
||
-- Name: COLUMN sys_logininfor.browser; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.browser IS '浏览器类型';
|
||
|
||
-- Name: COLUMN sys_logininfor.os; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.os IS '操作系统';
|
||
|
||
-- Name: COLUMN sys_logininfor.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.status IS '登录状态（0成功 1失败）';
|
||
|
||
-- Name: COLUMN sys_logininfor.msg; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.msg IS '提示消息';
|
||
|
||
-- Name: COLUMN sys_logininfor.login_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_logininfor.login_time IS '访问时间';
|
||
|
||
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_logininfor_info_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_logininfor_info_id_seq OWNED BY public.sys_logininfor.info_id;
|
||
|
||
-- Name: sys_menu; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_menu (
|
||
menu_id bigint NOT NULL,
|
||
menu_name character varying(50) NOT NULL,
|
||
parent_id bigint DEFAULT 0,
|
||
order_num integer,
|
||
path character varying(200),
|
||
component character varying(255),
|
||
query character varying(255),
|
||
route_name character varying(50) DEFAULT ''::character varying,
|
||
is_frame integer,
|
||
is_cache integer DEFAULT 0,
|
||
menu_type character(1),
|
||
visible character(1),
|
||
status smallint,
|
||
perms character varying(100),
|
||
icon character varying(100),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_menu; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_menu IS '菜单权限表';
|
||
|
||
-- Name: COLUMN sys_menu.menu_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.menu_id IS '菜单ID';
|
||
|
||
-- Name: COLUMN sys_menu.menu_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.menu_name IS '菜单名称';
|
||
|
||
-- Name: COLUMN sys_menu.parent_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.parent_id IS '父菜单ID';
|
||
|
||
-- Name: COLUMN sys_menu.order_num; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.order_num IS '显示顺序';
|
||
|
||
-- Name: COLUMN sys_menu.path; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.path IS '路由地址';
|
||
|
||
-- Name: COLUMN sys_menu.component; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.component IS '组件路径';
|
||
|
||
-- Name: COLUMN sys_menu.query; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.query IS '路由参数';
|
||
|
||
-- Name: COLUMN sys_menu.route_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.route_name IS '路由名称';
|
||
|
||
-- Name: COLUMN sys_menu.is_frame; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.is_frame IS '是否为外链（0是 1否）';
|
||
|
||
-- Name: COLUMN sys_menu.is_cache; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.is_cache IS '是否缓存（0缓存 1不缓存）';
|
||
|
||
-- Name: COLUMN sys_menu.menu_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.menu_type IS '菜单类型（M目录 C菜单 F按钮）';
|
||
|
||
-- Name: COLUMN sys_menu.visible; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.visible IS '菜单状态（0显示 1隐藏）';
|
||
|
||
-- Name: COLUMN sys_menu.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.status IS '菜单状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_menu.perms; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.perms IS '权限标识';
|
||
|
||
-- Name: COLUMN sys_menu.icon; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.icon IS '菜单图标';
|
||
|
||
-- Name: COLUMN sys_menu.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_menu.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_menu.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_menu.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_menu.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_menu.remark IS '备注';
|
||
|
||
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_menu_menu_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_menu_menu_id_seq OWNED BY public.sys_menu.menu_id;
|
||
|
||
-- Name: sys_notice; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_notice (
|
||
notice_id bigint NOT NULL,
|
||
notice_title character varying(50) NOT NULL,
|
||
notice_type character(1) NOT NULL,
|
||
notice_content text,
|
||
status character(1),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(255)
|
||
);
|
||
|
||
-- Name: TABLE sys_notice; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_notice IS '通知公告表';
|
||
|
||
-- Name: COLUMN sys_notice.notice_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.notice_id IS '公告ID';
|
||
|
||
-- Name: COLUMN sys_notice.notice_title; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.notice_title IS '公告标题';
|
||
|
||
-- Name: COLUMN sys_notice.notice_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.notice_type IS '公告类型（1通知 2公告）';
|
||
|
||
-- Name: COLUMN sys_notice.notice_content; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.notice_content IS '公告内容';
|
||
|
||
-- Name: COLUMN sys_notice.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.status IS '公告状态（0正常 1关闭）';
|
||
|
||
-- Name: COLUMN sys_notice.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_notice.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_notice.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_notice.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_notice.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_notice.remark IS '备注';
|
||
|
||
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_notice_notice_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_notice_notice_id_seq OWNED BY public.sys_notice.notice_id;
|
||
|
||
-- Name: sys_oper_log; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_oper_log (
|
||
oper_id bigint NOT NULL,
|
||
title character varying(50),
|
||
business_type integer,
|
||
method character varying(100),
|
||
request_method character varying(10),
|
||
operator_type integer,
|
||
oper_name character varying(50),
|
||
dept_name character varying(50),
|
||
oper_url character varying(255),
|
||
oper_ip character varying(128),
|
||
oper_location character varying(255),
|
||
oper_param character varying(2000),
|
||
json_result character varying(2000),
|
||
status integer,
|
||
error_msg character varying(2000),
|
||
oper_time timestamp(6) without time zone,
|
||
cost_time bigint DEFAULT 0
|
||
);
|
||
|
||
-- Name: TABLE sys_oper_log; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_oper_log IS '操作日志记录';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_id IS '日志主键';
|
||
|
||
-- Name: COLUMN sys_oper_log.title; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.title IS '模块标题';
|
||
|
||
-- Name: COLUMN sys_oper_log.business_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.business_type IS '业务类型（0其它 1新增 2修改 3删除）';
|
||
|
||
-- Name: COLUMN sys_oper_log.method; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.method IS '方法名称';
|
||
|
||
-- Name: COLUMN sys_oper_log.request_method; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.request_method IS '请求方式';
|
||
|
||
-- Name: COLUMN sys_oper_log.operator_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.operator_type IS '操作类别（0其它 1后台用户 2手机端用户）';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_name IS '操作人员';
|
||
|
||
-- Name: COLUMN sys_oper_log.dept_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.dept_name IS '部门名称';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_url; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_url IS '请求URL';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_ip; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_ip IS '主机地址';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_location; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_location IS '操作地点';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_param; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_param IS '请求参数';
|
||
|
||
-- Name: COLUMN sys_oper_log.json_result; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.json_result IS '返回参数';
|
||
|
||
-- Name: COLUMN sys_oper_log.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.status IS '操作状态（0正常 1异常）';
|
||
|
||
-- Name: COLUMN sys_oper_log.error_msg; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.error_msg IS '错误消息';
|
||
|
||
-- Name: COLUMN sys_oper_log.oper_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_oper_log.oper_time IS '操作时间';
|
||
|
||
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_oper_log_oper_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_oper_log_oper_id_seq OWNED BY public.sys_oper_log.oper_id;
|
||
|
||
-- Name: sys_post; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_post (
|
||
post_id bigint NOT NULL,
|
||
post_code character varying(64) NOT NULL,
|
||
post_name character varying(50) NOT NULL,
|
||
post_sort integer NOT NULL,
|
||
status character(1) NOT NULL,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_post; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_post IS '岗位信息表';
|
||
|
||
-- Name: COLUMN sys_post.post_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.post_id IS '岗位ID';
|
||
|
||
-- Name: COLUMN sys_post.post_code; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.post_code IS '岗位编码';
|
||
|
||
-- Name: COLUMN sys_post.post_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.post_name IS '岗位名称';
|
||
|
||
-- Name: COLUMN sys_post.post_sort; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.post_sort IS '显示顺序';
|
||
|
||
-- Name: COLUMN sys_post.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.status IS '状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_post.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_post.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_post.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_post.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_post.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_post.remark IS '备注';
|
||
|
||
-- Name: sys_post_post_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_post_post_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_post_post_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_post_post_id_seq OWNED BY public.sys_post.post_id;
|
||
|
||
-- Name: sys_role; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_role (
|
||
role_id bigint NOT NULL,
|
||
role_name character varying(30) NOT NULL,
|
||
role_key character varying(100) NOT NULL,
|
||
role_sort integer NOT NULL,
|
||
data_scope character(1),
|
||
menu_check_strictly boolean,
|
||
dept_check_strictly boolean,
|
||
status character(1) NOT NULL,
|
||
del_flag character(1) DEFAULT 0,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_role; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_role IS '角色信息表';
|
||
|
||
-- Name: COLUMN sys_role.role_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.role_id IS '角色ID';
|
||
|
||
-- Name: COLUMN sys_role.role_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.role_name IS '角色名称';
|
||
|
||
-- Name: COLUMN sys_role.role_key; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.role_key IS '角色权限字符串';
|
||
|
||
-- Name: COLUMN sys_role.role_sort; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.role_sort IS '显示顺序';
|
||
|
||
-- Name: COLUMN sys_role.data_scope; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.data_scope IS '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）';
|
||
|
||
-- Name: COLUMN sys_role.menu_check_strictly; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.menu_check_strictly IS '菜单树选择项是否关联显示';
|
||
|
||
-- Name: COLUMN sys_role.dept_check_strictly; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.dept_check_strictly IS '部门树选择项是否关联显示';
|
||
|
||
-- Name: COLUMN sys_role.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.status IS '角色状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_role.del_flag; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.del_flag IS '删除标志（0代表存在 2代表删除）';
|
||
|
||
-- Name: COLUMN sys_role.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_role.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_role.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_role.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_role.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role.remark IS '备注';
|
||
|
||
-- Name: sys_role_dept; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_role_dept (
|
||
role_id bigint NOT NULL,
|
||
dept_id bigint NOT NULL
|
||
);
|
||
|
||
-- Name: TABLE sys_role_dept; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_role_dept IS '角色和部门关联表';
|
||
|
||
-- Name: COLUMN sys_role_dept.role_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role_dept.role_id IS '角色ID';
|
||
|
||
-- Name: COLUMN sys_role_dept.dept_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role_dept.dept_id IS '部门ID';
|
||
|
||
-- Name: sys_role_menu; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_role_menu (
|
||
role_id bigint NOT NULL,
|
||
menu_id bigint NOT NULL
|
||
);
|
||
|
||
-- Name: TABLE sys_role_menu; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_role_menu IS '角色和菜单关联表';
|
||
|
||
-- Name: COLUMN sys_role_menu.role_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role_menu.role_id IS '角色ID';
|
||
|
||
-- Name: COLUMN sys_role_menu.menu_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_role_menu.menu_id IS '菜单ID';
|
||
|
||
-- Name: sys_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_role_role_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_role_role_id_seq OWNED BY public.sys_role.role_id;
|
||
|
||
-- Name: sys_user; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_user (
|
||
user_id bigint NOT NULL,
|
||
dept_id bigint,
|
||
user_name character varying(30) NOT NULL,
|
||
user_type character varying(2),
|
||
email character varying(50),
|
||
phonenumber character varying(11),
|
||
sex character(1),
|
||
avatar character varying(100),
|
||
password character varying(100),
|
||
status character(1),
|
||
del_flag character(1) DEFAULT '0'::bpchar,
|
||
login_ip character varying(128),
|
||
login_date timestamp(6) without time zone,
|
||
pwd_update_date timestamp(6) without time zone,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500)
|
||
);
|
||
|
||
-- Name: TABLE sys_user; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_user IS '用户信息表';
|
||
|
||
-- Name: COLUMN sys_user.user_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.user_id IS '用户ID';
|
||
|
||
-- Name: COLUMN sys_user.dept_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.dept_id IS '部门ID';
|
||
|
||
-- Name: COLUMN sys_user.user_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.user_name IS '用户账号';
|
||
|
||
-- Name: COLUMN sys_user.user_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.user_type IS '用户类型（00系统用户）';
|
||
|
||
-- Name: COLUMN sys_user.email; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.email IS '用户邮箱';
|
||
|
||
-- Name: COLUMN sys_user.phonenumber; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.phonenumber IS '手机号码';
|
||
|
||
-- Name: COLUMN sys_user.sex; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.sex IS '用户性别（0男 1女 2未知）';
|
||
|
||
-- Name: COLUMN sys_user.avatar; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.avatar IS '头像地址';
|
||
|
||
-- Name: COLUMN sys_user.password; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.password IS '密码';
|
||
|
||
-- Name: COLUMN sys_user.status; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.status IS '帐号状态（0正常 1停用）';
|
||
|
||
-- Name: COLUMN sys_user.del_flag; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.del_flag IS '删除标志（0代表存在 2代表删除）';
|
||
|
||
-- Name: COLUMN sys_user.login_ip; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.login_ip IS '最后登录IP';
|
||
|
||
-- Name: COLUMN sys_user.login_date; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.login_date IS '最后登录时间';
|
||
|
||
-- Name: COLUMN sys_user.pwd_update_date; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.pwd_update_date IS '密码最后更新时间';
|
||
|
||
-- Name: COLUMN sys_user.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_user.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_user.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_user.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_user.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user.remark IS '备注';
|
||
|
||
-- Name: sys_user_post; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_user_post (
|
||
user_id bigint NOT NULL,
|
||
post_id bigint NOT NULL
|
||
);
|
||
|
||
-- Name: TABLE sys_user_post; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_user_post IS '用户与岗位关联表';
|
||
|
||
-- Name: COLUMN sys_user_post.user_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user_post.user_id IS '用户ID';
|
||
|
||
-- Name: COLUMN sys_user_post.post_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user_post.post_id IS '岗位ID';
|
||
|
||
-- Name: sys_user_role; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_user_role (
|
||
user_id bigint NOT NULL,
|
||
role_id bigint NOT NULL
|
||
);
|
||
|
||
-- Name: TABLE sys_user_role; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_user_role IS '用户和角色关联表';
|
||
|
||
-- Name: COLUMN sys_user_role.user_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user_role.user_id IS '用户ID';
|
||
|
||
-- Name: COLUMN sys_user_role.role_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_user_role.role_id IS '角色ID';
|
||
|
||
-- Name: sys_user_user_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_user_user_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_user_user_id_seq OWNED BY public.sys_user.user_id;
|
||
|
||
-- Name: sys_vehicle_info; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_vehicle_info (
|
||
vehicle_id bigint NOT NULL,
|
||
license_plate character varying(50) NOT NULL,
|
||
vin_number character varying(50),
|
||
brand character varying(100),
|
||
owning_unit character varying(255),
|
||
contact_person character varying(100),
|
||
phone_number character varying(20),
|
||
image_url character varying(255),
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone,
|
||
remark character varying(500),
|
||
type_code character varying(30)
|
||
);
|
||
|
||
-- Name: TABLE sys_vehicle_info; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_vehicle_info IS '车辆信息表';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.vehicle_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.vehicle_id IS '车辆ID';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.license_plate; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.license_plate IS '车牌号';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.vin_number; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.vin_number IS 'VIN码';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.brand; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.brand IS '品牌';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.owning_unit; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.owning_unit IS '所属单位';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.contact_person; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.contact_person IS '联系人';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.phone_number; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.phone_number IS '电话';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.image_url; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.image_url IS '图片URL';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.create_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.create_by IS '创建者';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.create_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.create_time IS '创建时间';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.update_by; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.update_by IS '更新者';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.update_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.update_time IS '更新时间';
|
||
|
||
-- Name: COLUMN sys_vehicle_info.remark; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_info.remark IS '备注';
|
||
|
||
-- Name: sys_vehicle_info_vehicle_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_vehicle_info_vehicle_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_vehicle_info_vehicle_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_vehicle_info_vehicle_id_seq OWNED BY public.sys_vehicle_info.vehicle_id;
|
||
|
||
-- Name: sys_vehicle_type; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.sys_vehicle_type (
|
||
id bigint NOT NULL,
|
||
type_code character varying(30) NOT NULL,
|
||
type_name character varying(100) NOT NULL,
|
||
display_name_cn character varying(100) NOT NULL,
|
||
display_name_en character varying(100),
|
||
path_level integer NOT NULL,
|
||
parent_code character varying(30),
|
||
full_path character varying(200) NOT NULL,
|
||
is_leaf boolean DEFAULT false,
|
||
sort_order integer DEFAULT 0,
|
||
enabled boolean DEFAULT true,
|
||
description character varying(500),
|
||
attributes jsonb,
|
||
create_by character varying(64),
|
||
create_time timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
|
||
update_by character varying(64),
|
||
update_time timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
|
||
version bigint DEFAULT 0
|
||
);
|
||
|
||
-- Name: TABLE sys_vehicle_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.sys_vehicle_type IS '车辆类型表（路径编码模式）';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.id IS '代理主键ID';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.type_code; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.type_code IS '路径编码（如UV.PT表示无人车.巡逻车）';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.type_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.type_name IS '类型名称';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.display_name_cn; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.display_name_cn IS '中文显示名称';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.display_name_en; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.display_name_en IS '英文显示名称';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.path_level; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.path_level IS '路径层级（1=一级分类，2=二级分类）';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.parent_code; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.parent_code IS '父路径编码';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.full_path; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.full_path IS '完整路径描述';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.is_leaf; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.is_leaf IS '是否叶子节点';
|
||
|
||
-- Name: COLUMN sys_vehicle_type.attributes; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.sys_vehicle_type.attributes IS '扩展属性JSON（权限、速度限制等）';
|
||
|
||
-- Name: sys_vehicle_type_compatible; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.sys_vehicle_type_compatible AS
|
||
SELECT id AS type_id,
|
||
CASE
|
||
WHEN (parent_code IS NULL) THEN NULL::bigint
|
||
ELSE ( SELECT sys_vehicle_type.id
|
||
FROM public.sys_vehicle_type
|
||
WHERE ((sys_vehicle_type.type_code)::text = (vt.parent_code)::text))
|
||
END AS parent_id,
|
||
display_name_cn AS type_name,
|
||
path_level AS level,
|
||
create_by,
|
||
create_time,
|
||
update_by,
|
||
update_time,
|
||
description AS remark,
|
||
type_code,
|
||
full_path
|
||
FROM public.sys_vehicle_type vt
|
||
WHERE (enabled = true);
|
||
|
||
-- Name: sys_vehicle_type_new_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.sys_vehicle_type_new_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: sys_vehicle_type_new_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.sys_vehicle_type_new_id_seq OWNED BY public.sys_vehicle_type.id;
|
||
|
||
-- Name: transport_routes; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.transport_routes (
|
||
id bigint NOT NULL,
|
||
route_name character varying(100) NOT NULL,
|
||
route_type character varying(20) NOT NULL,
|
||
description character varying(500),
|
||
route_geometry public.geometry(LineString,4326) NOT NULL,
|
||
max_speed_kph double precision,
|
||
typical_speed_kph double precision,
|
||
active_time_start time without time zone,
|
||
active_time_end time without time zone,
|
||
status character varying(20) DEFAULT 'ACTIVE'::character varying,
|
||
is_bidirectional boolean DEFAULT false,
|
||
created_by character varying(50),
|
||
updated_by character varying(50),
|
||
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
|
||
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
|
||
CONSTRAINT transport_routes_max_speed_kph_check CHECK ((max_speed_kph > (0)::double precision)),
|
||
CONSTRAINT transport_routes_route_type_check CHECK (((route_type)::text = ANY ((ARRAY['AIRCRAFT'::character varying, 'UNMANNED_VEHICLE'::character varying, 'SPECIAL_VEHICLE'::character varying, 'NORMAL_VEHICLE'::character varying])::text[]))),
|
||
CONSTRAINT transport_routes_status_check CHECK (((status)::text = ANY ((ARRAY['ACTIVE'::character varying, 'INACTIVE'::character varying, 'MAINTENANCE'::character varying])::text[]))),
|
||
CONSTRAINT transport_routes_typical_speed_kph_check CHECK ((typical_speed_kph > (0)::double precision))
|
||
);
|
||
|
||
-- Name: TABLE transport_routes; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.transport_routes IS '交通路径定义表 - 存储航空器和无人车的预定路径';
|
||
|
||
-- Name: transport_routes_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.transport_routes_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: transport_routes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.transport_routes_id_seq OWNED BY public.transport_routes.id;
|
||
|
||
-- Name: uv_violation_events; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.uv_violation_events (
|
||
id bigint NOT NULL,
|
||
vehicle_id bigint NOT NULL,
|
||
vehicle_license character varying(50),
|
||
rule_name character varying(100) NOT NULL,
|
||
violation_type character varying(50) NOT NULL,
|
||
alert_level character varying(50) NOT NULL,
|
||
description character varying(150),
|
||
location public.geometry(Point,4326),
|
||
actual_value double precision,
|
||
limit_value double precision,
|
||
violation_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
CONSTRAINT uv_violation_events_alert_level_check CHECK (((alert_level)::text = ANY ((ARRAY['INFO'::character varying, 'WARNING'::character varying, 'CRITICAL'::character varying, 'EMERGENCY'::character varying])::text[]))),
|
||
CONSTRAINT uv_violation_events_violation_type_check CHECK (((violation_type)::text = ANY ((ARRAY['SPEED'::character varying, 'ACCESS'::character varying, 'HEIGHT'::character varying, 'WEIGHT'::character varying, 'OTHER'::character varying])::text[])))
|
||
);
|
||
|
||
-- Name: TABLE uv_violation_events; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.uv_violation_events IS '无人车违规事件表 - 专门记录机场无人车的各种违规行为';
|
||
|
||
-- Name: COLUMN uv_violation_events.id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.id IS '主键ID，自增';
|
||
|
||
-- Name: COLUMN uv_violation_events.vehicle_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.vehicle_id IS '车辆ID，关联sys_vehicle_info.vehicle_id，用于内部处理和查询优化';
|
||
|
||
-- Name: COLUMN uv_violation_events.vehicle_license; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.vehicle_license IS '无人车车牌号，用于显示和业务标识，可为空';
|
||
|
||
-- Name: COLUMN uv_violation_events.rule_name; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.rule_name IS '违规的规则名称';
|
||
|
||
-- Name: COLUMN uv_violation_events.violation_type; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.violation_type IS '违规类型：SPEED超速/ACCESS未授权进入/HEIGHT超高/WEIGHT超重';
|
||
|
||
-- Name: COLUMN uv_violation_events.alert_level; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.alert_level IS '告警级别：INFO信息/WARNING警告/CRITICAL严重/EMERGENCY紧急';
|
||
|
||
-- Name: COLUMN uv_violation_events.description; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.description IS '违规描述，如"超速: 19.8km/h"';
|
||
|
||
-- Name: COLUMN uv_violation_events.location; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.location IS '违规发生的地理位置（PostGIS Point）';
|
||
|
||
-- Name: COLUMN uv_violation_events.actual_value; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.actual_value IS '实际测量值，如实际速度19.8';
|
||
|
||
-- Name: COLUMN uv_violation_events.limit_value; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.limit_value IS '规则限制值，如限速5.0';
|
||
|
||
-- Name: COLUMN uv_violation_events.violation_time; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.violation_time IS '违规发生的时间';
|
||
|
||
-- Name: COLUMN uv_violation_events.created_at; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.uv_violation_events.created_at IS '记录创建时间';
|
||
|
||
-- Name: uv_violation_events_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.uv_violation_events_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: uv_violation_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.uv_violation_events_id_seq OWNED BY public.uv_violation_events.id;
|
||
|
||
-- Name: vehicle_commands; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.vehicle_commands (
|
||
id bigint NOT NULL,
|
||
trans_id character varying(100) NOT NULL,
|
||
"timestamp" timestamp without time zone NOT NULL,
|
||
command_type character varying(20) NOT NULL,
|
||
command_reason character varying(30) NOT NULL,
|
||
signal_state character varying(10),
|
||
intersection_id character varying(50),
|
||
target_location public.geometry(Point,4326) NOT NULL,
|
||
relative_speed double precision,
|
||
relative_motion_x double precision,
|
||
relative_motion_y double precision,
|
||
min_distance double precision,
|
||
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
vehicle_id bigint,
|
||
CONSTRAINT vehicle_commands_command_reason_check CHECK (((command_reason)::text = ANY ((ARRAY['TRAFFIC_LIGHT'::character varying, 'AIRCRAFT_CROSSING'::character varying, 'SPECIAL_VEHICLE'::character varying, 'AIRCRAFT_PUSH'::character varying, 'RESUME_TRAFFIC'::character varying, 'PARKING_SIDE'::character varying])::text[]))),
|
||
CONSTRAINT vehicle_commands_command_type_check CHECK (((command_type)::text = ANY ((ARRAY['ALERT'::character varying, 'SIGNAL'::character varying, 'WARNING'::character varying, 'RESUME'::character varying, 'PARKING'::character varying])::text[]))),
|
||
CONSTRAINT vehicle_commands_signal_state_check CHECK (((signal_state)::text = ANY ((ARRAY['RED'::character varying, 'YELLOW'::character varying, 'GREEN'::character varying])::text[])))
|
||
);
|
||
|
||
-- Name: TABLE vehicle_commands; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.vehicle_commands IS '无人车控制指令表，用于存储发送给无人车的控制指令，支持轨迹回放和日志审计';
|
||
|
||
-- Name: COLUMN vehicle_commands.vehicle_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.vehicle_commands.vehicle_id IS '系统车辆ID，对应sys_vehicle_info.vehicle_id';
|
||
|
||
-- Name: vehicle_commands_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.vehicle_commands_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: vehicle_commands_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.vehicle_commands_id_seq OWNED BY public.vehicle_commands.id;
|
||
|
||
-- Name: vehicle_locations; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.vehicle_locations (
|
||
id bigint NOT NULL,
|
||
location public.geometry(Point,4326) NOT NULL,
|
||
altitude double precision,
|
||
heading double precision,
|
||
speed double precision,
|
||
"timestamp" timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
data_quality character varying(20),
|
||
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
vehicle_id bigint,
|
||
CONSTRAINT vehicle_locations_heading_check CHECK (((heading >= (0)::double precision) AND (heading < (360)::double precision))),
|
||
CONSTRAINT vehicle_locations_speed_check CHECK ((speed >= (0)::double precision))
|
||
);
|
||
|
||
-- Name: TABLE vehicle_locations; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON TABLE public.vehicle_locations IS '车辆位置信息表（规范化版本）- 只存储位置相关数据，车辆基础信息通过关联查询获取';
|
||
|
||
-- Name: COLUMN vehicle_locations.vehicle_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.vehicle_locations.vehicle_id IS '系统车辆ID，对应sys_vehicle_info.vehicle_id';
|
||
|
||
-- Name: vehicle_complete_info; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.vehicle_complete_info AS
|
||
SELECT vi.vehicle_id,
|
||
vi.license_plate,
|
||
vi.vin_number,
|
||
vi.type_code,
|
||
vt.display_name_cn AS type_name,
|
||
vt.type_name AS type_code_name,
|
||
vi.brand,
|
||
vi.owning_unit,
|
||
vi.contact_person,
|
||
vi.phone_number,
|
||
vi.image_url,
|
||
vl.location,
|
||
vl.altitude,
|
||
vl.heading,
|
||
vl.speed,
|
||
vl."timestamp" AS last_location_time,
|
||
vl.data_quality,
|
||
vi.create_time,
|
||
vi.update_time
|
||
FROM ((public.sys_vehicle_info vi
|
||
LEFT JOIN public.sys_vehicle_type vt ON (((vi.type_code)::text = (vt.type_code)::text)))
|
||
LEFT JOIN LATERAL ( SELECT vehicle_locations.id,
|
||
vehicle_locations.location,
|
||
vehicle_locations.altitude,
|
||
vehicle_locations.heading,
|
||
vehicle_locations.speed,
|
||
vehicle_locations."timestamp",
|
||
vehicle_locations.data_quality,
|
||
vehicle_locations.created_at,
|
||
vehicle_locations.updated_at,
|
||
vehicle_locations.vehicle_id
|
||
FROM public.vehicle_locations
|
||
WHERE (vehicle_locations.vehicle_id = vi.vehicle_id)
|
||
ORDER BY vehicle_locations."timestamp" DESC
|
||
LIMIT 1) vl ON (true));
|
||
|
||
-- Name: vehicle_info_with_location; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.vehicle_info_with_location AS
|
||
SELECT vi.vehicle_id,
|
||
vi.license_plate,
|
||
vi.type_code,
|
||
vt.display_name_cn AS type_name,
|
||
vi.brand,
|
||
vl.location,
|
||
vl.speed,
|
||
vl."timestamp" AS last_update
|
||
FROM ((public.sys_vehicle_info vi
|
||
LEFT JOIN public.sys_vehicle_type vt ON (((vi.type_code)::text = (vt.type_code)::text)))
|
||
LEFT JOIN LATERAL ( SELECT vehicle_locations.location,
|
||
vehicle_locations.speed,
|
||
vehicle_locations."timestamp",
|
||
vehicle_locations.vehicle_id
|
||
FROM public.vehicle_locations
|
||
WHERE (vehicle_locations.vehicle_id = vi.vehicle_id)
|
||
ORDER BY vehicle_locations."timestamp" DESC
|
||
LIMIT 1) vl ON (true));
|
||
|
||
-- Name: vehicle_locations_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.vehicle_locations_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: vehicle_locations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.vehicle_locations_id_seq OWNED BY public.vehicle_locations.id;
|
||
|
||
-- Name: vehicle_status_summary; Type: VIEW; Schema: public; Owner:
|
||
CREATE VIEW public.vehicle_status_summary AS
|
||
SELECT count(*) AS total_vehicles,
|
||
count(
|
||
CASE
|
||
WHEN (last_location_time > (now() - '00:05:00'::interval)) THEN 1
|
||
ELSE NULL::integer
|
||
END) AS active_vehicles,
|
||
count(
|
||
CASE
|
||
WHEN ((last_location_time > (now() - '00:30:00'::interval)) AND (last_location_time <= (now() - '00:05:00'::interval))) THEN 1
|
||
ELSE NULL::integer
|
||
END) AS inactive_vehicles,
|
||
count(
|
||
CASE
|
||
WHEN ((last_location_time IS NULL) OR (last_location_time <= (now() - '00:30:00'::interval))) THEN 1
|
||
ELSE NULL::integer
|
||
END) AS offline_vehicles,
|
||
avg(speed) AS avg_speed,
|
||
max(speed) AS max_speed
|
||
FROM public.vehicle_complete_info;
|
||
|
||
-- Name: vehicle_trajectories; Type: TABLE; Schema: public; Owner:
|
||
CREATE TABLE public.vehicle_trajectories (
|
||
id bigint NOT NULL,
|
||
trajectory_date date NOT NULL,
|
||
trajectory_line public.geometry(LineString,4326),
|
||
total_distance double precision,
|
||
max_speed double precision,
|
||
avg_speed double precision,
|
||
duration_seconds integer,
|
||
point_count integer,
|
||
start_time timestamp with time zone NOT NULL,
|
||
end_time timestamp with time zone NOT NULL,
|
||
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
||
vehicle_id bigint
|
||
);
|
||
|
||
-- Name: COLUMN vehicle_trajectories.vehicle_id; Type: COMMENT; Schema: public; Owner:
|
||
COMMENT ON COLUMN public.vehicle_trajectories.vehicle_id IS '系统车辆ID，对应sys_vehicle_info.vehicle_id';
|
||
|
||
-- Name: vehicle_trajectories_id_seq; Type: SEQUENCE; Schema: public; Owner:
|
||
CREATE SEQUENCE public.vehicle_trajectories_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
-- Name: vehicle_trajectories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
|
||
ALTER SEQUENCE public.vehicle_trajectories_id_seq OWNED BY public.vehicle_trajectories.id;
|
||
|
||
-- Name: airport_areas id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.airport_areas ALTER COLUMN id SET DEFAULT nextval('public.airport_areas_id_seq'::regclass);
|
||
|
||
-- Name: conflict_alert_logs id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.conflict_alert_logs ALTER COLUMN id SET DEFAULT nextval('public.conflict_alert_logs_id_seq'::regclass);
|
||
|
||
-- Name: gen_table table_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.gen_table ALTER COLUMN table_id SET DEFAULT nextval('public.gen_table_table_id_seq'::regclass);
|
||
|
||
-- Name: gen_table_column column_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.gen_table_column ALTER COLUMN column_id SET DEFAULT nextval('public.gen_table_column_column_id_seq'::regclass);
|
||
|
||
-- Name: object_route_assignments id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.object_route_assignments ALTER COLUMN id SET DEFAULT nextval('public.object_route_assignments_id_seq'::regclass);
|
||
|
||
-- Name: sys_config config_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_config ALTER COLUMN config_id SET DEFAULT nextval('public.sys_config_config_id_seq'::regclass);
|
||
|
||
-- Name: sys_dept dept_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_dept ALTER COLUMN dept_id SET DEFAULT nextval('public.sys_dept_dept_id_seq'::regclass);
|
||
|
||
-- Name: sys_dict_data dict_code; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_dict_data ALTER COLUMN dict_code SET DEFAULT nextval('public.sys_dict_data_dict_code_seq'::regclass);
|
||
|
||
-- Name: sys_dict_type dict_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_dict_type ALTER COLUMN dict_id SET DEFAULT nextval('public.sys_dict_type_dict_id_seq'::regclass);
|
||
|
||
-- Name: sys_job job_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_job ALTER COLUMN job_id SET DEFAULT nextval('public.sys_job_job_id_seq'::regclass);
|
||
|
||
-- Name: sys_job_log job_log_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_job_log ALTER COLUMN job_log_id SET DEFAULT nextval('public.sys_job_log_job_log_id_seq'::regclass);
|
||
|
||
-- Name: sys_logininfor info_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_logininfor ALTER COLUMN info_id SET DEFAULT nextval('public.sys_logininfor_info_id_seq'::regclass);
|
||
|
||
-- Name: sys_menu menu_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_menu ALTER COLUMN menu_id SET DEFAULT nextval('public.sys_menu_menu_id_seq'::regclass);
|
||
|
||
-- Name: sys_notice notice_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_notice ALTER COLUMN notice_id SET DEFAULT nextval('public.sys_notice_notice_id_seq'::regclass);
|
||
|
||
-- Name: sys_oper_log oper_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_oper_log ALTER COLUMN oper_id SET DEFAULT nextval('public.sys_oper_log_oper_id_seq'::regclass);
|
||
|
||
-- Name: sys_post post_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_post ALTER COLUMN post_id SET DEFAULT nextval('public.sys_post_post_id_seq'::regclass);
|
||
|
||
-- Name: sys_role role_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_role ALTER COLUMN role_id SET DEFAULT nextval('public.sys_role_role_id_seq'::regclass);
|
||
|
||
-- Name: sys_user user_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_user ALTER COLUMN user_id SET DEFAULT nextval('public.sys_user_user_id_seq'::regclass);
|
||
|
||
-- Name: sys_vehicle_info vehicle_id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_info ALTER COLUMN vehicle_id SET DEFAULT nextval('public.sys_vehicle_info_vehicle_id_seq'::regclass);
|
||
|
||
-- Name: sys_vehicle_type id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_type ALTER COLUMN id SET DEFAULT nextval('public.sys_vehicle_type_new_id_seq'::regclass);
|
||
|
||
-- Name: transport_routes id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.transport_routes ALTER COLUMN id SET DEFAULT nextval('public.transport_routes_id_seq'::regclass);
|
||
|
||
-- Name: uv_violation_events id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.uv_violation_events ALTER COLUMN id SET DEFAULT nextval('public.uv_violation_events_id_seq'::regclass);
|
||
|
||
-- Name: vehicle_commands id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.vehicle_commands ALTER COLUMN id SET DEFAULT nextval('public.vehicle_commands_id_seq'::regclass);
|
||
|
||
-- Name: vehicle_locations id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.vehicle_locations ALTER COLUMN id SET DEFAULT nextval('public.vehicle_locations_id_seq'::regclass);
|
||
|
||
-- Name: vehicle_trajectories id; Type: DEFAULT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.vehicle_trajectories ALTER COLUMN id SET DEFAULT nextval('public.vehicle_trajectories_id_seq'::regclass);
|
||
|
||
-- Name: qrtz_blob_triggers QRTZ_BLOB_TRIGGERS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_blob_triggers
|
||
ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_pkey" PRIMARY KEY (sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_calendars QRTZ_CALENDARS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_calendars
|
||
ADD CONSTRAINT "QRTZ_CALENDARS_pkey" PRIMARY KEY (sched_name, calendar_name);
|
||
|
||
-- Name: qrtz_cron_triggers QRTZ_CRON_TRIGGERS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_cron_triggers
|
||
ADD CONSTRAINT "QRTZ_CRON_TRIGGERS_pkey" PRIMARY KEY (sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_fired_triggers QRTZ_FIRED_TRIGGERS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_fired_triggers
|
||
ADD CONSTRAINT "QRTZ_FIRED_TRIGGERS_pkey" PRIMARY KEY (sched_name, entry_id);
|
||
|
||
-- Name: qrtz_job_details QRTZ_JOB_DETAILS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_job_details
|
||
ADD CONSTRAINT "QRTZ_JOB_DETAILS_pkey" PRIMARY KEY (sched_name, job_name, job_group);
|
||
|
||
-- Name: qrtz_locks QRTZ_LOCKS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_locks
|
||
ADD CONSTRAINT "QRTZ_LOCKS_pkey" PRIMARY KEY (sched_name, lock_name);
|
||
|
||
-- Name: qrtz_paused_trigger_grps QRTZ_PAUSED_TRIGGER_GRPS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_paused_trigger_grps
|
||
ADD CONSTRAINT "QRTZ_PAUSED_TRIGGER_GRPS_pkey" PRIMARY KEY (sched_name, trigger_group);
|
||
|
||
-- Name: qrtz_scheduler_state QRTZ_SCHEDULER_STATE_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_scheduler_state
|
||
ADD CONSTRAINT "QRTZ_SCHEDULER_STATE_pkey" PRIMARY KEY (sched_name, instance_name);
|
||
|
||
-- Name: qrtz_simple_triggers QRTZ_SIMPLE_TRIGGERS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_simple_triggers
|
||
ADD CONSTRAINT "QRTZ_SIMPLE_TRIGGERS_pkey" PRIMARY KEY (sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_simprop_triggers QRTZ_SIMPROP_TRIGGERS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_simprop_triggers
|
||
ADD CONSTRAINT "QRTZ_SIMPROP_TRIGGERS_pkey" PRIMARY KEY (sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_triggers QRTZ_TRIGGERS_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_triggers
|
||
ADD CONSTRAINT "QRTZ_TRIGGERS_pkey" PRIMARY KEY (sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: airport_areas airport_areas_area_id_key; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.airport_areas
|
||
ADD CONSTRAINT airport_areas_area_id_key UNIQUE (area_id);
|
||
|
||
-- Name: airport_areas airport_areas_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.airport_areas
|
||
ADD CONSTRAINT airport_areas_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: conflict_alert_logs conflict_alert_logs_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.conflict_alert_logs
|
||
ADD CONSTRAINT conflict_alert_logs_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: flyway_schema_history flyway_schema_history_pk; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.flyway_schema_history
|
||
ADD CONSTRAINT flyway_schema_history_pk PRIMARY KEY (installed_rank);
|
||
|
||
-- Name: gen_table_column gen_table_column_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.gen_table_column
|
||
ADD CONSTRAINT gen_table_column_pkey PRIMARY KEY (column_id);
|
||
|
||
-- Name: gen_table gen_table_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.gen_table
|
||
ADD CONSTRAINT gen_table_pkey PRIMARY KEY (table_id);
|
||
|
||
-- Name: geofence_events geofence_events_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.geofence_events
|
||
ADD CONSTRAINT geofence_events_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: object_route_assignments object_route_assignments_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.object_route_assignments
|
||
ADD CONSTRAINT object_route_assignments_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: spatial_rule_vehicle_types spatial_rule_vehicle_types_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.spatial_rule_vehicle_types
|
||
ADD CONSTRAINT spatial_rule_vehicle_types_pkey PRIMARY KEY (rule_id, vehicle_type);
|
||
|
||
-- Name: spatial_rules spatial_rules_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.spatial_rules
|
||
ADD CONSTRAINT spatial_rules_pkey PRIMARY KEY (rule_id);
|
||
|
||
-- Name: sys_config sys_config_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_config
|
||
ADD CONSTRAINT sys_config_pkey PRIMARY KEY (config_id);
|
||
|
||
-- Name: sys_dept sys_dept_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_dept
|
||
ADD CONSTRAINT sys_dept_pkey PRIMARY KEY (dept_id);
|
||
|
||
-- Name: sys_dict_data sys_dict_data_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_dict_data
|
||
ADD CONSTRAINT sys_dict_data_pkey PRIMARY KEY (dict_code);
|
||
|
||
-- Name: sys_dict_type sys_dict_type_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_dict_type
|
||
ADD CONSTRAINT sys_dict_type_pkey PRIMARY KEY (dict_id);
|
||
|
||
-- Name: sys_driver_info sys_driver_info_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_driver_info
|
||
ADD CONSTRAINT sys_driver_info_pkey PRIMARY KEY (user_id);
|
||
|
||
-- Name: sys_job_log sys_job_log_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_job_log
|
||
ADD CONSTRAINT sys_job_log_pkey PRIMARY KEY (job_log_id);
|
||
|
||
-- Name: sys_job sys_job_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_job
|
||
ADD CONSTRAINT sys_job_pkey PRIMARY KEY (job_id, job_name, job_group);
|
||
|
||
-- Name: sys_logininfor sys_logininfor_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_logininfor
|
||
ADD CONSTRAINT sys_logininfor_pkey PRIMARY KEY (info_id);
|
||
|
||
-- Name: sys_menu sys_menu_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_menu
|
||
ADD CONSTRAINT sys_menu_pkey PRIMARY KEY (menu_id);
|
||
|
||
-- Name: sys_notice sys_notice_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_notice
|
||
ADD CONSTRAINT sys_notice_pkey PRIMARY KEY (notice_id);
|
||
|
||
-- Name: sys_oper_log sys_oper_log_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_oper_log
|
||
ADD CONSTRAINT sys_oper_log_pkey PRIMARY KEY (oper_id);
|
||
|
||
-- Name: sys_post sys_post_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_post
|
||
ADD CONSTRAINT sys_post_pkey PRIMARY KEY (post_id);
|
||
|
||
-- Name: sys_role_dept sys_role_dept_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_role_dept
|
||
ADD CONSTRAINT sys_role_dept_pkey PRIMARY KEY (role_id, dept_id);
|
||
|
||
-- Name: sys_role_menu sys_role_menu_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_role_menu
|
||
ADD CONSTRAINT sys_role_menu_pkey PRIMARY KEY (role_id, menu_id);
|
||
|
||
-- Name: sys_role sys_role_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_role
|
||
ADD CONSTRAINT sys_role_pkey PRIMARY KEY (role_id);
|
||
|
||
-- Name: sys_user sys_user_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_user
|
||
ADD CONSTRAINT sys_user_pkey PRIMARY KEY (user_id);
|
||
|
||
-- Name: sys_user_post sys_user_post_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_user_post
|
||
ADD CONSTRAINT sys_user_post_pkey PRIMARY KEY (user_id, post_id);
|
||
|
||
-- Name: sys_user_role sys_user_role_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_user_role
|
||
ADD CONSTRAINT sys_user_role_pkey PRIMARY KEY (user_id, role_id);
|
||
|
||
-- Name: sys_vehicle_info sys_vehicle_info_license_plate_number_key; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_info
|
||
ADD CONSTRAINT sys_vehicle_info_license_plate_number_key UNIQUE (license_plate);
|
||
|
||
-- Name: sys_vehicle_info sys_vehicle_info_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_info
|
||
ADD CONSTRAINT sys_vehicle_info_pkey PRIMARY KEY (vehicle_id);
|
||
|
||
-- Name: sys_vehicle_info sys_vehicle_info_vin_number_key; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_info
|
||
ADD CONSTRAINT sys_vehicle_info_vin_number_key UNIQUE (vin_number);
|
||
|
||
-- Name: sys_vehicle_type sys_vehicle_type_new_code_unique; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_type
|
||
ADD CONSTRAINT sys_vehicle_type_new_code_unique UNIQUE (type_code);
|
||
|
||
-- Name: sys_vehicle_type sys_vehicle_type_new_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_vehicle_type
|
||
ADD CONSTRAINT sys_vehicle_type_new_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: transport_routes transport_routes_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.transport_routes
|
||
ADD CONSTRAINT transport_routes_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: geofence_events ukaxyk98nttupuc7nuten8s5aad; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.geofence_events
|
||
ADD CONSTRAINT ukaxyk98nttupuc7nuten8s5aad UNIQUE (event_id);
|
||
|
||
-- Name: uv_violation_events uv_violation_events_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.uv_violation_events
|
||
ADD CONSTRAINT uv_violation_events_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: vehicle_commands vehicle_commands_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.vehicle_commands
|
||
ADD CONSTRAINT vehicle_commands_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: vehicle_locations vehicle_locations_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.vehicle_locations
|
||
ADD CONSTRAINT vehicle_locations_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: vehicle_trajectories vehicle_trajectories_pkey; Type: CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.vehicle_trajectories
|
||
ADD CONSTRAINT vehicle_trajectories_pkey PRIMARY KEY (id);
|
||
|
||
-- Name: dict_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX dict_type ON public.sys_dict_type USING btree (dict_type);
|
||
|
||
-- Name: flyway_schema_history_s_idx; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX flyway_schema_history_s_idx ON public.flyway_schema_history USING btree (success);
|
||
|
||
-- Name: idx_airport_areas_area_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_airport_areas_area_id ON public.airport_areas USING btree (area_id);
|
||
|
||
-- Name: idx_airport_areas_enabled; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_airport_areas_enabled ON public.airport_areas USING btree (enabled);
|
||
|
||
-- Name: idx_airport_areas_functional_category; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_airport_areas_functional_category ON public.airport_areas USING btree (functional_category);
|
||
|
||
-- Name: idx_airport_areas_geom; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_airport_areas_geom ON public.airport_areas USING gist (boundary);
|
||
|
||
-- Name: idx_airport_areas_parent_area_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_airport_areas_parent_area_id ON public.airport_areas USING btree (parent_area_id);
|
||
|
||
-- Name: idx_airport_areas_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_airport_areas_type ON public.airport_areas USING btree (type);
|
||
|
||
-- Name: idx_conflict_alerts_level; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_conflict_alerts_level ON public.conflict_alert_logs USING btree (alert_level);
|
||
|
||
-- Name: idx_conflict_alerts_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_conflict_alerts_time ON public.conflict_alert_logs USING btree (alert_time DESC);
|
||
|
||
-- Name: idx_conflict_alerts_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_conflict_alerts_type ON public.conflict_alert_logs USING btree (alert_type);
|
||
|
||
-- Name: idx_geofence_events_alert_level; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_alert_level ON public.geofence_events USING btree (alert_level);
|
||
|
||
-- Name: idx_geofence_events_event_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_event_id ON public.geofence_events USING btree (event_id);
|
||
|
||
-- Name: idx_geofence_events_fence_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_fence_id ON public.geofence_events USING btree (fence_id);
|
||
|
||
-- Name: idx_geofence_events_processed; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_processed ON public.geofence_events USING btree (processed);
|
||
|
||
-- Name: idx_geofence_events_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_time ON public.geofence_events USING btree (event_time);
|
||
|
||
-- Name: idx_geofence_events_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_type ON public.geofence_events USING btree (event_type);
|
||
|
||
-- Name: idx_geofence_events_vehicle_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_geofence_events_vehicle_id ON public.geofence_events USING btree (vehicle_id);
|
||
|
||
-- Name: idx_object_route_assignments_assigned_at; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_object_route_assignments_assigned_at ON public.object_route_assignments USING btree (assigned_at DESC);
|
||
|
||
-- Name: idx_object_route_assignments_object_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_object_route_assignments_object_type ON public.object_route_assignments USING btree (object_type);
|
||
|
||
-- Name: idx_object_route_assignments_route; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_object_route_assignments_route ON public.object_route_assignments USING btree (assigned_route_id);
|
||
|
||
-- Name: idx_spatial_rules_category; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_spatial_rules_category ON public.spatial_rules USING btree (rule_category);
|
||
|
||
-- Name: idx_spatial_rules_object_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_spatial_rules_object_id ON public.spatial_rules USING btree (spatial_object_id);
|
||
|
||
-- Name: idx_spatial_rules_object_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_spatial_rules_object_type ON public.spatial_rules USING btree (spatial_object_type);
|
||
|
||
-- Name: idx_spatial_rules_priority; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_spatial_rules_priority ON public.spatial_rules USING btree (priority);
|
||
|
||
-- Name: idx_spatial_rules_status; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_spatial_rules_status ON public.spatial_rules USING btree (status);
|
||
|
||
-- Name: idx_sys_vehicle_type_new_enabled; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_sys_vehicle_type_new_enabled ON public.sys_vehicle_type USING btree (enabled);
|
||
|
||
-- Name: idx_sys_vehicle_type_new_parent_code; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_sys_vehicle_type_new_parent_code ON public.sys_vehicle_type USING btree (parent_code);
|
||
|
||
-- Name: idx_sys_vehicle_type_new_path_level; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_sys_vehicle_type_new_path_level ON public.sys_vehicle_type USING btree (path_level);
|
||
|
||
-- Name: idx_sys_vehicle_type_new_sort_order; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_sys_vehicle_type_new_sort_order ON public.sys_vehicle_type USING btree (sort_order);
|
||
|
||
-- Name: idx_sys_vehicle_type_new_type_code; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_sys_vehicle_type_new_type_code ON public.sys_vehicle_type USING btree (type_code);
|
||
|
||
-- Name: idx_transport_routes_geometry_gist; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_transport_routes_geometry_gist ON public.transport_routes USING gist (route_geometry);
|
||
|
||
-- Name: idx_transport_routes_status; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_transport_routes_status ON public.transport_routes USING btree (status);
|
||
|
||
-- Name: idx_transport_routes_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_transport_routes_type ON public.transport_routes USING btree (route_type);
|
||
|
||
-- Name: idx_uv_violations_alert_level; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_alert_level ON public.uv_violation_events USING btree (alert_level);
|
||
|
||
-- Name: idx_uv_violations_location; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_location ON public.uv_violation_events USING gist (location);
|
||
|
||
-- Name: idx_uv_violations_rule; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_rule ON public.uv_violation_events USING btree (rule_name);
|
||
|
||
-- Name: idx_uv_violations_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_time ON public.uv_violation_events USING btree (violation_time);
|
||
|
||
-- Name: idx_uv_violations_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_type ON public.uv_violation_events USING btree (violation_type);
|
||
|
||
-- Name: idx_uv_violations_type_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_type_time ON public.uv_violation_events USING btree (violation_type, violation_time DESC);
|
||
|
||
-- Name: idx_uv_violations_vehicle_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_vehicle_id ON public.uv_violation_events USING btree (vehicle_id);
|
||
|
||
-- Name: idx_uv_violations_vehicle_id_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_vehicle_id_time ON public.uv_violation_events USING btree (vehicle_id, violation_time DESC);
|
||
|
||
-- Name: idx_uv_violations_vehicle_license; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_vehicle_license ON public.uv_violation_events USING btree (vehicle_license);
|
||
|
||
-- Name: idx_uv_violations_vehicle_license_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_uv_violations_vehicle_license_time ON public.uv_violation_events USING btree (vehicle_license, violation_time DESC);
|
||
|
||
-- Name: idx_vehicle_commands_command_type; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_command_type ON public.vehicle_commands USING btree (command_type);
|
||
|
||
-- Name: idx_vehicle_commands_created_at; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_created_at ON public.vehicle_commands USING btree (created_at);
|
||
|
||
-- Name: idx_vehicle_commands_location_gist; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_location_gist ON public.vehicle_commands USING gist (target_location);
|
||
|
||
-- Name: idx_vehicle_commands_timestamp; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_timestamp ON public.vehicle_commands USING btree ("timestamp" DESC);
|
||
|
||
-- Name: idx_vehicle_commands_trans_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_trans_id ON public.vehicle_commands USING btree (trans_id);
|
||
|
||
-- Name: idx_vehicle_commands_type_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_type_time ON public.vehicle_commands USING btree (command_type, "timestamp" DESC);
|
||
|
||
-- Name: idx_vehicle_commands_vehicle_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_commands_vehicle_id ON public.vehicle_commands USING btree (vehicle_id);
|
||
|
||
-- Name: idx_vehicle_locations_location_gist; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_locations_location_gist ON public.vehicle_locations USING gist (location);
|
||
|
||
-- Name: idx_vehicle_locations_sys_vehicle_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_locations_sys_vehicle_id ON public.vehicle_locations USING btree (vehicle_id);
|
||
|
||
-- Name: idx_vehicle_locations_timestamp; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_locations_timestamp ON public.vehicle_locations USING btree ("timestamp" DESC);
|
||
|
||
-- Name: idx_vehicle_locations_vehicle_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_locations_vehicle_id ON public.vehicle_locations USING btree (vehicle_id);
|
||
|
||
-- Name: idx_vehicle_locations_vehicle_time; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_locations_vehicle_time ON public.vehicle_locations USING btree (vehicle_id, "timestamp" DESC);
|
||
|
||
-- Name: idx_vehicle_trajectories_date; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_trajectories_date ON public.vehicle_trajectories USING btree (trajectory_date DESC);
|
||
|
||
-- Name: idx_vehicle_trajectories_line_gist; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_trajectories_line_gist ON public.vehicle_trajectories USING gist (trajectory_line);
|
||
|
||
-- Name: idx_vehicle_trajectories_vehicle_id; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX idx_vehicle_trajectories_vehicle_id ON public.vehicle_trajectories USING btree (vehicle_id);
|
||
|
||
-- Name: sched_name; Type: INDEX; Schema: public; Owner:
|
||
CREATE INDEX sched_name ON public.qrtz_triggers USING btree (sched_name, job_name, job_group);
|
||
|
||
-- Name: transport_routes trigger_transport_routes_updated_at; Type: TRIGGER; Schema: public; Owner:
|
||
CREATE TRIGGER trigger_transport_routes_updated_at BEFORE UPDATE ON public.transport_routes FOR EACH ROW EXECUTE FUNCTION public.update_timestamp_column();
|
||
|
||
-- Name: vehicle_locations trigger_vehicle_locations_updated_at; Type: TRIGGER; Schema: public; Owner:
|
||
CREATE TRIGGER trigger_vehicle_locations_updated_at BEFORE UPDATE ON public.vehicle_locations FOR EACH ROW EXECUTE FUNCTION public.update_updated_at_column();
|
||
|
||
-- Name: qrtz_blob_triggers QRTZ_BLOB_TRIGGERS_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_blob_triggers
|
||
ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_ibfk_1" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_cron_triggers QRTZ_CRON_TRIGGERS_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_cron_triggers
|
||
ADD CONSTRAINT "QRTZ_CRON_TRIGGERS_ibfk_1" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_simple_triggers QRTZ_SIMPLE_TRIGGERS_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_simple_triggers
|
||
ADD CONSTRAINT "QRTZ_SIMPLE_TRIGGERS_ibfk_1" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_simprop_triggers QRTZ_SIMPROP_TRIGGERS_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_simprop_triggers
|
||
ADD CONSTRAINT "QRTZ_SIMPROP_TRIGGERS_ibfk_1" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);
|
||
|
||
-- Name: qrtz_triggers QRTZ_TRIGGERS_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.qrtz_triggers
|
||
ADD CONSTRAINT "QRTZ_TRIGGERS_ibfk_1" FOREIGN KEY (sched_name, job_name, job_group) REFERENCES public.qrtz_job_details(sched_name, job_name, job_group);
|
||
|
||
-- Name: spatial_rule_vehicle_types fk_spatial_rule_vehicle_types_rule; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.spatial_rule_vehicle_types
|
||
ADD CONSTRAINT fk_spatial_rule_vehicle_types_rule FOREIGN KEY (rule_id) REFERENCES public.spatial_rules(rule_id) ON DELETE CASCADE;
|
||
|
||
-- Name: object_route_assignments object_route_assignments_assigned_route_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.object_route_assignments
|
||
ADD CONSTRAINT object_route_assignments_assigned_route_id_fkey FOREIGN KEY (assigned_route_id) REFERENCES public.transport_routes(id);
|
||
|
||
-- Name: sys_driver_info sys_driver_info_fk1; Type: FK CONSTRAINT; Schema: public; Owner:
|
||
ALTER TABLE ONLY public.sys_driver_info
|
||
ADD CONSTRAINT sys_driver_info_fk1 FOREIGN KEY (user_id) REFERENCES public.sys_user(user_id);
|
||
|
||
|
||
--
|
||
-- PostgreSQL database dump complete
|
||
--
|
||
|