Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| LTReportID | INT | 10 | 0 |
|
|
|||||
| ReportName | VARCHAR | 100 | null |
|
|
|||||
| ReportCategory | VARCHAR | 50 | √ | null |
|
|
||||
| ReportPublishDate | DATETIME | 19 | null |
|
|
|||||
| ReportPublishUser | VARCHAR | 15 | √ |
|
|
|||||
| ReportUpdateDate | DATETIME | 19 | null |
|
|
|||||
| ReportUpdateUser | VARCHAR | 15 | √ |
|
|
|||||
| ReportDescription | TEXT | 65535 | √ | null |
|
|
||||
| ReportIsSubreport | BIT | 1 | 0 |
|
|
|||||
| ReportInstanceGUID | CHAR | 36 | null |
|
|
|||||
| ReportTemplateGUID | VARCHAR | 36 | √ | null |
|
|
||||
| ReportTemplateName | VARCHAR | 150 | √ | null |
|
|
||||
| ReportFlagTypesEnabled | VARCHAR | 83 | √ | null |
|
|
||||
| ReportTemplatePublishedVersion | VARCHAR | 50 |
|
|
||||||
| ReportTemplateLatestVersion | VARCHAR | 61 |
|
|
||||||
| ReportStatus | VARCHAR | 17 |
|
|
Relationships
Close relationships within degrees of separation
