Miscellaneous objects

Objects

AppSettings

This table stored the application settings.

Column name Column type Purpose
Name nvarchar(50) NOT NULL System name of the setting
Value nvarchar(1000) NOT NULL Value of the setting
GroupName nvarchar(50) NULL Name of the group in UI
ParamName nvarchar(1024) NOT NULL Name of the setting in UI
Order int NULL Order of the setting in group
EditorType int NOT NULL 0 - text field1 - checkbox
IsHide bit NOT NULL 1 - mean that the setting is not visible in UI

MetaLocalization

This table stored localized values.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
Key nvarchar(256) NOT NULL Localization key
Lang nvarchar(256) NULL Language code (en, ru etc.)
Value nvarchar(max) NOT NULL Localized value

UploadedFiles

This table contains uploaded files.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
Data varbinary(max) NOT NULL File body
Used bit NOT NULL Obsolete
ObjectId uniqueidentifier NOT NULL Id of the object to which file was attached
Name nvarchar(max) NOT NULL Name of the file
TableName nvarchar(255) NOT NULL Data Model item or View name to which file was attached
CreatedBy nchar(1024) NULL Name of the user which attached the file
CreatedDate datetime NULL Date when the file was uploaded
AttachmentLength ubigint NOT NULL File length in bytes

MetadataEntityVersion

This table contains information about versions of the objects.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
LockVersion timestamp NOT NULL Version for optimistic lock
BaseEntityId uniqueidentifier NOT NULL Id of the entity for which the version was created
VersionNumber bigint NOT NULL Number of the version
DateFrom datetime NOT NULL Date from which the version is valid
DateTo datetime NULL Date to which the version is valid. If Null - mean that version is current
CreatedBy uniqueidentifier NULL Id of the User which created the version
BaseEntityName nvarchar(50) NOT NULL Name of the entity for which the version was created
Changes nvarchar(max) NOT NULL JSON serialized changeset

Workflow Engine .NET tables

Following tables is the part of Workflow Engine .NET. Read documentation about them here.

WorkflowProcessScheme, WorkflowProcessInstance, WorkflowProcessInstancePersistence, WorkflowProcessTransitionHistory, WorkflowProcessTransitionHistory, WorkflowProcessInstanceStatus, WorkflowRuntime, WorkflowScheme, WorkflowInbox.