Users

Id

INT [auto-generated] NOT NULL

ID of the user

Guid

UNIQUEIDENTIFIER NOT NULL

GUID of the user

Security Note
This identifier is prefer to be use for safe exchange

GroupId

INT FOREIGN KEY NOT NULL

Group Id of the user

FirstName

NVARCHAR(255) NULLABLE

FirstName of the user

LastName

NVARCHAR(255) NULLABLE

Description of the user

Description

NVARCHAR(MAX) NULLABLE

Description of the user

Email

NVARCHAR(255) NOT NULL

Email of the user

Login

NVARCHAR(255) NOT NULL

Login of the user

Password

NVARCHAR(255) NOT NULL

Hashed password of the user

PasswordSalt

NVARCHAR(255) NOT NULL

Random string use to salt the password of the user

LanguageId

INT FOREIGN KEY NOT NULL

Language Id of the user

UserProfileId

INT FOREIGN KEY NULLABLE

Id of the user profile from where the user inherits the settings.

IsSuperAdmin

BIT NOT NULL

Indicates if the user is a super administrator or not

State

INT NOT NULL

State of the user.

• 0 = Unauthorized

• 1 = Approved

• 2 = Activated

LicensesUsage

NVARCHAR(MAX) NULLABLE

Encrypted information about the licenses usage

LastConnectionAt

DATETIME NULLABLE

Date/Time of the latest connection

LastSessionGuid

UNIQUEIDENTIFIER NULLABLE

GUID of the latest session

LastSessionUsageAt

DATETIME NULLABLE

Date/Time of the latest session usage

ActivationEmailSentAt

DATETIME NULLABLE

Date/Time when the activation email has been sent

PasswordChangedAt

DATETIME NULLABLE

Date/Time when the pasword has been changed

CreatedBy

INT FOREIGN KEY NOT NULL

Id of the user who has created the user

CreatedAt

DATETIME NOT NULL

Date of creation

UpdatedBy

INT FOREIGN KEY NOT NULL

Id of the latest user who has updated the user

UpdatedAt

DATETIME NOT NULL

Date of the latest update

IsDeleted

BIT NOT NULL

Indicates if the user is deleted

DeletedBy

INT FOREIGN KEY NULLABLE

Id of the user who has deleted the user

DeletedAt

DATETIME NULLABLE

Date of deletion