| 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 | |
| Referenced by | Field |
|---|---|
 CustomFormAutoSavedForms |
FormGuid |
| CustomFormDataSource |
FormGuid |
| CustomFormEntry |
FormGuid |
| CUSTOMFORMENTRYDOCUMENT |
CUSTOMFORMELEMENTID |
| CustomFormFolder |
CustomFormElementID |
| CustomFormMappingSchema |
FormGuid |
| CustomFormPaymentSetting |
FormGUID |
| CustomFormSettings |
FormGUID |
| EA7_CustomFormApplicationChecklistSetting |
CustomFormID |