Click or drag to resize

Applications

Store all 3rd party application allowed to connect on AskiaPortal.

`Applications` table.

Name

Type

Description

Id

INT [auto-generated] NOT NULL

Id of the application

Guid

UNIQUEIDENTIFIER NOT NULL

GUID of the application

Name

NVARCHAR(255) NOT NULL

Name of the application

Description

NVARCHAR(MAX) NULLABLE

Description of the application

ApiKey

NVARCHAR(MAX) NOT NULL

Key allowing the application to connect in the AskiaPortal API

CreatedBy

INT FOREIGN KEY NOT NULL

Id of the user who has created the application

CreatedAt

DATETIME NOT NULL

Date of creation

UpdatedBy

INT FOREIGN KEY NOT NULL

Id of the latest user who has updated the application

UpdatedAt

DATETIME NOT NULL

Date of the latest update

IsDeleted

BIT NOT NULL

Indicates if the application is deleted

DeletedBy

INT FOREIGN KEY NULLABLE

Id of the user who has deleted the application

DeletedAt

DATETIME NULLABLE

Date of deletion

See Also