Relation between roles
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| true | RoleSecurityMemberId | VARCHAR | 210 | false | IWA_Role(SecurityMemberId) | ON DELETE CASCADE | MsSqlServer | References a role which has a relation with the role referenced by RoleMemberId. | ||
| true | RoleMemberSecurityMemberId | VARCHAR | 210 | false | IWA_Role(SecurityMemberId) | ON DELETE CASCADE | MsSqlServer | References a role which has a member relation with the role reference by RoleId. |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_RoleRoleMember_RoleSecurityMemberIdIndex | RoleSecurityMemberId | ||
| IWA_RoleRoleMember_RoleMemberSecurityMemberIdIndex | RoleMemberSecurityMemberId |
| Object | AsAssociation |
|---|---|
| IWA_RoleRoleMember | true |
| Object | NoReferenceUseTrigger |
|---|---|
| RoleSecurityMemberId | true |
| RoleMemberSecurityMemberId | true |