Skip to content
On this page

user_roles

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNED用户主键 IDNO关联字段 users->id
role_idint UNSIGNED角色 IDNO关联字段 roles->id
is_maintinyint UNSIGNED是否为主角色0NO0.普通 / 1.主角色
expired_attimestamp角色有效期YES过期时间
restore_role_idint UNSIGNED继承角色 IDYES如果是主角色,过期后谁继承主角色
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License