Skip to main content

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.

The table below is to give you an understanding of the iUser table fields and how they are used.

FieldDescription
iUserKeyHolds the key for the primary key field.
iRoleKeyHolds the role of the user.
UserIDHolds the user ID for the user.
FullNameHolds the full name for the user.
PasswordHolds the encrypted password for the user.
EmailHolds the email for the user.
PhoneNoHolds the phone number for the user.
iUserRecordKeyHolds the associated key of the configured security table.
EnabledHolds true by default to enable a user account.
LockedHolds false by default and locks if a user fails three log in attempts.
PasswordFailsHolds the number of times a user has failed log in attempts.
PasswordUpdateNextLoginIf 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.
PasswordUpdateTimeHolds the UTC time value of when the password was updated.
ResetPasswordTokenFive uses internally.
TokenExpiryFive uses internally.
LicenceAcceptedFive uses internally
UniqueLicenceIDFive uses internally.