iUser Table
Last updated 19/03/2024
Five adds the iUser table into your application when you turn your application into a multi-user application. This enables you to start adding users immediately into your application, as a Users form and menu item are created using the iUser table as the data source.caution
You can edit the iUser table, however, it is strongly recommended not to delete any of the fields on the iUser table.
If there are fields you do not want to show in your application, it is best to hide the fields at the form-level rather than deleting the fields from the table.
Not all the fields are shown on the Users form as Five uses some of the fields in the iUser table internally.
If there are fields you do not want to show in your application, it is best to hide the fields at the form-level rather than deleting the fields from the table.
Not all the fields are shown on the Users form as Five uses some of the fields in the iUser table internally.
The table below is to give you an understanding of the iUser table fields and how they are used.
Field | Description |
---|---|
iUserKey | Holds the key for the primary key field. |
iRoleKey | Holds the role of the user. |
UserID | Holds the user ID for the user. |
FullName | Holds the full name for the user. |
Password | Holds the encrypted password for the user. |
Holds the email for the user. | |
PhoneNo | Holds the phone number for the user. |
iUserRecordKey | Holds the associated key of the configured security table. |
Enabled | Holds true by default to enable a user account. |
Locked | Holds false by default and locks if a user fails three log in attempts. |
PasswordFails | Holds the number of times a user has failed log in attempts. |
PasswordUpdateNextLogin | If true, the user will be forced to set password on next login. By default, it is set to true for initial log in and then turns to false. |
PasswordUpdateTime | Holds the UTC time value of when the password was updated. |
ResetPasswordToken | Five uses internally. |
TokenExpiry | Five uses internally. |
LicenceAccepted | Five uses internally |
UniqueLicenceID | Five uses internally. |