-- 属地单位：审批方式（部门 / 人员分组 / 人员）+ 人员多选关联表
|
|
CREATE TABLE IF NOT EXISTS pass_local_unit (
|
id BIGINT PRIMARY KEY AUTO_INCREMENT,
|
uuid VARCHAR(64) NOT NULL,
|
version BIGINT NOT NULL DEFAULT 0,
|
create_id BIGINT NULL,
|
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
update_id BIGINT NULL,
|
update_time DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
del_flag INT NOT NULL DEFAULT 0,
|
|
unit_name VARCHAR(128) NOT NULL COMMENT '单位名称',
|
remark VARCHAR(512) NULL COMMENT '备注',
|
approver_type TINYINT NOT NULL COMMENT '1部门 2人员分组 3人员',
|
approver_group_id BIGINT NULL COMMENT '人员分组 mp_staff_group.id',
|
approver_dept_ids TEXT NULL COMMENT '部门 id 列表 JSON',
|
|
UNIQUE KEY uk_pass_local_unit_uuid (uuid),
|
KEY idx_plu_name (unit_name)
|
);
|
|
CREATE TABLE IF NOT EXISTS pass_local_unit_member (
|
id BIGINT PRIMARY KEY AUTO_INCREMENT,
|
uuid VARCHAR(64) NOT NULL,
|
version BIGINT NOT NULL DEFAULT 0,
|
create_id BIGINT NULL,
|
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
update_id BIGINT NULL,
|
update_time DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
del_flag INT NOT NULL DEFAULT 0,
|
|
unit_id BIGINT NOT NULL COMMENT 'pass_local_unit.id',
|
mp_user_id BIGINT NOT NULL COMMENT 'mp_user.id',
|
|
UNIQUE KEY uk_plum_unit_user (unit_id, mp_user_id),
|
KEY idx_plum_unit (unit_id)
|
);
|
