Skip to content

user_roles

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDUser Primary Key IDNORelated field users->id
role_idint UNSIGNEDRole IDNORelated field roles->id
is_maintinyint UNSIGNEDIs Main Role0NO0.Ordinary / 1.Main Role
expired_attimestampRole Validity PeriodYESExpiration Time
restore_role_idint UNSIGNEDInherit Role IDYESIf the main role, who will inherit the main role after expiration
created_attimestampCreate TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License