Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkOutSrcID | int identity | 4 | √ | null |
|
|
Primary key - OutputSource unique identifier for each record |
||||
| fkReportID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to Report table for data relationships |
||||
| fkOutputID | int | 4 | √ | null |
|
|
Output reference - Reference to the output definition |
||||
| outputProcessingFile | varchar | 100 | √ | null |
|
|
File reference - File path or filename for OutputSource document management |
||||
| outputSrcFile | varchar | 100 | √ | null |
|
|
File reference - File path or filename for OutputSource document management |
||||
| Parameters | Unknown | 0 | null |
|
|
Parameters - Parameters required for the data source |
|||||
| SourceId | Unknown | 0 | null |
|
|
Primary key - OutputSource unique identifier for each output source |
|||||
| SourceQuery | Unknown | 0 | null |
|
|
Source query - SQL query or data source for the output |
|||||
| SourceType | Unknown | 0 | null |
|
|
Source type - Type of data source (Query, View, Procedure, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pkOutSrcID | Primary key | Asc | pkOutSrcID |