Servers

Id

INT [auto-generated] NOT NULL

ID of the server.

GUID

UNIQUEIDENTIFIER NOT NULL

GUID of the server.

ModuleGuid

UNIQUEIDENTIFIER FOREIGN KEY NOT NULL

GUID of the module that have installed the server.

Name

NVARCHAR(255) NOT NULL

Name of the server (eg. MyServerName\askiafield, MyServerName\askiavistaserver...).

Description

NVARCHAR(MAX) NULL

Description of the server (eg. SMTP server, Askia data collect, Calculation engine).

Type

NVARCHAR(50) NOT NULL

Type of the server (eg. askiafield, askiavistaserver...).

All of the below types are used by AskiaPortal:

• smtp

MasterServerId

INT FOREIGN KEY NULL

ID of the master server.

Slave servers are used for fail-over or load-balancing.

ConnectionStringType

INT NOT NULL

Type of the connection string.

• 0: Custom

• 1: Database (eg. Provider=SQLOLEDB.1;Data Source=MyServer;Initial Catalog=MyDb;...)

• 2: Socket (eg. 127.0.0.1:3500)

• 3: SMTP (eg. Host=127.0.0.1;Port=21;SSL=false;UserName=XXX;Password=YYY)

• 4: Path (eg. \\myserver\path\)

• 5: URI (eg. http://my.web.service.com/)

ConnectionString

NVARCHAR(MAX) NULL

String used to connect on the server.

IsDisabled

BIT NOT NULL

Indicates if the server is disabled.

CreatedBy

INT FOREIGN KEY NOT NULL

Id of the user who has created the server.

CreatedAt

DATETIME NOT NULL

Date of creation.

UpdatedBy

INT FOREIGN KEY NOT NULL

Id of the latest user who has updated the server.

UpdatedAt

DATETIME NOT NULL

Date of the latest update.

IsDeleted

BIT NOT NULL

Indicates if the server is deleted.

DeletedBy

INT FOREIGN KEY NULL

Id of the user who has deleted the server.

DeletedAt

DATETIME NULL

Date of deletion.