DB foundation_user

user_core

column name	definition
user_core_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_id	BIGINT UNSIGNED NOT NULL COMMENT 'user id'
type	TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户类型'
state	TINYINT UNSIGNED NOT NULL COMMENT '用户状态'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

individual_user_general

column name	definition
individual_user_general_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_id	BIGINT UNSIGNED NOT NULL
nickname	VARCHAR (20) NULL COMMENT '昵称'
biography	VARCHAR (128) NULL COMMENT '个人简介。简短的介绍'
picture	VARCHAR (45) NULL COMMENT '用户图像。保存的是图片地址。命名来源：github'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

user_account

column name	definition
user_account_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_id	BIGINT UNSIGNED NOT NULL COMMENT '用户ID'
username	VARCHAR (45) NOT NULL COMMENT '只能是英文模式下的字母，数字，下划线，中划线，必须明确检查保证不是邮箱。设置以后不能修改(github可以修改)，可用作用户主页URL的一部分，参考github。注意和昵称的区别'
password	VARCHAR (45) NOT NULL COMMENT '只能是ASCII表中的可打印字符'
state	TINYINT UNSIGNED NOT NULL COMMENT '账号的状态'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

user_phone

column name	definition
id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_id	BIGINT UNSIGNED NOT NULL
phone_id	BIGINT UNSIGNED NOT NULL
use	TINYINT UNSIGNED NOT NULL COMMENT '电话的用途。比如用于400电话。也就是电话使用的业务场景。'
state	TINYINT UNSIGNED NOT NULL COMMENT '状态，每种用途的phone的il状态可能不同，比如如果用于登录的phone，状态可以是禁止登录状态'
description	VARCHAR (45) NULL COMMENT '简单描述'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

user_email

column name	definition
id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_id	BIGINT UNSIGNED NOT NULL
email_id	BIGINT UNSIGNED NOT NULL
use	TINYINT UNSIGNED NOT NULL COMMENT '用途。比如用于登录'
state	TINYINT UNSIGNED NOT NULL COMMENT '状态，每种用途的email状态可能不同，比如如果用于登录的email，状态可以是禁止登录状态'
description	VARCHAR (45) NULL COMMENT '简单描述'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

user_belongs_to_group_core

column name	definition
user_belongs_to_group_core_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_belongs_to_group_id	BIGINT UNSIGNED NOT NULL COMMENT '用于串连user belongs to group的所有信息'
user_id	BIGINT UNSIGNED NOT NULL COMMENT '用户ID'
group_type	SMALLINT UNSIGNED NOT NULL COMMENT '组的类型，比如部门是一种组，其他组织机构也是一种组'
group_identifier	BIGINT UNSIGNED NOT NULL COMMENT '组的唯一标记，如果组的类型是部门，则该值应该是部门表的ID'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

user_belongs_to_group_general

column name	definition
user_belongs_to_group_general_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_belongs_to_group_id	BIGINT UNSIGNED NOT NULL
nickname	VARCHAR (45) NULL COMMENT '用户在组里面的昵称'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

user_belongs_to_group_role

column name	definition
user_belongs_to_group_role_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
user_belongs_to_group_id	BIGINT UNSIGNED NOT NULL
permission_role_id	BIGINT UNSIGNED NOT NULL COMMENT '角色ID'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0