Primary Key Field Type
 ID int

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

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

Index Name Field(s) Unique Primary Clustered
 IX_CustomFormElement_ParentID_ID_TypeID_SubTypeID_Title ParentID, ID, TypeID, SubTypeID, Title      
 PK_CustomFormElement ID
 UK_CustomFormElement_Guid Guid    

Trigger Name Description
 TR_CUSTOMFORMELEMENT_DELETE

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

Entity-Relationship diagram of this table