Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FormattedReportID | int identity | 4 | √ | null |
|
|
Report layout primary key - Unique identifier for each custom report layout |
|
| NameReport | varchar | 2147483647 | null |
|
|
Report name - Descriptive name for the custom report layout |
||
| ReportID | int | 4 | null |
|
|
Base report reference - Links to the base report template |
||
| Layout | varbinary | 2147483647 | null |
|
|
Layout definition - Binary data containing the custom layout configuration |
||
| CreatedBy | int | 4 | null |
|
|
Created by user - UserID of the person who created this custom layout |
||
| CreatedDate | datetime | 16,3 | null |
|
|
Creation date - Date when this custom layout was created |
||
| EditedBy | int | 4 | √ | null |
|
|
Edited by user - UserID of the person who last edited this layout |
|
| EditedDate | datetime | 16,3 | √ | null |
|
|
Last edit date - Date when this layout was last modified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormattedReports | Primary key | Asc | FormattedReportID |
Relationships
Close relationships within degrees of separation
