-- -- PostgreSQL database dump -- \restrict swEXqwojduBDQKpOx6Q25cRqHXnmaoe4Lr0hssIzgdaajrTqce9nudi6lVrIVLR -- Dumped from database version 18.3 (Debian 18.3-1.pgdg13+1) -- Dumped by pg_dump version 18.3 (Debian 18.3-1.pgdg13+1) 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; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: app_portal; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.app_portal ( name character varying(64) NOT NULL, access_url character varying(500) NOT NULL, icon_url character varying(300), id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.app_portal OWNER TO admin; -- -- Name: TABLE app_portal; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.app_portal IS '门户应用'; -- -- Name: COLUMN app_portal.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.name IS '应用名称'; -- -- Name: COLUMN app_portal.access_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.access_url IS '访问地址'; -- -- Name: COLUMN app_portal.icon_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.icon_url IS '应用图标URL'; -- -- Name: COLUMN app_portal.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.id IS '主键ID'; -- -- Name: COLUMN app_portal.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN app_portal.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN app_portal.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.description IS '备注/描述'; -- -- Name: COLUMN app_portal.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.created_time IS '创建时间'; -- -- Name: COLUMN app_portal.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.updated_time IS '更新时间'; -- -- Name: COLUMN app_portal.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.tenant_id IS '租户ID'; -- -- Name: COLUMN app_portal.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.created_id IS '创建人ID'; -- -- Name: COLUMN app_portal.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.app_portal.updated_id IS '更新人ID'; -- -- Name: app_portal_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.app_portal_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.app_portal_id_seq OWNER TO admin; -- -- Name: app_portal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.app_portal_id_seq OWNED BY public.app_portal.id; -- -- Name: apscheduler_jobs; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.apscheduler_jobs ( id character varying(191) NOT NULL, next_run_time double precision, job_state bytea NOT NULL ); ALTER TABLE public.apscheduler_jobs OWNER TO admin; -- -- Name: gen_demo; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.gen_demo ( name character varying(64) NOT NULL, a integer, b bigint, c double precision, d boolean NOT NULL, e date, f time without time zone, g timestamp without time zone, h text, i json, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.gen_demo OWNER TO admin; -- -- Name: TABLE gen_demo; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.gen_demo IS '示例表'; -- -- Name: COLUMN gen_demo.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.name IS '名称'; -- -- Name: COLUMN gen_demo.a; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.a IS '整数'; -- -- Name: COLUMN gen_demo.b; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.b IS '大整数'; -- -- Name: COLUMN gen_demo.c; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.c IS '浮点数'; -- -- Name: COLUMN gen_demo.d; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.d IS '布尔型'; -- -- Name: COLUMN gen_demo.e; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.e IS '日期'; -- -- Name: COLUMN gen_demo.f; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.f IS '时间'; -- -- Name: COLUMN gen_demo.g; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.g IS '日期时间'; -- -- Name: COLUMN gen_demo.h; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.h IS '长文本'; -- -- Name: COLUMN gen_demo.i; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.i IS '元数据(JSON格式)'; -- -- Name: COLUMN gen_demo.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.id IS '主键ID'; -- -- Name: COLUMN gen_demo.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN gen_demo.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN gen_demo.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.description IS '备注/描述'; -- -- Name: COLUMN gen_demo.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.created_time IS '创建时间'; -- -- Name: COLUMN gen_demo.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.updated_time IS '更新时间'; -- -- Name: COLUMN gen_demo.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.created_id IS '创建人ID'; -- -- Name: COLUMN gen_demo.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo.updated_id IS '更新人ID'; -- -- Name: gen_demo01; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.gen_demo01 ( name character varying(64) NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.gen_demo01 OWNER TO admin; -- -- Name: TABLE gen_demo01; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.gen_demo01 IS '示例1表'; -- -- Name: COLUMN gen_demo01.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.name IS '名称'; -- -- Name: COLUMN gen_demo01.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.id IS '主键ID'; -- -- Name: COLUMN gen_demo01.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN gen_demo01.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN gen_demo01.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.description IS '备注/描述'; -- -- Name: COLUMN gen_demo01.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.created_time IS '创建时间'; -- -- Name: COLUMN gen_demo01.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.updated_time IS '更新时间'; -- -- Name: COLUMN gen_demo01.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.created_id IS '创建人ID'; -- -- Name: COLUMN gen_demo01.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_demo01.updated_id IS '更新人ID'; -- -- Name: gen_demo01_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.gen_demo01_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.gen_demo01_id_seq OWNER TO admin; -- -- Name: gen_demo01_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.gen_demo01_id_seq OWNED BY public.gen_demo01.id; -- -- Name: gen_demo_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.gen_demo_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.gen_demo_id_seq OWNER TO admin; -- -- Name: gen_demo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.gen_demo_id_seq OWNED BY public.gen_demo.id; -- -- Name: gen_table; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.gen_table ( table_name character varying(200) NOT NULL, table_comment character varying(500), class_name character varying(100) NOT NULL, package_name character varying(100), module_name character varying(30), business_name character varying(30), function_name character varying(100), sub_table_name character varying(64) DEFAULT NULL::character varying, sub_table_fk_name character varying(64) DEFAULT NULL::character varying, parent_menu_id integer, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.gen_table OWNER TO admin; -- -- Name: TABLE gen_table; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.gen_table IS '代码生成表'; -- -- Name: COLUMN gen_table.table_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.table_name IS '表名称'; -- -- Name: COLUMN gen_table.table_comment; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.table_comment IS '表描述'; -- -- Name: COLUMN gen_table.class_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.class_name IS '实体类名称'; -- -- Name: COLUMN gen_table.package_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.package_name IS '生成包路径'; -- -- Name: COLUMN gen_table.module_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.module_name IS '生成模块名'; -- -- Name: COLUMN gen_table.business_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.business_name IS '生成业务名'; -- -- Name: COLUMN gen_table.function_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.function_name IS '生成功能名'; -- -- Name: COLUMN gen_table.sub_table_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.sub_table_name IS '关联子表的表名'; -- -- Name: COLUMN gen_table.sub_table_fk_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.sub_table_fk_name IS '子表关联的外键名'; -- -- Name: COLUMN gen_table.parent_menu_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.parent_menu_id IS '父菜单ID'; -- -- Name: COLUMN gen_table.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.id IS '主键ID'; -- -- Name: COLUMN gen_table.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN gen_table.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN gen_table.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.description IS '备注/描述'; -- -- Name: COLUMN gen_table.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.created_time IS '创建时间'; -- -- Name: COLUMN gen_table.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.updated_time IS '更新时间'; -- -- Name: COLUMN gen_table.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.created_id IS '创建人ID'; -- -- Name: COLUMN gen_table.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table.updated_id IS '更新人ID'; -- -- Name: gen_table_column; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.gen_table_column ( column_name character varying(200) NOT NULL, column_comment character varying(500), column_type character varying(100) NOT NULL, column_length character varying(50), column_default character varying(200), is_pk boolean DEFAULT false NOT NULL, is_increment boolean DEFAULT false NOT NULL, is_nullable boolean DEFAULT true NOT NULL, is_unique boolean DEFAULT false NOT NULL, python_type character varying(100), python_field character varying(200), is_insert boolean DEFAULT true NOT NULL, is_edit boolean DEFAULT true NOT NULL, is_list boolean DEFAULT true NOT NULL, is_query boolean DEFAULT false NOT NULL, query_type character varying(50), html_type character varying(100), dict_type character varying(200), sort integer NOT NULL, table_id integer NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.gen_table_column OWNER TO admin; -- -- Name: TABLE gen_table_column; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.gen_table_column IS '代码生成表字段'; -- -- Name: COLUMN gen_table_column.column_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.column_name IS '列名称'; -- -- Name: COLUMN gen_table_column.column_comment; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.column_comment IS '列描述'; -- -- Name: COLUMN gen_table_column.column_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.column_type IS '列类型'; -- -- Name: COLUMN gen_table_column.column_length; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.column_length IS '列长度'; -- -- Name: COLUMN gen_table_column.column_default; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.column_default IS '列默认值'; -- -- Name: COLUMN gen_table_column.is_pk; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_pk IS '是否主键'; -- -- Name: COLUMN gen_table_column.is_increment; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_increment IS '是否自增'; -- -- Name: COLUMN gen_table_column.is_nullable; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_nullable IS '是否允许为空'; -- -- Name: COLUMN gen_table_column.is_unique; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_unique IS '是否唯一'; -- -- Name: COLUMN gen_table_column.python_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.python_type IS 'Python类型'; -- -- Name: COLUMN gen_table_column.python_field; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.python_field IS 'Python字段名'; -- -- Name: COLUMN gen_table_column.is_insert; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_insert IS '是否为新增字段'; -- -- Name: COLUMN gen_table_column.is_edit; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_edit IS '是否编辑字段'; -- -- Name: COLUMN gen_table_column.is_list; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_list IS '是否列表字段'; -- -- Name: COLUMN gen_table_column.is_query; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.is_query IS '是否查询字段'; -- -- Name: COLUMN gen_table_column.query_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.query_type IS '查询方式'; -- -- Name: COLUMN gen_table_column.html_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.html_type IS '显示类型'; -- -- Name: COLUMN gen_table_column.dict_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.dict_type IS '字典类型'; -- -- Name: COLUMN gen_table_column.sort; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.sort IS '排序'; -- -- Name: COLUMN gen_table_column.table_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.table_id IS '归属表编号'; -- -- Name: COLUMN gen_table_column.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.id IS '主键ID'; -- -- Name: COLUMN gen_table_column.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN gen_table_column.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN gen_table_column.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.description IS '备注/描述'; -- -- Name: COLUMN gen_table_column.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.created_time IS '创建时间'; -- -- Name: COLUMN gen_table_column.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.updated_time IS '更新时间'; -- -- Name: COLUMN gen_table_column.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.created_id IS '创建人ID'; -- -- Name: COLUMN gen_table_column.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.gen_table_column.updated_id IS '更新人ID'; -- -- Name: gen_table_column_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.gen_table_column_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.gen_table_column_id_seq OWNER TO admin; -- -- Name: gen_table_column_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.gen_table_column_id_seq OWNED BY public.gen_table_column.id; -- -- Name: gen_table_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.gen_table_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.gen_table_id_seq OWNER TO admin; -- -- Name: gen_table_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.gen_table_id_seq OWNED BY public.gen_table.id; -- -- Name: open_conf; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.open_conf ( app_id character varying(64) NOT NULL, private_key character varying(2048), public_key character varying(2048), gateway_url character varying(256), sign_type character varying(32), charset character varying(32), format character varying(32), notify_url character varying(512), return_url character varying(512), app_cert_sn character varying(64), alipay_root_cert_sn character varying(64), encrypt_key character varying(64), status character varying(16) NOT NULL, description character varying(256), id bigint NOT NULL, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL ); ALTER TABLE public.open_conf OWNER TO admin; -- -- Name: TABLE open_conf; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.open_conf IS '三方配置表'; -- -- Name: COLUMN open_conf.app_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.app_id IS '应用ID'; -- -- Name: COLUMN open_conf.private_key; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.private_key IS '应用私钥(PKCS8格式)'; -- -- Name: COLUMN open_conf.public_key; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.public_key IS '平台公钥'; -- -- Name: COLUMN open_conf.gateway_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.gateway_url IS '支付宝网关地址'; -- -- Name: COLUMN open_conf.sign_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.sign_type IS '签名类型: RSA/RSA2'; -- -- Name: COLUMN open_conf.charset; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.charset IS '字符编码'; -- -- Name: COLUMN open_conf.format; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.format IS '数据格式'; -- -- Name: COLUMN open_conf.notify_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.notify_url IS '异步通知地址'; -- -- Name: COLUMN open_conf.return_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.return_url IS '同步返回地址'; -- -- Name: COLUMN open_conf.app_cert_sn; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.app_cert_sn IS '应用证书序列号'; -- -- Name: COLUMN open_conf.alipay_root_cert_sn; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.alipay_root_cert_sn IS '支付宝根证书序列号'; -- -- Name: COLUMN open_conf.encrypt_key; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.encrypt_key IS 'AES加密密钥'; -- -- Name: COLUMN open_conf.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.status IS '状态: ENABLED/DISABLED'; -- -- Name: COLUMN open_conf.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.description IS '配置描述'; -- -- Name: COLUMN open_conf.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.id IS '主键ID'; -- -- Name: COLUMN open_conf.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.created_time IS '创建时间'; -- -- Name: COLUMN open_conf.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.updated_time IS '更新时间'; -- -- Name: COLUMN open_conf.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_conf.tenant_id IS '租户ID'; -- -- Name: open_conf_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.open_conf_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.open_conf_id_seq OWNER TO admin; -- -- Name: open_conf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.open_conf_id_seq OWNED BY public.open_conf.id; -- -- Name: open_transfer; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.open_transfer ( third_biz_no character varying(64) NOT NULL, out_biz_no character varying(64) NOT NULL, id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64), api_key character varying(256) ); ALTER TABLE public.open_transfer OWNER TO admin; -- -- Name: TABLE open_transfer; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.open_transfer IS '三方转账表'; -- -- Name: COLUMN open_transfer.third_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.third_biz_no IS '三方订单号'; -- -- Name: COLUMN open_transfer.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.out_biz_no IS '平台订单号'; -- -- Name: COLUMN open_transfer.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.id IS '主键ID'; -- -- Name: COLUMN open_transfer.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN open_transfer.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.description IS '备注/描述'; -- -- Name: COLUMN open_transfer.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.created_time IS '创建时间'; -- -- Name: COLUMN open_transfer.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.updated_time IS '更新时间'; -- -- Name: COLUMN open_transfer.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.tenant_id IS '租户ID'; -- -- Name: COLUMN open_transfer.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.enterprise_id IS '企业ID'; -- -- Name: COLUMN open_transfer.api_key; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.open_transfer.api_key IS 'API Key'; -- -- Name: open_transfer_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.open_transfer_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.open_transfer_id_seq OWNER TO admin; -- -- Name: open_transfer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.open_transfer_id_seq OWNED BY public.open_transfer.id; -- -- Name: pay_account; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_account ( account_book_id character varying(64), account_name character varying(128), account_type character varying(32), scene character varying(32) NOT NULL, sign_status character varying(32) NOT NULL, sign_time timestamp without time zone, status character varying(32) NOT NULL, remark text, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_account OWNER TO admin; -- -- Name: TABLE pay_account; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_account IS '资金专户表'; -- -- Name: COLUMN pay_account.account_book_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.account_book_id IS '资金专户号'; -- -- Name: COLUMN pay_account.account_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.account_name IS '账户名称'; -- -- Name: COLUMN pay_account.account_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.account_type IS '账户类型: INCOME/DISBURSE/ALL'; -- -- Name: COLUMN pay_account.scene; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.scene IS '应用场景码: ENT_CREDIT/B2B_TRANS'; -- -- Name: COLUMN pay_account.sign_status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.sign_status IS '签约状态: PENDING/AUTHORIZED/AUTHORIZE_FAILED/UNAUTHORIZED'; -- -- Name: COLUMN pay_account.sign_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.sign_time IS '签约时间'; -- -- Name: COLUMN pay_account.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.status IS '专户状态: ACTIVE/FROZEN/CLOSED'; -- -- Name: COLUMN pay_account.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.remark IS '备注'; -- -- Name: COLUMN pay_account.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.id IS '主键ID'; -- -- Name: COLUMN pay_account.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.description IS '备注/描述'; -- -- Name: COLUMN pay_account.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.created_time IS '创建时间'; -- -- Name: COLUMN pay_account.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.updated_time IS '更新时间'; -- -- Name: COLUMN pay_account.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_account.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_account.enterprise_id IS '企业ID'; -- -- Name: pay_account_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_account_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_account_id_seq OWNER TO admin; -- -- Name: pay_account_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_account_id_seq OWNED BY public.pay_account.id; -- -- Name: pay_alipay_notify_log; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_alipay_notify_log ( notify_id character varying(50) NOT NULL, msg_method character varying(100) NOT NULL, notify_type character varying(100), message json NOT NULL, verify_result boolean NOT NULL, process_result boolean, error text, received_at timestamp without time zone NOT NULL, id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.pay_alipay_notify_log OWNER TO admin; -- -- Name: TABLE pay_alipay_notify_log; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_alipay_notify_log IS '支付宝通知日志表'; -- -- Name: COLUMN pay_alipay_notify_log.notify_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.notify_id IS '通知ID'; -- -- Name: COLUMN pay_alipay_notify_log.msg_method; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.msg_method IS '消息接口名称'; -- -- Name: COLUMN pay_alipay_notify_log.notify_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.notify_type IS '通知类型'; -- -- Name: COLUMN pay_alipay_notify_log.message; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.message IS '完整的消息数据'; -- -- Name: COLUMN pay_alipay_notify_log.verify_result; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.verify_result IS '验签结果'; -- -- Name: COLUMN pay_alipay_notify_log.process_result; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.process_result IS '处理结果'; -- -- Name: COLUMN pay_alipay_notify_log.error; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.error IS '错误信息'; -- -- Name: COLUMN pay_alipay_notify_log.received_at; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.received_at IS '接收时间'; -- -- Name: COLUMN pay_alipay_notify_log.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.id IS '主键ID'; -- -- Name: COLUMN pay_alipay_notify_log.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN pay_alipay_notify_log.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.description IS '备注/描述'; -- -- Name: COLUMN pay_alipay_notify_log.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.created_time IS '创建时间'; -- -- Name: COLUMN pay_alipay_notify_log.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_alipay_notify_log.updated_time IS '更新时间'; -- -- Name: pay_alipay_notify_log_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_alipay_notify_log_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_alipay_notify_log_id_seq OWNER TO admin; -- -- Name: pay_alipay_notify_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_alipay_notify_log_id_seq OWNED BY public.pay_alipay_notify_log.id; -- -- Name: pay_bill; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_bill ( pay_no character varying(64) NOT NULL, account_id character varying(64) NOT NULL, employee_id character varying(64) NOT NULL, consume_type character varying(32) NOT NULL, consume_amount numeric(12,2) NOT NULL, gmt_biz_create timestamp without time zone NOT NULL, gmt_recieve_pay timestamp without time zone, peer_pay_amount numeric(12,2), notify_reason character varying(255) NOT NULL, notify_msg text, related_pay_no character varying(64), expense_rule_group_id character varying(64), expense_scene_code character varying(32), expense_type character varying(64), status character varying(32) NOT NULL, ext_infos json, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_bill OWNER TO admin; -- -- Name: TABLE pay_bill; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_bill IS '企业码账单表'; -- -- Name: COLUMN pay_bill.pay_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.pay_no IS '支付宝账单号'; -- -- Name: COLUMN pay_bill.account_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.account_id IS '共同账户ID'; -- -- Name: COLUMN pay_bill.employee_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.employee_id IS '员工ID'; -- -- Name: COLUMN pay_bill.consume_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.consume_type IS '账单类型: CONSUME/REFUND/TRANSFER'; -- -- Name: COLUMN pay_bill.consume_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.consume_amount IS '账单金额'; -- -- Name: COLUMN pay_bill.gmt_biz_create; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.gmt_biz_create IS '账单创建时间'; -- -- Name: COLUMN pay_bill.gmt_recieve_pay; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.gmt_recieve_pay IS '支付时间'; -- -- Name: COLUMN pay_bill.peer_pay_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.peer_pay_amount IS '企业代付金额'; -- -- Name: COLUMN pay_bill.notify_reason; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.notify_reason IS '通知原因'; -- -- Name: COLUMN pay_bill.notify_msg; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.notify_msg IS '通知描述'; -- -- Name: COLUMN pay_bill.related_pay_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.related_pay_no IS '关联账单号'; -- -- Name: COLUMN pay_bill.expense_rule_group_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.expense_rule_group_id IS '费控规则ID'; -- -- Name: COLUMN pay_bill.expense_scene_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.expense_scene_code IS '费用场景'; -- -- Name: COLUMN pay_bill.expense_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.expense_type IS '费用类型'; -- -- Name: COLUMN pay_bill.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.status IS '状态: NEW/PROCESSED/FAILED'; -- -- Name: COLUMN pay_bill.ext_infos; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.ext_infos IS '扩展信息'; -- -- Name: COLUMN pay_bill.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.id IS '主键ID'; -- -- Name: COLUMN pay_bill.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.description IS '备注/描述'; -- -- Name: COLUMN pay_bill.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.created_time IS '创建时间'; -- -- Name: COLUMN pay_bill.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.updated_time IS '更新时间'; -- -- Name: COLUMN pay_bill.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_bill.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill.enterprise_id IS '企业ID'; -- -- Name: pay_bill_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_bill_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_bill_id_seq OWNER TO admin; -- -- Name: pay_bill_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_bill_id_seq OWNED BY public.pay_bill.id; -- -- Name: pay_bill_order; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_bill_order ( pay_no character varying(64) NOT NULL, order_no character varying(64) NOT NULL, trade_no character varying(64), product_code character varying(64), order_title character varying(255), order_amount numeric(12,2), order_status character varying(32), merchant_name character varying(255), merchant_id character varying(64), shop_name character varying(255), gmt_payment timestamp without time zone, fund_channel character varying(64), id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_bill_order OWNER TO admin; -- -- Name: TABLE pay_bill_order; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_bill_order IS '账单订单明细表'; -- -- Name: COLUMN pay_bill_order.pay_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.pay_no IS '关联账单号'; -- -- Name: COLUMN pay_bill_order.order_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.order_no IS '支付宝订单号'; -- -- Name: COLUMN pay_bill_order.trade_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.trade_no IS '支付宝交易号'; -- -- Name: COLUMN pay_bill_order.product_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.product_code IS '产品码'; -- -- Name: COLUMN pay_bill_order.order_title; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.order_title IS '订单标题'; -- -- Name: COLUMN pay_bill_order.order_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.order_amount IS '订单金额'; -- -- Name: COLUMN pay_bill_order.order_status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.order_status IS '订单状态'; -- -- Name: COLUMN pay_bill_order.merchant_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.merchant_name IS '商户名称'; -- -- Name: COLUMN pay_bill_order.merchant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.merchant_id IS '商户ID'; -- -- Name: COLUMN pay_bill_order.shop_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.shop_name IS '门店名称'; -- -- Name: COLUMN pay_bill_order.gmt_payment; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.gmt_payment IS '支付时间'; -- -- Name: COLUMN pay_bill_order.fund_channel; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.fund_channel IS '资金渠道'; -- -- Name: COLUMN pay_bill_order.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.id IS '主键ID'; -- -- Name: COLUMN pay_bill_order.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN pay_bill_order.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.description IS '备注/描述'; -- -- Name: COLUMN pay_bill_order.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.created_time IS '创建时间'; -- -- Name: COLUMN pay_bill_order.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.updated_time IS '更新时间'; -- -- Name: COLUMN pay_bill_order.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_bill_order.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_order.enterprise_id IS '企业ID'; -- -- Name: pay_bill_order_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_bill_order_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_bill_order_id_seq OWNER TO admin; -- -- Name: pay_bill_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_bill_order_id_seq OWNED BY public.pay_bill_order.id; -- -- Name: pay_bill_voucher; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_bill_voucher ( pay_no character varying(64) NOT NULL, voucher_id character varying(64) NOT NULL, voucher_type character varying(32), voucher_status character varying(32), invoice_code character varying(64), invoice_no character varying(64), invoice_amount numeric(12,2), tax_amount numeric(12,2), issue_date timestamp without time zone, check_code character varying(64), pdf_url text, id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_bill_voucher OWNER TO admin; -- -- Name: TABLE pay_bill_voucher; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_bill_voucher IS '账单凭证信息表'; -- -- Name: COLUMN pay_bill_voucher.pay_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.pay_no IS '关联账单号'; -- -- Name: COLUMN pay_bill_voucher.voucher_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.voucher_id IS '凭证ID'; -- -- Name: COLUMN pay_bill_voucher.voucher_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.voucher_type IS '凭证类型'; -- -- Name: COLUMN pay_bill_voucher.voucher_status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.voucher_status IS '凭证状态'; -- -- Name: COLUMN pay_bill_voucher.invoice_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.invoice_code IS '发票代码'; -- -- Name: COLUMN pay_bill_voucher.invoice_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.invoice_no IS '发票号码'; -- -- Name: COLUMN pay_bill_voucher.invoice_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.invoice_amount IS '发票金额'; -- -- Name: COLUMN pay_bill_voucher.tax_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.tax_amount IS '税额'; -- -- Name: COLUMN pay_bill_voucher.issue_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.issue_date IS '开票日期'; -- -- Name: COLUMN pay_bill_voucher.check_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.check_code IS '校验码'; -- -- Name: COLUMN pay_bill_voucher.pdf_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.pdf_url IS 'PDF下载地址'; -- -- Name: COLUMN pay_bill_voucher.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.id IS '主键ID'; -- -- Name: COLUMN pay_bill_voucher.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN pay_bill_voucher.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.description IS '备注/描述'; -- -- Name: COLUMN pay_bill_voucher.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.created_time IS '创建时间'; -- -- Name: COLUMN pay_bill_voucher.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.updated_time IS '更新时间'; -- -- Name: COLUMN pay_bill_voucher.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_bill_voucher.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_bill_voucher.enterprise_id IS '企业ID'; -- -- Name: pay_bill_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_bill_voucher_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_bill_voucher_id_seq OWNER TO admin; -- -- Name: pay_bill_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_bill_voucher_id_seq OWNED BY public.pay_bill_voucher.id; -- -- Name: pay_department; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_department ( id integer NOT NULL, department_id character varying(64) NOT NULL, department_name character varying(128) NOT NULL, department_code character varying(64), parent_department_id character varying(64), status character varying(32) NOT NULL, sort_order integer, leader_employee_id character varying(64), leader_employee_name character varying(128), created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, description text, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_department OWNER TO admin; -- -- Name: TABLE pay_department; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_department IS '部门表'; -- -- Name: COLUMN pay_department.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.id IS '主键ID'; -- -- Name: COLUMN pay_department.department_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.department_id IS '部门ID'; -- -- Name: COLUMN pay_department.department_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.department_name IS '部门名称'; -- -- Name: COLUMN pay_department.department_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.department_code IS '部门编码'; -- -- Name: COLUMN pay_department.parent_department_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.parent_department_id IS '上级部门ID'; -- -- Name: COLUMN pay_department.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.status IS '状态'; -- -- Name: COLUMN pay_department.sort_order; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.sort_order IS '排序值'; -- -- Name: COLUMN pay_department.leader_employee_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.leader_employee_id IS '部门负责人ID'; -- -- Name: COLUMN pay_department.leader_employee_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.leader_employee_name IS '部门负责人姓名'; -- -- Name: COLUMN pay_department.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.created_time IS '创建时间'; -- -- Name: COLUMN pay_department.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.updated_time IS '更新时间'; -- -- Name: COLUMN pay_department.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.description IS '备注/描述'; -- -- Name: COLUMN pay_department.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_department.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_department.enterprise_id IS '企业ID'; -- -- Name: pay_department_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_department_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_department_id_seq OWNER TO admin; -- -- Name: pay_department_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_department_id_seq OWNED BY public.pay_department.id; -- -- Name: pay_deposit; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_deposit ( out_biz_no character varying(64), account_book_id character varying(64), amount numeric(12,2), url text, status character varying(32) NOT NULL, notify_content json, remark text, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_deposit OWNER TO admin; -- -- Name: TABLE pay_deposit; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_deposit IS '充值记录表'; -- -- Name: COLUMN pay_deposit.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.out_biz_no IS '商家侧订单号'; -- -- Name: COLUMN pay_deposit.account_book_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.account_book_id IS '资金专户号'; -- -- Name: COLUMN pay_deposit.amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.amount IS '充值金额'; -- -- Name: COLUMN pay_deposit.url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.url IS '充值确认页面URL'; -- -- Name: COLUMN pay_deposit.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.status IS '充值状态: DEALING/SUCCESS/FAIL'; -- -- Name: COLUMN pay_deposit.notify_content; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.notify_content IS '通知内容原始数据'; -- -- Name: COLUMN pay_deposit.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.remark IS '备注'; -- -- Name: COLUMN pay_deposit.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.id IS '主键ID'; -- -- Name: COLUMN pay_deposit.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.description IS '备注/描述'; -- -- Name: COLUMN pay_deposit.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.created_time IS '创建时间'; -- -- Name: COLUMN pay_deposit.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.updated_time IS '更新时间'; -- -- Name: COLUMN pay_deposit.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_deposit.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_deposit.enterprise_id IS '企业ID'; -- -- Name: pay_deposit_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_deposit_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_deposit_id_seq OWNER TO admin; -- -- Name: pay_deposit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_deposit_id_seq OWNED BY public.pay_deposit.id; -- -- Name: pay_employee; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_employee ( employee_id character varying(64), employee_name character varying(128), employee_no character varying(64), identity_type character varying(32), identity character varying(64), identity_open_id character varying(128), employee_mobile character varying(32), employee_email character varying(128), employee_cert_type character varying(32), employee_cert_no character varying(64), status character varying(32) NOT NULL, iot_check_type character varying(64), department_ids json, accounting_entity_ids json, label_names json, sign_return_url text, create_share_code boolean, sign_url_carry_info boolean, sign_url text, share_code character varying(128), iot_unique_id character varying(64), profiles json, withholding_sign_str text, free_sign_token character varying(256), department_list json, role_list json, user_id integer, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_employee OWNER TO admin; -- -- Name: TABLE pay_employee; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_employee IS '员工表'; -- -- Name: COLUMN pay_employee.employee_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_id IS '员工ID(业务主键)'; -- -- Name: COLUMN pay_employee.employee_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_name IS '员工姓名'; -- -- Name: COLUMN pay_employee.employee_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_no IS '员工工号'; -- -- Name: COLUMN pay_employee.identity_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.identity_type IS '身份类型: ALIPAY_USER_ID/ALIPAY_LOGON_ID/ENTERPRISE_USER_ID'; -- -- Name: COLUMN pay_employee.identity; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.identity IS '身份标识'; -- -- Name: COLUMN pay_employee.identity_open_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.identity_open_id IS '员工openId'; -- -- Name: COLUMN pay_employee.employee_mobile; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_mobile IS '员工手机号'; -- -- Name: COLUMN pay_employee.employee_email; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_email IS '员工邮箱'; -- -- Name: COLUMN pay_employee.employee_cert_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_cert_type IS '证件类型: IDENTITY_CARD/PASSPORT/DRIVER_LICENSE'; -- -- Name: COLUMN pay_employee.employee_cert_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.employee_cert_no IS '证件号码'; -- -- Name: COLUMN pay_employee.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.status IS '状态: EMPLOYEE_CREATE/EMPLOYEE_ACTIVATED/EMPLOYEE_UNSIGN'; -- -- Name: COLUMN pay_employee.iot_check_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.iot_check_type IS 'IoT核身方式'; -- -- Name: COLUMN pay_employee.department_ids; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.department_ids IS '部门ID列表'; -- -- Name: COLUMN pay_employee.accounting_entity_ids; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.accounting_entity_ids IS '核算主体ID列表'; -- -- Name: COLUMN pay_employee.label_names; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.label_names IS '标签名称列表'; -- -- Name: COLUMN pay_employee.sign_return_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.sign_return_url IS '签约跳转URL'; -- -- Name: COLUMN pay_employee.create_share_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.create_share_code IS '是否创建分享码'; -- -- Name: COLUMN pay_employee.sign_url_carry_info; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.sign_url_carry_info IS '签约链接是否携带信息'; -- -- Name: COLUMN pay_employee.sign_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.sign_url IS '邀请链接'; -- -- Name: COLUMN pay_employee.share_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.share_code IS '分享码'; -- -- Name: COLUMN pay_employee.iot_unique_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.iot_unique_id IS 'IoT唯一标识'; -- -- Name: COLUMN pay_employee.profiles; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.profiles IS '扩展参数'; -- -- Name: COLUMN pay_employee.withholding_sign_str; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.withholding_sign_str IS '代扣签约串'; -- -- Name: COLUMN pay_employee.free_sign_token; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.free_sign_token IS '免登签约token'; -- -- Name: COLUMN pay_employee.department_list; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.department_list IS '部门列表'; -- -- Name: COLUMN pay_employee.role_list; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.role_list IS '角色列表'; -- -- Name: COLUMN pay_employee.user_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.user_id IS '关联的系统用户ID'; -- -- Name: COLUMN pay_employee.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.id IS '主键ID'; -- -- Name: COLUMN pay_employee.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.description IS '备注/描述'; -- -- Name: COLUMN pay_employee.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.created_time IS '创建时间'; -- -- Name: COLUMN pay_employee.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.updated_time IS '更新时间'; -- -- Name: COLUMN pay_employee.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_employee.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_employee.enterprise_id IS '企业ID'; -- -- Name: pay_employee_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_employee_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_employee_id_seq OWNER TO admin; -- -- Name: pay_employee_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_employee_id_seq OWNED BY public.pay_employee.id; -- -- Name: pay_enterprise; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_enterprise ( enterprise_id character varying(64), out_biz_no character varying(64), account_id character varying(64), name character varying(128), short_name character varying(64), status character varying(32) NOT NULL, sign_url text, pc_invite_url text, invite_time timestamp without time zone, expire_time timestamp without time zone, identity_type character varying(64), identity character varying(64), identity_open_id character varying(128), register_mode character varying(32), sign_fund_way character varying(32), base_info json, profiles json, remark text, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, service_provider_id bigint, scope_label character varying(64), business_license character varying(500), business_scenario text, business_contracts text, legal_rep_id_photo character varying(500), wanlihui_uid character varying(128) ); ALTER TABLE public.pay_enterprise OWNER TO admin; -- -- Name: TABLE pay_enterprise; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_enterprise IS '企业表'; -- -- Name: COLUMN pay_enterprise.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.enterprise_id IS '企业ID(业务主键)'; -- -- Name: COLUMN pay_enterprise.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.out_biz_no IS '外部业务号'; -- -- Name: COLUMN pay_enterprise.account_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.account_id IS '支付宝账号ID(签约后获取)'; -- -- Name: COLUMN pay_enterprise.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.name IS '企业名称'; -- -- Name: COLUMN pay_enterprise.short_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.short_name IS '企业简称'; -- -- Name: COLUMN pay_enterprise.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.status IS '状态: ENTERPRISE_APPLICATION/ENTERPRISE_CREATE/ENTERPRISE_ACTIVATED/ENTERPRISE_UNSIGN/ENTERPRISE_WITHDRAW/ENTERPRISE_AUTH/ENTERPRISE_AUTH_REJECTED'; -- -- Name: COLUMN pay_enterprise.sign_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.sign_url IS '签约链接'; -- -- Name: COLUMN pay_enterprise.pc_invite_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.pc_invite_url IS '邀请URL'; -- -- Name: COLUMN pay_enterprise.invite_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.invite_time IS '邀请码创建时间'; -- -- Name: COLUMN pay_enterprise.expire_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.expire_time IS '链接过期时间'; -- -- Name: COLUMN pay_enterprise.identity_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.identity_type IS '企业管理员身份类型: ALIPAY_USER_ID/ALIPAY_LOGON_ID/ISV_USER_ID'; -- -- Name: COLUMN pay_enterprise.identity; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.identity IS '企业管理员身份标识'; -- -- Name: COLUMN pay_enterprise.identity_open_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.identity_open_id IS '企业管理员openId'; -- -- Name: COLUMN pay_enterprise.register_mode; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.register_mode IS '注册模式: NORMAL/ISV_AGENT/ISV_VIRTUAL'; -- -- Name: COLUMN pay_enterprise.sign_fund_way; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.sign_fund_way IS '签约出资方式: BALANCE/CREDIT/CORPORATE_CARD/ENT_FA_EXPRESS/GEN_PER_ADV_PAY/CARD_PAY_LEDGER/PER_ALI_CREDIT'; -- -- Name: COLUMN pay_enterprise.base_info; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.base_info IS '企业基本信息: industry/enterprise_code/enterprise_name'; -- -- Name: COLUMN pay_enterprise.profiles; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.profiles IS '扩展参数: group_app_id/access_channel等'; -- -- Name: COLUMN pay_enterprise.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.remark IS '备注'; -- -- Name: COLUMN pay_enterprise.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.id IS '主键ID'; -- -- Name: COLUMN pay_enterprise.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.description IS '备注/描述'; -- -- Name: COLUMN pay_enterprise.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.created_time IS '创建时间'; -- -- Name: COLUMN pay_enterprise.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.updated_time IS '更新时间'; -- -- Name: COLUMN pay_enterprise.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_enterprise.tenant_id IS '租户ID'; -- -- Name: pay_enterprise_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_enterprise_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_enterprise_id_seq OWNER TO admin; -- -- Name: pay_enterprise_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_enterprise_id_seq OWNED BY public.pay_enterprise.id; -- -- Name: pay_expense_institution; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_expense_institution ( institution_id character varying(64), institution_name character varying(128), institution_desc text, scene_type character varying(32), expense_type character varying(32) NOT NULL, expense_sub_type character varying(32) NOT NULL, status character varying(32) NOT NULL, effective character varying(32), effective_start_date timestamp without time zone, effective_end_date timestamp without time zone, consult_mode character varying(32), multi_employee_share_mode character varying(32), currency character varying(32), id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64), grant_mode character varying(32), period_type character varying(32), amount numeric(12,2) DEFAULT 0, single_limit numeric(12,2) DEFAULT 0, effective_time_type character varying(32) DEFAULT 'unlimited'::character varying, applicable_scope character varying(32) DEFAULT 'none'::character varying ); ALTER TABLE public.pay_expense_institution OWNER TO admin; -- -- Name: TABLE pay_expense_institution; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_expense_institution IS '费控制度表'; -- -- Name: COLUMN pay_expense_institution.institution_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.institution_id IS '费控规则ID(创建后获取)'; -- -- Name: COLUMN pay_expense_institution.institution_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.institution_name IS '制度名称'; -- -- Name: COLUMN pay_expense_institution.institution_desc; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.institution_desc IS '制度描述'; -- -- Name: COLUMN pay_expense_institution.scene_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.scene_type IS '因公场景'; -- -- Name: COLUMN pay_expense_institution.expense_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.expense_type IS '费用类型'; -- -- Name: COLUMN pay_expense_institution.expense_sub_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.expense_sub_type IS '费用类型子类'; -- -- Name: COLUMN pay_expense_institution.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.status IS '状态: INSTITUTION_CREATE/INSTITUTION_EFFECTIVE/INSTITUTION_INVALID'; -- -- Name: COLUMN pay_expense_institution.effective; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.effective IS '是否启用: 0(停用)/1(启用)'; -- -- Name: COLUMN pay_expense_institution.effective_start_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.effective_start_date IS '制度生效起始时间'; -- -- Name: COLUMN pay_expense_institution.effective_end_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.effective_end_date IS '制度生效结束时间'; -- -- Name: COLUMN pay_expense_institution.consult_mode; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.consult_mode IS '费控咨询模式: 0(支付宝内部计算)/1(咨询外部服务商)'; -- -- Name: COLUMN pay_expense_institution.multi_employee_share_mode; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.multi_employee_share_mode IS '多员工分享模式: 0(不分享)/1(分享)'; -- -- Name: COLUMN pay_expense_institution.currency; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.currency IS '货币类型'; -- -- Name: COLUMN pay_expense_institution.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.id IS '主键ID'; -- -- Name: COLUMN pay_expense_institution.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.description IS '备注/描述'; -- -- Name: COLUMN pay_expense_institution.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.created_time IS '创建时间'; -- -- Name: COLUMN pay_expense_institution.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.updated_time IS '更新时间'; -- -- Name: COLUMN pay_expense_institution.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_expense_institution.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_institution.enterprise_id IS '企业ID'; -- -- Name: pay_expense_institution_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_expense_institution_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_expense_institution_id_seq OWNER TO admin; -- -- Name: pay_expense_institution_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_expense_institution_id_seq OWNED BY public.pay_expense_institution.id; -- -- Name: pay_expense_issue_batch; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_expense_issue_batch ( issue_batch_id character varying(64), batch_no character varying(64) NOT NULL, institution_id character varying(64) NOT NULL, issue_name character varying(64) NOT NULL, quota_type character varying(32) NOT NULL, share_mode character varying(8) NOT NULL, total_count integer NOT NULL, total_amount numeric(12,2), status character varying(32) NOT NULL, effective_start_date timestamp without time zone, effective_end_date timestamp without time zone, issue_desc text, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_expense_issue_batch OWNER TO admin; -- -- Name: TABLE pay_expense_issue_batch; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_expense_issue_batch IS '手工发放批次表'; -- -- Name: COLUMN pay_expense_issue_batch.issue_batch_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.issue_batch_id IS '发放批次ID(支付宝返回)'; -- -- Name: COLUMN pay_expense_issue_batch.batch_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.batch_no IS '发放批次号(幂等)'; -- -- Name: COLUMN pay_expense_issue_batch.institution_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.institution_id IS '制度ID'; -- -- Name: COLUMN pay_expense_issue_batch.issue_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.issue_name IS '发放名称'; -- -- Name: COLUMN pay_expense_issue_batch.quota_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.quota_type IS '额度类型'; -- -- Name: COLUMN pay_expense_issue_batch.share_mode; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.share_mode IS '是否可转赠: 0/1'; -- -- Name: COLUMN pay_expense_issue_batch.total_count; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.total_count IS '发放总人数'; -- -- Name: COLUMN pay_expense_issue_batch.total_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.total_amount IS '发放总金额'; -- -- Name: COLUMN pay_expense_issue_batch.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.status IS '状态: ACTIVE/CANCELLED'; -- -- Name: COLUMN pay_expense_issue_batch.effective_start_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.effective_start_date IS '额度有效起始时间'; -- -- Name: COLUMN pay_expense_issue_batch.effective_end_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.effective_end_date IS '额度有效结束时间'; -- -- Name: COLUMN pay_expense_issue_batch.issue_desc; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.issue_desc IS '发放说明'; -- -- Name: COLUMN pay_expense_issue_batch.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.id IS '主键ID'; -- -- Name: COLUMN pay_expense_issue_batch.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.description IS '备注/描述'; -- -- Name: COLUMN pay_expense_issue_batch.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.created_time IS '创建时间'; -- -- Name: COLUMN pay_expense_issue_batch.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.updated_time IS '更新时间'; -- -- Name: COLUMN pay_expense_issue_batch.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_expense_issue_batch.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_issue_batch.enterprise_id IS '企业ID'; -- -- Name: pay_expense_issue_batch_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_expense_issue_batch_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_expense_issue_batch_id_seq OWNER TO admin; -- -- Name: pay_expense_issue_batch_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_expense_issue_batch_id_seq OWNED BY public.pay_expense_issue_batch.id; -- -- Name: pay_expense_quota; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_expense_quota ( employee_id character varying(64) NOT NULL, institution_id character varying(64) NOT NULL, out_biz_no character varying(64), quota_id character varying(64), total_amount numeric(12,2), available_amount numeric(12,2), valid_from timestamp without time zone, valid_to timestamp without time zone, status character varying(32) NOT NULL, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64), quota_type character varying(32) DEFAULT 'CAP'::character varying, target_type character varying(32), target_id character varying(64) ); ALTER TABLE public.pay_expense_quota OWNER TO admin; -- -- Name: TABLE pay_expense_quota; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_expense_quota IS '额度表'; -- -- Name: COLUMN pay_expense_quota.employee_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.employee_id IS '员工ID'; -- -- Name: COLUMN pay_expense_quota.institution_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.institution_id IS '制度ID'; -- -- Name: COLUMN pay_expense_quota.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.out_biz_no IS '外部业务编号'; -- -- Name: COLUMN pay_expense_quota.quota_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.quota_id IS '额度ID(支付宝返回)'; -- -- Name: COLUMN pay_expense_quota.total_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.total_amount IS '总金额'; -- -- Name: COLUMN pay_expense_quota.available_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.available_amount IS '可用金额'; -- -- Name: COLUMN pay_expense_quota.valid_from; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.valid_from IS '有效期开始'; -- -- Name: COLUMN pay_expense_quota.valid_to; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.valid_to IS '有效期结束'; -- -- Name: COLUMN pay_expense_quota.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.status IS '状态'; -- -- Name: COLUMN pay_expense_quota.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.id IS '主键ID'; -- -- Name: COLUMN pay_expense_quota.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.description IS '备注/描述'; -- -- Name: COLUMN pay_expense_quota.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.created_time IS '创建时间'; -- -- Name: COLUMN pay_expense_quota.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.updated_time IS '更新时间'; -- -- Name: COLUMN pay_expense_quota.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_expense_quota.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota.enterprise_id IS '企业ID'; -- -- Name: pay_expense_quota_change_log; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_expense_quota_change_log ( quota_id character varying(64) NOT NULL, employee_id character varying(64) NOT NULL, institution_id character varying(64) NOT NULL, change_type character varying(32) NOT NULL, coupon_name character varying(128), change_amount numeric(12,2) NOT NULL, before_amount numeric(12,2), after_amount numeric(12,2), change_desc text, id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64) ); ALTER TABLE public.pay_expense_quota_change_log OWNER TO admin; -- -- Name: TABLE pay_expense_quota_change_log; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_expense_quota_change_log IS '额度变更记录表'; -- -- Name: COLUMN pay_expense_quota_change_log.quota_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.quota_id IS '额度ID'; -- -- Name: COLUMN pay_expense_quota_change_log.employee_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.employee_id IS '员工ID'; -- -- Name: COLUMN pay_expense_quota_change_log.institution_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.institution_id IS '制度ID'; -- -- Name: COLUMN pay_expense_quota_change_log.change_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.change_type IS '变更类型: ISSUE(发放)/ADJUST(调整)/CANCEL(作废)'; -- -- Name: COLUMN pay_expense_quota_change_log.coupon_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.coupon_name IS '点券名称'; -- -- Name: COLUMN pay_expense_quota_change_log.change_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.change_amount IS '变更金额(正为增加，负为减少)'; -- -- Name: COLUMN pay_expense_quota_change_log.before_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.before_amount IS '变更前金额'; -- -- Name: COLUMN pay_expense_quota_change_log.after_amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.after_amount IS '变更后金额'; -- -- Name: COLUMN pay_expense_quota_change_log.change_desc; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.change_desc IS '变更说明'; -- -- Name: COLUMN pay_expense_quota_change_log.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.id IS '主键ID'; -- -- Name: COLUMN pay_expense_quota_change_log.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN pay_expense_quota_change_log.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.description IS '备注/描述'; -- -- Name: COLUMN pay_expense_quota_change_log.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.created_time IS '创建时间'; -- -- Name: COLUMN pay_expense_quota_change_log.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.updated_time IS '更新时间'; -- -- Name: COLUMN pay_expense_quota_change_log.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_expense_quota_change_log.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_quota_change_log.enterprise_id IS '企业ID'; -- -- Name: pay_expense_quota_change_log_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_expense_quota_change_log_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_expense_quota_change_log_id_seq OWNER TO admin; -- -- Name: pay_expense_quota_change_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_expense_quota_change_log_id_seq OWNED BY public.pay_expense_quota_change_log.id; -- -- Name: pay_expense_quota_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_expense_quota_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_expense_quota_id_seq OWNER TO admin; -- -- Name: pay_expense_quota_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_expense_quota_id_seq OWNED BY public.pay_expense_quota.id; -- -- Name: pay_expense_rule; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_expense_rule ( out_biz_no character varying(64) NOT NULL, institution_id character varying(64) NOT NULL, rule_id character varying(64), standard_name character varying(128), standard_desc text, expense_type_sub_category character varying(32), status character varying(32) NOT NULL, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64), condition_info jsonb, single_limit numeric(12,2) ); ALTER TABLE public.pay_expense_rule OWNER TO admin; -- -- Name: TABLE pay_expense_rule; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_expense_rule IS '使用规则表'; -- -- Name: COLUMN pay_expense_rule.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.out_biz_no IS '外部业务编号'; -- -- Name: COLUMN pay_expense_rule.institution_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.institution_id IS '制度ID'; -- -- Name: COLUMN pay_expense_rule.rule_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.rule_id IS '规则ID(支付宝返回)'; -- -- Name: COLUMN pay_expense_rule.standard_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.standard_name IS '规则名称'; -- -- Name: COLUMN pay_expense_rule.standard_desc; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.standard_desc IS '规则描述'; -- -- Name: COLUMN pay_expense_rule.expense_type_sub_category; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.expense_type_sub_category IS '费用类型子类'; -- -- Name: COLUMN pay_expense_rule.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.status IS '状态: RULE_ACTIVE/RULE_INACTIVE'; -- -- Name: COLUMN pay_expense_rule.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.id IS '主键ID'; -- -- Name: COLUMN pay_expense_rule.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.description IS '备注/描述'; -- -- Name: COLUMN pay_expense_rule.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.created_time IS '创建时间'; -- -- Name: COLUMN pay_expense_rule.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.updated_time IS '更新时间'; -- -- Name: COLUMN pay_expense_rule.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_expense_rule.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_expense_rule.enterprise_id IS '企业ID'; -- -- Name: pay_expense_rule_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_expense_rule_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_expense_rule_id_seq OWNER TO admin; -- -- Name: pay_expense_rule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_expense_rule_id_seq OWNED BY public.pay_expense_rule.id; -- -- Name: pay_facetoface_order; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_facetoface_order ( enterprise_id character varying(64), batch_no character varying(64), order_no character varying(64), order_status character varying(32) NOT NULL, account character varying(128), contact_name character varying(32), contact_mobile character varying(16), contact_email character varying(64), order_ticket character varying(40), rate character varying(8), sign_and_auth boolean NOT NULL, merchant_pid character varying(32), confirm_url text, app_auth_token character varying(128), app_refresh_token character varying(128), auth_app_id character varying(32), user_id character varying(32), open_id character varying(128), expires_in character varying(16), re_expires_in character varying(16), reject_reason text, remark text, last_query_time timestamp without time zone, next_query_time timestamp without time zone, query_count integer NOT NULL, id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, version integer DEFAULT 0 ); ALTER TABLE public.pay_facetoface_order OWNER TO admin; -- -- Name: TABLE pay_facetoface_order; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_facetoface_order IS '当面付代开通申请单'; -- -- Name: COLUMN pay_facetoface_order.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.enterprise_id IS '关联企业ID'; -- -- Name: COLUMN pay_facetoface_order.batch_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.batch_no IS '支付宝事务编号'; -- -- Name: COLUMN pay_facetoface_order.order_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.order_no IS '签约单号'; -- -- Name: COLUMN pay_facetoface_order.order_status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.order_status IS '申请单状态'; -- -- Name: COLUMN pay_facetoface_order.account; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.account IS '商户支付宝账号/pid'; -- -- Name: COLUMN pay_facetoface_order.contact_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.contact_name IS '联系人名称'; -- -- Name: COLUMN pay_facetoface_order.contact_mobile; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.contact_mobile IS '联系人手机号'; -- -- Name: COLUMN pay_facetoface_order.contact_email; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.contact_email IS '联系人邮箱'; -- -- Name: COLUMN pay_facetoface_order.order_ticket; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.order_ticket IS '订单授权凭证（预授权模式）'; -- -- Name: COLUMN pay_facetoface_order.rate; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.rate IS '费率(sign_and_auth=true时必填)'; -- -- Name: COLUMN pay_facetoface_order.sign_and_auth; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.sign_and_auth IS '是否签约且授权'; -- -- Name: COLUMN pay_facetoface_order.merchant_pid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.merchant_pid IS '商户pid（query返回）'; -- -- Name: COLUMN pay_facetoface_order.confirm_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.confirm_url IS '商家确认链接'; -- -- Name: COLUMN pay_facetoface_order.app_auth_token; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.app_auth_token IS '应用授权令牌'; -- -- Name: COLUMN pay_facetoface_order.app_refresh_token; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.app_refresh_token IS '刷新令牌'; -- -- Name: COLUMN pay_facetoface_order.auth_app_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.auth_app_id IS '授权商户的appId'; -- -- Name: COLUMN pay_facetoface_order.user_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.user_id IS '授权商户的userId'; -- -- Name: COLUMN pay_facetoface_order.open_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.open_id IS '授权商户的openId'; -- -- Name: COLUMN pay_facetoface_order.expires_in; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.expires_in IS '授权令牌过期秒数'; -- -- Name: COLUMN pay_facetoface_order.re_expires_in; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.re_expires_in IS '刷新令牌过期秒数'; -- -- Name: COLUMN pay_facetoface_order.reject_reason; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.reject_reason IS '驳回原因'; -- -- Name: COLUMN pay_facetoface_order.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.remark IS '备注'; -- -- Name: COLUMN pay_facetoface_order.last_query_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.last_query_time IS '最后查询时间'; -- -- Name: COLUMN pay_facetoface_order.next_query_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.next_query_time IS '下次查询时间'; -- -- Name: COLUMN pay_facetoface_order.query_count; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.query_count IS '已查询次数'; -- -- Name: COLUMN pay_facetoface_order.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.id IS '主键ID'; -- -- Name: COLUMN pay_facetoface_order.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN pay_facetoface_order.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.description IS '备注/描述'; -- -- Name: COLUMN pay_facetoface_order.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.created_time IS '创建时间'; -- -- Name: COLUMN pay_facetoface_order.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.updated_time IS '更新时间'; -- -- Name: COLUMN pay_facetoface_order.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_facetoface_order.tenant_id IS '租户ID'; -- -- Name: pay_facetoface_order_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_facetoface_order_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_facetoface_order_id_seq OWNER TO admin; -- -- Name: pay_facetoface_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_facetoface_order_id_seq OWNED BY public.pay_facetoface_order.id; -- -- Name: pay_points; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_points ( points numeric(12,2) NOT NULL, status character varying(32) NOT NULL, rule character varying(64), ext_info json, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL ); ALTER TABLE public.pay_points OWNER TO admin; -- -- Name: TABLE pay_points; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_points IS '积分表'; -- -- Name: COLUMN pay_points.points; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.points IS '积分余额'; -- -- Name: COLUMN pay_points.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.status IS '状态: ACTIVE/FROZEN'; -- -- Name: COLUMN pay_points.rule; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.rule IS '积分规则'; -- -- Name: COLUMN pay_points.ext_info; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.ext_info IS '扩展信息'; -- -- Name: COLUMN pay_points.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.id IS '主键ID'; -- -- Name: COLUMN pay_points.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.description IS '备注/描述'; -- -- Name: COLUMN pay_points.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.created_time IS '创建时间'; -- -- Name: COLUMN pay_points.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.updated_time IS '更新时间'; -- -- Name: COLUMN pay_points.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points.tenant_id IS '租户ID'; -- -- Name: pay_points_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_points_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_points_id_seq OWNER TO admin; -- -- Name: pay_points_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_points_id_seq OWNED BY public.pay_points.id; -- -- Name: pay_points_record; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_points_record ( enterprise_id character varying(64), employee_id character varying(64), points numeric(12,2) NOT NULL, balance numeric(12,2) NOT NULL, type character varying(32), business_type character varying(32), business_id character varying(64), remark text, ext_info json, id bigint NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL ); ALTER TABLE public.pay_points_record OWNER TO admin; -- -- Name: TABLE pay_points_record; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_points_record IS '积分变动记录表'; -- -- Name: COLUMN pay_points_record.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.enterprise_id IS '企业ID'; -- -- Name: COLUMN pay_points_record.employee_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.employee_id IS '员工ID'; -- -- Name: COLUMN pay_points_record.points; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.points IS '变动积分'; -- -- Name: COLUMN pay_points_record.balance; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.balance IS '变动后余额'; -- -- Name: COLUMN pay_points_record.type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.type IS '变动类型: ADD/DEDUCT'; -- -- Name: COLUMN pay_points_record.business_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.business_type IS '业务类型: TRANSFER'; -- -- Name: COLUMN pay_points_record.business_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.business_id IS '业务ID'; -- -- Name: COLUMN pay_points_record.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.remark IS '备注'; -- -- Name: COLUMN pay_points_record.ext_info; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.ext_info IS '扩展信息'; -- -- Name: COLUMN pay_points_record.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.id IS '主键ID'; -- -- Name: COLUMN pay_points_record.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN pay_points_record.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.description IS '备注/描述'; -- -- Name: COLUMN pay_points_record.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.created_time IS '创建时间'; -- -- Name: COLUMN pay_points_record.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.updated_time IS '更新时间'; -- -- Name: COLUMN pay_points_record.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_points_record.tenant_id IS '租户ID'; -- -- Name: pay_points_record_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_points_record_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_points_record_id_seq OWNER TO admin; -- -- Name: pay_points_record_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_points_record_id_seq OWNED BY public.pay_points_record.id; -- -- Name: pay_service_provider; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_service_provider ( id bigint NOT NULL, name character varying(64) NOT NULL, scope_label character varying(64) DEFAULT 'DOMESTIC'::character varying, app_id character varying(64) NOT NULL, app_private_key text NOT NULL, alipay_public_key text NOT NULL, server_url character varying(256) DEFAULT 'https://openapi.alipay.com/gateway.do'::character varying, sign_type character varying(16) DEFAULT 'RSA2'::character varying, format character varying(16) DEFAULT 'JSON'::character varying, charset character varying(16) DEFAULT 'UTF-8'::character varying, provider_status character varying(32) DEFAULT 'ACTIVE'::character varying, description character varying(512), status character varying(1) DEFAULT '0'::character varying, uuid character varying(64), created_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP, updated_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP ); ALTER TABLE public.pay_service_provider OWNER TO admin; -- -- Name: pay_service_provider_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_service_provider_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_service_provider_id_seq OWNER TO admin; -- -- Name: pay_service_provider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_service_provider_id_seq OWNED BY public.pay_service_provider.id; -- -- Name: pay_service_provider_profile; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_service_provider_profile ( id bigint NOT NULL, service_provider_id bigint NOT NULL, biz_type character varying(32) NOT NULL, app_id character varying(64), app_private_key text, alipay_public_key text, app_cert_content text, alipay_public_cert_content text, root_cert_content text, server_url character varying(256), format character varying(16) DEFAULT 'JSON'::character varying, charset character varying(16) DEFAULT 'UTF-8'::character varying, sign_type character varying(16) DEFAULT 'RSA2'::character varying, description character varying(512), created_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP, updated_time timestamp without time zone DEFAULT CURRENT_TIMESTAMP, status character varying(1) DEFAULT '0'::character varying ); ALTER TABLE public.pay_service_provider_profile OWNER TO admin; -- -- Name: pay_service_provider_profile_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_service_provider_profile_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_service_provider_profile_id_seq OWNER TO admin; -- -- Name: pay_service_provider_profile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_service_provider_profile_id_seq OWNED BY public.pay_service_provider_profile.id; -- -- Name: pay_transfer; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_transfer ( out_biz_no character varying(64), account_book_id character varying(64), amount numeric(12,2), order_title character varying(64), payee_info json, status character varying(32) NOT NULL, order_no character varying(64), fund_order_id character varying(64), error_code character varying(64), error_msg text, ext_info json, remark text, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, enterprise_id character varying(64), payee_type character varying(32), retry_count integer DEFAULT 0 NOT NULL, next_retry_at timestamp without time zone ); ALTER TABLE public.pay_transfer OWNER TO admin; -- -- Name: TABLE pay_transfer; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_transfer IS '转账记录表'; -- -- Name: COLUMN pay_transfer.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.out_biz_no IS '商家侧订单号'; -- -- Name: COLUMN pay_transfer.account_book_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.account_book_id IS '付款方资金专户号'; -- -- Name: COLUMN pay_transfer.amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.amount IS '转账金额'; -- -- Name: COLUMN pay_transfer.order_title; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.order_title IS '转账标题'; -- -- Name: COLUMN pay_transfer.payee_info; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.payee_info IS '收款方信息'; -- -- Name: COLUMN pay_transfer.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.status IS '转账状态: DEALING/SUCCESS/FAIL/REFUND'; -- -- Name: COLUMN pay_transfer.order_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.order_no IS '支付宝转账单号'; -- -- Name: COLUMN pay_transfer.fund_order_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.fund_order_id IS '宝支付资金流水号'; -- -- Name: COLUMN pay_transfer.error_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.error_code IS '错误码'; -- -- Name: COLUMN pay_transfer.error_msg; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.error_msg IS '错误信息'; -- -- Name: COLUMN pay_transfer.ext_info; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.ext_info IS '扩展信息'; -- -- Name: COLUMN pay_transfer.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.remark IS '备注'; -- -- Name: COLUMN pay_transfer.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.id IS '主键ID'; -- -- Name: COLUMN pay_transfer.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.description IS '备注/描述'; -- -- Name: COLUMN pay_transfer.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.created_time IS '创建时间'; -- -- Name: COLUMN pay_transfer.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.updated_time IS '更新时间'; -- -- Name: COLUMN pay_transfer.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.tenant_id IS '租户ID'; -- -- Name: COLUMN pay_transfer.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_transfer.enterprise_id IS '企业ID'; -- -- Name: pay_transfer_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_transfer_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_transfer_id_seq OWNER TO admin; -- -- Name: pay_transfer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_transfer_id_seq OWNED BY public.pay_transfer.id; -- -- Name: pay_withdraw; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.pay_withdraw ( enterprise_id character varying(64), out_biz_no character varying(64), account_book_id character varying(64), amount numeric(12,2), status character varying(32) NOT NULL, order_no character varying(64), notify_content json, error_code character varying(64), error_msg text, remark text, id bigint NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL ); ALTER TABLE public.pay_withdraw OWNER TO admin; -- -- Name: TABLE pay_withdraw; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.pay_withdraw IS '提现记录表'; -- -- Name: COLUMN pay_withdraw.enterprise_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.enterprise_id IS '所属企业ID'; -- -- Name: COLUMN pay_withdraw.out_biz_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.out_biz_no IS '商家侧订单号'; -- -- Name: COLUMN pay_withdraw.account_book_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.account_book_id IS '资金专户号'; -- -- Name: COLUMN pay_withdraw.amount; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.amount IS '提现金额'; -- -- Name: COLUMN pay_withdraw.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.status IS '提现状态: DEALING/SUCCESS/FAIL'; -- -- Name: COLUMN pay_withdraw.order_no; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.order_no IS '支付宝提现单号'; -- -- Name: COLUMN pay_withdraw.notify_content; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.notify_content IS '通知内容原始数据'; -- -- Name: COLUMN pay_withdraw.error_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.error_code IS '错误码'; -- -- Name: COLUMN pay_withdraw.error_msg; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.error_msg IS '错误信息'; -- -- Name: COLUMN pay_withdraw.remark; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.remark IS '备注'; -- -- Name: COLUMN pay_withdraw.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.id IS '主键ID'; -- -- Name: COLUMN pay_withdraw.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.description IS '备注/描述'; -- -- Name: COLUMN pay_withdraw.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.created_time IS '创建时间'; -- -- Name: COLUMN pay_withdraw.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.updated_time IS '更新时间'; -- -- Name: COLUMN pay_withdraw.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.pay_withdraw.tenant_id IS '租户ID'; -- -- Name: pay_withdraw_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.pay_withdraw_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.pay_withdraw_id_seq OWNER TO admin; -- -- Name: pay_withdraw_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.pay_withdraw_id_seq OWNED BY public.pay_withdraw.id; -- -- Name: sys_dept; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_dept ( name character varying(64) NOT NULL, "order" integer NOT NULL, code character varying(16) NOT NULL, leader character varying(32), phone character varying(11), email character varying(64), parent_id integer, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_dept OWNER TO admin; -- -- Name: TABLE sys_dept; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_dept IS '部门表'; -- -- Name: COLUMN sys_dept.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.name IS '部门名称'; -- -- Name: COLUMN sys_dept."order"; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept."order" IS '显示排序'; -- -- Name: COLUMN sys_dept.code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.code IS '部门编码'; -- -- Name: COLUMN sys_dept.leader; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.leader IS '部门负责人'; -- -- Name: COLUMN sys_dept.phone; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.phone IS '手机'; -- -- Name: COLUMN sys_dept.email; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.email IS '邮箱'; -- -- Name: COLUMN sys_dept.parent_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.parent_id IS '父级部门ID'; -- -- Name: COLUMN sys_dept.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.id IS '主键ID'; -- -- Name: COLUMN sys_dept.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_dept.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_dept.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.description IS '备注/描述'; -- -- Name: COLUMN sys_dept.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.created_time IS '创建时间'; -- -- Name: COLUMN sys_dept.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dept.updated_time IS '更新时间'; -- -- Name: sys_dept_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_dept_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_dept_id_seq OWNER TO admin; -- -- Name: sys_dept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_dept_id_seq OWNED BY public.sys_dept.id; -- -- Name: sys_dict_data; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_dict_data ( dict_sort integer NOT NULL, dict_label character varying(255) NOT NULL, dict_value character varying(255) NOT NULL, css_class character varying(255), list_class character varying(255), is_default boolean NOT NULL, dict_type character varying(255) NOT NULL, dict_type_id integer NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_dict_data OWNER TO admin; -- -- Name: TABLE sys_dict_data; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_dict_data IS '字典数据表'; -- -- Name: COLUMN sys_dict_data.dict_sort; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.dict_sort IS '字典排序'; -- -- Name: COLUMN sys_dict_data.dict_label; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.dict_label IS '字典标签'; -- -- Name: COLUMN sys_dict_data.dict_value; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.dict_value IS '字典键值'; -- -- Name: COLUMN sys_dict_data.css_class; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.css_class IS '样式属性（其他样式扩展）'; -- -- Name: COLUMN sys_dict_data.list_class; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.list_class IS '表格回显样式'; -- -- Name: COLUMN sys_dict_data.is_default; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.is_default IS '是否默认（True是 False否）'; -- -- Name: COLUMN sys_dict_data.dict_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.dict_type IS '字典类型'; -- -- Name: COLUMN sys_dict_data.dict_type_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.dict_type_id IS '字典类型ID'; -- -- Name: COLUMN sys_dict_data.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.id IS '主键ID'; -- -- Name: COLUMN sys_dict_data.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_dict_data.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_dict_data.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.description IS '备注/描述'; -- -- Name: COLUMN sys_dict_data.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.created_time IS '创建时间'; -- -- Name: COLUMN sys_dict_data.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_data.updated_time IS '更新时间'; -- -- Name: sys_dict_data_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_dict_data_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_dict_data_id_seq OWNER TO admin; -- -- Name: sys_dict_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_dict_data_id_seq OWNED BY public.sys_dict_data.id; -- -- Name: sys_dict_type; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_dict_type ( dict_name character varying(64) NOT NULL, dict_type character varying(255) NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_dict_type OWNER TO admin; -- -- Name: TABLE sys_dict_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_dict_type IS '字典类型表'; -- -- Name: COLUMN sys_dict_type.dict_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.dict_name IS '字典名称'; -- -- Name: COLUMN sys_dict_type.dict_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.dict_type IS '字典类型'; -- -- Name: COLUMN sys_dict_type.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.id IS '主键ID'; -- -- Name: COLUMN sys_dict_type.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_dict_type.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_dict_type.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.description IS '备注/描述'; -- -- Name: COLUMN sys_dict_type.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.created_time IS '创建时间'; -- -- Name: COLUMN sys_dict_type.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_dict_type.updated_time IS '更新时间'; -- -- Name: sys_dict_type_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_dict_type_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_dict_type_id_seq OWNER TO admin; -- -- Name: sys_dict_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_dict_type_id_seq OWNED BY public.sys_dict_type.id; -- -- Name: sys_invitation_code; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_invitation_code ( id bigint NOT NULL, uuid character varying(64), status character varying(1) DEFAULT '0'::character varying, code character varying(64) NOT NULL, used_by bigint, used_time timestamp with time zone, created_by bigint, description character varying(255), created_time timestamp with time zone DEFAULT now(), updated_time timestamp with time zone DEFAULT now() ); ALTER TABLE public.sys_invitation_code OWNER TO admin; -- -- Name: sys_invitation_code_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_invitation_code_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_invitation_code_id_seq OWNER TO admin; -- -- Name: sys_invitation_code_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_invitation_code_id_seq OWNED BY public.sys_invitation_code.id; -- -- Name: sys_log; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_log ( type integer NOT NULL, request_path character varying(255) NOT NULL, request_method character varying(10) NOT NULL, request_payload text, request_ip character varying(50), login_location character varying(255), request_os character varying(64), request_browser character varying(64), response_code integer NOT NULL, response_json text, process_time character varying(20), id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.sys_log OWNER TO admin; -- -- Name: TABLE sys_log; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_log IS '系统日志表'; -- -- Name: COLUMN sys_log.type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.type IS '日志类型(1登录日志 2操作日志)'; -- -- Name: COLUMN sys_log.request_path; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.request_path IS '请求路径'; -- -- Name: COLUMN sys_log.request_method; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.request_method IS '请求方式'; -- -- Name: COLUMN sys_log.request_payload; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.request_payload IS '请求体'; -- -- Name: COLUMN sys_log.request_ip; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.request_ip IS '请求IP地址'; -- -- Name: COLUMN sys_log.login_location; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.login_location IS '登录位置'; -- -- Name: COLUMN sys_log.request_os; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.request_os IS '操作系统'; -- -- Name: COLUMN sys_log.request_browser; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.request_browser IS '浏览器'; -- -- Name: COLUMN sys_log.response_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.response_code IS '响应状态码'; -- -- Name: COLUMN sys_log.response_json; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.response_json IS '响应体'; -- -- Name: COLUMN sys_log.process_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.process_time IS '处理时间'; -- -- Name: COLUMN sys_log.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.id IS '主键ID'; -- -- Name: COLUMN sys_log.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_log.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_log.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.description IS '备注/描述'; -- -- Name: COLUMN sys_log.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.created_time IS '创建时间'; -- -- Name: COLUMN sys_log.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.updated_time IS '更新时间'; -- -- Name: COLUMN sys_log.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.created_id IS '创建人ID'; -- -- Name: COLUMN sys_log.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_log.updated_id IS '更新人ID'; -- -- Name: sys_log_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_log_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_log_id_seq OWNER TO admin; -- -- Name: sys_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_log_id_seq OWNED BY public.sys_log.id; -- -- Name: sys_menu; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_menu ( name character varying(50) NOT NULL, type integer NOT NULL, "order" integer NOT NULL, permission character varying(100), icon character varying(50), route_name character varying(100), route_path character varying(200), component_path character varying(200), redirect character varying(200), hidden boolean NOT NULL, keep_alive boolean NOT NULL, always_show boolean NOT NULL, title character varying(50), params json, affix boolean NOT NULL, parent_id integer, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_menu OWNER TO admin; -- -- Name: TABLE sys_menu; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_menu IS '菜单表'; -- -- Name: COLUMN sys_menu.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.name IS '菜单名称'; -- -- Name: COLUMN sys_menu.type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.type IS '菜单类型(1:目录 2:菜单 3:按钮/权限 4:链接)'; -- -- Name: COLUMN sys_menu."order"; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu."order" IS '显示排序'; -- -- Name: COLUMN sys_menu.permission; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.permission IS '权限标识(如:module_system:user:query)'; -- -- Name: COLUMN sys_menu.icon; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.icon IS '菜单图标'; -- -- Name: COLUMN sys_menu.route_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.route_name IS '路由名称'; -- -- Name: COLUMN sys_menu.route_path; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.route_path IS '路由路径'; -- -- Name: COLUMN sys_menu.component_path; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.component_path IS '组件路径'; -- -- Name: COLUMN sys_menu.redirect; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.redirect IS '重定向地址'; -- -- Name: COLUMN sys_menu.hidden; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.hidden IS '是否隐藏(True:隐藏 False:显示)'; -- -- Name: COLUMN sys_menu.keep_alive; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.keep_alive IS '是否缓存(True:是 False:否)'; -- -- Name: COLUMN sys_menu.always_show; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.always_show IS '是否始终显示(True:是 False:否)'; -- -- Name: COLUMN sys_menu.title; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.title IS '菜单标题'; -- -- Name: COLUMN sys_menu.params; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.params IS '路由参数(JSON对象)'; -- -- Name: COLUMN sys_menu.affix; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.affix IS '是否固定标签页(True:是 False:否)'; -- -- Name: COLUMN sys_menu.parent_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.parent_id IS '父菜单ID'; -- -- Name: COLUMN sys_menu.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.id IS '主键ID'; -- -- Name: COLUMN sys_menu.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_menu.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_menu.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.description IS '备注/描述'; -- -- Name: COLUMN sys_menu.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.created_time IS '创建时间'; -- -- Name: COLUMN sys_menu.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_menu.updated_time IS '更新时间'; -- -- Name: sys_menu_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_menu_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_menu_id_seq OWNER TO admin; -- -- Name: sys_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_menu_id_seq OWNED BY public.sys_menu.id; -- -- Name: sys_notice; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_notice ( notice_title character varying(64) NOT NULL, notice_type character varying(1) NOT NULL, notice_content text, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.sys_notice OWNER TO admin; -- -- Name: TABLE sys_notice; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_notice IS '通知公告表'; -- -- Name: COLUMN sys_notice.notice_title; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.notice_title IS '公告标题'; -- -- Name: COLUMN sys_notice.notice_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.notice_type IS '公告类型(1通知 2公告)'; -- -- Name: COLUMN sys_notice.notice_content; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.notice_content IS '公告内容'; -- -- Name: COLUMN sys_notice.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.id IS '主键ID'; -- -- Name: COLUMN sys_notice.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_notice.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_notice.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.description IS '备注/描述'; -- -- Name: COLUMN sys_notice.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.created_time IS '创建时间'; -- -- Name: COLUMN sys_notice.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.updated_time IS '更新时间'; -- -- Name: COLUMN sys_notice.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.created_id IS '创建人ID'; -- -- Name: COLUMN sys_notice.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_notice.updated_id IS '更新人ID'; -- -- Name: sys_notice_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_notice_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_notice_id_seq OWNER TO admin; -- -- Name: sys_notice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_notice_id_seq OWNED BY public.sys_notice.id; -- -- Name: sys_param; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_param ( config_name character varying(64) NOT NULL, config_key character varying(500) NOT NULL, config_value character varying(500), config_type boolean, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_param OWNER TO admin; -- -- Name: TABLE sys_param; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_param IS '系统参数表'; -- -- Name: COLUMN sys_param.config_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.config_name IS '参数名称'; -- -- Name: COLUMN sys_param.config_key; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.config_key IS '参数键名'; -- -- Name: COLUMN sys_param.config_value; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.config_value IS '参数键值'; -- -- Name: COLUMN sys_param.config_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.config_type IS '系统内置(True:是 False:否)'; -- -- Name: COLUMN sys_param.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.id IS '主键ID'; -- -- Name: COLUMN sys_param.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_param.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_param.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.description IS '备注/描述'; -- -- Name: COLUMN sys_param.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.created_time IS '创建时间'; -- -- Name: COLUMN sys_param.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_param.updated_time IS '更新时间'; -- -- Name: sys_param_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_param_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_param_id_seq OWNER TO admin; -- -- Name: sys_param_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_param_id_seq OWNED BY public.sys_param.id; -- -- Name: sys_position; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_position ( name character varying(64) NOT NULL, "order" integer NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.sys_position OWNER TO admin; -- -- Name: TABLE sys_position; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_position IS '岗位表'; -- -- Name: COLUMN sys_position.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.name IS '岗位名称'; -- -- Name: COLUMN sys_position."order"; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position."order" IS '显示排序'; -- -- Name: COLUMN sys_position.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.id IS '主键ID'; -- -- Name: COLUMN sys_position.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_position.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_position.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.description IS '备注/描述'; -- -- Name: COLUMN sys_position.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.created_time IS '创建时间'; -- -- Name: COLUMN sys_position.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.updated_time IS '更新时间'; -- -- Name: COLUMN sys_position.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.created_id IS '创建人ID'; -- -- Name: COLUMN sys_position.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_position.updated_id IS '更新人ID'; -- -- Name: sys_position_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_position_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_position_id_seq OWNER TO admin; -- -- Name: sys_position_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_position_id_seq OWNED BY public.sys_position.id; -- -- Name: sys_role; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_role ( name character varying(64) NOT NULL, code character varying(16) NOT NULL, "order" integer NOT NULL, data_scope integer NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_role OWNER TO admin; -- -- Name: TABLE sys_role; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_role IS '角色表'; -- -- Name: COLUMN sys_role.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.name IS '角色名称'; -- -- Name: COLUMN sys_role.code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.code IS '角色编码'; -- -- Name: COLUMN sys_role."order"; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role."order" IS '显示排序'; -- -- Name: COLUMN sys_role.data_scope; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.data_scope IS '数据权限范围(1:仅本人 2:本部门 3:本部门及以下 4:全部 5:自定义)'; -- -- Name: COLUMN sys_role.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.id IS '主键ID'; -- -- Name: COLUMN sys_role.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_role.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_role.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.description IS '备注/描述'; -- -- Name: COLUMN sys_role.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.created_time IS '创建时间'; -- -- Name: COLUMN sys_role.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role.updated_time IS '更新时间'; -- -- Name: sys_role_depts; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_role_depts ( role_id integer NOT NULL, dept_id integer NOT NULL ); ALTER TABLE public.sys_role_depts OWNER TO admin; -- -- Name: TABLE sys_role_depts; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_role_depts IS '角色部门关联表'; -- -- Name: COLUMN sys_role_depts.role_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role_depts.role_id IS '角色ID'; -- -- Name: COLUMN sys_role_depts.dept_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role_depts.dept_id IS '部门ID'; -- -- Name: sys_role_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_role_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_role_id_seq OWNER TO admin; -- -- Name: sys_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_role_id_seq OWNED BY public.sys_role.id; -- -- Name: sys_role_menus; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_role_menus ( role_id integer NOT NULL, menu_id integer NOT NULL ); ALTER TABLE public.sys_role_menus OWNER TO admin; -- -- Name: TABLE sys_role_menus; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_role_menus IS '角色菜单关联表'; -- -- Name: COLUMN sys_role_menus.role_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role_menus.role_id IS '角色ID'; -- -- Name: COLUMN sys_role_menus.menu_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_role_menus.menu_id IS '菜单ID'; -- -- Name: sys_tenant; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_tenant ( name character varying(100) NOT NULL, code character varying(100) NOT NULL, start_time timestamp without time zone, end_time timestamp without time zone, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.sys_tenant OWNER TO admin; -- -- Name: TABLE sys_tenant; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_tenant IS '租户表'; -- -- Name: COLUMN sys_tenant.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.name IS '租户名称'; -- -- Name: COLUMN sys_tenant.code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.code IS '租户编码'; -- -- Name: COLUMN sys_tenant.start_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.start_time IS '开始时间'; -- -- Name: COLUMN sys_tenant.end_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.end_time IS '结束时间'; -- -- Name: COLUMN sys_tenant.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.id IS '主键ID'; -- -- Name: COLUMN sys_tenant.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_tenant.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_tenant.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.description IS '备注/描述'; -- -- Name: COLUMN sys_tenant.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.created_time IS '创建时间'; -- -- Name: COLUMN sys_tenant.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant.updated_time IS '更新时间'; -- -- Name: sys_tenant_api_key; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_tenant_api_key ( api_key character varying(256) NOT NULL, api_secret character varying(256) NOT NULL, expired_at timestamp without time zone, last_used_at timestamp without time zone, tenant_id integer NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, return_url character varying(512) ); ALTER TABLE public.sys_tenant_api_key OWNER TO admin; -- -- Name: COLUMN sys_tenant_api_key.api_key; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.api_key IS 'API Key'; -- -- Name: COLUMN sys_tenant_api_key.api_secret; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.api_secret IS 'API Secret'; -- -- Name: COLUMN sys_tenant_api_key.expired_at; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.expired_at IS '过期时间'; -- -- Name: COLUMN sys_tenant_api_key.last_used_at; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.last_used_at IS '最后使用时间'; -- -- Name: COLUMN sys_tenant_api_key.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.tenant_id IS '租户ID'; -- -- Name: COLUMN sys_tenant_api_key.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.id IS '主键ID'; -- -- Name: COLUMN sys_tenant_api_key.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_tenant_api_key.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_tenant_api_key.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.description IS '备注/描述'; -- -- Name: COLUMN sys_tenant_api_key.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.created_time IS '创建时间'; -- -- Name: COLUMN sys_tenant_api_key.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.updated_time IS '更新时间'; -- -- Name: COLUMN sys_tenant_api_key.return_url; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_key.return_url IS '同步返回地址'; -- -- Name: sys_tenant_api_key_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_tenant_api_key_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_tenant_api_key_id_seq OWNER TO admin; -- -- Name: sys_tenant_api_key_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_tenant_api_key_id_seq OWNED BY public.sys_tenant_api_key.id; -- -- Name: sys_tenant_api_log; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_tenant_api_log ( api_key_id integer, endpoint character varying(256) NOT NULL, method character varying(10) NOT NULL, request_ip character varying(50) NOT NULL, request_data text, response_code integer NOT NULL, response_time integer NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL ); ALTER TABLE public.sys_tenant_api_log OWNER TO admin; -- -- Name: COLUMN sys_tenant_api_log.api_key_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.api_key_id IS 'API Key ID'; -- -- Name: COLUMN sys_tenant_api_log.endpoint; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.endpoint IS '调用的接口'; -- -- Name: COLUMN sys_tenant_api_log.method; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.method IS '请求方法'; -- -- Name: COLUMN sys_tenant_api_log.request_ip; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.request_ip IS '请求IP'; -- -- Name: COLUMN sys_tenant_api_log.request_data; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.request_data IS '请求数据（脱敏存储）'; -- -- Name: COLUMN sys_tenant_api_log.response_code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.response_code IS '响应码'; -- -- Name: COLUMN sys_tenant_api_log.response_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.response_time IS '响应时间（毫秒）'; -- -- Name: COLUMN sys_tenant_api_log.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.id IS '主键ID'; -- -- Name: COLUMN sys_tenant_api_log.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_tenant_api_log.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_tenant_api_log.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.description IS '备注/描述'; -- -- Name: COLUMN sys_tenant_api_log.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.created_time IS '创建时间'; -- -- Name: COLUMN sys_tenant_api_log.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.updated_time IS '更新时间'; -- -- Name: COLUMN sys_tenant_api_log.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_tenant_api_log.tenant_id IS '租户ID'; -- -- Name: sys_tenant_api_log_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_tenant_api_log_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_tenant_api_log_id_seq OWNER TO admin; -- -- Name: sys_tenant_api_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_tenant_api_log_id_seq OWNED BY public.sys_tenant_api_log.id; -- -- Name: sys_tenant_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_tenant_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_tenant_id_seq OWNER TO admin; -- -- Name: sys_tenant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_tenant_id_seq OWNED BY public.sys_tenant.id; -- -- Name: sys_user; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_user ( username character varying(64) NOT NULL, password character varying(255) NOT NULL, name character varying(32) NOT NULL, mobile character varying(11), email character varying(64), gender character varying(1), avatar character varying(255), is_superuser boolean NOT NULL, last_login timestamp with time zone, gitee_login character varying(32), github_login character varying(32), wx_login character varying(32), qq_login character varying(32), dept_id integer, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, tenant_id integer NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.sys_user OWNER TO admin; -- -- Name: TABLE sys_user; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_user IS '用户表'; -- -- Name: COLUMN sys_user.username; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.username IS '用户名/登录账号'; -- -- Name: COLUMN sys_user.password; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.password IS '密码哈希'; -- -- Name: COLUMN sys_user.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.name IS '昵称'; -- -- Name: COLUMN sys_user.mobile; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.mobile IS '手机号'; -- -- Name: COLUMN sys_user.email; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.email IS '邮箱'; -- -- Name: COLUMN sys_user.gender; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.gender IS '性别(0:男 1:女 2:未知)'; -- -- Name: COLUMN sys_user.avatar; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.avatar IS '头像URL地址'; -- -- Name: COLUMN sys_user.is_superuser; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.is_superuser IS '是否超管'; -- -- Name: COLUMN sys_user.last_login; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.last_login IS '最后登录时间'; -- -- Name: COLUMN sys_user.gitee_login; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.gitee_login IS 'Gitee登录'; -- -- Name: COLUMN sys_user.github_login; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.github_login IS 'Github登录'; -- -- Name: COLUMN sys_user.wx_login; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.wx_login IS '微信登录'; -- -- Name: COLUMN sys_user.qq_login; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.qq_login IS 'QQ登录'; -- -- Name: COLUMN sys_user.dept_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.dept_id IS '部门ID'; -- -- Name: COLUMN sys_user.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.id IS '主键ID'; -- -- Name: COLUMN sys_user.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN sys_user.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN sys_user.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.description IS '备注/描述'; -- -- Name: COLUMN sys_user.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.created_time IS '创建时间'; -- -- Name: COLUMN sys_user.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.updated_time IS '更新时间'; -- -- Name: COLUMN sys_user.tenant_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.tenant_id IS '租户ID'; -- -- Name: COLUMN sys_user.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.created_id IS '创建人ID'; -- -- Name: COLUMN sys_user.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user.updated_id IS '更新人ID'; -- -- Name: sys_user_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.sys_user_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sys_user_id_seq OWNER TO admin; -- -- Name: sys_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.sys_user_id_seq OWNED BY public.sys_user.id; -- -- Name: sys_user_positions; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_user_positions ( user_id integer NOT NULL, position_id integer NOT NULL ); ALTER TABLE public.sys_user_positions OWNER TO admin; -- -- Name: TABLE sys_user_positions; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_user_positions IS '用户岗位关联表'; -- -- Name: COLUMN sys_user_positions.user_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user_positions.user_id IS '用户ID'; -- -- Name: COLUMN sys_user_positions.position_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user_positions.position_id IS '岗位ID'; -- -- Name: sys_user_roles; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.sys_user_roles ( user_id integer NOT NULL, role_id integer NOT NULL ); ALTER TABLE public.sys_user_roles OWNER TO admin; -- -- Name: TABLE sys_user_roles; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.sys_user_roles IS '用户角色关联表'; -- -- Name: COLUMN sys_user_roles.user_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user_roles.user_id IS '用户ID'; -- -- Name: COLUMN sys_user_roles.role_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.sys_user_roles.role_id IS '角色ID'; -- -- Name: task_job; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.task_job ( job_id character varying(64) NOT NULL, job_name character varying(128), trigger_type character varying(32), status character varying(16) NOT NULL, next_run_time character varying(64), job_state text, result text, error text, id integer NOT NULL, uuid character varying(64) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL ); ALTER TABLE public.task_job OWNER TO admin; -- -- Name: TABLE task_job; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.task_job IS '任务执行日志表'; -- -- Name: COLUMN task_job.job_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.job_id IS '任务ID'; -- -- Name: COLUMN task_job.job_name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.job_name IS '任务名称'; -- -- Name: COLUMN task_job.trigger_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.trigger_type IS '触发方式: cron/interval/date/manual'; -- -- Name: COLUMN task_job.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.status IS '执行状态'; -- -- Name: COLUMN task_job.next_run_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.next_run_time IS '下次执行时间'; -- -- Name: COLUMN task_job.job_state; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.job_state IS '任务状态信息'; -- -- Name: COLUMN task_job.result; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.result IS '执行结果'; -- -- Name: COLUMN task_job.error; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.error IS '错误信息'; -- -- Name: COLUMN task_job.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.id IS '主键ID'; -- -- Name: COLUMN task_job.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN task_job.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.description IS '备注/描述'; -- -- Name: COLUMN task_job.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.created_time IS '创建时间'; -- -- Name: COLUMN task_job.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_job.updated_time IS '更新时间'; -- -- Name: task_job_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.task_job_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.task_job_id_seq OWNER TO admin; -- -- Name: task_job_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.task_job_id_seq OWNED BY public.task_job.id; -- -- Name: task_node; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.task_node ( name character varying(64) NOT NULL, code character varying(32) NOT NULL, jobstore character varying(64), executor character varying(64), trigger character varying(64), trigger_args text, func text, args text, kwargs text, "coalesce" boolean, max_instances integer, start_date character varying(64), end_date character varying(64), id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.task_node OWNER TO admin; -- -- Name: TABLE task_node; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.task_node IS '节点类型表'; -- -- Name: COLUMN task_node.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.name IS '节点名称'; -- -- Name: COLUMN task_node.code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.code IS '节点编码'; -- -- Name: COLUMN task_node.jobstore; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.jobstore IS '存储器'; -- -- Name: COLUMN task_node.executor; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.executor IS '执行器'; -- -- Name: COLUMN task_node.trigger; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.trigger IS '触发器'; -- -- Name: COLUMN task_node.trigger_args; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.trigger_args IS '触发器参数'; -- -- Name: COLUMN task_node.func; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.func IS '代码块'; -- -- Name: COLUMN task_node.args; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.args IS '位置参数'; -- -- Name: COLUMN task_node.kwargs; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.kwargs IS '关键字参数'; -- -- Name: COLUMN task_node."coalesce"; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node."coalesce" IS '是否合并运行'; -- -- Name: COLUMN task_node.max_instances; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.max_instances IS '最大实例数'; -- -- Name: COLUMN task_node.start_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.start_date IS '开始时间'; -- -- Name: COLUMN task_node.end_date; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.end_date IS '结束时间'; -- -- Name: COLUMN task_node.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.id IS '主键ID'; -- -- Name: COLUMN task_node.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN task_node.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN task_node.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.description IS '备注/描述'; -- -- Name: COLUMN task_node.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.created_time IS '创建时间'; -- -- Name: COLUMN task_node.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.updated_time IS '更新时间'; -- -- Name: COLUMN task_node.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.created_id IS '创建人ID'; -- -- Name: COLUMN task_node.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_node.updated_id IS '更新人ID'; -- -- Name: task_node_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.task_node_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.task_node_id_seq OWNER TO admin; -- -- Name: task_node_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.task_node_id_seq OWNED BY public.task_node.id; -- -- Name: task_workflow; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.task_workflow ( name character varying(128) NOT NULL, code character varying(64) NOT NULL, workflow_status character varying(32) NOT NULL, nodes json, edges json, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.task_workflow OWNER TO admin; -- -- Name: TABLE task_workflow; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.task_workflow IS '工作流定义表'; -- -- Name: COLUMN task_workflow.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.name IS '流程名称'; -- -- Name: COLUMN task_workflow.code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.code IS '流程编码'; -- -- Name: COLUMN task_workflow.workflow_status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.workflow_status IS '流程状态: draft/published/archived'; -- -- Name: COLUMN task_workflow.nodes; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.nodes IS 'Vue Flow nodes JSON'; -- -- Name: COLUMN task_workflow.edges; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.edges IS 'Vue Flow edges JSON'; -- -- Name: COLUMN task_workflow.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.id IS '主键ID'; -- -- Name: COLUMN task_workflow.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN task_workflow.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN task_workflow.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.description IS '备注/描述'; -- -- Name: COLUMN task_workflow.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.created_time IS '创建时间'; -- -- Name: COLUMN task_workflow.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.updated_time IS '更新时间'; -- -- Name: COLUMN task_workflow.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.created_id IS '创建人ID'; -- -- Name: COLUMN task_workflow.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow.updated_id IS '更新人ID'; -- -- Name: task_workflow_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.task_workflow_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.task_workflow_id_seq OWNER TO admin; -- -- Name: task_workflow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.task_workflow_id_seq OWNED BY public.task_workflow.id; -- -- Name: task_workflow_node_type; Type: TABLE; Schema: public; Owner: admin -- CREATE TABLE public.task_workflow_node_type ( name character varying(128) NOT NULL, code character varying(64) NOT NULL, category character varying(32) NOT NULL, func text NOT NULL, args text, kwargs text, sort_order integer NOT NULL, is_active boolean NOT NULL, id integer NOT NULL, uuid character varying(64) NOT NULL, status character varying(10) NOT NULL, description text, created_time timestamp without time zone NOT NULL, updated_time timestamp without time zone NOT NULL, created_id integer, updated_id integer ); ALTER TABLE public.task_workflow_node_type OWNER TO admin; -- -- Name: TABLE task_workflow_node_type; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON TABLE public.task_workflow_node_type IS '工作流编排节点类型（非定时任务节点）'; -- -- Name: COLUMN task_workflow_node_type.name; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.name IS '显示名称'; -- -- Name: COLUMN task_workflow_node_type.code; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.code IS '节点编码，对应画布 node.type'; -- -- Name: COLUMN task_workflow_node_type.category; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.category IS '分类: trigger/action/condition/control'; -- -- Name: COLUMN task_workflow_node_type.func; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.func IS 'Python 代码块，须定义 handler(*args,**kwargs)'; -- -- Name: COLUMN task_workflow_node_type.args; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.args IS '默认位置参数，逗号分隔'; -- -- Name: COLUMN task_workflow_node_type.kwargs; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.kwargs IS '默认关键字参数 JSON'; -- -- Name: COLUMN task_workflow_node_type.sort_order; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.sort_order IS '排序'; -- -- Name: COLUMN task_workflow_node_type.is_active; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.is_active IS '是否启用'; -- -- Name: COLUMN task_workflow_node_type.id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.id IS '主键ID'; -- -- Name: COLUMN task_workflow_node_type.uuid; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.uuid IS 'UUID全局唯一标识'; -- -- Name: COLUMN task_workflow_node_type.status; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.status IS '状态(0:正常 1:禁用)'; -- -- Name: COLUMN task_workflow_node_type.description; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.description IS '备注/描述'; -- -- Name: COLUMN task_workflow_node_type.created_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.created_time IS '创建时间'; -- -- Name: COLUMN task_workflow_node_type.updated_time; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.updated_time IS '更新时间'; -- -- Name: COLUMN task_workflow_node_type.created_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.created_id IS '创建人ID'; -- -- Name: COLUMN task_workflow_node_type.updated_id; Type: COMMENT; Schema: public; Owner: admin -- COMMENT ON COLUMN public.task_workflow_node_type.updated_id IS '更新人ID'; -- -- Name: task_workflow_node_type_id_seq; Type: SEQUENCE; Schema: public; Owner: admin -- CREATE SEQUENCE public.task_workflow_node_type_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.task_workflow_node_type_id_seq OWNER TO admin; -- -- Name: task_workflow_node_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin -- ALTER SEQUENCE public.task_workflow_node_type_id_seq OWNED BY public.task_workflow_node_type.id; -- -- Name: app_portal id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.app_portal ALTER COLUMN id SET DEFAULT nextval('public.app_portal_id_seq'::regclass); -- -- Name: gen_demo id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo ALTER COLUMN id SET DEFAULT nextval('public.gen_demo_id_seq'::regclass); -- -- Name: gen_demo01 id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo01 ALTER COLUMN id SET DEFAULT nextval('public.gen_demo01_id_seq'::regclass); -- -- Name: gen_table id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table ALTER COLUMN id SET DEFAULT nextval('public.gen_table_id_seq'::regclass); -- -- Name: gen_table_column id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table_column ALTER COLUMN id SET DEFAULT nextval('public.gen_table_column_id_seq'::regclass); -- -- Name: open_conf id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_conf ALTER COLUMN id SET DEFAULT nextval('public.open_conf_id_seq'::regclass); -- -- Name: open_transfer id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_transfer ALTER COLUMN id SET DEFAULT nextval('public.open_transfer_id_seq'::regclass); -- -- Name: pay_account id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_account ALTER COLUMN id SET DEFAULT nextval('public.pay_account_id_seq'::regclass); -- -- Name: pay_alipay_notify_log id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_alipay_notify_log ALTER COLUMN id SET DEFAULT nextval('public.pay_alipay_notify_log_id_seq'::regclass); -- -- Name: pay_bill id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill ALTER COLUMN id SET DEFAULT nextval('public.pay_bill_id_seq'::regclass); -- -- Name: pay_bill_order id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill_order ALTER COLUMN id SET DEFAULT nextval('public.pay_bill_order_id_seq'::regclass); -- -- Name: pay_bill_voucher id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill_voucher ALTER COLUMN id SET DEFAULT nextval('public.pay_bill_voucher_id_seq'::regclass); -- -- Name: pay_department id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_department ALTER COLUMN id SET DEFAULT nextval('public.pay_department_id_seq'::regclass); -- -- Name: pay_deposit id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_deposit ALTER COLUMN id SET DEFAULT nextval('public.pay_deposit_id_seq'::regclass); -- -- Name: pay_employee id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_employee ALTER COLUMN id SET DEFAULT nextval('public.pay_employee_id_seq'::regclass); -- -- Name: pay_enterprise id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_enterprise ALTER COLUMN id SET DEFAULT nextval('public.pay_enterprise_id_seq'::regclass); -- -- Name: pay_expense_institution id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_institution ALTER COLUMN id SET DEFAULT nextval('public.pay_expense_institution_id_seq'::regclass); -- -- Name: pay_expense_issue_batch id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_issue_batch ALTER COLUMN id SET DEFAULT nextval('public.pay_expense_issue_batch_id_seq'::regclass); -- -- Name: pay_expense_quota id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_quota ALTER COLUMN id SET DEFAULT nextval('public.pay_expense_quota_id_seq'::regclass); -- -- Name: pay_expense_quota_change_log id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_quota_change_log ALTER COLUMN id SET DEFAULT nextval('public.pay_expense_quota_change_log_id_seq'::regclass); -- -- Name: pay_expense_rule id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_rule ALTER COLUMN id SET DEFAULT nextval('public.pay_expense_rule_id_seq'::regclass); -- -- Name: pay_facetoface_order id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_facetoface_order ALTER COLUMN id SET DEFAULT nextval('public.pay_facetoface_order_id_seq'::regclass); -- -- Name: pay_points id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_points ALTER COLUMN id SET DEFAULT nextval('public.pay_points_id_seq'::regclass); -- -- Name: pay_points_record id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_points_record ALTER COLUMN id SET DEFAULT nextval('public.pay_points_record_id_seq'::regclass); -- -- Name: pay_service_provider id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_service_provider ALTER COLUMN id SET DEFAULT nextval('public.pay_service_provider_id_seq'::regclass); -- -- Name: pay_service_provider_profile id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_service_provider_profile ALTER COLUMN id SET DEFAULT nextval('public.pay_service_provider_profile_id_seq'::regclass); -- -- Name: pay_transfer id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_transfer ALTER COLUMN id SET DEFAULT nextval('public.pay_transfer_id_seq'::regclass); -- -- Name: pay_withdraw id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_withdraw ALTER COLUMN id SET DEFAULT nextval('public.pay_withdraw_id_seq'::regclass); -- -- Name: sys_dept id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dept ALTER COLUMN id SET DEFAULT nextval('public.sys_dept_id_seq'::regclass); -- -- Name: sys_dict_data id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dict_data ALTER COLUMN id SET DEFAULT nextval('public.sys_dict_data_id_seq'::regclass); -- -- Name: sys_dict_type id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dict_type ALTER COLUMN id SET DEFAULT nextval('public.sys_dict_type_id_seq'::regclass); -- -- Name: sys_invitation_code id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_invitation_code ALTER COLUMN id SET DEFAULT nextval('public.sys_invitation_code_id_seq'::regclass); -- -- Name: sys_log id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_log ALTER COLUMN id SET DEFAULT nextval('public.sys_log_id_seq'::regclass); -- -- Name: sys_menu id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_menu ALTER COLUMN id SET DEFAULT nextval('public.sys_menu_id_seq'::regclass); -- -- Name: sys_notice id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_notice ALTER COLUMN id SET DEFAULT nextval('public.sys_notice_id_seq'::regclass); -- -- Name: sys_param id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_param ALTER COLUMN id SET DEFAULT nextval('public.sys_param_id_seq'::regclass); -- -- Name: sys_position id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_position ALTER COLUMN id SET DEFAULT nextval('public.sys_position_id_seq'::regclass); -- -- Name: sys_role id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role ALTER COLUMN id SET DEFAULT nextval('public.sys_role_id_seq'::regclass); -- -- Name: sys_tenant id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant ALTER COLUMN id SET DEFAULT nextval('public.sys_tenant_id_seq'::regclass); -- -- Name: sys_tenant_api_key id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant_api_key ALTER COLUMN id SET DEFAULT nextval('public.sys_tenant_api_key_id_seq'::regclass); -- -- Name: sys_tenant_api_log id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant_api_log ALTER COLUMN id SET DEFAULT nextval('public.sys_tenant_api_log_id_seq'::regclass); -- -- Name: sys_user id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ALTER COLUMN id SET DEFAULT nextval('public.sys_user_id_seq'::regclass); -- -- Name: task_job id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_job ALTER COLUMN id SET DEFAULT nextval('public.task_job_id_seq'::regclass); -- -- Name: task_node id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_node ALTER COLUMN id SET DEFAULT nextval('public.task_node_id_seq'::regclass); -- -- Name: task_workflow id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow ALTER COLUMN id SET DEFAULT nextval('public.task_workflow_id_seq'::regclass); -- -- Name: task_workflow_node_type id; Type: DEFAULT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow_node_type ALTER COLUMN id SET DEFAULT nextval('public.task_workflow_node_type_id_seq'::regclass); -- -- Name: app_portal app_portal_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.app_portal ADD CONSTRAINT app_portal_pkey PRIMARY KEY (id); -- -- Name: apscheduler_jobs apscheduler_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.apscheduler_jobs ADD CONSTRAINT apscheduler_jobs_pkey PRIMARY KEY (id); -- -- Name: gen_demo01 gen_demo01_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo01 ADD CONSTRAINT gen_demo01_pkey PRIMARY KEY (id); -- -- Name: gen_demo gen_demo_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo ADD CONSTRAINT gen_demo_pkey PRIMARY KEY (id); -- -- Name: gen_table_column gen_table_column_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table_column ADD CONSTRAINT gen_table_column_pkey PRIMARY KEY (id); -- -- Name: gen_table gen_table_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table ADD CONSTRAINT gen_table_pkey PRIMARY KEY (id); -- -- Name: open_conf open_conf_app_id_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_conf ADD CONSTRAINT open_conf_app_id_key UNIQUE (app_id); -- -- Name: open_conf open_conf_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_conf ADD CONSTRAINT open_conf_pkey PRIMARY KEY (id); -- -- Name: open_transfer open_transfer_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_transfer ADD CONSTRAINT open_transfer_pkey PRIMARY KEY (id); -- -- Name: pay_account pay_account_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_account ADD CONSTRAINT pay_account_pkey PRIMARY KEY (id); -- -- Name: pay_alipay_notify_log pay_alipay_notify_log_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_alipay_notify_log ADD CONSTRAINT pay_alipay_notify_log_pkey PRIMARY KEY (id); -- -- Name: pay_bill_order pay_bill_order_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill_order ADD CONSTRAINT pay_bill_order_pkey PRIMARY KEY (id); -- -- Name: pay_bill pay_bill_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill ADD CONSTRAINT pay_bill_pkey PRIMARY KEY (id); -- -- Name: pay_bill_voucher pay_bill_voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill_voucher ADD CONSTRAINT pay_bill_voucher_pkey PRIMARY KEY (id); -- -- Name: pay_department pay_department_department_id_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_department ADD CONSTRAINT pay_department_department_id_key UNIQUE (department_id); -- -- Name: pay_department pay_department_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_department ADD CONSTRAINT pay_department_pkey PRIMARY KEY (id); -- -- Name: pay_deposit pay_deposit_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_deposit ADD CONSTRAINT pay_deposit_pkey PRIMARY KEY (id); -- -- Name: pay_employee pay_employee_employee_id_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_employee ADD CONSTRAINT pay_employee_employee_id_key UNIQUE (employee_id); -- -- Name: pay_employee pay_employee_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_employee ADD CONSTRAINT pay_employee_pkey PRIMARY KEY (id); -- -- Name: pay_enterprise pay_enterprise_enterprise_id_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_enterprise ADD CONSTRAINT pay_enterprise_enterprise_id_key UNIQUE (enterprise_id); -- -- Name: pay_enterprise pay_enterprise_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_enterprise ADD CONSTRAINT pay_enterprise_pkey PRIMARY KEY (id); -- -- Name: pay_expense_institution pay_expense_institution_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_institution ADD CONSTRAINT pay_expense_institution_pkey PRIMARY KEY (id); -- -- Name: pay_expense_issue_batch pay_expense_issue_batch_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_issue_batch ADD CONSTRAINT pay_expense_issue_batch_pkey PRIMARY KEY (id); -- -- Name: pay_expense_quota_change_log pay_expense_quota_change_log_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_quota_change_log ADD CONSTRAINT pay_expense_quota_change_log_pkey PRIMARY KEY (id); -- -- Name: pay_expense_quota pay_expense_quota_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_quota ADD CONSTRAINT pay_expense_quota_pkey PRIMARY KEY (id); -- -- Name: pay_expense_rule pay_expense_rule_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_rule ADD CONSTRAINT pay_expense_rule_pkey PRIMARY KEY (id); -- -- Name: pay_facetoface_order pay_facetoface_order_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_facetoface_order ADD CONSTRAINT pay_facetoface_order_pkey PRIMARY KEY (id); -- -- Name: pay_points pay_points_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_points ADD CONSTRAINT pay_points_pkey PRIMARY KEY (id); -- -- Name: pay_points_record pay_points_record_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_points_record ADD CONSTRAINT pay_points_record_pkey PRIMARY KEY (id); -- -- Name: pay_service_provider pay_service_provider_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_service_provider ADD CONSTRAINT pay_service_provider_pkey PRIMARY KEY (id); -- -- Name: pay_service_provider_profile pay_service_provider_profile_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_service_provider_profile ADD CONSTRAINT pay_service_provider_profile_pkey PRIMARY KEY (id); -- -- Name: pay_service_provider_profile pay_service_provider_profile_service_provider_id_biz_type_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_service_provider_profile ADD CONSTRAINT pay_service_provider_profile_service_provider_id_biz_type_key UNIQUE (service_provider_id, biz_type); -- -- Name: pay_transfer pay_transfer_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_transfer ADD CONSTRAINT pay_transfer_pkey PRIMARY KEY (id); -- -- Name: pay_withdraw pay_withdraw_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_withdraw ADD CONSTRAINT pay_withdraw_pkey PRIMARY KEY (id); -- -- Name: sys_dept sys_dept_code_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dept ADD CONSTRAINT sys_dept_code_key UNIQUE (code); -- -- Name: sys_dept sys_dept_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dept ADD CONSTRAINT sys_dept_pkey PRIMARY KEY (id); -- -- Name: sys_dict_data sys_dict_data_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dict_data ADD CONSTRAINT sys_dict_data_pkey PRIMARY KEY (id); -- -- Name: sys_dict_type sys_dict_type_dict_type_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dict_type ADD CONSTRAINT sys_dict_type_dict_type_key UNIQUE (dict_type); -- -- Name: sys_dict_type sys_dict_type_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dict_type ADD CONSTRAINT sys_dict_type_pkey PRIMARY KEY (id); -- -- Name: sys_invitation_code sys_invitation_code_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_invitation_code ADD CONSTRAINT sys_invitation_code_pkey PRIMARY KEY (id); -- -- Name: sys_log sys_log_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_log ADD CONSTRAINT sys_log_pkey PRIMARY KEY (id); -- -- Name: sys_menu sys_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_menu ADD CONSTRAINT sys_menu_pkey PRIMARY KEY (id); -- -- Name: sys_notice sys_notice_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_notice ADD CONSTRAINT sys_notice_pkey PRIMARY KEY (id); -- -- Name: sys_param sys_param_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_param ADD CONSTRAINT sys_param_pkey PRIMARY KEY (id); -- -- Name: sys_position sys_position_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_position ADD CONSTRAINT sys_position_pkey PRIMARY KEY (id); -- -- Name: sys_role sys_role_code_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role ADD CONSTRAINT sys_role_code_key UNIQUE (code); -- -- Name: sys_role_depts sys_role_depts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role_depts ADD CONSTRAINT sys_role_depts_pkey PRIMARY KEY (role_id, dept_id); -- -- Name: sys_role_menus sys_role_menus_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role_menus ADD CONSTRAINT sys_role_menus_pkey PRIMARY KEY (role_id, menu_id); -- -- Name: sys_role sys_role_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role ADD CONSTRAINT sys_role_pkey PRIMARY KEY (id); -- -- Name: sys_tenant_api_key sys_tenant_api_key_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant_api_key ADD CONSTRAINT sys_tenant_api_key_pkey PRIMARY KEY (id); -- -- Name: sys_tenant_api_log sys_tenant_api_log_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant_api_log ADD CONSTRAINT sys_tenant_api_log_pkey PRIMARY KEY (id); -- -- Name: sys_tenant sys_tenant_code_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant ADD CONSTRAINT sys_tenant_code_key UNIQUE (code); -- -- Name: sys_tenant sys_tenant_name_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant ADD CONSTRAINT sys_tenant_name_key UNIQUE (name); -- -- Name: sys_tenant sys_tenant_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant ADD CONSTRAINT sys_tenant_pkey PRIMARY KEY (id); -- -- Name: sys_user sys_user_email_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_email_key UNIQUE (email); -- -- Name: sys_user sys_user_mobile_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_mobile_key UNIQUE (mobile); -- -- Name: sys_user sys_user_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_pkey PRIMARY KEY (id); -- -- Name: sys_user_positions sys_user_positions_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user_positions ADD CONSTRAINT sys_user_positions_pkey PRIMARY KEY (user_id, position_id); -- -- Name: sys_user_roles sys_user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user_roles ADD CONSTRAINT sys_user_roles_pkey PRIMARY KEY (user_id, role_id); -- -- Name: sys_user sys_user_username_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_username_key UNIQUE (username); -- -- Name: task_job task_job_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_job ADD CONSTRAINT task_job_pkey PRIMARY KEY (id); -- -- Name: task_node task_node_code_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_node ADD CONSTRAINT task_node_code_key UNIQUE (code); -- -- Name: task_node task_node_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_node ADD CONSTRAINT task_node_pkey PRIMARY KEY (id); -- -- Name: task_workflow_node_type task_workflow_node_type_code_key; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow_node_type ADD CONSTRAINT task_workflow_node_type_code_key UNIQUE (code); -- -- Name: task_workflow_node_type task_workflow_node_type_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow_node_type ADD CONSTRAINT task_workflow_node_type_pkey PRIMARY KEY (id); -- -- Name: task_workflow task_workflow_pkey; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow ADD CONSTRAINT task_workflow_pkey PRIMARY KEY (id); -- -- Name: task_workflow uq_task_workflow_code; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow ADD CONSTRAINT uq_task_workflow_code UNIQUE (code); -- -- Name: open_transfer uq_third_biz_tenant; Type: CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_transfer ADD CONSTRAINT uq_third_biz_tenant UNIQUE (third_biz_no, tenant_id); -- -- Name: idx_invitation_code; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX idx_invitation_code ON public.sys_invitation_code USING btree (code); -- -- Name: idx_transfer_retry; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX idx_transfer_retry ON public.pay_transfer USING btree (next_retry_at) WHERE (((status)::text = 'DEALING'::text) AND (retry_count < 4)); -- -- Name: idx_transfer_stat; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX idx_transfer_stat ON public.pay_transfer USING btree (status, created_time, amount); -- -- Name: ix_app_portal_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_created_id ON public.app_portal USING btree (created_id); -- -- Name: ix_app_portal_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_created_time ON public.app_portal USING btree (created_time); -- -- Name: ix_app_portal_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_id ON public.app_portal USING btree (id); -- -- Name: ix_app_portal_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_status ON public.app_portal USING btree (status); -- -- Name: ix_app_portal_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_tenant_id ON public.app_portal USING btree (tenant_id); -- -- Name: ix_app_portal_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_updated_id ON public.app_portal USING btree (updated_id); -- -- Name: ix_app_portal_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_app_portal_updated_time ON public.app_portal USING btree (updated_time); -- -- Name: ix_app_portal_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_app_portal_uuid ON public.app_portal USING btree (uuid); -- -- Name: ix_apscheduler_jobs_next_run_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_apscheduler_jobs_next_run_time ON public.apscheduler_jobs USING btree (next_run_time); -- -- Name: ix_gen_demo01_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo01_created_id ON public.gen_demo01 USING btree (created_id); -- -- Name: ix_gen_demo01_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo01_created_time ON public.gen_demo01 USING btree (created_time); -- -- Name: ix_gen_demo01_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo01_id ON public.gen_demo01 USING btree (id); -- -- Name: ix_gen_demo01_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo01_status ON public.gen_demo01 USING btree (status); -- -- Name: ix_gen_demo01_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo01_updated_id ON public.gen_demo01 USING btree (updated_id); -- -- Name: ix_gen_demo01_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo01_updated_time ON public.gen_demo01 USING btree (updated_time); -- -- Name: ix_gen_demo01_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_gen_demo01_uuid ON public.gen_demo01 USING btree (uuid); -- -- Name: ix_gen_demo_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo_created_id ON public.gen_demo USING btree (created_id); -- -- Name: ix_gen_demo_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo_created_time ON public.gen_demo USING btree (created_time); -- -- Name: ix_gen_demo_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo_id ON public.gen_demo USING btree (id); -- -- Name: ix_gen_demo_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo_status ON public.gen_demo USING btree (status); -- -- Name: ix_gen_demo_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo_updated_id ON public.gen_demo USING btree (updated_id); -- -- Name: ix_gen_demo_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_demo_updated_time ON public.gen_demo USING btree (updated_time); -- -- Name: ix_gen_demo_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_gen_demo_uuid ON public.gen_demo USING btree (uuid); -- -- Name: ix_gen_table_column_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_created_id ON public.gen_table_column USING btree (created_id); -- -- Name: ix_gen_table_column_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_created_time ON public.gen_table_column USING btree (created_time); -- -- Name: ix_gen_table_column_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_id ON public.gen_table_column USING btree (id); -- -- Name: ix_gen_table_column_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_status ON public.gen_table_column USING btree (status); -- -- Name: ix_gen_table_column_table_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_table_id ON public.gen_table_column USING btree (table_id); -- -- Name: ix_gen_table_column_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_updated_id ON public.gen_table_column USING btree (updated_id); -- -- Name: ix_gen_table_column_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_column_updated_time ON public.gen_table_column USING btree (updated_time); -- -- Name: ix_gen_table_column_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_gen_table_column_uuid ON public.gen_table_column USING btree (uuid); -- -- Name: ix_gen_table_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_created_id ON public.gen_table USING btree (created_id); -- -- Name: ix_gen_table_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_created_time ON public.gen_table USING btree (created_time); -- -- Name: ix_gen_table_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_id ON public.gen_table USING btree (id); -- -- Name: ix_gen_table_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_status ON public.gen_table USING btree (status); -- -- Name: ix_gen_table_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_updated_id ON public.gen_table USING btree (updated_id); -- -- Name: ix_gen_table_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_gen_table_updated_time ON public.gen_table USING btree (updated_time); -- -- Name: ix_gen_table_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_gen_table_uuid ON public.gen_table USING btree (uuid); -- -- Name: ix_open_conf_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_conf_created_time ON public.open_conf USING btree (created_time); -- -- Name: ix_open_conf_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_conf_id ON public.open_conf USING btree (id); -- -- Name: ix_open_conf_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_conf_tenant_id ON public.open_conf USING btree (tenant_id); -- -- Name: ix_open_conf_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_conf_updated_time ON public.open_conf USING btree (updated_time); -- -- Name: ix_open_transfer_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_created_time ON public.open_transfer USING btree (created_time); -- -- Name: ix_open_transfer_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_enterprise_id ON public.open_transfer USING btree (enterprise_id); -- -- Name: ix_open_transfer_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_id ON public.open_transfer USING btree (id); -- -- Name: ix_open_transfer_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_out_biz_no ON public.open_transfer USING btree (out_biz_no); -- -- Name: ix_open_transfer_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_status ON public.open_transfer USING btree (status); -- -- Name: ix_open_transfer_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_tenant_id ON public.open_transfer USING btree (tenant_id); -- -- Name: ix_open_transfer_third_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_third_biz_no ON public.open_transfer USING btree (third_biz_no); -- -- Name: ix_open_transfer_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_open_transfer_updated_time ON public.open_transfer USING btree (updated_time); -- -- Name: ix_pay_account_account_book_id; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_account_account_book_id ON public.pay_account USING btree (account_book_id); -- -- Name: ix_pay_account_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_account_created_time ON public.pay_account USING btree (created_time); -- -- Name: ix_pay_account_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_account_enterprise_id ON public.pay_account USING btree (enterprise_id); -- -- Name: ix_pay_account_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_account_id ON public.pay_account USING btree (id); -- -- Name: ix_pay_account_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_account_tenant_id ON public.pay_account USING btree (tenant_id); -- -- Name: ix_pay_account_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_account_updated_time ON public.pay_account USING btree (updated_time); -- -- Name: ix_pay_alipay_notify_log_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_alipay_notify_log_created_time ON public.pay_alipay_notify_log USING btree (created_time); -- -- Name: ix_pay_alipay_notify_log_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_alipay_notify_log_id ON public.pay_alipay_notify_log USING btree (id); -- -- Name: ix_pay_alipay_notify_log_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_alipay_notify_log_status ON public.pay_alipay_notify_log USING btree (status); -- -- Name: ix_pay_alipay_notify_log_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_alipay_notify_log_updated_time ON public.pay_alipay_notify_log USING btree (updated_time); -- -- Name: ix_pay_bill_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_created_time ON public.pay_bill USING btree (created_time); -- -- Name: ix_pay_bill_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_enterprise_id ON public.pay_bill USING btree (enterprise_id); -- -- Name: ix_pay_bill_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_id ON public.pay_bill USING btree (id); -- -- Name: ix_pay_bill_order_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_created_time ON public.pay_bill_order USING btree (created_time); -- -- Name: ix_pay_bill_order_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_enterprise_id ON public.pay_bill_order USING btree (enterprise_id); -- -- Name: ix_pay_bill_order_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_id ON public.pay_bill_order USING btree (id); -- -- Name: ix_pay_bill_order_order_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_bill_order_order_no ON public.pay_bill_order USING btree (order_no); -- -- Name: ix_pay_bill_order_pay_no; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_pay_no ON public.pay_bill_order USING btree (pay_no); -- -- Name: ix_pay_bill_order_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_status ON public.pay_bill_order USING btree (status); -- -- Name: ix_pay_bill_order_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_tenant_id ON public.pay_bill_order USING btree (tenant_id); -- -- Name: ix_pay_bill_order_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_order_updated_time ON public.pay_bill_order USING btree (updated_time); -- -- Name: ix_pay_bill_pay_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_bill_pay_no ON public.pay_bill USING btree (pay_no); -- -- Name: ix_pay_bill_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_tenant_id ON public.pay_bill USING btree (tenant_id); -- -- Name: ix_pay_bill_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_updated_time ON public.pay_bill USING btree (updated_time); -- -- Name: ix_pay_bill_voucher_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_created_time ON public.pay_bill_voucher USING btree (created_time); -- -- Name: ix_pay_bill_voucher_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_enterprise_id ON public.pay_bill_voucher USING btree (enterprise_id); -- -- Name: ix_pay_bill_voucher_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_id ON public.pay_bill_voucher USING btree (id); -- -- Name: ix_pay_bill_voucher_pay_no; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_pay_no ON public.pay_bill_voucher USING btree (pay_no); -- -- Name: ix_pay_bill_voucher_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_status ON public.pay_bill_voucher USING btree (status); -- -- Name: ix_pay_bill_voucher_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_tenant_id ON public.pay_bill_voucher USING btree (tenant_id); -- -- Name: ix_pay_bill_voucher_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_updated_time ON public.pay_bill_voucher USING btree (updated_time); -- -- Name: ix_pay_bill_voucher_voucher_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_bill_voucher_voucher_id ON public.pay_bill_voucher USING btree (voucher_id); -- -- Name: ix_pay_department_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_department_enterprise_id ON public.pay_department USING btree (enterprise_id); -- -- Name: ix_pay_department_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_department_id ON public.pay_department USING btree (id); -- -- Name: ix_pay_department_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_department_tenant_id ON public.pay_department USING btree (tenant_id); -- -- Name: ix_pay_deposit_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_deposit_created_time ON public.pay_deposit USING btree (created_time); -- -- Name: ix_pay_deposit_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_deposit_enterprise_id ON public.pay_deposit USING btree (enterprise_id); -- -- Name: ix_pay_deposit_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_deposit_id ON public.pay_deposit USING btree (id); -- -- Name: ix_pay_deposit_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_deposit_out_biz_no ON public.pay_deposit USING btree (out_biz_no); -- -- Name: ix_pay_deposit_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_deposit_tenant_id ON public.pay_deposit USING btree (tenant_id); -- -- Name: ix_pay_deposit_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_deposit_updated_time ON public.pay_deposit USING btree (updated_time); -- -- Name: ix_pay_employee_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_employee_created_time ON public.pay_employee USING btree (created_time); -- -- Name: ix_pay_employee_employee_no; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_employee_employee_no ON public.pay_employee USING btree (employee_no); -- -- Name: ix_pay_employee_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_employee_enterprise_id ON public.pay_employee USING btree (enterprise_id); -- -- Name: ix_pay_employee_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_employee_id ON public.pay_employee USING btree (id); -- -- Name: ix_pay_employee_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_employee_tenant_id ON public.pay_employee USING btree (tenant_id); -- -- Name: ix_pay_employee_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_employee_updated_time ON public.pay_employee USING btree (updated_time); -- -- Name: ix_pay_enterprise_account_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_enterprise_account_id ON public.pay_enterprise USING btree (account_id); -- -- Name: ix_pay_enterprise_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_enterprise_created_time ON public.pay_enterprise USING btree (created_time); -- -- Name: ix_pay_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_enterprise_id ON public.pay_enterprise USING btree (id); -- -- Name: ix_pay_enterprise_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_enterprise_out_biz_no ON public.pay_enterprise USING btree (out_biz_no); -- -- Name: ix_pay_enterprise_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_enterprise_tenant_id ON public.pay_enterprise USING btree (tenant_id); -- -- Name: ix_pay_enterprise_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_enterprise_updated_time ON public.pay_enterprise USING btree (updated_time); -- -- Name: ix_pay_expense_institution_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_institution_created_time ON public.pay_expense_institution USING btree (created_time); -- -- Name: ix_pay_expense_institution_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_institution_enterprise_id ON public.pay_expense_institution USING btree (enterprise_id); -- -- Name: ix_pay_expense_institution_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_institution_id ON public.pay_expense_institution USING btree (id); -- -- Name: ix_pay_expense_institution_institution_id; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_expense_institution_institution_id ON public.pay_expense_institution USING btree (institution_id); -- -- Name: ix_pay_expense_institution_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_institution_tenant_id ON public.pay_expense_institution USING btree (tenant_id); -- -- Name: ix_pay_expense_institution_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_institution_updated_time ON public.pay_expense_institution USING btree (updated_time); -- -- Name: ix_pay_expense_issue_batch_batch_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_expense_issue_batch_batch_no ON public.pay_expense_issue_batch USING btree (batch_no); -- -- Name: ix_pay_expense_issue_batch_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_issue_batch_created_time ON public.pay_expense_issue_batch USING btree (created_time); -- -- Name: ix_pay_expense_issue_batch_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_issue_batch_enterprise_id ON public.pay_expense_issue_batch USING btree (enterprise_id); -- -- Name: ix_pay_expense_issue_batch_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_issue_batch_id ON public.pay_expense_issue_batch USING btree (id); -- -- Name: ix_pay_expense_issue_batch_institution_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_issue_batch_institution_id ON public.pay_expense_issue_batch USING btree (institution_id); -- -- Name: ix_pay_expense_issue_batch_issue_batch_id; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_expense_issue_batch_issue_batch_id ON public.pay_expense_issue_batch USING btree (issue_batch_id); -- -- Name: ix_pay_expense_issue_batch_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_issue_batch_tenant_id ON public.pay_expense_issue_batch USING btree (tenant_id); -- -- Name: ix_pay_expense_issue_batch_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_issue_batch_updated_time ON public.pay_expense_issue_batch USING btree (updated_time); -- -- Name: ix_pay_expense_quota_change_log_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_created_time ON public.pay_expense_quota_change_log USING btree (created_time); -- -- Name: ix_pay_expense_quota_change_log_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_enterprise_id ON public.pay_expense_quota_change_log USING btree (enterprise_id); -- -- Name: ix_pay_expense_quota_change_log_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_id ON public.pay_expense_quota_change_log USING btree (id); -- -- Name: ix_pay_expense_quota_change_log_quota_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_quota_id ON public.pay_expense_quota_change_log USING btree (quota_id); -- -- Name: ix_pay_expense_quota_change_log_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_status ON public.pay_expense_quota_change_log USING btree (status); -- -- Name: ix_pay_expense_quota_change_log_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_tenant_id ON public.pay_expense_quota_change_log USING btree (tenant_id); -- -- Name: ix_pay_expense_quota_change_log_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_change_log_updated_time ON public.pay_expense_quota_change_log USING btree (updated_time); -- -- Name: ix_pay_expense_quota_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_created_time ON public.pay_expense_quota USING btree (created_time); -- -- Name: ix_pay_expense_quota_employee_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_employee_id ON public.pay_expense_quota USING btree (employee_id); -- -- Name: ix_pay_expense_quota_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_enterprise_id ON public.pay_expense_quota USING btree (enterprise_id); -- -- Name: ix_pay_expense_quota_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_id ON public.pay_expense_quota USING btree (id); -- -- Name: ix_pay_expense_quota_institution_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_institution_id ON public.pay_expense_quota USING btree (institution_id); -- -- Name: ix_pay_expense_quota_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_expense_quota_out_biz_no ON public.pay_expense_quota USING btree (out_biz_no); -- -- Name: ix_pay_expense_quota_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_tenant_id ON public.pay_expense_quota USING btree (tenant_id); -- -- Name: ix_pay_expense_quota_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_quota_updated_time ON public.pay_expense_quota USING btree (updated_time); -- -- Name: ix_pay_expense_rule_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_rule_created_time ON public.pay_expense_rule USING btree (created_time); -- -- Name: ix_pay_expense_rule_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_rule_enterprise_id ON public.pay_expense_rule USING btree (enterprise_id); -- -- Name: ix_pay_expense_rule_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_rule_id ON public.pay_expense_rule USING btree (id); -- -- Name: ix_pay_expense_rule_institution_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_rule_institution_id ON public.pay_expense_rule USING btree (institution_id); -- -- Name: ix_pay_expense_rule_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_expense_rule_out_biz_no ON public.pay_expense_rule USING btree (out_biz_no); -- -- Name: ix_pay_expense_rule_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_rule_tenant_id ON public.pay_expense_rule USING btree (tenant_id); -- -- Name: ix_pay_expense_rule_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_expense_rule_updated_time ON public.pay_expense_rule USING btree (updated_time); -- -- Name: ix_pay_facetoface_order_batch_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_facetoface_order_batch_no ON public.pay_facetoface_order USING btree (batch_no); -- -- Name: ix_pay_facetoface_order_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_created_time ON public.pay_facetoface_order USING btree (created_time); -- -- Name: ix_pay_facetoface_order_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_facetoface_order_enterprise_id ON public.pay_facetoface_order USING btree (enterprise_id); -- -- Name: ix_pay_facetoface_order_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_id ON public.pay_facetoface_order USING btree (id); -- -- Name: ix_pay_facetoface_order_next_query_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_next_query_time ON public.pay_facetoface_order USING btree (next_query_time); -- -- Name: ix_pay_facetoface_order_order_no; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_order_no ON public.pay_facetoface_order USING btree (order_no); -- -- Name: ix_pay_facetoface_order_order_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_order_status ON public.pay_facetoface_order USING btree (order_status); -- -- Name: ix_pay_facetoface_order_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_status ON public.pay_facetoface_order USING btree (status); -- -- Name: ix_pay_facetoface_order_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_tenant_id ON public.pay_facetoface_order USING btree (tenant_id); -- -- Name: ix_pay_facetoface_order_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_facetoface_order_updated_time ON public.pay_facetoface_order USING btree (updated_time); -- -- Name: ix_pay_points_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_created_time ON public.pay_points USING btree (created_time); -- -- Name: ix_pay_points_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_id ON public.pay_points USING btree (id); -- -- Name: ix_pay_points_record_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_created_time ON public.pay_points_record USING btree (created_time); -- -- Name: ix_pay_points_record_employee_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_employee_id ON public.pay_points_record USING btree (employee_id); -- -- Name: ix_pay_points_record_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_enterprise_id ON public.pay_points_record USING btree (enterprise_id); -- -- Name: ix_pay_points_record_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_id ON public.pay_points_record USING btree (id); -- -- Name: ix_pay_points_record_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_status ON public.pay_points_record USING btree (status); -- -- Name: ix_pay_points_record_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_tenant_id ON public.pay_points_record USING btree (tenant_id); -- -- Name: ix_pay_points_record_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_record_updated_time ON public.pay_points_record USING btree (updated_time); -- -- Name: ix_pay_points_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_tenant_id ON public.pay_points USING btree (tenant_id); -- -- Name: ix_pay_points_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_points_updated_time ON public.pay_points USING btree (updated_time); -- -- Name: ix_pay_transfer_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_transfer_created_time ON public.pay_transfer USING btree (created_time); -- -- Name: ix_pay_transfer_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_transfer_enterprise_id ON public.pay_transfer USING btree (enterprise_id); -- -- Name: ix_pay_transfer_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_transfer_id ON public.pay_transfer USING btree (id); -- -- Name: ix_pay_transfer_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_transfer_out_biz_no ON public.pay_transfer USING btree (out_biz_no); -- -- Name: ix_pay_transfer_payee_type; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_transfer_payee_type ON public.pay_transfer USING btree (payee_type); -- -- Name: ix_pay_transfer_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_transfer_tenant_id ON public.pay_transfer USING btree (tenant_id); -- -- Name: ix_pay_transfer_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_transfer_updated_time ON public.pay_transfer USING btree (updated_time); -- -- Name: ix_pay_withdraw_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_withdraw_created_time ON public.pay_withdraw USING btree (created_time); -- -- Name: ix_pay_withdraw_enterprise_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_withdraw_enterprise_id ON public.pay_withdraw USING btree (enterprise_id); -- -- Name: ix_pay_withdraw_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_withdraw_id ON public.pay_withdraw USING btree (id); -- -- Name: ix_pay_withdraw_out_biz_no; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_pay_withdraw_out_biz_no ON public.pay_withdraw USING btree (out_biz_no); -- -- Name: ix_pay_withdraw_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_withdraw_tenant_id ON public.pay_withdraw USING btree (tenant_id); -- -- Name: ix_pay_withdraw_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_pay_withdraw_updated_time ON public.pay_withdraw USING btree (updated_time); -- -- Name: ix_sys_dept_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dept_created_time ON public.sys_dept USING btree (created_time); -- -- Name: ix_sys_dept_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dept_id ON public.sys_dept USING btree (id); -- -- Name: ix_sys_dept_parent_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dept_parent_id ON public.sys_dept USING btree (parent_id); -- -- Name: ix_sys_dept_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dept_status ON public.sys_dept USING btree (status); -- -- Name: ix_sys_dept_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dept_updated_time ON public.sys_dept USING btree (updated_time); -- -- Name: ix_sys_dept_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_dept_uuid ON public.sys_dept USING btree (uuid); -- -- Name: ix_sys_dict_data_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_data_created_time ON public.sys_dict_data USING btree (created_time); -- -- Name: ix_sys_dict_data_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_data_id ON public.sys_dict_data USING btree (id); -- -- Name: ix_sys_dict_data_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_data_status ON public.sys_dict_data USING btree (status); -- -- Name: ix_sys_dict_data_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_data_updated_time ON public.sys_dict_data USING btree (updated_time); -- -- Name: ix_sys_dict_data_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_dict_data_uuid ON public.sys_dict_data USING btree (uuid); -- -- Name: ix_sys_dict_type_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_type_created_time ON public.sys_dict_type USING btree (created_time); -- -- Name: ix_sys_dict_type_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_type_id ON public.sys_dict_type USING btree (id); -- -- Name: ix_sys_dict_type_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_type_status ON public.sys_dict_type USING btree (status); -- -- Name: ix_sys_dict_type_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_dict_type_updated_time ON public.sys_dict_type USING btree (updated_time); -- -- Name: ix_sys_dict_type_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_dict_type_uuid ON public.sys_dict_type USING btree (uuid); -- -- Name: ix_sys_log_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_log_created_id ON public.sys_log USING btree (created_id); -- -- Name: ix_sys_log_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_log_created_time ON public.sys_log USING btree (created_time); -- -- Name: ix_sys_log_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_log_id ON public.sys_log USING btree (id); -- -- Name: ix_sys_log_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_log_status ON public.sys_log USING btree (status); -- -- Name: ix_sys_log_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_log_updated_id ON public.sys_log USING btree (updated_id); -- -- Name: ix_sys_log_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_log_updated_time ON public.sys_log USING btree (updated_time); -- -- Name: ix_sys_log_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_log_uuid ON public.sys_log USING btree (uuid); -- -- Name: ix_sys_menu_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_menu_created_time ON public.sys_menu USING btree (created_time); -- -- Name: ix_sys_menu_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_menu_id ON public.sys_menu USING btree (id); -- -- Name: ix_sys_menu_parent_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_menu_parent_id ON public.sys_menu USING btree (parent_id); -- -- Name: ix_sys_menu_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_menu_status ON public.sys_menu USING btree (status); -- -- Name: ix_sys_menu_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_menu_updated_time ON public.sys_menu USING btree (updated_time); -- -- Name: ix_sys_menu_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_menu_uuid ON public.sys_menu USING btree (uuid); -- -- Name: ix_sys_notice_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_notice_created_id ON public.sys_notice USING btree (created_id); -- -- Name: ix_sys_notice_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_notice_created_time ON public.sys_notice USING btree (created_time); -- -- Name: ix_sys_notice_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_notice_id ON public.sys_notice USING btree (id); -- -- Name: ix_sys_notice_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_notice_status ON public.sys_notice USING btree (status); -- -- Name: ix_sys_notice_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_notice_updated_id ON public.sys_notice USING btree (updated_id); -- -- Name: ix_sys_notice_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_notice_updated_time ON public.sys_notice USING btree (updated_time); -- -- Name: ix_sys_notice_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_notice_uuid ON public.sys_notice USING btree (uuid); -- -- Name: ix_sys_param_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_param_created_time ON public.sys_param USING btree (created_time); -- -- Name: ix_sys_param_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_param_id ON public.sys_param USING btree (id); -- -- Name: ix_sys_param_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_param_status ON public.sys_param USING btree (status); -- -- Name: ix_sys_param_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_param_updated_time ON public.sys_param USING btree (updated_time); -- -- Name: ix_sys_param_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_param_uuid ON public.sys_param USING btree (uuid); -- -- Name: ix_sys_position_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_position_created_id ON public.sys_position USING btree (created_id); -- -- Name: ix_sys_position_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_position_created_time ON public.sys_position USING btree (created_time); -- -- Name: ix_sys_position_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_position_id ON public.sys_position USING btree (id); -- -- Name: ix_sys_position_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_position_status ON public.sys_position USING btree (status); -- -- Name: ix_sys_position_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_position_updated_id ON public.sys_position USING btree (updated_id); -- -- Name: ix_sys_position_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_position_updated_time ON public.sys_position USING btree (updated_time); -- -- Name: ix_sys_position_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_position_uuid ON public.sys_position USING btree (uuid); -- -- Name: ix_sys_role_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_role_created_time ON public.sys_role USING btree (created_time); -- -- Name: ix_sys_role_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_role_id ON public.sys_role USING btree (id); -- -- Name: ix_sys_role_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_role_status ON public.sys_role USING btree (status); -- -- Name: ix_sys_role_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_role_updated_time ON public.sys_role USING btree (updated_time); -- -- Name: ix_sys_role_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_role_uuid ON public.sys_role USING btree (uuid); -- -- Name: ix_sys_tenant_api_key_api_key; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_tenant_api_key_api_key ON public.sys_tenant_api_key USING btree (api_key); -- -- Name: ix_sys_tenant_api_key_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_key_created_time ON public.sys_tenant_api_key USING btree (created_time); -- -- Name: ix_sys_tenant_api_key_expired_at; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_key_expired_at ON public.sys_tenant_api_key USING btree (expired_at); -- -- Name: ix_sys_tenant_api_key_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_key_id ON public.sys_tenant_api_key USING btree (id); -- -- Name: ix_sys_tenant_api_key_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_key_status ON public.sys_tenant_api_key USING btree (status); -- -- Name: ix_sys_tenant_api_key_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_key_tenant_id ON public.sys_tenant_api_key USING btree (tenant_id); -- -- Name: ix_sys_tenant_api_key_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_key_updated_time ON public.sys_tenant_api_key USING btree (updated_time); -- -- Name: ix_sys_tenant_api_key_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_tenant_api_key_uuid ON public.sys_tenant_api_key USING btree (uuid); -- -- Name: ix_sys_tenant_api_log_api_key_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_api_key_id ON public.sys_tenant_api_log USING btree (api_key_id); -- -- Name: ix_sys_tenant_api_log_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_created_time ON public.sys_tenant_api_log USING btree (created_time); -- -- Name: ix_sys_tenant_api_log_endpoint; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_endpoint ON public.sys_tenant_api_log USING btree (endpoint); -- -- Name: ix_sys_tenant_api_log_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_id ON public.sys_tenant_api_log USING btree (id); -- -- Name: ix_sys_tenant_api_log_request_ip; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_request_ip ON public.sys_tenant_api_log USING btree (request_ip); -- -- Name: ix_sys_tenant_api_log_response_code; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_response_code ON public.sys_tenant_api_log USING btree (response_code); -- -- Name: ix_sys_tenant_api_log_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_status ON public.sys_tenant_api_log USING btree (status); -- -- Name: ix_sys_tenant_api_log_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_tenant_id ON public.sys_tenant_api_log USING btree (tenant_id); -- -- Name: ix_sys_tenant_api_log_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_api_log_updated_time ON public.sys_tenant_api_log USING btree (updated_time); -- -- Name: ix_sys_tenant_api_log_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_tenant_api_log_uuid ON public.sys_tenant_api_log USING btree (uuid); -- -- Name: ix_sys_tenant_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_created_time ON public.sys_tenant USING btree (created_time); -- -- Name: ix_sys_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_id ON public.sys_tenant USING btree (id); -- -- Name: ix_sys_tenant_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_status ON public.sys_tenant USING btree (status); -- -- Name: ix_sys_tenant_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_tenant_updated_time ON public.sys_tenant USING btree (updated_time); -- -- Name: ix_sys_tenant_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_tenant_uuid ON public.sys_tenant USING btree (uuid); -- -- Name: ix_sys_user_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_created_id ON public.sys_user USING btree (created_id); -- -- Name: ix_sys_user_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_created_time ON public.sys_user USING btree (created_time); -- -- Name: ix_sys_user_dept_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_dept_id ON public.sys_user USING btree (dept_id); -- -- Name: ix_sys_user_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_id ON public.sys_user USING btree (id); -- -- Name: ix_sys_user_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_status ON public.sys_user USING btree (status); -- -- Name: ix_sys_user_tenant_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_tenant_id ON public.sys_user USING btree (tenant_id); -- -- Name: ix_sys_user_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_updated_id ON public.sys_user USING btree (updated_id); -- -- Name: ix_sys_user_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_sys_user_updated_time ON public.sys_user USING btree (updated_time); -- -- Name: ix_sys_user_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_sys_user_uuid ON public.sys_user USING btree (uuid); -- -- Name: ix_task_job_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_job_created_time ON public.task_job USING btree (created_time); -- -- Name: ix_task_job_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_job_id ON public.task_job USING btree (id); -- -- Name: ix_task_job_job_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_job_job_id ON public.task_job USING btree (job_id); -- -- Name: ix_task_job_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_job_updated_time ON public.task_job USING btree (updated_time); -- -- Name: ix_task_job_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_task_job_uuid ON public.task_job USING btree (uuid); -- -- Name: ix_task_node_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_node_created_id ON public.task_node USING btree (created_id); -- -- Name: ix_task_node_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_node_created_time ON public.task_node USING btree (created_time); -- -- Name: ix_task_node_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_node_id ON public.task_node USING btree (id); -- -- Name: ix_task_node_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_node_status ON public.task_node USING btree (status); -- -- Name: ix_task_node_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_node_updated_id ON public.task_node USING btree (updated_id); -- -- Name: ix_task_node_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_node_updated_time ON public.task_node USING btree (updated_time); -- -- Name: ix_task_node_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_task_node_uuid ON public.task_node USING btree (uuid); -- -- Name: ix_task_workflow_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_created_id ON public.task_workflow USING btree (created_id); -- -- Name: ix_task_workflow_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_created_time ON public.task_workflow USING btree (created_time); -- -- Name: ix_task_workflow_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_id ON public.task_workflow USING btree (id); -- -- Name: ix_task_workflow_node_type_created_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_node_type_created_id ON public.task_workflow_node_type USING btree (created_id); -- -- Name: ix_task_workflow_node_type_created_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_node_type_created_time ON public.task_workflow_node_type USING btree (created_time); -- -- Name: ix_task_workflow_node_type_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_node_type_id ON public.task_workflow_node_type USING btree (id); -- -- Name: ix_task_workflow_node_type_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_node_type_status ON public.task_workflow_node_type USING btree (status); -- -- Name: ix_task_workflow_node_type_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_node_type_updated_id ON public.task_workflow_node_type USING btree (updated_id); -- -- Name: ix_task_workflow_node_type_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_node_type_updated_time ON public.task_workflow_node_type USING btree (updated_time); -- -- Name: ix_task_workflow_node_type_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_task_workflow_node_type_uuid ON public.task_workflow_node_type USING btree (uuid); -- -- Name: ix_task_workflow_status; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_status ON public.task_workflow USING btree (status); -- -- Name: ix_task_workflow_updated_id; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_updated_id ON public.task_workflow USING btree (updated_id); -- -- Name: ix_task_workflow_updated_time; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX ix_task_workflow_updated_time ON public.task_workflow USING btree (updated_time); -- -- Name: ix_task_workflow_uuid; Type: INDEX; Schema: public; Owner: admin -- CREATE UNIQUE INDEX ix_task_workflow_uuid ON public.task_workflow USING btree (uuid); -- -- Name: open_transfer_api_key_index; Type: INDEX; Schema: public; Owner: admin -- CREATE INDEX open_transfer_api_key_index ON public.open_transfer USING btree (api_key); -- -- Name: app_portal app_portal_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.app_portal ADD CONSTRAINT app_portal_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: app_portal app_portal_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.app_portal ADD CONSTRAINT app_portal_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: app_portal app_portal_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.app_portal ADD CONSTRAINT app_portal_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_demo01 gen_demo01_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo01 ADD CONSTRAINT gen_demo01_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_demo01 gen_demo01_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo01 ADD CONSTRAINT gen_demo01_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_demo gen_demo_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo ADD CONSTRAINT gen_demo_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_demo gen_demo_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_demo ADD CONSTRAINT gen_demo_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_table_column gen_table_column_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table_column ADD CONSTRAINT gen_table_column_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_table_column gen_table_column_table_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table_column ADD CONSTRAINT gen_table_column_table_id_fkey FOREIGN KEY (table_id) REFERENCES public.gen_table(id) ON DELETE CASCADE; -- -- Name: gen_table_column gen_table_column_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table_column ADD CONSTRAINT gen_table_column_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_table gen_table_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table ADD CONSTRAINT gen_table_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: gen_table gen_table_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.gen_table ADD CONSTRAINT gen_table_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: open_conf open_conf_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_conf ADD CONSTRAINT open_conf_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: open_transfer open_transfer_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.open_transfer ADD CONSTRAINT open_transfer_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_account pay_account_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_account ADD CONSTRAINT pay_account_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_bill_order pay_bill_order_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill_order ADD CONSTRAINT pay_bill_order_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_bill pay_bill_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill ADD CONSTRAINT pay_bill_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_bill_voucher pay_bill_voucher_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_bill_voucher ADD CONSTRAINT pay_bill_voucher_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_department pay_department_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_department ADD CONSTRAINT pay_department_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_deposit pay_deposit_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_deposit ADD CONSTRAINT pay_deposit_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_employee pay_employee_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_employee ADD CONSTRAINT pay_employee_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_employee pay_employee_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_employee ADD CONSTRAINT pay_employee_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: pay_enterprise pay_enterprise_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_enterprise ADD CONSTRAINT pay_enterprise_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_expense_institution pay_expense_institution_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_institution ADD CONSTRAINT pay_expense_institution_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_expense_issue_batch pay_expense_issue_batch_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_issue_batch ADD CONSTRAINT pay_expense_issue_batch_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_expense_quota_change_log pay_expense_quota_change_log_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_quota_change_log ADD CONSTRAINT pay_expense_quota_change_log_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_expense_quota pay_expense_quota_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_quota ADD CONSTRAINT pay_expense_quota_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_expense_rule pay_expense_rule_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_expense_rule ADD CONSTRAINT pay_expense_rule_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_facetoface_order pay_facetoface_order_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_facetoface_order ADD CONSTRAINT pay_facetoface_order_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_points_record pay_points_record_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_points_record ADD CONSTRAINT pay_points_record_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_points pay_points_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_points ADD CONSTRAINT pay_points_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_transfer pay_transfer_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_transfer ADD CONSTRAINT pay_transfer_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: pay_withdraw pay_withdraw_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.pay_withdraw ADD CONSTRAINT pay_withdraw_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: sys_dept sys_dept_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dept ADD CONSTRAINT sys_dept_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES public.sys_dept(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_dict_data sys_dict_data_dict_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_dict_data ADD CONSTRAINT sys_dict_data_dict_type_id_fkey FOREIGN KEY (dict_type_id) REFERENCES public.sys_dict_type(id) ON DELETE CASCADE; -- -- Name: sys_log sys_log_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_log ADD CONSTRAINT sys_log_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_log sys_log_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_log ADD CONSTRAINT sys_log_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_menu sys_menu_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_menu ADD CONSTRAINT sys_menu_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES public.sys_menu(id) ON DELETE SET NULL; -- -- Name: sys_notice sys_notice_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_notice ADD CONSTRAINT sys_notice_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_notice sys_notice_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_notice ADD CONSTRAINT sys_notice_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_position sys_position_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_position ADD CONSTRAINT sys_position_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_position sys_position_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_position ADD CONSTRAINT sys_position_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_role_depts sys_role_depts_dept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role_depts ADD CONSTRAINT sys_role_depts_dept_id_fkey FOREIGN KEY (dept_id) REFERENCES public.sys_dept(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_role_depts sys_role_depts_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role_depts ADD CONSTRAINT sys_role_depts_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.sys_role(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_role_menus sys_role_menus_menu_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role_menus ADD CONSTRAINT sys_role_menus_menu_id_fkey FOREIGN KEY (menu_id) REFERENCES public.sys_menu(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_role_menus sys_role_menus_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_role_menus ADD CONSTRAINT sys_role_menus_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.sys_role(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_tenant_api_key sys_tenant_api_key_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant_api_key ADD CONSTRAINT sys_tenant_api_key_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_tenant_api_log sys_tenant_api_log_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_tenant_api_log ADD CONSTRAINT sys_tenant_api_log_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: sys_user sys_user_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_user sys_user_dept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_dept_id_fkey FOREIGN KEY (dept_id) REFERENCES public.sys_dept(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: sys_user_positions sys_user_positions_position_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user_positions ADD CONSTRAINT sys_user_positions_position_id_fkey FOREIGN KEY (position_id) REFERENCES public.sys_position(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_user_positions sys_user_positions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user_positions ADD CONSTRAINT sys_user_positions_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_user_roles sys_user_roles_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user_roles ADD CONSTRAINT sys_user_roles_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.sys_role(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_user_roles sys_user_roles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user_roles ADD CONSTRAINT sys_user_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sys_user sys_user_tenant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_tenant_id_fkey FOREIGN KEY (tenant_id) REFERENCES public.sys_tenant(id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: sys_user sys_user_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.sys_user ADD CONSTRAINT sys_user_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: task_node task_node_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_node ADD CONSTRAINT task_node_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: task_node task_node_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_node ADD CONSTRAINT task_node_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: task_workflow task_workflow_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow ADD CONSTRAINT task_workflow_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: task_workflow_node_type task_workflow_node_type_created_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow_node_type ADD CONSTRAINT task_workflow_node_type_created_id_fkey FOREIGN KEY (created_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: task_workflow_node_type task_workflow_node_type_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow_node_type ADD CONSTRAINT task_workflow_node_type_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: task_workflow task_workflow_updated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin -- ALTER TABLE ONLY public.task_workflow ADD CONSTRAINT task_workflow_updated_id_fkey FOREIGN KEY (updated_id) REFERENCES public.sys_user(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- PostgreSQL database dump complete -- \unrestrict swEXqwojduBDQKpOx6Q25cRqHXnmaoe4Lr0hssIzgdaajrTqce9nudi6lVrIVLR