Table IWA_UserRole

Relation between roles and users.

Columns

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
true UserSecurityMemberId VARCHAR 210 false IWA_User(SecurityMemberId) ON DELETE CASCADE

Indexes

Name Columns Hints Comment
IWA_UserRole_RoleSecurityMemberIdIndex RoleSecurityMemberId
IWA_UserRole_UserSecurityMemberIdIndex UserSecurityMemberId

Java

Object AsAssociation
IWA_UserRole true