Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkChecklistDocumentID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each document attachment, auto-incrementing integer |
|
| fkChecklistFieldValueID | int | 4 | √ | null |
|
|
Field value reference - Foreign key linking to ChecklistFieldValues for the checklist item this document supports |
|
| docName | varchar | 300 | √ | null |
|
|
Document name - Display name of the attached document for user identification |
|
| fileName | varchar | 100 | √ | null |
|
|
File name - Physical file name of the stored document |
|
| description | text | 2147483647 | √ | null |
|
|
Document description - Detailed description of the document content and purpose |
|
| originalFileName | varchar | 300 | √ | null |
|
|
Original file name - Original name of the file as uploaded by the user |
|
| contentType | varchar | 300 | √ | null |
|
|
MIME type - Content type of the file for proper handling and display |
|
| CreateByCategory | nvarchar | 30 | √ | null |
|
|
Creation category - Category or context under which this document was created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ChecklistDocumentID | Primary key | Asc | pkChecklistDocumentID |