Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| FileID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each uploaded scan file |
||||
| fkUploadID | int | 4 | √ | null |
|
|
Upload batch reference - Links to the scan upload history record |
||||
| fileNames | varchar | 100 | null |
|
|
File name - Name of the uploaded scan file |
|||||
| PageScanned | int | 4 | √ | null |
|
|
Pages scanned - Number of pages scanned from this file |
||||
| Batch | int | 4 | √ | null |
|
|
Batch number - Batch number for grouping related files |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ScanUploadFile__76F68FE1 | Primary key | Asc | FileID |
Relationships
Close relationships within degrees of separation
