MPSysUserTableFields

Table Name:	MPSysUserTableFields
View Name:	MARISysUserTableFields
Group:	Group: SysUserTable
Description:	SDK: User-Defined Tables: Field definition

Field	View(engl.field)/Type	Related
TableID	TableID SMALLINT Primary
FieldName	FieldName NVARCHAR (50) Primary
Description	Description NVARCHAR (50)
FieldType	FieldType INT
FieldLength	FieldLength INT
ReadOnly	ReadOnly INT
OrderID	OrderID INT Index
ActionType	ActionType INT
ValidationTyp	ValidationTyp INT
ValidationDefRange1	ValidationDefRange1 INT
ValidationRange1	ValidationRange1 INT
ValidationDefRange2	ValidationDefRange2 INT
ValidationRange2	ValidationRange2 INT
ValidationSQL1	ValidationSQL1 NTEXT
ValidationSQL2	ValidationSQL2 NTEXT
ValidationMessage	ValidationMessage NVARCHAR (255)
LinkTable	LinkTable NVARCHAR (50)
LinkTableField	LinkTableField NVARCHAR (50)
LinkTableCondition	LinkTableCondition NVARCHAR (100)
LinkClassID	LinkClassID INT Index	ClassID
LinkClassIDSource	LinkClassIDSource INT
LinkCompanyField	LinkCompanyField NVARCHAR (100)
LinkCompanyMode	LinkCompanyMode INT
FieldNameEN	FieldNameEN NVARCHAR (50)
FieldNameLangID	FieldNameLangID NVARCHAR (50) Index
FullTextIndexMode	FullTextIndexMode INT
DefaultValue	DefaultValue NVARCHAR (255)

MARIProject Database Structure