UserTokens

Id

INT [auto-generated] NOT NULL

Unique ID of the user token.

UserId

INT FOREIGN KEY NOT NULL

ID of the user associated with the token.

ModuleGuid

UNIQUEIDENTIFIER FOREIGN KEY NOT NULL

GUID of the module which manage the token.

ServerId

INT FOREIGN KEY NULLLABLE

ID of the server which manage the token.

Key

NVARCHAR(50) NOT NULL

Key of the user token (eg. "SSO", "ajax", "ActiveDirectory"...).

Token

NVARCHAR(MAX)

Value of the user token.

CreatedBy

INT FOREIGN KEY NOT NULL

Id of the user who has created the user token.

CreatedAt

DATETIME NOT NULL

Date of creation.

UpdatedBy

INT FOREIGN KEY NOT NULL

Id of the latest user who has updated the user token.

UpdatedAt

DATETIME NOT NULL

Date of the latest update.

IsDeleted

BIT NOT NULL

Indicates if the user token is deleted.

DeletedBy

INT FOREIGN KEY NULLABLE

Id of the user who has deleted the user token.

DeletedAt

DATETIME NULLABLE

Date of deletion.