CustomFormElement

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
TypeID	int
SubTypeID	int	yes
Title	nvarchar(200)
Label	nvarchar(max)
Description	nvarchar(1000)
Instruction	nvarchar(1000)
Guid	uniqueidentifier
Sequence	int
ParentID	uniqueidentifier	yes
Properties	xml	yes
FieldTypeForValidation	int		Default = 0
DateCreated	datetime	yes
IsComplete	bit	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
OwnerID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CustomFormElement_ParentID_ID_TypeID_SubTypeID_Title	ParentID, ID, TypeID, SubTypeID, Title
PK_CustomFormElement	ID	yes	yes	yes
UK_CustomFormElement_Guid	Guid	yes

Triggers

Trigger Name	Description
TR_CUSTOMFORMELEMENT_DELETE

Referenced by

Referenced by	Field
CustomFormAutoSavedForms	FormGuid
CustomFormDataSource	FormGuid
CustomFormEntry	FormGuid
CUSTOMFORMENTRYDOCUMENT	CUSTOMFORMELEMENTID
CUSTOMFORMFEE	FORMID
CustomFormFolder	CustomFormElementID
CustomFormMappingSchema	FormGuid
CustomFormPaymentSetting	FormGUID
CUSTOMFORMRULEACTION	FORMID
CUSTOMFORMRULEACTION	RULEACTIONFIELDID
CUSTOMFORMRULETARGET	RULETARGETFIELDID
CustomFormSettings	FormGUID
EA7_CustomFormApplicationChecklistSetting	CustomFormID