Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each form entry |
|
| fkCustomFormID | int | 4 | null |
|
|
Custom form reference - Links to CustomForms table for the form definition |
||
| FieldValues | nvarchar | 1073741823 | √ | null |
|
|
Field values - JSON or serialized data containing all form field values |
|
| KeyTable | nvarchar | 100 | √ | null |
|
|
Key table name - Name of the table this form entry is related to |
|
| KeyFieldName | nvarchar | 200 | √ | null |
|
|
Key field name - Name of the key field in the related table |
|
| KeyFieldValue | int | 4 | √ | null |
|
|
Key field value - Value of the key field linking to the related record |
|
| IPAddress | nvarchar | 40 | √ | null |
|
|
IP address - IP address of the user who submitted the form |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the form entry was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the entry |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the form entry was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the entry |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| CoreFieldValue | int | 4 | √ | null |
|
|
Core field value - Value of the core field for this entry |
|
| fkSubmissionID | int | 4 | √ | null |
|
|
Submission reference - Links to submission batch or process |
|
| CustomKeyFieldValue | int | 4 | √ | null |
|
|
Custom key value - Custom key field value for additional linking |
|
| IsTemp | bit | 1 | √ | null |
|
|
Temporary flag - Boolean indicating if this is a temporary entry |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CustomFormEntries | Primary key | Asc | ID |
| IX_CustomFormEntries_FkCustomFormID_DeletedDate_CoreFieldValue | Performance | Asc/Asc/Asc | fkCustomFormID + DeletedDate + CoreFieldValue |
| IX_CustomFormEntries_FkSubmissionID | Performance | Asc | fkSubmissionID |
Relationships
Close relationships within degrees of separation
