Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each document history record, auto-incrementing integer |
|
| SubmissionID | int | 4 | null |
|
|
Submission reference - Reference to the submission or form instance this document version belongs to (required field) |
||
| FileName | nvarchar | 510 | null |
|
|
Document file name - Name of the document file for this version (required field) |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this document version was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this document version |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this document version was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to this document version |
|
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this document version was logically deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_WordFormHistories | Primary key | Asc | ID |