Click or drag to resize

Settings

Profile of settings or preferences for users.

`Settings` table.

Name

Type

Description

EntityType

NVARCHAR(50) NOT NULL

Type of the entity.

All of the below entity types are used by AskiaPortal:

  • userprofile

  • user

  • survey

  • server

  • application

EntityId

INT NOT NULL

Id of the entity.

ModuleGuid

UNIQUEIDENTIFIER FOREIGN KEY NOT NULL

Define for which module the settings belongs to.

Key

NVARCHAR(255) NOT NULL

Key of the settings.

All of the below keys are used by AskiaPortal:

  • DefaultModuleGuid (GUID)

  • AllowConcurrentSessions (boolean)

  • AllowedIpAddresses (string)

  • AllowedUrlReferrers (string)

  • IsOptedIntoAnalytics (boolean)

  • ShareByDefault (boolean)

Value

NVARCHAR(MAX)

Value associated with the key.

Serialized as string

See Also