Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkPageID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each page configuration |
|
| PageName | nvarchar | 400 | √ | null |
|
|
Page name - Descriptive name for the report page |
|
| PageDesc | nvarchar | 1000 | √ | null |
|
|
Page description - Detailed description of the page purpose and content |
|
| fkDataSourceID | int | 4 | √ | null |
|
|
Data source reference - Links to the data source used for this page |
|
| fkPageOutputID | int | 4 | √ | null |
|
|
Page output reference - Links to the output configuration for this page |
|
| CriteriaStr | nvarchar | 1000 | √ | null |
|
|
Criteria string - SQL or filter criteria for data selection on this page |
|
| Draft | bit | 1 | √ | null |
|
|
Draft flag - Boolean indicator whether this page configuration is in draft status |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Pages__495CDAF257CE5803 | Primary key | Asc | pkPageID |
Relationships
Close relationships within degrees of separation
