Form

Following tables represents a storage structure of Form entity.

Form

MetaForm

This table contains main information about Form Item.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
ParentId uniqueidentifier NULL Id of parent form
Name nvarchar(1024) NOT NULL Name of the Form
Caption nvarchar(1024) NOT NULL Name of the Form in UI
IsDeleted bit NOT NULL 1 - mean that record was logically deleted
Source nvarchar(max) NULL Source of the form. It is used in the generation of the form.
IsAvailableForSearch bit NOT NULL 1 - mean that form is indexed by a search engine
SearchWeight int NULL Weight of the form for a search engine
IsAvailableForImportExport bit NOT NULL 1 - mean that Form can be exported to exchange (Excel) format or imported from exchange (Excel) format.

MetaFormBlock

This table contains main information about Form's blocks.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
Name nvarchar(50) NOT NULL Name of the block
MetaFormId uniqueidentifier NOT NULL Reference on a record in MetaForm table
TemplateId uniqueidentifier NULL Reference on MetaFormBlockTemplate table. It is used in the generation of the form
TemplateParams nvarchar(max) NULL Parameters to be replaced at template. It is used in the generation of the form
Source nvarchar(max) NULL Source of the block. It is used in the generation of the form
IsDeleted bit NOT NULL 1 - mean that record was logically deleted
Order int NOT NULL Order of the block on form. It is used in the generation of the form
IsExcludedFromImportExport bit NOT NULL 1 - mean that the Block not exported to exchange (Excel) format or imported from exchange (Excel) format
IsLazyLoad bit NOT NULL 1 - mean that the Block does not load at load form, but can be loaded by request
Code nvarchar(1024) NULL System name of the block

MetaFormBlockTemplate

This table contains main information about Template from which are inherited the Blocks.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
Name nvarchar(50) NOT NULL Name of the Template
Source nvarchar(max) NULL Source of the template. It is used in the generation of the form
Comment nvarchar(max) NULL Description of the template
Params nvarchar(max) NULL Parameters to be replaced at template. It is used in the generation of the form
IsDeleted bit NOT NULL 1 - mean that record was logically deleted

MetaEditFormTemplate

This table contains Razor templates to build an edit form.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
Name nvarchar(50) NOT NULL Name of the Template
Template nvarchar(max) NOT NULL Razor source of the template. It is used in the generation of the form

MetaMenu

This table contains main information about Menu items.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
ParentId uniqueidentifier NULL Id of the parent Menu item.
Name nvarchar(50) NOT NULL Name of Menu item
SortOrder int NOT NULL Order of the Menu item in menu
FormId uniqueidentifier NULL Reference on MetaForm table, not null if Menu item refers to Form
Url nvarchar(max) NULL Not null if Menu item refers to some url
AddParams nvarchar(max) NULL Additional parametrs which added to a GET query string
TypeId int NOT NULL Reference on MetaMenuType table
IsShow bit NOT NULL 1 - mean that the Menu item is show in Menu
IsDeleted bit NOT NULL 1 - mean that record was logically deleted
OpenInNewWindow bit NOT NULL 1- mean that Menu item will be opened in new window
ImageUrl nvarchar(256) NULL Url of the image to show near of the Menu item
Caption nvarchar(256) NULL Name of the Menu item in UI

MetaMenuType

This table contains types of the menu.

Column name Column type Purpose
Id int NOT NULL Primary key
Name nvarchar(50) NOT NULL Name of the Menu type

MetaFormExternalMethod

This table contains binding between Form object and Function.

Column name Column type Purpose
Id uniqueidentifier NOT NULL Primary key
MetaFormId uniqueidentifier NOT NULL Reference on a record in MetaForm table
ExternalMethodId uniqueidentifier NOT NULL Reference on a record in ExternalMethod table
TypeId tinyint NOT NULL Reference on a record in ExternalMethodOpType table10 - Form handler11 - Dispatcher
Params nvarchar(max) NULL Parameters which passed to function as dictionary
Order int NOT NULL It defines the order of execution of functions

Description of ExternalMethod and ExternalMethodOpType tables contained in the Data model section.