Role Properties
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| false | SecurityMemberId | VARCHAR | 210 | false | IWA_Role(SecurityMemberId) | ON DELETE CASCADE | Java | References the user this property belongs to. | ||
| true | RolePropertyId | BIGINT | false | Identifies the user property | ||||||
| false | PropertyName | VARCHAR | 255 | false | Oracle | Name of the property. | ||||
| false | PropertyValue | CLOB | false | Java | Value of the property. |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | RoleProperty_SecMemberIdPropertyNameIndex | SecurityMemberId , PropertyName |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_RoleProperty_SecurityMemberIdIndex | SecurityMemberId |
| Object | Strategy |
|---|---|
| IWA_RoleProperty | ALL_REMOVE_UNUSED |
| Object | AsParent | DataType |
|---|---|---|
| SecurityMemberId | true | |
| PropertyValue | String |
| Object | ConvertEmptyStringToNull |
|---|---|
| PropertyName | true |