Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkOutputLogID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each output log entry |
|
| fkReportID | int | 4 | √ | null |
|
|
Report reference - Links to the report that was generated |
|
| Type | int | 4 | √ | null |
|
|
Output type - Numeric classification of the output type (e.g., PDF, Excel, Print) |
|
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation timestamp - Date and time when the report output was generated |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who generated the report |
|
| NumOfPages | int | 4 | √ | null |
|
|
Page count - Number of pages in the generated report output |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_OutputLog | Primary key | Asc | pkOutputLogID |
Relationships
Close relationships within degrees of separation
