-- 小程序用户；执行 V3 后：员工含 dept_id、dept_leader_flag，且不再与 sys_user 绑定
|
CREATE TABLE IF NOT EXISTS mp_user (
|
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
uuid VARCHAR(64) NOT NULL,
|
version BIGINT NOT NULL DEFAULT 1,
|
create_id BIGINT NULL,
|
create_time DATETIME NULL,
|
update_id BIGINT NULL,
|
update_time DATETIME NULL,
|
del_flag INT NOT NULL DEFAULT 0,
|
open_id VARCHAR(64) NOT NULL,
|
union_id VARCHAR(64) NULL,
|
user_type VARCHAR(32) NOT NULL COMMENT 'VISITOR / EMPLOYEE',
|
sys_user_id BIGINT NULL COMMENT '历史字段，V3 迁移后删除',
|
nick_name VARCHAR(128) NULL,
|
avatar_url VARCHAR(512) NULL,
|
mobile VARCHAR(32) NULL,
|
UNIQUE KEY uk_mp_user_uuid (uuid),
|
UNIQUE KEY uk_mp_user_open_id (open_id),
|
KEY idx_mp_user_sys (sys_user_id)
|
);
|
