Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| checksum | Unknown | 0 | null |
|
|
File checksum - Checksum for file integrity verification |
|||||
| docID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each document |
||||
| fkTrackingFieldValueID | int | 4 | √ | null |
|
|
Tracking field reference - Links to TrackingFieldValues for document tracking |
||||
| docName | varchar | 300 | √ | null |
|
|
Document name - Name or title of the document |
||||
| fileName | varchar | 100 | √ | null |
|
|
File name - Original file name of the uploaded document |
||||
| description | text | 2147483647 | √ | null |
|
|
Document description - Detailed description of the document content |
||||
| uploadDate | datetime | 16,3 | √ | null |
|
|
Upload date - Date when the document was uploaded |
||||
| contentType | varchar | 300 | √ | null |
|
|
Content type - MIME type of the uploaded file |
||||
| DeletedDate | smalldatetime | 16 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted the document |
||||
| filePath | Unknown | 0 | null |
|
|
File path - Physical or network path to the stored document |
|||||
| fileSize | Unknown | 0 | null |
|
|
File size - Size of the document file in bytes |
|||||
| isActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if the document is currently active |
|||||
| uploadedBy | int | 4 | √ | null |
|
|
Uploaded by user - UserID of the person who uploaded the document |
||||
| originalFileName | varchar | 300 | √ | null |
|
|
Original file name - Original name of the file before upload |
||||
| fkCategoryID | int | 4 | √ | null |
|
|
Category reference - Links to document category for organization |
||||
| uploadedDate | Unknown | 0 | null |
|
|
Upload date - Date when the document was uploaded |
|||||
| version | Unknown | 0 | null |
|
|
Document version - Version number for document revision tracking |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_documents | Primary key | Asc | docID |
Relationships
Close relationships within degrees of separation
