member_role_rels

Column NameTypeCommentsDefaultNullRemark
idbigint UNSIGNEDPrimary IDNOAUTO_INCREMENT
member_idbigint UNSIGNED成员 IDNO关联字段 member > id
role_idint UNSIGNED角色 IDNO关联字段 member_roles > id
typetinyint UNSIGNED是否为主角色1NO1.普通 / 2.主角色
expired_attimestamp角色有效期YES过期时间
restore_role_idint UNSIGNED继承角色 IDYES如果是主角色,过期后谁继承主角色
created_attimestampCreated TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdated TimeCURRENT_TIMESTAMPNO
deleted_attimestampDeleted TimeYES