CustomFormEntry
Primary Key
| Primary Key | Field Type |
|---|---|
| EntryID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientUserID | int | yes | ||
| EntryData | xml | |||
| EntryAlias | nvarchar(100) | yes | ||
| EntryState | int | yes | ||
| ID | int | |||
| Printed | bit | Default = 0 | ||
| ClientSitesID | int | yes | Default = '1' | |
| SITEFOLDERSID | int | Default = 0 | ||
| PAYMENTREVIEWED | tinyint | Default = 0 | ||
| CREDITCARDTYPE | nvarchar(100) | yes | ||
| PAYMENTDATE | datetimeoffset | yes | ||
| PAYMENTAMOUNT | money | yes | ||
| CARDHOLDERNAME | nvarchar(255) | yes | ||
| CREDITCARDNUMBER | nvarchar(20) | yes | ||
| PAYMENTMETHOD | nvarchar(100) | yes | ||
| REFERENCENUMBER | nvarchar(100) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| FormGuid | uniqueidentifier | CustomFormElement.Guid |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_CustomFormEntry | EntryID | yes | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_CUSTOMFORMENTRY_INSERT_UPDATE |
Referenced by
| Referenced by | Field |
|---|---|
| CUSTOMFORMDASHBOARDFORMENTRY | CUSTOMFORMENTRYID |
| CustomFormEntryAttribute | EntryID |
| CUSTOMFORMENTRYDOCUMENT | CUSTOMFORMENTRYID |