ADMINUser

 Show all Hide all
Deprecated in: 5.4.019

Stores properties about users in the system.

Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
UserID int Yes No Yes Primary key for the user. You may create foreign keys referencing this column.
Username varchar(50) Yes No No The username the user uses to login to the system
Password varchar(50) No No No Password the user uses to login to the system. This column is only relevant when password hashing is turned off.
UsernameFirst varchar(50) Yes No No Users first name
UsernameLast varchar(50) Yes No No Users last name
UserEmail varchar(100) Yes No No Users email address
LanguageID int Yes No No Reference to the users default language in the ADMINLanguage table
RoleID int Yes No No Reference to the users role in the AMDINRole table
Administrator bit Yes No No Indicates that the user is a Softadmin® administrator.
Enabled bit Yes No No Indicates whther the account is active, i.e. can be used to login to the system.
MaintenanceUserRightsID int Yes No No Reference to the users maintenance rights in the ADMINMaintenanceUserIRights table.
HelpAdministrator bit No No No Indicates that the user is a help administrator, i.e. is allowed to edit documentation pages for the system.
PasswordHash binary(64) No No No Hash of the users password. This column is only relevant when password hashing is enabled.
PasswordSalt binary(16) Yes No No Salt used to compute the password hash. This column is only relevant when password hashing is enabled.
PasswordHasExpired bit Yes No No Indicates that the users password has expired and needs to be reset.
PasswordUpdateDatetime datetime Yes No No Indicates that last time the users password was changed.
CreateDatetime datetime Yes No No Indicates when the account was initially created.
LatestNewsViewingDatetime datetime No No No Private. Indicates the last time the user viewed news from the news channel.
UsernameFull varchar(101) Yes No No Concatenation of UsernameFirst and UsernameLast.