iUser Table

Last updated 4/12/2023

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.

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.
Email	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.