14 lines
914 B
SQL
14 lines
914 B
SQL
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
||
CREATE TABLE IF NOT EXISTS admin_bd_leader_position_aliases (
|
||
app_code VARCHAR(32) NOT NULL DEFAULT 'lalu' COMMENT '应用编码，用于多租户隔离',
|
||
user_id BIGINT NOT NULL COMMENT 'BD Leader 用户 ID',
|
||
position_alias VARCHAR(64) NOT NULL DEFAULT '' COMMENT '职位别名，用于覆盖 App H5 admin 配置展示名',
|
||
created_by_admin_id BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建管理员 ID',
|
||
updated_by_admin_id BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新管理员 ID',
|
||
created_at_ms BIGINT NOT NULL COMMENT '创建时间，UTC epoch ms',
|
||
updated_at_ms BIGINT NOT NULL COMMENT '更新时间，UTC epoch ms',
|
||
PRIMARY KEY (app_code, user_id),
|
||
KEY idx_admin_bd_leader_position_alias_updated (app_code, updated_at_ms)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BD Leader 职位别名配置表';
|