Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| docName | varchar | 300 | √ | null |
|
|
Document name - Display name of the document |
|
| fileName | varchar | 100 | √ | null |
|
|
File name - System file name for the stored document |
|
| description | text | 2147483647 | √ | null |
|
|
Document description - Detailed description of the document content |
|
| fileSize | Unknown | 0 | null |
|
|
File size - Size of the document file in bytes |
||
| pkChecklistDocumentID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist document |
|
| fkChecklistFieldValueID | int | 4 | √ | null |
|
|
Field value reference - Links to ChecklistFieldValues for the associated field |
|
| originalFileName | varchar | 300 | √ | null |
|
|
Original filename - Original name of the uploaded file |
|
| contentType | varchar | 300 | √ | null |
|
|
Content type - MIME type of the document (PDF, Word, Image, etc.) |
|
| CreateByCategory | nvarchar | 30 | √ | null |
|
|
Creation category - Category or method used to create the document |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ChecklistDocumentID | Primary key | Asc | pkChecklistDocumentID |
| IX_ChecklistValueID | Performance | Asc | fkChecklistFieldValueID |
Relationships
Close relationships within degrees of separation
