Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each document history record |
|
| SubmissionID | int | 4 | null |
|
|
Submission reference - Links to the form submission that generated this document |
||
| FileName | nvarchar | 510 | null |
|
|
File name - Name of the Word document file |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the document was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the document |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date and time when the document was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the document |
|
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the document was soft-deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_WordFormHistories | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
