Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EntryID | int | 4 | null |
|
|
Entry identifier - Reference to data entry record |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the history record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created the history record |
|
| FormId | Unknown | 0 | null |
|
|
Form reference - Reference to the custom form |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each form history record, auto-incrementing integer |
|
| Notes | Unknown | 0 | null |
|
|
Processing notes - Notes or comments about the form processing |
||
| ProcessedBy | Unknown | 0 | null |
|
|
Processor user ID - Reference to user who processed the submission |
||
| ProcessedDate | Unknown | 0 | null |
|
|
Processing timestamp - When the submission was processed |
||
| ProcessingStatus | Unknown | 0 | null |
|
|
Processing status - Current processing status of the form submission |
||
| SubmissionData | Unknown | 0 | null |
|
|
Submission data - Serialized form data as submitted |
||
| SubmissionDate | Unknown | 0 | null |
|
|
Submission timestamp - When the form was submitted |
||
| SubmissionId | Unknown | 0 | null |
|
|
Submission reference - Reference to the form submission |
||
| SubmittedBy | Unknown | 0 | null |
|
|
Submitter user ID - Reference to user who submitted the form |
||
| Values | nvarchar | 1073741823 | √ | null |
|
|
Form values - Serialized form field values at time of history |
|
| Type | varchar | 20 | ('Web') |
|
|
History type - Type of history record (Submission, Update, Processing) |
||
| VersionNumber | Unknown | 0 | null |
|
|
Version number - Version number of the form at time of submission |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormHistories | Primary key | Asc | ID |