leietal/senmesh-zc
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
senmesh-zc/deploy/offline/sql/01-init-table.sql
KodouWZF 4eb67e246e feat(交付): 客户侧两台服务器离线部署包 
内网机/外网机各起一套栈，两台之间不开任何端口，文件只经光闸在
gate/out 与对端 gate/in 之间单向摆渡。一份 compose + 一份 config +
一份 nginx 模板，全部差异收在 .env 里。

- docker-compose.yml：5 服务只发布前端端口；app 容器 IP 锁死并由
  compose 注入 -Dcode.snowflake.workid.<IP>=<WORK_ID>，绕开兜底 99
  超雪花 5 位上限导致启动即崩的问题
- .env.iw / .env.ow：出厂配置与随机口令已填好，仅 MESHSAFE_SECRET
  故意留占位（以 MeshSafe 侧白名单为准）；按 maintainer 决定原样入库
- install.sh iw|ow：按角色建 .env -> 自检 -> sha256 校验 tar -> 架构
  核对 -> docker load 后校验 tag -> 建目录/属主/SELinux 标签 -> 起栈
  并逐个等健康。修掉 pipefail 下 `grep | head -1` 静默中断、架构字段
  误读 manifest.json（实际在 Config blob）、die() 未定义先被调用
- export-images.sh：就地刷新 images/*.tar、sql、.env 的 tag 与
  SHA256SUMS，再打 dist 交付盘；tar 与 SHA256SUMS 由 .gitignore 排除
- sql/01+02：从 backend/db 的 PG 全量与初始数据覆盖拷贝。三个
  upgrade-*.sql 的 PG 段（x_upload_config、x_file_security）已在
  init-table-postgres-full.sql 内，空库跑 01->02 即完整现状
- smoke_test.py：18 条断言的现场验收，凭证全部走环境变量
- 部署说明.md：拓扑、交付清单、出厂口令表、iw/ow 差异、验收清单、
  13 条已知坑

镜像 tar 不进 git，装机包由 export-images.sh 出盘。
2026-11-02 20:40:16 +08:00

2083 lines
92 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- PostgreSQL Database Initialization Script
-- Converted from MySQL with Column Comments
-- ----------------------------
-- Table structure for async_task_notice
-- ----------------------------
DROP TABLE IF EXISTS async_task_notice;
CREATE TABLE async_task_notice (
id BIGSERIAL PRIMARY KEY,
union_type VARCHAR(32) NOT NULL,
union_id BIGINT NOT NULL,
content VARCHAR(255) NOT NULL,
biz_status_str VARCHAR(32) DEFAULT NULL,
biz_param_data VARCHAR(512) DEFAULT NULL,
flow_status SMALLINT DEFAULT 1,
notice_status SMALLINT DEFAULT 1,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_create_by ON async_task_notice(create_by);
CREATE INDEX idx_union ON async_task_notice(union_type,union_id);
COMMENT ON TABLE async_task_notice IS '异步任务通知';
COMMENT ON COLUMN async_task_notice.id IS '主键';
COMMENT ON COLUMN async_task_notice.union_type IS '关联类型：common_import等';
COMMENT ON COLUMN async_task_notice.union_id IS '关联id';
COMMENT ON COLUMN async_task_notice.content IS '内容';
COMMENT ON COLUMN async_task_notice.biz_status_str IS '业务状态';
COMMENT ON COLUMN async_task_notice.biz_param_data IS '业务参数';
COMMENT ON COLUMN async_task_notice.flow_status IS '流程状态：1开启，2结束';
COMMENT ON COLUMN async_task_notice.notice_status IS '通知状态：1未读，2已读';
COMMENT ON COLUMN async_task_notice.deleted IS '是否逻辑删除';
COMMENT ON COLUMN async_task_notice.create_by IS '创建人';
COMMENT ON COLUMN async_task_notice.create_time IS '创建时间';
COMMENT ON COLUMN async_task_notice.update_by IS '更新人';
COMMENT ON COLUMN async_task_notice.update_time IS '更新时间';
COMMENT ON COLUMN async_task_notice.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for notice_content_template
-- ----------------------------
DROP TABLE IF EXISTS notice_content_template;
CREATE TABLE notice_content_template (
id BIGSERIAL PRIMARY KEY,
template_id BIGINT DEFAULT NULL,
channel_type SMALLINT DEFAULT NULL,
title VARCHAR(64) DEFAULT NULL,
content_template TEXT,
enabled BOOLEAN DEFAULT TRUE,
link VARCHAR(128) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE notice_content_template IS '通知消息体模版';
COMMENT ON COLUMN notice_content_template.id IS '主键';
COMMENT ON COLUMN notice_content_template.template_id IS '通知模版id';
COMMENT ON COLUMN notice_content_template.channel_type IS '消息通道类型:1站内信,2短信,3钉钉,4企业微信,5邮件(见notice_channel_type)';
COMMENT ON COLUMN notice_content_template.title IS '标题';
COMMENT ON COLUMN notice_content_template.content_template IS '内容模版';
COMMENT ON COLUMN notice_content_template.enabled IS '是否启用';
COMMENT ON COLUMN notice_content_template.link IS '链接';
COMMENT ON COLUMN notice_content_template.deleted IS '是否逻辑删除';
COMMENT ON COLUMN notice_content_template.create_by IS '创建人';
COMMENT ON COLUMN notice_content_template.create_time IS '创建时间';
COMMENT ON COLUMN notice_content_template.update_by IS '更新人';
COMMENT ON COLUMN notice_content_template.update_time IS '更新时间';
COMMENT ON COLUMN notice_content_template.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for notice_receiver_setting
-- ----------------------------
DROP TABLE IF EXISTS notice_receiver_setting;
CREATE TABLE notice_receiver_setting (
id BIGSERIAL PRIMARY KEY,
template_id BIGINT DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
receiver_union_type SMALLINT DEFAULT NULL,
receiver_union_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE notice_receiver_setting IS '通知接收人设置';
COMMENT ON COLUMN notice_receiver_setting.id IS '主键';
COMMENT ON COLUMN notice_receiver_setting.template_id IS '通知模版id';
COMMENT ON COLUMN notice_receiver_setting.org_id IS '机构id';
COMMENT ON COLUMN notice_receiver_setting.receiver_union_type IS '接收人关联类型:1用户id,2角色,3标准角色(见notice_receiver_type)';
COMMENT ON COLUMN notice_receiver_setting.receiver_union_id IS '接收人关联id:用户id,角色id,标准角色id';
COMMENT ON COLUMN notice_receiver_setting.deleted IS '是否逻辑删除';
COMMENT ON COLUMN notice_receiver_setting.create_by IS '创建人';
COMMENT ON COLUMN notice_receiver_setting.create_time IS '创建时间';
COMMENT ON COLUMN notice_receiver_setting.update_by IS '更新人';
COMMENT ON COLUMN notice_receiver_setting.update_time IS '更新时间';
COMMENT ON COLUMN notice_receiver_setting.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for notice_send_record
-- ----------------------------
DROP TABLE IF EXISTS notice_send_record;
CREATE TABLE notice_send_record (
id BIGSERIAL PRIMARY KEY,
template_id BIGINT DEFAULT NULL,
sender_org_id BIGINT DEFAULT NULL,
receiver_org_id BIGINT DEFAULT NULL,
content_template_id BIGINT DEFAULT NULL,
content_param_data VARCHAR(512) DEFAULT NULL,
content TEXT,
appointed BOOLEAN DEFAULT NULL,
link VARCHAR(128) DEFAULT NULL,
content_template TEXT,
title VARCHAR(64) DEFAULT NULL,
channel_type SMALLINT DEFAULT NULL,
status SMALLINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE notice_send_record IS '通知发送记录(内容模版级)';
COMMENT ON COLUMN notice_send_record.id IS '主键';
COMMENT ON COLUMN notice_send_record.template_id IS '通知模版id';
COMMENT ON COLUMN notice_send_record.sender_org_id IS '发送方机构id';
COMMENT ON COLUMN notice_send_record.receiver_org_id IS '接收方机构id';
COMMENT ON COLUMN notice_send_record.content_template_id IS '消息体模版id';
COMMENT ON COLUMN notice_send_record.content_param_data IS '消息体参数';
COMMENT ON COLUMN notice_send_record.content IS '消息体';
COMMENT ON COLUMN notice_send_record.appointed IS '是否指定接收方(非预先设定)';
COMMENT ON COLUMN notice_send_record.link IS '链接';
COMMENT ON COLUMN notice_send_record.content_template IS '内容模版';
COMMENT ON COLUMN notice_send_record.title IS '标题';
COMMENT ON COLUMN notice_send_record.channel_type IS '消息通道类型:1站内信,2短信,3钉钉,4企业微信,5邮件(见notice_channel_type)';
COMMENT ON COLUMN notice_send_record.status IS '状态:1待处理,2已处理 等(见notice_send_status)';
COMMENT ON COLUMN notice_send_record.deleted IS '是否逻辑删除';
COMMENT ON COLUMN notice_send_record.create_by IS '创建人';
COMMENT ON COLUMN notice_send_record.create_time IS '创建时间';
COMMENT ON COLUMN notice_send_record.update_by IS '更新人';
COMMENT ON COLUMN notice_send_record.update_time IS '更新时间';
COMMENT ON COLUMN notice_send_record.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for notice_send_record_detail
-- ----------------------------
DROP TABLE IF EXISTS notice_send_record_detail;
CREATE TABLE notice_send_record_detail (
id BIGSERIAL PRIMARY KEY,
record_id BIGINT DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
receiver_account_no VARCHAR(32) DEFAULT NULL,
receiver_status SMALLINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE notice_send_record_detail IS '通知发送记录明细(接收人)';
COMMENT ON COLUMN notice_send_record_detail.id IS '主键';
COMMENT ON COLUMN notice_send_record_detail.record_id IS '发送记录id';
COMMENT ON COLUMN notice_send_record_detail.user_id IS '接收人id';
COMMENT ON COLUMN notice_send_record_detail.receiver_account_no IS '接收方帐号';
COMMENT ON COLUMN notice_send_record_detail.receiver_status IS '接收状态:1待发送,2已发送,3发送失败,4接收已读(见notice_receiver_status)';
COMMENT ON COLUMN notice_send_record_detail.deleted IS '是否逻辑删除';
COMMENT ON COLUMN notice_send_record_detail.create_by IS '创建人';
COMMENT ON COLUMN notice_send_record_detail.create_time IS '创建时间';
COMMENT ON COLUMN notice_send_record_detail.update_by IS '更新人';
COMMENT ON COLUMN notice_send_record_detail.update_time IS '更新时间';
COMMENT ON COLUMN notice_send_record_detail.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for notice_template
-- ----------------------------
DROP TABLE IF EXISTS notice_template;
CREATE TABLE notice_template (
id BIGSERIAL PRIMARY KEY,
template_code VARCHAR(32) DEFAULT NULL,
template_name VARCHAR(64) DEFAULT NULL,
module_type SMALLINT DEFAULT NULL,
biz_type SMALLINT DEFAULT NULL,
level SMALLINT DEFAULT NULL,
enabled BOOLEAN DEFAULT TRUE,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE notice_template IS '通知模版';
COMMENT ON COLUMN notice_template.id IS '主键';
COMMENT ON COLUMN notice_template.template_code IS '通知模版code';
COMMENT ON COLUMN notice_template.template_name IS '通知模版名称';
COMMENT ON COLUMN notice_template.module_type IS '模块分类:1业务,2监控/预警(见notice_module_type)';
COMMENT ON COLUMN notice_template.biz_type IS '业务分类:';
COMMENT ON COLUMN notice_template.level IS '级别:1平台,2机构(见notice_level)';
COMMENT ON COLUMN notice_template.enabled IS '是否启用';
COMMENT ON COLUMN notice_template.deleted IS '是否逻辑删除';
COMMENT ON COLUMN notice_template.create_by IS '创建人';
COMMENT ON COLUMN notice_template.create_time IS '创建时间';
COMMENT ON COLUMN notice_template.update_by IS '更新人';
COMMENT ON COLUMN notice_template.update_time IS '更新时间';
COMMENT ON COLUMN notice_template.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_action
-- ----------------------------
DROP TABLE IF EXISTS uc_action;
CREATE TABLE uc_action (
id BIGSERIAL PRIMARY KEY,
union_type VARCHAR(32) DEFAULT NULL,
union_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_action IS '操作记录';
COMMENT ON COLUMN uc_action.id IS '主键';
COMMENT ON COLUMN uc_action.union_type IS '关联类型';
COMMENT ON COLUMN uc_action.union_id IS '关联id';
COMMENT ON COLUMN uc_action.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_action.create_by IS '创建人';
COMMENT ON COLUMN uc_action.create_time IS '创建时间';
COMMENT ON COLUMN uc_action.update_by IS '更新人';
COMMENT ON COLUMN uc_action.update_time IS '更新时间';
COMMENT ON COLUMN uc_action.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_action_detail
-- ----------------------------
DROP TABLE IF EXISTS uc_action_detail;
CREATE TABLE uc_action_detail (
id BIGSERIAL PRIMARY KEY,
action_id BIGINT DEFAULT NULL,
field VARCHAR(32) DEFAULT NULL,
field_alias VARCHAR(32) DEFAULT NULL,
field_dict_code VARCHAR(32) DEFAULT NULL,
old_value VARCHAR(255) DEFAULT NULL,
new_value VARCHAR(255) DEFAULT NULL,
diff TEXT,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_action_detail IS '操作记录明细';
COMMENT ON COLUMN uc_action_detail.id IS '主键';
COMMENT ON COLUMN uc_action_detail.action_id IS '操作记录id';
COMMENT ON COLUMN uc_action_detail.field IS '属性';
COMMENT ON COLUMN uc_action_detail.field_alias IS '属性别名';
COMMENT ON COLUMN uc_action_detail.field_dict_code IS '属性字典';
COMMENT ON COLUMN uc_action_detail.old_value IS '旧值';
COMMENT ON COLUMN uc_action_detail.new_value IS '新值';
COMMENT ON COLUMN uc_action_detail.diff IS '差异';
COMMENT ON COLUMN uc_action_detail.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_action_detail.create_by IS '创建人';
COMMENT ON COLUMN uc_action_detail.create_time IS '创建时间';
COMMENT ON COLUMN uc_action_detail.update_by IS '更新人';
COMMENT ON COLUMN uc_action_detail.update_time IS '更新时间';
COMMENT ON COLUMN uc_action_detail.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_auth_client
-- ----------------------------
DROP TABLE IF EXISTS uc_auth_client;
CREATE TABLE uc_auth_client (
id BIGSERIAL PRIMARY KEY,
auth_type_code SMALLINT DEFAULT NULL,
client_name VARCHAR(32) DEFAULT NULL,
param_data VARCHAR(256) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_auth_client IS '授权客户端';
COMMENT ON COLUMN uc_auth_client.id IS '主键';
COMMENT ON COLUMN uc_auth_client.auth_type_code IS '授权类型标识';
COMMENT ON COLUMN uc_auth_client.client_name IS '授权应用名称';
COMMENT ON COLUMN uc_auth_client.param_data IS '配置数据';
COMMENT ON COLUMN uc_auth_client.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_auth_client.create_by IS '创建人';
COMMENT ON COLUMN uc_auth_client.create_time IS '创建时间';
COMMENT ON COLUMN uc_auth_client.update_by IS '更新人';
COMMENT ON COLUMN uc_auth_client.update_time IS '更新时间';
COMMENT ON COLUMN uc_auth_client.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_auth_detail
-- ----------------------------
DROP TABLE IF EXISTS uc_auth_detail;
CREATE TABLE uc_auth_detail (
id BIGSERIAL PRIMARY KEY,
auth_client_id BIGINT DEFAULT NULL,
auth_type_code SMALLINT DEFAULT NULL,
nickname VARCHAR(32) DEFAULT NULL,
avatar VARCHAR(256) DEFAULT NULL,
gender VARCHAR(2) DEFAULT NULL,
country VARCHAR(32) DEFAULT NULL,
province VARCHAR(32) DEFAULT NULL,
city VARCHAR(32) DEFAULT NULL,
open_id VARCHAR(32) DEFAULT NULL,
unique_id VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_auth_detail IS '授权明细表';
COMMENT ON COLUMN uc_auth_detail.id IS '主键';
COMMENT ON COLUMN uc_auth_detail.auth_client_id IS '授权客户端id';
COMMENT ON COLUMN uc_auth_detail.auth_type_code IS '授权类型标识';
COMMENT ON COLUMN uc_auth_detail.nickname IS '昵称';
COMMENT ON COLUMN uc_auth_detail.avatar IS '头像';
COMMENT ON COLUMN uc_auth_detail.gender IS '性别';
COMMENT ON COLUMN uc_auth_detail.country IS '国家';
COMMENT ON COLUMN uc_auth_detail.province IS '省份';
COMMENT ON COLUMN uc_auth_detail.city IS '城市';
COMMENT ON COLUMN uc_auth_detail.open_id IS 'open_id';
COMMENT ON COLUMN uc_auth_detail.unique_id IS '授权唯一id';
COMMENT ON COLUMN uc_auth_detail.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_auth_detail.create_by IS '创建人';
COMMENT ON COLUMN uc_auth_detail.create_time IS '创建时间';
COMMENT ON COLUMN uc_auth_detail.update_by IS '更新人';
COMMENT ON COLUMN uc_auth_detail.update_time IS '更新时间';
COMMENT ON COLUMN uc_auth_detail.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_auth_detail_entrypoint
-- ----------------------------
DROP TABLE IF EXISTS uc_auth_detail_entrypoint;
CREATE TABLE uc_auth_detail_entrypoint (
id BIGSERIAL PRIMARY KEY,
auth_detail_id BIGINT DEFAULT NULL,
union_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_union_id ON uc_auth_detail_entrypoint(union_id);
COMMENT ON TABLE uc_auth_detail_entrypoint IS '授权明细入口';
COMMENT ON COLUMN uc_auth_detail_entrypoint.id IS '主键';
COMMENT ON COLUMN uc_auth_detail_entrypoint.auth_detail_id IS '授权客户端id';
COMMENT ON COLUMN uc_auth_detail_entrypoint.union_id IS '关联id(小程序码id)';
COMMENT ON COLUMN uc_auth_detail_entrypoint.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_auth_detail_entrypoint.create_by IS '创建人';
COMMENT ON COLUMN uc_auth_detail_entrypoint.create_time IS '创建时间';
COMMENT ON COLUMN uc_auth_detail_entrypoint.update_by IS '更新人';
COMMENT ON COLUMN uc_auth_detail_entrypoint.update_time IS '更新时间';
COMMENT ON COLUMN uc_auth_detail_entrypoint.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_auth_subscribe_detail
-- ----------------------------
DROP TABLE IF EXISTS uc_auth_subscribe_detail;
CREATE TABLE uc_auth_subscribe_detail (
id BIGSERIAL PRIMARY KEY,
auth_client_id BIGINT DEFAULT NULL,
open_id VARCHAR(32) DEFAULT NULL,
unique_id VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_auth_subscribe_detail IS '授权订阅明细表';
COMMENT ON COLUMN uc_auth_subscribe_detail.id IS '主键';
COMMENT ON COLUMN uc_auth_subscribe_detail.auth_client_id IS '授权客户端id';
COMMENT ON COLUMN uc_auth_subscribe_detail.open_id IS 'open_id';
COMMENT ON COLUMN uc_auth_subscribe_detail.unique_id IS '授权唯一id';
COMMENT ON COLUMN uc_auth_subscribe_detail.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_auth_subscribe_detail.create_by IS '创建人';
COMMENT ON COLUMN uc_auth_subscribe_detail.create_time IS '创建时间';
COMMENT ON COLUMN uc_auth_subscribe_detail.update_by IS '更新人';
COMMENT ON COLUMN uc_auth_subscribe_detail.update_time IS '更新时间';
COMMENT ON COLUMN uc_auth_subscribe_detail.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_auth_type
-- ----------------------------
DROP TABLE IF EXISTS uc_auth_type;
CREATE TABLE uc_auth_type (
id BIGSERIAL PRIMARY KEY,
auth_main_type SMALLINT DEFAULT NULL,
auth_type_code SMALLINT DEFAULT NULL,
name VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_auth_type IS '授权类型';
COMMENT ON COLUMN uc_auth_type.id IS '主键';
COMMENT ON COLUMN uc_auth_type.auth_main_type IS '授权大类:1微信,2支付宝';
COMMENT ON COLUMN uc_auth_type.auth_type_code IS '授权类型标识';
COMMENT ON COLUMN uc_auth_type.name IS '名称';
COMMENT ON COLUMN uc_auth_type.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_auth_type.create_by IS '创建人';
COMMENT ON COLUMN uc_auth_type.create_time IS '创建时间';
COMMENT ON COLUMN uc_auth_type.update_by IS '更新人';
COMMENT ON COLUMN uc_auth_type.update_time IS '更新时间';
COMMENT ON COLUMN uc_auth_type.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_domain
-- ----------------------------
DROP TABLE IF EXISTS uc_domain;
CREATE TABLE uc_domain (
id BIGSERIAL PRIMARY KEY,
platform_code SMALLINT DEFAULT NULL,
domain_name VARCHAR(32) DEFAULT NULL,
ip_port VARCHAR(32) DEFAULT NULL,
publiced BOOLEAN DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_domain IS '域名表';
COMMENT ON COLUMN uc_domain.id IS '主键';
COMMENT ON COLUMN uc_domain.platform_code IS '平台编码';
COMMENT ON COLUMN uc_domain.domain_name IS '域名';
COMMENT ON COLUMN uc_domain.ip_port IS 'ip:port';
COMMENT ON COLUMN uc_domain.publiced IS '是否公共';
COMMENT ON COLUMN uc_domain.org_id IS '机构id';
COMMENT ON COLUMN uc_domain.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_domain.create_by IS '创建人';
COMMENT ON COLUMN uc_domain.create_time IS '创建时间';
COMMENT ON COLUMN uc_domain.update_by IS '更新人';
COMMENT ON COLUMN uc_domain.update_time IS '更新时间';
COMMENT ON COLUMN uc_domain.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_domain_auth
-- ----------------------------
DROP TABLE IF EXISTS uc_domain_auth;
CREATE TABLE uc_domain_auth (
id BIGSERIAL PRIMARY KEY,
domain_id BIGINT DEFAULT NULL,
auth_type_code SMALLINT DEFAULT NULL,
auth_client_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_domain_auth IS '域名授权表';
COMMENT ON COLUMN uc_domain_auth.id IS '主键';
COMMENT ON COLUMN uc_domain_auth.domain_id IS '域名id';
COMMENT ON COLUMN uc_domain_auth.auth_type_code IS '授权类型标识';
COMMENT ON COLUMN uc_domain_auth.auth_client_id IS '授权客户端id';
COMMENT ON COLUMN uc_domain_auth.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_domain_auth.create_by IS '创建人';
COMMENT ON COLUMN uc_domain_auth.create_time IS '创建时间';
COMMENT ON COLUMN uc_domain_auth.update_by IS '更新人';
COMMENT ON COLUMN uc_domain_auth.update_time IS '更新时间';
COMMENT ON COLUMN uc_domain_auth.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_domain_setting
-- ----------------------------
DROP TABLE IF EXISTS uc_domain_setting;
CREATE TABLE uc_domain_setting (
id BIGSERIAL PRIMARY KEY,
domain_id BIGINT DEFAULT NULL,
type SMALLINT DEFAULT NULL,
remark VARCHAR(32) DEFAULT '',
data TEXT,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_domain_setting IS '域名配置表';
COMMENT ON COLUMN uc_domain_setting.id IS '主键';
COMMENT ON COLUMN uc_domain_setting.domain_id IS '域名id';
COMMENT ON COLUMN uc_domain_setting.type IS '类型';
COMMENT ON COLUMN uc_domain_setting.remark IS '配置备注';
COMMENT ON COLUMN uc_domain_setting.data IS '配置数据';
COMMENT ON COLUMN uc_domain_setting.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_domain_setting.create_by IS '创建人';
COMMENT ON COLUMN uc_domain_setting.create_time IS '创建时间';
COMMENT ON COLUMN uc_domain_setting.update_by IS '更新人';
COMMENT ON COLUMN uc_domain_setting.update_time IS '更新时间';
COMMENT ON COLUMN uc_domain_setting.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_dynamic_table
-- ----------------------------
DROP TABLE IF EXISTS uc_dynamic_table;
CREATE TABLE uc_dynamic_table (
id BIGSERIAL PRIMARY KEY,
table_type VARCHAR(32) DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
column_data TEXT,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
-- ----------------------------
-- Table structure for uc_faq
-- ----------------------------
DROP TABLE IF EXISTS uc_faq;
CREATE TABLE uc_faq (
id BIGSERIAL PRIMARY KEY,
faq_order INTEGER DEFAULT 0,
faq_type VARCHAR(2) DEFAULT NULL,
question VARCHAR(512) DEFAULT NULL,
answer TEXT,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_faq IS '常见问题表';
COMMENT ON COLUMN uc_faq.id IS '主键';
COMMENT ON COLUMN uc_faq.faq_order IS '排序';
COMMENT ON COLUMN uc_faq.faq_type IS '类型';
COMMENT ON COLUMN uc_faq.question IS '问题';
COMMENT ON COLUMN uc_faq.answer IS '回答';
COMMENT ON COLUMN uc_faq.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_faq.create_by IS '创建人';
COMMENT ON COLUMN uc_faq.create_time IS '创建时间';
COMMENT ON COLUMN uc_faq.update_by IS '更新人';
COMMENT ON COLUMN uc_faq.update_time IS '更新时间';
COMMENT ON COLUMN uc_faq.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_faq_file
-- ----------------------------
DROP TABLE IF EXISTS uc_faq_file;
CREATE TABLE uc_faq_file (
id BIGSERIAL PRIMARY KEY,
question_id BIGINT DEFAULT NULL,
file_name VARCHAR(256) DEFAULT NULL,
file_code VARCHAR(32) DEFAULT NULL,
file_suffix VARCHAR(32) DEFAULT NULL,
sort BIGINT DEFAULT NULL,
description VARCHAR(256) DEFAULT NULL,
deleted BOOLEAN NOT NULL DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_faq_file IS '常见问题附件关系表';
COMMENT ON COLUMN uc_faq_file.id IS '主键';
COMMENT ON COLUMN uc_faq_file.question_id IS '常见问题ID';
COMMENT ON COLUMN uc_faq_file.file_name IS '文件名称';
COMMENT ON COLUMN uc_faq_file.file_code IS '文件编码';
COMMENT ON COLUMN uc_faq_file.file_suffix IS '文件后缀';
COMMENT ON COLUMN uc_faq_file.sort IS '排序';
COMMENT ON COLUMN uc_faq_file.description IS '文件描述';
COMMENT ON COLUMN uc_faq_file.deleted IS '是否删除';
COMMENT ON COLUMN uc_faq_file.create_by IS '创建人';
COMMENT ON COLUMN uc_faq_file.create_time IS '创建时间';
COMMENT ON COLUMN uc_faq_file.update_by IS '更新人';
COMMENT ON COLUMN uc_faq_file.update_time IS '更新时间';
COMMENT ON COLUMN uc_faq_file.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_feedback
-- ----------------------------
DROP TABLE IF EXISTS uc_feedback;
CREATE TABLE uc_feedback (
id BIGSERIAL PRIMARY KEY,
type VARCHAR(2) DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
phone VARCHAR(32) DEFAULT NULL,
content VARCHAR(255) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
source_type VARCHAR(2) DEFAULT NULL
);
COMMENT ON TABLE uc_feedback IS '反馈表';
COMMENT ON COLUMN uc_feedback.id IS '主键';
COMMENT ON COLUMN uc_feedback.type IS '反馈类型';
COMMENT ON COLUMN uc_feedback.user_id IS '用户id';
COMMENT ON COLUMN uc_feedback.phone IS '手机号';
COMMENT ON COLUMN uc_feedback.content IS '反馈内容';
COMMENT ON COLUMN uc_feedback.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_feedback.create_by IS '创建人';
COMMENT ON COLUMN uc_feedback.create_time IS '创建时间';
COMMENT ON COLUMN uc_feedback.update_by IS '更新人';
COMMENT ON COLUMN uc_feedback.update_time IS '更新时间';
COMMENT ON COLUMN uc_feedback.proxy_by IS '代理人';
COMMENT ON COLUMN uc_feedback.source_type IS '来源';
-- ----------------------------
-- Table structure for uc_import_main
-- ----------------------------
DROP TABLE IF EXISTS uc_import_main;
CREATE TABLE uc_import_main (
id BIGSERIAL PRIMARY KEY,
import_no VARCHAR(64) DEFAULT NULL,
type VARCHAR(32) DEFAULT NULL,
import_status SMALLINT DEFAULT NULL,
total_num INTEGER DEFAULT NULL,
success_num INTEGER DEFAULT NULL,
fail_msg VARCHAR(255) DEFAULT NULL,
finish_time TIMESTAMP DEFAULT NULL,
execute_type SMALLINT DEFAULT NULL,
extra_id BIGINT DEFAULT NULL,
file_code VARCHAR(32) DEFAULT NULL,
file_name VARCHAR(128) DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
remark VARCHAR(255) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_import_no ON uc_import_main(import_no);
COMMENT ON TABLE uc_import_main IS '通用导入批次表';
COMMENT ON COLUMN uc_import_main.id IS '主键ID';
COMMENT ON COLUMN uc_import_main.import_no IS '批次号';
COMMENT ON COLUMN uc_import_main.type IS '导入类型';
COMMENT ON COLUMN uc_import_main.import_status IS '导入状态:1新建，2解析失败，3校验中，4校验失败，5校验成功，6执行导入';
COMMENT ON COLUMN uc_import_main.total_num IS '总数';
COMMENT ON COLUMN uc_import_main.success_num IS '成功数';
COMMENT ON COLUMN uc_import_main.fail_msg IS '失败原因';
COMMENT ON COLUMN uc_import_main.finish_time IS '完成时间时间';
COMMENT ON COLUMN uc_import_main.execute_type IS '执行类型：1.普通，2.指定外部id';
COMMENT ON COLUMN uc_import_main.extra_id IS '外部生成id';
COMMENT ON COLUMN uc_import_main.file_code IS '文件CODE';
COMMENT ON COLUMN uc_import_main.file_name IS '文件名称';
COMMENT ON COLUMN uc_import_main.org_id IS '机构ID';
COMMENT ON COLUMN uc_import_main.remark IS '备注';
COMMENT ON COLUMN uc_import_main.deleted IS '是否删除';
COMMENT ON COLUMN uc_import_main.create_by IS '创建人';
COMMENT ON COLUMN uc_import_main.create_time IS '创建时间';
COMMENT ON COLUMN uc_import_main.update_by IS '修改人';
COMMENT ON COLUMN uc_import_main.update_time IS '修改时间';
COMMENT ON COLUMN uc_import_main.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_lite_code
-- ----------------------------
DROP TABLE IF EXISTS uc_lite_code;
CREATE TABLE uc_lite_code (
id BIGSERIAL PRIMARY KEY,
lite_code_config_id BIGINT DEFAULT NULL,
unique_code VARCHAR(32) DEFAULT NULL,
param_value VARCHAR(255) DEFAULT NULL,
query_value VARCHAR(255) DEFAULT NULL,
file_code VARCHAR(32) DEFAULT NULL,
url_scheme VARCHAR(64) DEFAULT NULL,
name VARCHAR(32) DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
platform_code SMALLINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_lite_code IS '小程序码';
COMMENT ON COLUMN uc_lite_code.id IS '主键';
COMMENT ON COLUMN uc_lite_code.lite_code_config_id IS '小程序码配置id';
COMMENT ON COLUMN uc_lite_code.unique_code IS '唯一码-uuid';
COMMENT ON COLUMN uc_lite_code.param_value IS '参数值(按参数键升序排列)(格式:**&**)';
COMMENT ON COLUMN uc_lite_code.query_value IS 'query参数值(格式:**=**&**=**)';
COMMENT ON COLUMN uc_lite_code.file_code IS '小程序码文件编码';
COMMENT ON COLUMN uc_lite_code.url_scheme IS '小程序scheme码';
COMMENT ON COLUMN uc_lite_code.name IS '名称';
COMMENT ON COLUMN uc_lite_code.user_id IS '用户id';
COMMENT ON COLUMN uc_lite_code.org_id IS '机构id';
COMMENT ON COLUMN uc_lite_code.platform_code IS '平台编码';
COMMENT ON COLUMN uc_lite_code.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_lite_code.create_by IS '创建人';
COMMENT ON COLUMN uc_lite_code.create_time IS '创建时间';
COMMENT ON COLUMN uc_lite_code.update_by IS '更新人';
COMMENT ON COLUMN uc_lite_code.update_time IS '更新时间';
COMMENT ON COLUMN uc_lite_code.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_lite_code_config
-- ----------------------------
DROP TABLE IF EXISTS uc_lite_code_config;
CREATE TABLE uc_lite_code_config (
id BIGSERIAL PRIMARY KEY,
auth_client_id BIGINT DEFAULT NULL,
biz_type SMALLINT DEFAULT NULL,
path VARCHAR(64) DEFAULT NULL,
param_key VARCHAR(64) DEFAULT NULL,
env_param_key VARCHAR(64) DEFAULT NULL,
platform_code SMALLINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_lite_code_config IS '小程序码配置';
COMMENT ON COLUMN uc_lite_code_config.id IS '主键';
COMMENT ON COLUMN uc_lite_code_config.auth_client_id IS '授权客户端id';
COMMENT ON COLUMN uc_lite_code_config.biz_type IS '小程序码业务类型';
COMMENT ON COLUMN uc_lite_code_config.path IS '路径';
COMMENT ON COLUMN uc_lite_code_config.param_key IS '参数键-逗号分隔';
COMMENT ON COLUMN uc_lite_code_config.env_param_key IS '内置环境参数键-逗号分隔';
COMMENT ON COLUMN uc_lite_code_config.platform_code IS '平台编码';
COMMENT ON COLUMN uc_lite_code_config.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_lite_code_config.create_by IS '创建人';
COMMENT ON COLUMN uc_lite_code_config.create_time IS '创建时间';
COMMENT ON COLUMN uc_lite_code_config.update_by IS '更新人';
COMMENT ON COLUMN uc_lite_code_config.update_time IS '更新时间';
COMMENT ON COLUMN uc_lite_code_config.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_org_relation
-- ----------------------------
DROP TABLE IF EXISTS uc_org_relation;
CREATE TABLE uc_org_relation (
id BIGSERIAL PRIMARY KEY,
org_id BIGINT DEFAULT NULL,
org_type SMALLINT DEFAULT NULL,
parent_id BIGINT DEFAULT NULL,
path VARCHAR(255) DEFAULT NULL,
platform_code SMALLINT DEFAULT NULL,
platform_name VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_org_id ON uc_org_relation(org_id);
COMMENT ON TABLE uc_org_relation IS '机构关系表';
COMMENT ON COLUMN uc_org_relation.id IS '主键';
COMMENT ON COLUMN uc_org_relation.org_id IS '机构id';
COMMENT ON COLUMN uc_org_relation.org_type IS '类型';
COMMENT ON COLUMN uc_org_relation.parent_id IS '上级id';
COMMENT ON COLUMN uc_org_relation.path IS '路径';
COMMENT ON COLUMN uc_org_relation.platform_code IS '平台编码';
COMMENT ON COLUMN uc_org_relation.platform_name IS '平台名称';
COMMENT ON COLUMN uc_org_relation.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_org_relation.create_by IS '创建人';
COMMENT ON COLUMN uc_org_relation.create_time IS '创建时间';
COMMENT ON COLUMN uc_org_relation.update_by IS '更新人';
COMMENT ON COLUMN uc_org_relation.update_time IS '更新时间';
COMMENT ON COLUMN uc_org_relation.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_org_user
-- ----------------------------
DROP TABLE IF EXISTS uc_org_user;
CREATE TABLE uc_org_user (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
administrator BOOLEAN DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX INDEX12378548369700 ON uc_org_user(user_id);
CREATE INDEX INDEX12378670651400 ON uc_org_user(org_id);
COMMENT ON TABLE uc_org_user IS '机构用户表';
COMMENT ON COLUMN uc_org_user.id IS '主键';
COMMENT ON COLUMN uc_org_user.user_id IS '用户id';
COMMENT ON COLUMN uc_org_user.org_id IS '机构id';
COMMENT ON COLUMN uc_org_user.administrator IS '是否管理员';
COMMENT ON COLUMN uc_org_user.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_org_user.create_by IS '创建人';
COMMENT ON COLUMN uc_org_user.create_time IS '创建时间';
COMMENT ON COLUMN uc_org_user.update_by IS '更新人';
COMMENT ON COLUMN uc_org_user.update_time IS '更新时间';
COMMENT ON COLUMN uc_org_user.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_platform
-- ----------------------------
DROP TABLE IF EXISTS uc_platform;
CREATE TABLE uc_platform (
id BIGSERIAL PRIMARY KEY,
platform_code SMALLINT DEFAULT NULL,
name VARCHAR(32) DEFAULT NULL,
full_name VARCHAR(32) DEFAULT NULL,
short_name VARCHAR(32) DEFAULT NULL,
business BOOLEAN DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_platform IS '系统应用表';
COMMENT ON COLUMN uc_platform.id IS '主键';
COMMENT ON COLUMN uc_platform.platform_code IS '平台编码';
COMMENT ON COLUMN uc_platform.name IS '名称';
COMMENT ON COLUMN uc_platform.full_name IS '全称';
COMMENT ON COLUMN uc_platform.short_name IS '简称';
COMMENT ON COLUMN uc_platform.business IS '是否业务系统';
COMMENT ON COLUMN uc_platform.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_platform.create_by IS '创建人';
COMMENT ON COLUMN uc_platform.create_time IS '创建时间';
COMMENT ON COLUMN uc_platform.update_by IS '更新人';
COMMENT ON COLUMN uc_platform.update_time IS '更新时间';
COMMENT ON COLUMN uc_platform.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_slick_param
-- ----------------------------
DROP TABLE IF EXISTS uc_slick_param;
CREATE TABLE uc_slick_param (
id BIGSERIAL PRIMARY KEY,
unique_code VARCHAR(32) DEFAULT NULL,
query_value VARCHAR(255) DEFAULT NULL,
param_data VARCHAR(255) DEFAULT NULL,
hash_code INTEGER DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_hash_code ON uc_slick_param(hash_code);
CREATE INDEX idx_unique_code ON uc_slick_param(unique_code);
COMMENT ON TABLE uc_slick_param IS '圆滑的参数';
COMMENT ON COLUMN uc_slick_param.id IS '主键';
COMMENT ON COLUMN uc_slick_param.unique_code IS '唯一码-uuid';
COMMENT ON COLUMN uc_slick_param.query_value IS 'query升序值(格式:**=**&**=**)';
COMMENT ON COLUMN uc_slick_param.param_data IS 'json';
COMMENT ON COLUMN uc_slick_param.hash_code IS '哈希值';
COMMENT ON COLUMN uc_slick_param.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_slick_param.create_by IS '创建人';
COMMENT ON COLUMN uc_slick_param.create_time IS '创建时间';
COMMENT ON COLUMN uc_slick_param.update_by IS '更新人';
COMMENT ON COLUMN uc_slick_param.update_time IS '更新时间';
COMMENT ON COLUMN uc_slick_param.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_user
-- ----------------------------
DROP TABLE IF EXISTS uc_user;
CREATE TABLE uc_user (
id BIGSERIAL PRIMARY KEY,
username VARCHAR(32) DEFAULT NULL,
password VARCHAR(128) DEFAULT NULL,
type SMALLINT DEFAULT NULL,
supeiror BOOLEAN DEFAULT NULL,
security_code VARCHAR(128) DEFAULT NULL,
nickname VARCHAR(32) DEFAULT NULL,
avatar VARCHAR(256) DEFAULT NULL,
phone VARCHAR(32) DEFAULT NULL,
phone_binding BOOLEAN DEFAULT NULL,
real_name VARCHAR(32) DEFAULT NULL,
card_no VARCHAR(18) DEFAULT NULL,
authenticated BOOLEAN DEFAULT NULL,
status SMALLINT DEFAULT NULL,
email VARCHAR(32) DEFAULT NULL,
address VARCHAR(32) DEFAULT NULL,
education SMALLINT DEFAULT NULL,
init_user_id BIGINT DEFAULT NULL,
enabled BOOLEAN DEFAULT NULL,
account_non_expired BOOLEAN DEFAULT NULL,
account_non_locked BOOLEAN DEFAULT NULL,
credentials_non_expired BOOLEAN DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
gender SMALLINT DEFAULT NULL,
birthday date DEFAULT NULL
);
CREATE INDEX idx_card_no ON uc_user(card_no);
CREATE INDEX idx_phone ON uc_user(phone);
CREATE INDEX idx_real_name ON uc_user(real_name);
COMMENT ON TABLE uc_user IS '用户表';
COMMENT ON COLUMN uc_user.id IS '主键';
COMMENT ON COLUMN uc_user.username IS '账号';
COMMENT ON COLUMN uc_user.password IS '密码';
COMMENT ON COLUMN uc_user.type IS '用户类型:1企业用户,2个人用户';
COMMENT ON COLUMN uc_user.supeiror IS '是否超管';
COMMENT ON COLUMN uc_user.security_code IS '安全码';
COMMENT ON COLUMN uc_user.nickname IS '昵称';
COMMENT ON COLUMN uc_user.avatar IS '头像';
COMMENT ON COLUMN uc_user.phone IS '手机号码';
COMMENT ON COLUMN uc_user.phone_binding IS '手机号绑定状态';
COMMENT ON COLUMN uc_user.real_name IS '真实姓名';
COMMENT ON COLUMN uc_user.card_no IS '身份证号';
COMMENT ON COLUMN uc_user.authenticated IS '是否实名';
COMMENT ON COLUMN uc_user.status IS '状态:1.待激活,2已激活,3已注销';
COMMENT ON COLUMN uc_user.email IS '邮箱';
COMMENT ON COLUMN uc_user.address IS '用户所在地';
COMMENT ON COLUMN uc_user.education IS '1博士、2硕士、3本科、4大专、5高中、6中专/中技、7初中及以下、8不限';
COMMENT ON COLUMN uc_user.init_user_id IS '初始(推荐)用户id';
COMMENT ON COLUMN uc_user.enabled IS '是否启用';
COMMENT ON COLUMN uc_user.account_non_expired IS '账号是否未过期';
COMMENT ON COLUMN uc_user.account_non_locked IS '是否未锁定';
COMMENT ON COLUMN uc_user.credentials_non_expired IS '凭据是否未过期';
COMMENT ON COLUMN uc_user.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user.create_by IS '创建人';
COMMENT ON COLUMN uc_user.create_time IS '创建时间';
COMMENT ON COLUMN uc_user.update_by IS '更新人';
COMMENT ON COLUMN uc_user.update_time IS '更新时间';
COMMENT ON COLUMN uc_user.proxy_by IS '代理人';
COMMENT ON COLUMN uc_user.gender IS '性别：1男2女';
COMMENT ON COLUMN uc_user.birthday IS '生日';
-- ----------------------------
-- Table structure for uc_user_auth
-- ----------------------------
DROP TABLE IF EXISTS uc_user_auth;
CREATE TABLE uc_user_auth (
id BIGSERIAL PRIMARY KEY,
auth_main_type SMALLINT DEFAULT NULL,
unique_id VARCHAR(32) DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_unique_id ON uc_user_auth(unique_id);
COMMENT ON TABLE uc_user_auth IS '用户授权中间表';
COMMENT ON COLUMN uc_user_auth.id IS '主键';
COMMENT ON COLUMN uc_user_auth.auth_main_type IS '授权大类';
COMMENT ON COLUMN uc_user_auth.unique_id IS '授权唯一id';
COMMENT ON COLUMN uc_user_auth.user_id IS '用户id';
COMMENT ON COLUMN uc_user_auth.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user_auth.create_by IS '创建人';
COMMENT ON COLUMN uc_user_auth.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_auth.update_by IS '更新人';
COMMENT ON COLUMN uc_user_auth.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_auth.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_user_cancel
-- ----------------------------
DROP TABLE IF EXISTS uc_user_cancel;
CREATE TABLE uc_user_cancel (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
status SMALLINT DEFAULT 1,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
cancellation_type VARCHAR(2) DEFAULT NULL,
remark VARCHAR(255) DEFAULT NULL
);
COMMENT ON TABLE uc_user_cancel IS '用户申请注销表';
COMMENT ON COLUMN uc_user_cancel.id IS '主键';
COMMENT ON COLUMN uc_user_cancel.user_id IS '用户表ID';
COMMENT ON COLUMN uc_user_cancel.status IS '申请状态 1：已申请 2：已注销';
COMMENT ON COLUMN uc_user_cancel.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user_cancel.create_by IS '创建人';
COMMENT ON COLUMN uc_user_cancel.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_cancel.update_by IS '更新人';
COMMENT ON COLUMN uc_user_cancel.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_cancel.proxy_by IS '代理人';
COMMENT ON COLUMN uc_user_cancel.cancellation_type IS '注销原因类型 数据字典';
COMMENT ON COLUMN uc_user_cancel.remark IS '备注';
-- ----------------------------
-- Table structure for uc_user_config
-- ----------------------------
DROP TABLE IF EXISTS uc_user_config;
CREATE TABLE uc_user_config (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
config_code VARCHAR(64) DEFAULT NULL,
config_value VARCHAR(1024) DEFAULT NULL,
remark VARCHAR(128) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_user_config IS '用户配置表';
COMMENT ON COLUMN uc_user_config.id IS '主键';
COMMENT ON COLUMN uc_user_config.user_id IS '用户id';
COMMENT ON COLUMN uc_user_config.config_code IS '编码';
COMMENT ON COLUMN uc_user_config.config_value IS '配置值';
COMMENT ON COLUMN uc_user_config.remark IS '备注';
COMMENT ON COLUMN uc_user_config.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user_config.create_by IS '创建人';
COMMENT ON COLUMN uc_user_config.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_config.update_by IS '更新人';
COMMENT ON COLUMN uc_user_config.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_config.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_user_extension
-- ----------------------------
DROP TABLE IF EXISTS uc_user_extension;
CREATE TABLE uc_user_extension (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
technique_tag VARCHAR(256) DEFAULT NULL,
residence_address VARCHAR(128) DEFAULT NULL,
file_code VARCHAR(255) DEFAULT NULL,
file_name VARCHAR(255) DEFAULT NULL,
covid_vaccine SMALLINT DEFAULT NULL,
wechat_qr_code VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_user_extension IS '用户扩展表';
COMMENT ON COLUMN uc_user_extension.id IS '主键';
COMMENT ON COLUMN uc_user_extension.user_id IS '用户id';
COMMENT ON COLUMN uc_user_extension.technique_tag IS '技能标签';
COMMENT ON COLUMN uc_user_extension.residence_address IS '常住地区';
COMMENT ON COLUMN uc_user_extension.file_code IS '简历附件编码';
COMMENT ON COLUMN uc_user_extension.file_name IS '简历附件名称';
COMMENT ON COLUMN uc_user_extension.covid_vaccine IS '新冠疫苗:1.未接种,2.1针,3.2针,4.3针';
COMMENT ON COLUMN uc_user_extension.wechat_qr_code IS '微信二维码';
COMMENT ON COLUMN uc_user_extension.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user_extension.create_by IS '创建人';
COMMENT ON COLUMN uc_user_extension.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_extension.update_by IS '更新人';
COMMENT ON COLUMN uc_user_extension.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_extension.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_user_face
-- ----------------------------
DROP TABLE IF EXISTS uc_user_face;
CREATE TABLE uc_user_face (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
type SMALLINT DEFAULT NULL,
file_code VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN NOT NULL DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX INDEX12379510213700 ON uc_user_face(user_id);
COMMENT ON TABLE uc_user_face IS '用户活体信息表';
COMMENT ON COLUMN uc_user_face.id IS 'ID';
COMMENT ON COLUMN uc_user_face.user_id IS '用户ID';
COMMENT ON COLUMN uc_user_face.type IS '类型 1：照片 2：视频';
COMMENT ON COLUMN uc_user_face.file_code IS '文件编码';
COMMENT ON COLUMN uc_user_face.deleted IS '是否删除';
COMMENT ON COLUMN uc_user_face.create_by IS '创建人';
COMMENT ON COLUMN uc_user_face.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_face.update_by IS '更新人';
COMMENT ON COLUMN uc_user_face.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_face.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_user_postal_info
-- ----------------------------
DROP TABLE IF EXISTS uc_user_postal_info;
CREATE TABLE uc_user_postal_info (
id BIGSERIAL PRIMARY KEY,
defaulted BOOLEAN DEFAULT NULL,
name VARCHAR(50) DEFAULT NULL,
phone VARCHAR(50) DEFAULT NULL,
address_code VARCHAR(50) DEFAULT NULL,
address_name VARCHAR(50) DEFAULT NULL,
address_detail VARCHAR(100) DEFAULT NULL,
deleted BOOLEAN DEFAULT NULL,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE uc_user_postal_info IS '用户邮寄信息';
COMMENT ON COLUMN uc_user_postal_info.id IS '主键';
COMMENT ON COLUMN uc_user_postal_info.defaulted IS '是否默认';
COMMENT ON COLUMN uc_user_postal_info.name IS '收货人';
COMMENT ON COLUMN uc_user_postal_info.phone IS '手机号';
COMMENT ON COLUMN uc_user_postal_info.address_code IS '地区编码';
COMMENT ON COLUMN uc_user_postal_info.address_name IS '地址名称';
COMMENT ON COLUMN uc_user_postal_info.address_detail IS '详细地址';
COMMENT ON COLUMN uc_user_postal_info.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user_postal_info.create_by IS '创建人';
COMMENT ON COLUMN uc_user_postal_info.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_postal_info.update_by IS '更新人';
COMMENT ON COLUMN uc_user_postal_info.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_postal_info.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for uc_user_register
-- ----------------------------
DROP TABLE IF EXISTS uc_user_register;
CREATE TABLE uc_user_register (
id BIGSERIAL PRIMARY KEY,
platform_code SMALLINT DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
inviter_id BIGINT DEFAULT NULL,
inviter_type SMALLINT DEFAULT NULL,
inviter_org_id BIGINT DEFAULT NULL,
entrypoint VARCHAR(32) DEFAULT NULL,
union_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_user_id ON uc_user_register(user_id);
COMMENT ON TABLE uc_user_register IS '用户注册表';
COMMENT ON COLUMN uc_user_register.id IS '主键';
COMMENT ON COLUMN uc_user_register.platform_code IS '平台编码';
COMMENT ON COLUMN uc_user_register.user_id IS '用户id';
COMMENT ON COLUMN uc_user_register.inviter_id IS '邀请人id';
COMMENT ON COLUMN uc_user_register.inviter_type IS '邀请人用户类型';
COMMENT ON COLUMN uc_user_register.inviter_org_id IS '邀请人机构id';
COMMENT ON COLUMN uc_user_register.entrypoint IS '入口点';
COMMENT ON COLUMN uc_user_register.union_id IS '关联id(小程序码id)';
COMMENT ON COLUMN uc_user_register.deleted IS '是否逻辑删除';
COMMENT ON COLUMN uc_user_register.create_by IS '创建人';
COMMENT ON COLUMN uc_user_register.create_time IS '创建时间';
COMMENT ON COLUMN uc_user_register.update_by IS '更新人';
COMMENT ON COLUMN uc_user_register.update_time IS '更新时间';
COMMENT ON COLUMN uc_user_register.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_chat
-- ----------------------------
DROP TABLE IF EXISTS xs_chat;
CREATE TABLE xs_chat (
id BIGSERIAL PRIMARY KEY,
org_id BIGINT DEFAULT NULL,
org_user_id BIGINT DEFAULT NULL,
person_user_id BIGINT DEFAULT NULL,
type VARCHAR(32) DEFAULT NULL,
status SMALLINT DEFAULT NULL,
deleted BOOLEAN NOT NULL DEFAULT FALSE,
create_by BIGINT NOT NULL,
create_time TIMESTAMP NOT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_chat IS '聊天表';
COMMENT ON COLUMN xs_chat.id IS '主键';
COMMENT ON COLUMN xs_chat.org_id IS '机构id';
COMMENT ON COLUMN xs_chat.org_user_id IS '机构用户id';
COMMENT ON COLUMN xs_chat.person_user_id IS '个人用户id';
COMMENT ON COLUMN xs_chat.type IS '类型(chat_type)';
COMMENT ON COLUMN xs_chat.status IS '状态：1有效，2关闭';
COMMENT ON COLUMN xs_chat.deleted IS '是否逻辑删除';
COMMENT ON COLUMN xs_chat.create_by IS '创建人';
COMMENT ON COLUMN xs_chat.create_time IS '创建时间';
COMMENT ON COLUMN xs_chat.update_by IS '更新人';
COMMENT ON COLUMN xs_chat.update_time IS '更新时间';
COMMENT ON COLUMN xs_chat.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_chat_msg
-- ----------------------------
DROP TABLE IF EXISTS xs_chat_msg;
CREATE TABLE xs_chat_msg (
id BIGSERIAL PRIMARY KEY,
chat_id BIGINT DEFAULT NULL,
sender_id BIGINT DEFAULT NULL,
msg_type VARCHAR(16) DEFAULT NULL,
content VARCHAR(1024) DEFAULT NULL,
msg_status SMALLINT DEFAULT NULL,
deleted BOOLEAN NOT NULL DEFAULT FALSE,
create_by BIGINT NOT NULL,
create_time TIMESTAMP NOT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_chat_msg IS '聊天消息表';
COMMENT ON COLUMN xs_chat_msg.id IS '主键';
COMMENT ON COLUMN xs_chat_msg.chat_id IS '聊天id';
COMMENT ON COLUMN xs_chat_msg.sender_id IS '发送用户id';
COMMENT ON COLUMN xs_chat_msg.msg_type IS '消息类型(chat_msg_type)：text等';
COMMENT ON COLUMN xs_chat_msg.content IS '个人用户id';
COMMENT ON COLUMN xs_chat_msg.msg_status IS '消息状态：1未读，2已读';
COMMENT ON COLUMN xs_chat_msg.deleted IS '是否逻辑删除';
COMMENT ON COLUMN xs_chat_msg.create_by IS '创建人';
COMMENT ON COLUMN xs_chat_msg.create_time IS '创建时间';
COMMENT ON COLUMN xs_chat_msg.update_by IS '更新人';
COMMENT ON COLUMN xs_chat_msg.update_time IS '更新时间';
COMMENT ON COLUMN xs_chat_msg.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_code_setting
-- ----------------------------
DROP TABLE IF EXISTS xs_code_setting;
CREATE TABLE xs_code_setting (
id BIGSERIAL PRIMARY KEY,
code VARCHAR(64) DEFAULT NULL,
name VARCHAR(128) DEFAULT NULL,
remark VARCHAR(128) DEFAULT NULL,
type VARCHAR(2) DEFAULT NULL,
data_type VARCHAR(2) DEFAULT NULL,
data_format VARCHAR(128) DEFAULT NULL,
level VARCHAR(20) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_code_setting IS '编码表';
COMMENT ON COLUMN xs_code_setting.id IS '主键ID';
COMMENT ON COLUMN xs_code_setting.code IS '编码';
COMMENT ON COLUMN xs_code_setting.name IS '名称';
COMMENT ON COLUMN xs_code_setting.remark IS '备注';
COMMENT ON COLUMN xs_code_setting.type IS '类型 模板编码、配置编码';
COMMENT ON COLUMN xs_code_setting.data_type IS '数据类型';
COMMENT ON COLUMN xs_code_setting.data_format IS '数据格式编号';
COMMENT ON COLUMN xs_code_setting.level IS '级别 平台、渠道、定制机构、普通机构';
COMMENT ON COLUMN xs_code_setting.deleted IS '是否删除';
COMMENT ON COLUMN xs_code_setting.create_by IS '创建人';
COMMENT ON COLUMN xs_code_setting.create_time IS '创建时间';
COMMENT ON COLUMN xs_code_setting.update_by IS '修改人';
COMMENT ON COLUMN xs_code_setting.update_time IS '修改时间';
COMMENT ON COLUMN xs_code_setting.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_company_extend
-- ----------------------------
DROP TABLE IF EXISTS xs_company_extend;
CREATE TABLE xs_company_extend (
id BIGSERIAL PRIMARY KEY,
seller_id BIGINT DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX INDEX173651263650200 ON xs_company_extend(org_id);
COMMENT ON TABLE xs_company_extend IS '企业的扩展信息';
COMMENT ON COLUMN xs_company_extend.id IS '主键ID';
COMMENT ON COLUMN xs_company_extend.seller_id IS '销售';
COMMENT ON COLUMN xs_company_extend.org_id IS '所属机构ID';
COMMENT ON COLUMN xs_company_extend.deleted IS '是否删除';
COMMENT ON COLUMN xs_company_extend.create_by IS '创建人';
COMMENT ON COLUMN xs_company_extend.create_time IS '创建时间';
COMMENT ON COLUMN xs_company_extend.update_by IS '修改人';
COMMENT ON COLUMN xs_company_extend.update_time IS '修改时间';
COMMENT ON COLUMN xs_company_extend.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_component
-- ----------------------------
DROP TABLE IF EXISTS xs_component;
CREATE TABLE xs_component (
id BIGSERIAL PRIMARY KEY,
url_id BIGINT DEFAULT NULL,
code VARCHAR(32) DEFAULT NULL,
name VARCHAR(64) DEFAULT NULL,
platform_code SMALLINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_component IS '组件';
COMMENT ON COLUMN xs_component.id IS '主键ID';
COMMENT ON COLUMN xs_component.url_id IS '菜单id';
COMMENT ON COLUMN xs_component.code IS '组件编码';
COMMENT ON COLUMN xs_component.name IS '组件名称';
COMMENT ON COLUMN xs_component.platform_code IS '平台编码';
COMMENT ON COLUMN xs_component.deleted IS '是否删除';
COMMENT ON COLUMN xs_component.create_by IS '创建人';
COMMENT ON COLUMN xs_component.create_time IS '创建时间';
COMMENT ON COLUMN xs_component.update_by IS '修改人';
COMMENT ON COLUMN xs_component.update_time IS '修改时间';
COMMENT ON COLUMN xs_component.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_config
-- ----------------------------
DROP TABLE IF EXISTS xs_config;
CREATE TABLE xs_config (
id BIGSERIAL PRIMARY KEY,
config_code VARCHAR(64) DEFAULT NULL,
config_value TEXT,
org_id BIGINT DEFAULT NULL,
remark VARCHAR(128) DEFAULT NULL,
enable BOOLEAN DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_config IS '配置表';
COMMENT ON COLUMN xs_config.id IS '主键ID';
COMMENT ON COLUMN xs_config.config_code IS '编码';
COMMENT ON COLUMN xs_config.config_value IS '配置值';
COMMENT ON COLUMN xs_config.org_id IS '机构';
COMMENT ON COLUMN xs_config.remark IS '备注';
COMMENT ON COLUMN xs_config.enable IS '是否启用';
COMMENT ON COLUMN xs_config.deleted IS '是否删除';
COMMENT ON COLUMN xs_config.create_by IS '创建人';
COMMENT ON COLUMN xs_config.create_time IS '创建时间';
COMMENT ON COLUMN xs_config.update_by IS '修改人';
COMMENT ON COLUMN xs_config.update_time IS '修改时间';
COMMENT ON COLUMN xs_config.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_dict
-- ----------------------------
DROP TABLE IF EXISTS xs_dict;
CREATE TABLE xs_dict (
id BIGSERIAL PRIMARY KEY,
dict_code VARCHAR(32) DEFAULT NULL,
dict_name VARCHAR(64) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_dict_code ON xs_dict(dict_code);
COMMENT ON TABLE xs_dict IS '数据字典主信息';
COMMENT ON COLUMN xs_dict.id IS '主键ID';
COMMENT ON COLUMN xs_dict.dict_code IS '字典编码';
COMMENT ON COLUMN xs_dict.dict_name IS '字典名称';
COMMENT ON COLUMN xs_dict.deleted IS '是否删除';
COMMENT ON COLUMN xs_dict.create_by IS '创建人';
COMMENT ON COLUMN xs_dict.create_time IS '创建时间';
COMMENT ON COLUMN xs_dict.update_by IS '修改人';
COMMENT ON COLUMN xs_dict.update_time IS '修改时间';
COMMENT ON COLUMN xs_dict.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS xs_dict_detail;
CREATE TABLE xs_dict_detail (
id BIGSERIAL PRIMARY KEY,
dict_id BIGINT DEFAULT NULL,
dict_detail_code VARCHAR(64) DEFAULT NULL,
dict_detail_name VARCHAR(128) DEFAULT NULL,
dict_order INTEGER DEFAULT NULL,
parent_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_dict_id ON xs_dict_detail(dict_id);
COMMENT ON TABLE xs_dict_detail IS '数据字典明细信息';
COMMENT ON COLUMN xs_dict_detail.id IS '主键ID';
COMMENT ON COLUMN xs_dict_detail.dict_id IS '字典ID';
COMMENT ON COLUMN xs_dict_detail.dict_detail_code IS '子项编码';
COMMENT ON COLUMN xs_dict_detail.dict_detail_name IS '子项名称';
COMMENT ON COLUMN xs_dict_detail.dict_order IS '排序';
COMMENT ON COLUMN xs_dict_detail.parent_id IS '父子项ID';
COMMENT ON COLUMN xs_dict_detail.deleted IS '是否删除';
COMMENT ON COLUMN xs_dict_detail.create_by IS '创建人';
COMMENT ON COLUMN xs_dict_detail.create_time IS '创建时间';
COMMENT ON COLUMN xs_dict_detail.update_by IS '修改人';
COMMENT ON COLUMN xs_dict_detail.update_time IS '修改时间';
COMMENT ON COLUMN xs_dict_detail.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_district
-- ----------------------------
DROP TABLE IF EXISTS xs_district;
CREATE TABLE xs_district (
id BIGSERIAL PRIMARY KEY,
name VARCHAR(32) DEFAULT NULL,
parent_id BIGINT DEFAULT NULL,
initial VARCHAR(32) DEFAULT NULL,
initials VARCHAR(32) DEFAULT NULL,
pinyin VARCHAR(32) DEFAULT NULL,
extra VARCHAR(32) DEFAULT NULL,
suffix VARCHAR(32) DEFAULT NULL,
code VARCHAR(32) DEFAULT NULL,
area_code VARCHAR(32) DEFAULT NULL,
district_order INTEGER DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
level INTEGER DEFAULT NULL
);
COMMENT ON TABLE xs_district IS '省份城市';
COMMENT ON COLUMN xs_district.id IS '主键ID';
COMMENT ON COLUMN xs_district.name IS '城市名称';
COMMENT ON COLUMN xs_district.parent_id IS '上级城市ID';
COMMENT ON COLUMN xs_district.initial IS '首字母';
COMMENT ON COLUMN xs_district.initials IS '简拼';
COMMENT ON COLUMN xs_district.pinyin IS '全拼';
COMMENT ON COLUMN xs_district.extra IS '特别行政区';
COMMENT ON COLUMN xs_district.suffix IS '后缀';
COMMENT ON COLUMN xs_district.code IS '城市编码';
COMMENT ON COLUMN xs_district.area_code IS '区域编码';
COMMENT ON COLUMN xs_district.district_order IS '排序';
COMMENT ON COLUMN xs_district.deleted IS '是否删除';
COMMENT ON COLUMN xs_district.create_by IS '创建人';
COMMENT ON COLUMN xs_district.create_time IS '创建时间';
COMMENT ON COLUMN xs_district.update_by IS '修改人';
COMMENT ON COLUMN xs_district.update_time IS '修改时间';
COMMENT ON COLUMN xs_district.proxy_by IS '代理人';
COMMENT ON COLUMN xs_district.level IS '层级';
-- ----------------------------
-- Table structure for xs_file_record
-- ----------------------------
DROP TABLE IF EXISTS xs_file_record;
CREATE TABLE xs_file_record (
id BIGSERIAL PRIMARY KEY,
file_code VARCHAR(64) DEFAULT NULL,
file_path VARCHAR(512) DEFAULT NULL,
file_name VARCHAR(128) DEFAULT NULL,
file_size INTEGER DEFAULT NULL,
md5_code VARCHAR(64) DEFAULT NULL,
file_suffix VARCHAR(32) DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
storage_type VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_file_code ON xs_file_record(file_code);
COMMENT ON TABLE xs_file_record IS '附件信息';
COMMENT ON COLUMN xs_file_record.id IS '主键ID';
COMMENT ON COLUMN xs_file_record.file_code IS '文件编码';
COMMENT ON COLUMN xs_file_record.file_path IS '文件路径';
COMMENT ON COLUMN xs_file_record.file_name IS '文件名';
COMMENT ON COLUMN xs_file_record.file_size IS '文件大小';
COMMENT ON COLUMN xs_file_record.md5_code IS '文件MD5';
COMMENT ON COLUMN xs_file_record.file_suffix IS '文件后缀';
COMMENT ON COLUMN xs_file_record.org_id IS '所属机构';
COMMENT ON COLUMN xs_file_record.storage_type IS '储存器类型';
COMMENT ON COLUMN xs_file_record.deleted IS '是否删除';
COMMENT ON COLUMN xs_file_record.create_by IS '创建人';
COMMENT ON COLUMN xs_file_record.create_time IS '创建时间';
COMMENT ON COLUMN xs_file_record.update_by IS '修改人';
COMMENT ON COLUMN xs_file_record.update_time IS '修改时间';
COMMENT ON COLUMN xs_file_record.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_org
-- ----------------------------
DROP TABLE IF EXISTS xs_org;
CREATE TABLE xs_org (
id BIGSERIAL PRIMARY KEY,
org_name VARCHAR(32) DEFAULT NULL,
org_code VARCHAR(64) DEFAULT NULL,
type VARCHAR(2) DEFAULT NULL,
address_code VARCHAR(16) DEFAULT NULL,
address_name VARCHAR(128) DEFAULT NULL,
description VARCHAR(1024) DEFAULT NULL,
quality BOOLEAN DEFAULT FALSE,
enable BOOLEAN DEFAULT NULL,
activated BOOLEAN DEFAULT FALSE,
parent_id BIGINT DEFAULT NULL,
credit_code VARCHAR(64) DEFAULT NULL,
trade VARCHAR(2) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
activation_code VARCHAR(32) DEFAULT NULL,
phone VARCHAR(32) DEFAULT NULL,
query_children BOOLEAN DEFAULT NULL,
org_logo VARCHAR(64) DEFAULT NULL,
registered_address VARCHAR(128) DEFAULT NULL,
company_size VARCHAR(32) DEFAULT NULL,
business_license VARCHAR(64) DEFAULT NULL,
recruit_position_type VARCHAR(2) NOT NULL DEFAULT 1
);
COMMENT ON TABLE xs_org IS '机构';
COMMENT ON COLUMN xs_org.id IS '主键ID';
COMMENT ON COLUMN xs_org.org_name IS '机构名称';
COMMENT ON COLUMN xs_org.org_code IS '机构编号';
COMMENT ON COLUMN xs_org.type IS '机构类型（1.平台 2.渠道代理商 3.普通机构 4.定制机构 5.散户机构 6.产品机构）';
COMMENT ON COLUMN xs_org.address_code IS '任务地点编码';
COMMENT ON COLUMN xs_org.address_name IS '任务地点全称';
COMMENT ON COLUMN xs_org.description IS '机构描述';
COMMENT ON COLUMN xs_org.quality IS '是否优质企业';
COMMENT ON COLUMN xs_org.enable IS '是否启用';
COMMENT ON COLUMN xs_org.activated IS '是否激活';
COMMENT ON COLUMN xs_org.parent_id IS '父机构ID';
COMMENT ON COLUMN xs_org.credit_code IS '统一社会信用代码';
COMMENT ON COLUMN xs_org.trade IS '所属行业';
COMMENT ON COLUMN xs_org.deleted IS '是否删除';
COMMENT ON COLUMN xs_org.create_by IS '创建人';
COMMENT ON COLUMN xs_org.create_time IS '创建时间';
COMMENT ON COLUMN xs_org.update_by IS '修改人';
COMMENT ON COLUMN xs_org.update_time IS '修改时间';
COMMENT ON COLUMN xs_org.proxy_by IS '代理人';
COMMENT ON COLUMN xs_org.activation_code IS '机构账号激活码';
COMMENT ON COLUMN xs_org.phone IS '手机号码';
COMMENT ON COLUMN xs_org.query_children IS '是否能查看下级数据';
COMMENT ON COLUMN xs_org.org_logo IS '企业logo';
COMMENT ON COLUMN xs_org.registered_address IS '注册地址';
COMMENT ON COLUMN xs_org.company_size IS '规模 数据字典';
COMMENT ON COLUMN xs_org.business_license IS '营业执照';
COMMENT ON COLUMN xs_org.recruit_position_type IS '招聘岗位类型';
-- ----------------------------
-- Table structure for xs_org_user
-- ----------------------------
DROP TABLE IF EXISTS xs_org_user;
CREATE TABLE xs_org_user (
id BIGSERIAL PRIMARY KEY,
org_id BIGINT DEFAULT NULL,
user_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_org_user IS '机构用户';
COMMENT ON COLUMN xs_org_user.id IS '主键ID';
COMMENT ON COLUMN xs_org_user.org_id IS '机构id';
COMMENT ON COLUMN xs_org_user.user_id IS '用户id';
COMMENT ON COLUMN xs_org_user.deleted IS '是否删除';
COMMENT ON COLUMN xs_org_user.create_by IS '创建人';
COMMENT ON COLUMN xs_org_user.create_time IS '创建时间';
COMMENT ON COLUMN xs_org_user.update_by IS '修改人';
COMMENT ON COLUMN xs_org_user.update_time IS '修改时间';
COMMENT ON COLUMN xs_org_user.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_permission
-- ----------------------------
DROP TABLE IF EXISTS xs_permission;
CREATE TABLE xs_permission (
id BIGSERIAL PRIMARY KEY,
role_id BIGINT DEFAULT NULL,
resource_type VARCHAR(2) DEFAULT NULL,
resource_id BIGINT DEFAULT NULL,
attribute VARCHAR(32) DEFAULT NULL,
org_id BIGINT DEFAULT NULL,
platform_code SMALLINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_permission IS '权限表';
COMMENT ON COLUMN xs_permission.id IS '主键ID';
COMMENT ON COLUMN xs_permission.role_id IS '角色id';
COMMENT ON COLUMN xs_permission.resource_type IS '资源类型:1菜单 2组件 3接口';
COMMENT ON COLUMN xs_permission.resource_id IS '资源id';
COMMENT ON COLUMN xs_permission.attribute IS '权限鉴别属性，默认格式：ROLE_{roleId}，可以扩展';
COMMENT ON COLUMN xs_permission.org_id IS '机构id';
COMMENT ON COLUMN xs_permission.platform_code IS '平台编码 1.业务系统 2.运营中台 3.用户中心 4.支付系统 5.在线培训 6.转发器 7.风控 8.网关 9.发号器 10.基础框架';
COMMENT ON COLUMN xs_permission.deleted IS '是否删除';
COMMENT ON COLUMN xs_permission.create_by IS '创建人';
COMMENT ON COLUMN xs_permission.create_time IS '创建时间';
COMMENT ON COLUMN xs_permission.update_by IS '修改人';
COMMENT ON COLUMN xs_permission.update_time IS '修改时间';
COMMENT ON COLUMN xs_permission.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_permission_organization
-- ----------------------------
DROP TABLE IF EXISTS xs_permission_organization;
CREATE TABLE xs_permission_organization (
id BIGSERIAL PRIMARY KEY,
permission_package_id BIGINT DEFAULT NULL,
allocation_org_id BIGINT DEFAULT NULL,
remark VARCHAR(100) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_allocation_org_id ON xs_permission_organization(allocation_org_id);
CREATE INDEX idx_permission_package_id ON xs_permission_organization(permission_package_id);
COMMENT ON TABLE xs_permission_organization IS '权限包-机构关系表';
COMMENT ON COLUMN xs_permission_organization.id IS '主键id';
COMMENT ON COLUMN xs_permission_organization.permission_package_id IS '权限包id';
COMMENT ON COLUMN xs_permission_organization.allocation_org_id IS '分配机构orgid';
COMMENT ON COLUMN xs_permission_organization.remark IS '备注';
COMMENT ON COLUMN xs_permission_organization.deleted IS '是否删除';
COMMENT ON COLUMN xs_permission_organization.create_by IS '创建人';
COMMENT ON COLUMN xs_permission_organization.create_time IS '创建时间';
COMMENT ON COLUMN xs_permission_organization.update_by IS '修改人';
COMMENT ON COLUMN xs_permission_organization.update_time IS '修改时间';
COMMENT ON COLUMN xs_permission_organization.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_permission_package
-- ----------------------------
DROP TABLE IF EXISTS xs_permission_package;
CREATE TABLE xs_permission_package (
id BIGSERIAL PRIMARY KEY,
permission_package_name VARCHAR(64) DEFAULT NULL,
permission_package_type SMALLINT DEFAULT 1,
platform_code SMALLINT DEFAULT NULL,
status SMALLINT DEFAULT 1,
remark VARCHAR(100) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE xs_permission_package IS '标准权限包';
COMMENT ON COLUMN xs_permission_package.id IS '主键id';
COMMENT ON COLUMN xs_permission_package.permission_package_name IS '权限包名称';
COMMENT ON COLUMN xs_permission_package.permission_package_type IS '类型 1.基础包 2.其他类型';
COMMENT ON COLUMN xs_permission_package.platform_code IS '平台编码 1.业务系统 2.运营中台 3.用户中心 4.支付系统 5.在线培训 6.转发器 7.风控 8.网关 9.发号器 10.基础框架';
COMMENT ON COLUMN xs_permission_package.status IS '状态 1.有效 2.失效';
COMMENT ON COLUMN xs_permission_package.remark IS '备注';
COMMENT ON COLUMN xs_permission_package.deleted IS '是否删除';
COMMENT ON COLUMN xs_permission_package.create_by IS '创建人';
COMMENT ON COLUMN xs_permission_package.create_time IS '创建时间';
COMMENT ON COLUMN xs_permission_package.update_by IS '修改人';
COMMENT ON COLUMN xs_permission_package.update_time IS '修改时间';
COMMENT ON COLUMN xs_permission_package.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_permission_resources
-- ----------------------------
DROP TABLE IF EXISTS xs_permission_resources;
CREATE TABLE xs_permission_resources (
id BIGSERIAL PRIMARY KEY,
permission_package_id BIGINT DEFAULT NULL,
resource_id BIGINT DEFAULT NULL,
resource_type SMALLINT DEFAULT 1,
remark VARCHAR(100) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_resource_id ON xs_permission_resources(resource_id);
CREATE INDEX INDEX12372582404500 ON xs_permission_resources(permission_package_id);
COMMENT ON TABLE xs_permission_resources IS '权限包-资源关系表';
COMMENT ON COLUMN xs_permission_resources.id IS '主键id';
COMMENT ON COLUMN xs_permission_resources.permission_package_id IS '权限包id';
COMMENT ON COLUMN xs_permission_resources.resource_id IS '资源id';
COMMENT ON COLUMN xs_permission_resources.resource_type IS '类型 1.菜单 2.组件 3.接口';
COMMENT ON COLUMN xs_permission_resources.remark IS '备注';
COMMENT ON COLUMN xs_permission_resources.deleted IS '是否删除';
COMMENT ON COLUMN xs_permission_resources.create_by IS '创建人';
COMMENT ON COLUMN xs_permission_resources.create_time IS '创建时间';
COMMENT ON COLUMN xs_permission_resources.update_by IS '修改人';
COMMENT ON COLUMN xs_permission_resources.update_time IS '修改时间';
COMMENT ON COLUMN xs_permission_resources.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_real_name_two_verification
-- ----------------------------
DROP TABLE IF EXISTS xs_real_name_two_verification;
CREATE TABLE xs_real_name_two_verification (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
person_name VARCHAR(64) DEFAULT NULL,
identity_no VARCHAR(32) DEFAULT NULL,
status VARCHAR(2) DEFAULT 0,
authentication_source SMALLINT DEFAULT NULL,
err_msg VARCHAR(64) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
-- ----------------------------
-- Table structure for xs_role
-- ----------------------------
DROP TABLE IF EXISTS xs_role;
CREATE TABLE xs_role (
id BIGSERIAL PRIMARY KEY,
org_id BIGINT DEFAULT NULL,
name VARCHAR(128) DEFAULT NULL,
type VARCHAR(2) DEFAULT 0,
enabled BOOLEAN NOT NULL DEFAULT FALSE,
description VARCHAR(128) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
standard_type VARCHAR(2) DEFAULT 1,
platform_code SMALLINT DEFAULT NULL
);
COMMENT ON TABLE xs_role IS '角色';
COMMENT ON COLUMN xs_role.id IS '主键ID';
COMMENT ON COLUMN xs_role.org_id IS '机构id';
COMMENT ON COLUMN xs_role.name IS '名称';
COMMENT ON COLUMN xs_role.type IS '类型：0业务角色、1系统角色-渠道代理商、2系统角色-普通机构';
COMMENT ON COLUMN xs_role.enabled IS '是否启用';
COMMENT ON COLUMN xs_role.description IS '描述';
COMMENT ON COLUMN xs_role.deleted IS '是否删除';
COMMENT ON COLUMN xs_role.create_by IS '创建人';
COMMENT ON COLUMN xs_role.create_time IS '创建时间';
COMMENT ON COLUMN xs_role.update_by IS '修改人';
COMMENT ON COLUMN xs_role.update_time IS '修改时间';
COMMENT ON COLUMN xs_role.proxy_by IS '代理人';
COMMENT ON COLUMN xs_role.standard_type IS '标准角色类型：见role_standard_type';
COMMENT ON COLUMN xs_role.platform_code IS '平台编码';
-- ----------------------------
-- Table structure for xs_role_allocation
-- ----------------------------
DROP TABLE IF EXISTS xs_role_allocation;
CREATE TABLE xs_role_allocation (
id BIGSERIAL PRIMARY KEY,
role_id BIGINT DEFAULT NULL,
allocation_type VARCHAR(2) DEFAULT NULL,
allocation_id BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_allocation_id ON xs_role_allocation(allocation_id);
COMMENT ON TABLE xs_role_allocation IS '角色分配表';
COMMENT ON COLUMN xs_role_allocation.id IS '主键ID';
COMMENT ON COLUMN xs_role_allocation.role_id IS '角色id';
COMMENT ON COLUMN xs_role_allocation.allocation_type IS '角色分配类型：1个人2部门3组';
COMMENT ON COLUMN xs_role_allocation.allocation_id IS '角色具体分配类型对应的id';
COMMENT ON COLUMN xs_role_allocation.deleted IS '是否删除';
COMMENT ON COLUMN xs_role_allocation.create_by IS '创建人';
COMMENT ON COLUMN xs_role_allocation.create_time IS '创建时间';
COMMENT ON COLUMN xs_role_allocation.update_by IS '修改人';
COMMENT ON COLUMN xs_role_allocation.update_time IS '修改时间';
COMMENT ON COLUMN xs_role_allocation.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for xs_role_standard_type
-- ----------------------------
DROP TABLE IF EXISTS xs_role_standard_type;
CREATE TABLE xs_role_standard_type (
id BIGSERIAL PRIMARY KEY,
role_code VARCHAR(32) DEFAULT NULL,
name VARCHAR(64) DEFAULT NULL,
platform_code VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
type_order INTEGER DEFAULT NULL
);
COMMENT ON TABLE xs_role_standard_type IS '标准角色类型';
COMMENT ON COLUMN xs_role_standard_type.id IS '主键';
COMMENT ON COLUMN xs_role_standard_type.role_code IS '编码';
COMMENT ON COLUMN xs_role_standard_type.name IS '名称';
COMMENT ON COLUMN xs_role_standard_type.platform_code IS '平台编码';
COMMENT ON COLUMN xs_role_standard_type.deleted IS '是否逻辑删除';
COMMENT ON COLUMN xs_role_standard_type.create_by IS '创建人';
COMMENT ON COLUMN xs_role_standard_type.create_time IS '创建时间';
COMMENT ON COLUMN xs_role_standard_type.update_by IS '更新人';
COMMENT ON COLUMN xs_role_standard_type.update_time IS '更新时间';
COMMENT ON COLUMN xs_role_standard_type.proxy_by IS '代理人';
COMMENT ON COLUMN xs_role_standard_type.type_order IS '排序';
-- ----------------------------
-- Table structure for xs_url
-- ----------------------------
DROP TABLE IF EXISTS xs_url;
CREATE TABLE xs_url (
id BIGSERIAL PRIMARY KEY,
name VARCHAR(128) DEFAULT NULL,
link VARCHAR(256) DEFAULT NULL,
icon VARCHAR(32) DEFAULT NULL,
parent_id BIGINT DEFAULT NULL,
resource_order INTEGER DEFAULT NULL,
type SMALLINT DEFAULT NULL,
visible BOOLEAN DEFAULT NULL,
description VARCHAR(128) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
platform_code SMALLINT DEFAULT NULL
);
COMMENT ON TABLE xs_url IS '菜单地址';
COMMENT ON COLUMN xs_url.id IS '主键ID';
COMMENT ON COLUMN xs_url.name IS '名称';
COMMENT ON COLUMN xs_url.link IS '链接';
COMMENT ON COLUMN xs_url.icon IS 'icon';
COMMENT ON COLUMN xs_url.parent_id IS '父级';
COMMENT ON COLUMN xs_url.resource_order IS '排序';
COMMENT ON COLUMN xs_url.type IS '资源类型 1:菜单 2:接口';
COMMENT ON COLUMN xs_url.visible IS '是否可见';
COMMENT ON COLUMN xs_url.description IS '描述';
COMMENT ON COLUMN xs_url.deleted IS '是否删除';
COMMENT ON COLUMN xs_url.create_by IS '创建人';
COMMENT ON COLUMN xs_url.create_time IS '创建时间';
COMMENT ON COLUMN xs_url.update_by IS '修改人';
COMMENT ON COLUMN xs_url.update_time IS '修改时间';
COMMENT ON COLUMN xs_url.proxy_by IS '代理人';
COMMENT ON COLUMN xs_url.platform_code IS '平台编码';
-- ----------------------------
-- Table structure for x_file_category
-- ----------------------------
DROP TABLE IF EXISTS x_file_category;
CREATE TABLE x_file_category (
id BIGSERIAL PRIMARY KEY,
file_category VARCHAR(32) DEFAULT NULL,
file_suffix VARCHAR(32) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE x_file_category IS '文件种类';
COMMENT ON COLUMN x_file_category.id IS '主键ID';
COMMENT ON COLUMN x_file_category.file_category IS '文件种类';
COMMENT ON COLUMN x_file_category.file_suffix IS '文件后缀';
COMMENT ON COLUMN x_file_category.deleted IS '是否删除';
COMMENT ON COLUMN x_file_category.create_by IS '创建人';
COMMENT ON COLUMN x_file_category.create_time IS '创建时间';
COMMENT ON COLUMN x_file_category.update_by IS '修改人';
COMMENT ON COLUMN x_file_category.update_time IS '修改时间';
COMMENT ON COLUMN x_file_category.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for x_user_space
-- ----------------------------
DROP TABLE IF EXISTS x_user_space;
CREATE TABLE x_user_space (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
total_size BIGINT DEFAULT NULL,
used_size BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE x_user_space IS '用户空间';
COMMENT ON COLUMN x_user_space.id IS '主键ID';
COMMENT ON COLUMN x_user_space.user_id IS '用户id';
COMMENT ON COLUMN x_user_space.total_size IS '总容量';
COMMENT ON COLUMN x_user_space.used_size IS '已使用容量';
COMMENT ON COLUMN x_user_space.deleted IS '是否删除';
COMMENT ON COLUMN x_user_space.create_by IS '创建人';
COMMENT ON COLUMN x_user_space.create_time IS '创建时间';
COMMENT ON COLUMN x_user_space.update_by IS '修改人';
COMMENT ON COLUMN x_user_space.update_time IS '修改时间';
COMMENT ON COLUMN x_user_space.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for x_user_file
-- ----------------------------
DROP TABLE IF EXISTS x_user_file;
CREATE TABLE x_user_file (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT DEFAULT NULL,
root_type VARCHAR(2) DEFAULT NULL,
file_type VARCHAR(32) DEFAULT NULL,
file_name VARCHAR(256) DEFAULT NULL,
parent_id BIGINT DEFAULT NULL,
file_code VARCHAR(32) DEFAULT NULL,
file_status VARCHAR(2) DEFAULT NULL,
path VARCHAR(255) DEFAULT NULL,
end_time TIMESTAMP DEFAULT NULL,
access_code VARCHAR(6) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
COMMENT ON TABLE x_user_file IS '用户文件';
COMMENT ON COLUMN x_user_file.id IS '主键ID';
COMMENT ON COLUMN x_user_file.user_id IS '用户id';
COMMENT ON COLUMN x_user_file.root_type IS '根类型：1普通/2内穿外/3外传内/4我的分享';
COMMENT ON COLUMN x_user_file.file_type IS '文件大类：1文件/2文件夹';
COMMENT ON COLUMN x_user_file.file_name IS '文件名';
COMMENT ON COLUMN x_user_file.parent_id IS '父id';
COMMENT ON COLUMN x_user_file.file_code IS '文件编码';
COMMENT ON COLUMN x_user_file.file_status IS '文件状态：1正常2失效11解析中12待审核13传输中';
COMMENT ON COLUMN x_user_file.path IS '路径';
COMMENT ON COLUMN x_user_file.end_time IS '有效期';
COMMENT ON COLUMN x_user_file.access_code IS '访问码';
COMMENT ON COLUMN x_user_file.deleted IS '是否删除';
COMMENT ON COLUMN x_user_file.create_by IS '创建人';
COMMENT ON COLUMN x_user_file.create_time IS '创建时间';
COMMENT ON COLUMN x_user_file.update_by IS '修改人';
COMMENT ON COLUMN x_user_file.update_time IS '修改时间';
COMMENT ON COLUMN x_user_file.proxy_by IS '代理人';
-- ----------------------------
-- Table structure for x_file_risk
-- ----------------------------
DROP TABLE IF EXISTS x_file_risk;
CREATE TABLE x_file_risk (
id BIGSERIAL PRIMARY KEY,
file_code VARCHAR(32) DEFAULT NULL,
max_risk_level VARCHAR(2) DEFAULT NULL,
risk_json TEXT DEFAULT NULL,
dify_file_json TEXT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
CONSTRAINT uk_file_code UNIQUE (file_code)
);
COMMENT ON TABLE x_file_risk IS '文件风险';
COMMENT ON COLUMN x_file_risk.id IS '主键ID';
COMMENT ON COLUMN x_file_risk.file_code IS '文件编码';
COMMENT ON COLUMN x_file_risk.max_risk_level IS '最高风险等级：1重度/2中度/3轻度';
COMMENT ON COLUMN x_file_risk.risk_json IS '风险详情JSON';
COMMENT ON COLUMN x_file_risk.dify_file_json IS 'Dify文件上传响应JSON';
COMMENT ON COLUMN x_file_risk.deleted IS '是否删除';
COMMENT ON COLUMN x_file_risk.create_by IS '创建人';
COMMENT ON COLUMN x_file_risk.create_time IS '创建时间';
COMMENT ON COLUMN x_file_risk.update_by IS '修改人';
COMMENT ON COLUMN x_file_risk.update_time IS '修改时间';
COMMENT ON COLUMN x_file_risk.proxy_by IS '代理人';
CREATE TABLE x_upload_config (
id BIGSERIAL PRIMARY KEY,
org_id BIGINT DEFAULT NULL,
upload_enabled BOOLEAN DEFAULT TRUE,
allow_all_type BOOLEAN DEFAULT TRUE,
allowed_suffixes VARCHAR(1024) DEFAULT NULL,
max_file_size BIGINT DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL,
CONSTRAINT uk_upload_config_org_id UNIQUE (org_id)
);
COMMENT ON TABLE x_upload_config IS '机构上传配置';
COMMENT ON COLUMN x_upload_config.id IS '主键ID';
COMMENT ON COLUMN x_upload_config.org_id IS '机构id';
COMMENT ON COLUMN x_upload_config.upload_enabled IS '是否允许上传';
COMMENT ON COLUMN x_upload_config.allow_all_type IS '是否允许全部类型(false时按allowed_suffixes白名单校验)';
COMMENT ON COLUMN x_upload_config.allowed_suffixes IS '允许的文件后缀(逗号分隔,小写),allow_all_type=false时生效';
COMMENT ON COLUMN x_upload_config.max_file_size IS '单文件大小上限(MB),空或0不限制';
COMMENT ON COLUMN x_upload_config.deleted IS '是否删除';
COMMENT ON COLUMN x_upload_config.create_by IS '创建人';
COMMENT ON COLUMN x_upload_config.create_time IS '创建时间';
COMMENT ON COLUMN x_upload_config.update_by IS '修改人';
COMMENT ON COLUMN x_upload_config.update_time IS '修改时间';
COMMENT ON COLUMN x_upload_config.proxy_by IS '代理人';
CREATE TABLE x_file_security (
id BIGSERIAL PRIMARY KEY,
file_code VARCHAR(32) DEFAULT NULL,
task_id VARCHAR(64) DEFAULT NULL,
scan_status VARCHAR(2) DEFAULT NULL,
action VARCHAR(32) DEFAULT NULL,
reason VARCHAR(1024) DEFAULT NULL,
result_json TEXT DEFAULT NULL,
review_comment VARCHAR(512) DEFAULT NULL,
deleted BOOLEAN DEFAULT FALSE,
create_by BIGINT DEFAULT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_by BIGINT DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
proxy_by BIGINT DEFAULT NULL
);
CREATE INDEX idx_file_security_file_code ON x_file_security(file_code);
CREATE INDEX idx_file_security_scan_status ON x_file_security(scan_status);
COMMENT ON TABLE x_file_security IS '文件安全检测记录';
COMMENT ON COLUMN x_file_security.id IS '主键ID';
COMMENT ON COLUMN x_file_security.file_code IS '文件编码';
COMMENT ON COLUMN x_file_security.task_id IS 'MeshSafe检测任务ID';
COMMENT ON COLUMN x_file_security.scan_status IS '检测状态：1检测中/2通过/3不通过/4检测失败';
COMMENT ON COLUMN x_file_security.action IS 'MeshSafe处置动作：pass/manual_review/reject';
COMMENT ON COLUMN x_file_security.reason IS '检测结论说明';
COMMENT ON COLUMN x_file_security.result_json IS '检测完整结果JSON';
COMMENT ON COLUMN x_file_security.review_comment IS '人工复核说明(人工改判时有值)';
COMMENT ON COLUMN x_file_security.deleted IS '是否删除';
COMMENT ON COLUMN x_file_security.create_by IS '创建人';
COMMENT ON COLUMN x_file_security.create_time IS '创建时间';
COMMENT ON COLUMN x_file_security.update_by IS '修改人';
COMMENT ON COLUMN x_file_security.update_time IS '修改时间';
COMMENT ON COLUMN x_file_security.proxy_by IS '代理人';
Reference in New Issue View Git Blame Copy Permalink