-- 属地单位：审批方式（部门 / 人员分组 / 人员）+ 人员多选关联表

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)
);