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 | 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.user.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 | ||
| IWA_User_SecSysSecMemberIndex | SecuritySystemId , SecurityMemberId | ||
| IWA_User_SecSysNameSecMemberIdx | SecuritySystemId , Name , SecurityMemberId | MySql |
| 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 | DbDataClass | Enum | HideFieldOnQuery | QueryClassPublicAPI | QueryClassWithGroupFunction | QueryExecutorProviderClass |
|---|---|---|---|---|---|---|---|---|---|
| IWA_User | ch.ivyteam.ivy.security.IUser | ch.ivyteam.ivy.security.internal.db.DbUserData | true | true | ch.ivyteam.ivy.security.internal.user.query.UserQueryExecutorProvider | ||||
| UserId | true | ||||||||
| UserPassword | passwordHash | true | |||||||
| SecuritySystemId | true | ||||||||
| ExternalSecurityName | true | ||||||||
| Language | true | ||||||||
| FormattingLanguage | true | ||||||||
| State | ch.ivyteam.ivy.security.internal.user.UserState | true |
| Object | Strategy |
|---|---|
| IWA_User | ALL_REMOVE_UNUSED |
| Object | ConvertEmptyStringToNull | IndexName |
|---|---|---|
| Name | true | |
| UserPassword | true | |
| IWA_User_ExternalSecurityNameIndex | IWA_User_ExternalSecNameIdx |
| Object | IndexColumnLength |
|---|---|
| IWA_User_SecSysNameSecMemberIdx | ,50,200 |