Users
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| false | UserId | BIGINT | false | Java | Identifies the user. | |||||
| false | Name | VARCHAR | 200 | false | Oracle | Name of the user. The name identifies a user within a web application. | ||||
| false | FullName | VARCHAR | 200 | true | Full name of the user. | |||||
| false | UserPassword | VARCHAR | 200 | false | Java , Oracle | Password the user uses to authenticate to the system. The password is stored encrypted. | ||||
| false | SecuritySystemId | BIGINT | false | IWA_SecuritySystem(SecuritySystemId) | Java | References the application this user belongs to. | ||||
| false | ExternalSecurityName | VARCHAR | 500 | true | Java | The name of the user in an external security system. | ||||
| false | ExternalId | VARCHAR | 200 | true | The id of the user in an external security system. | |||||
| false | EMailAddress | VARCHAR | 200 | true | E-Mail address of the user. | |||||
| false | EMailNotificationSettings | INTEGER | false | 0 | Java | The kind of e-mail notification the user likes. See java enumeration ch.ivyteam.ivy.security.EMailNotificationKind for possible values. | ||||
| false | Language | VARCHAR | 5 | true | Java | The content language locale of the user | ||||
| false | FormattingLanguage | VARCHAR | 5 | true | Java | The formatting language locale of the user | ||||
| false | State | INTEGER | false | 0 | Java | See java enumeration ch.ivyteam.ivy.security.internal.UserState for possible values. | ||||
| true | SecurityMemberId | VARCHAR | 210 | false | IWA_SecurityMember(SecurityMemberId) |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | IWA_User_UserIdUnique | UserId | ||
| UNIQUE | IWA_User_SecSystemIdNameIndex | SecuritySystemId , Name |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_User_ExternalIdIndex | SecuritySystemId , ExternalId | ||
| IWA_User_StateIndex | State | ||
| IWA_User_ExternalSecurityNameIndex | SecuritySystemId , ExternalSecurityName | Oracle | |
| IWA_User_SecuritySystemIdIndex | SecuritySystemId |
| Foreign Table | Column | Comment |
|---|---|---|
| IWA_UserRole | UserSecurityMemberId | |
| IWA_UserProperty | SecurityMemberId | References the user this property belongs to. |
| IWA_UserAbsence | SecurityMemberId | References the user this absence belongs to |
| IWA_UserSubstitute | SecurityMemberId | References the user this substitute belongs to. |
| IWA_UserSubstitute | SubstituteUserSecurityMemberId | References the user which substitutes the user references by UserId in the case he is absent. |
| IWA_Note | SecurityMemberId | References the user, which has written this note. Maybe null if the user who has written the note was deleted. |
| IWA_UserLocation | SecurityMemberId |
| Object | AsParent | AttributeName | BusinessClass | Enum | HideFieldOnQuery |
|---|---|---|---|---|---|
| IWA_User | ch.ivyteam.ivy.security.IUser | ||||
| UserId | true | ||||
| UserPassword | passwordHash | true | |||
| SecuritySystemId | true | ||||
| ExternalSecurityName | true | ||||
| EMailNotificationSettings | true | ||||
| Language | true | ||||
| FormattingLanguage | true | ||||
| State | ch.ivyteam.ivy.security.internal.UserState | true |
| Object | Strategy |
|---|---|
| IWA_User | ALL_REMOVE_UNUSED |
| Object | ConvertEmptyStringToNull | IndexName |
|---|---|---|
| Name | true | |
| UserPassword | true | |
| IWA_User_ExternalSecurityNameIndex | IWA_User_ExternalSecNameIdx |