You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
759 B
12 lines
759 B
1 week ago
|
-- 协同房间用户资料表（显示名 + 头像）
|
||
|
|
CREATE TABLE IF NOT EXISTS room_user_profile (
|
||
|
|
id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
user_id BIGINT NOT NULL COMMENT 'sys_user.user_id',
|
||
|
|
display_name VARCHAR(64) NOT NULL COMMENT '协同显示名',
|
||
|
|
avatar VARCHAR(255) DEFAULT NULL COMMENT '协同头像URL/资源路径',
|
||
|
|
create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
|
|
update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
|
|
PRIMARY KEY (id),
|
||
|
|
UNIQUE KEY uk_user_id (user_id)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='协同房间用户资料';
|