Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
History primary key - Unique identifier for each form history record |
|
| Values | nvarchar | 1073741823 | √ | null |
|
|
Form values - JSON or XML snapshot of form data values at time of submission |
|
| EntryID | int | 4 | null |
|
|
Entry reference - Links to the form entry that was modified |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when this history record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who made the form changes |
|
| Type | varchar | 20 | ('Web') |
|
|
Submission type - Type of form submission or modification (Web, Mobile, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormHistories | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
