Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ReportID | int identity | 4 | √ | null |
|
|
Report primary key - Unique identifier for each report |
||||
| ReportCatName | int | 4 | √ | null |
|
|
Report category name - Category identifier for report classification |
||||
| ReportName | nvarchar | 1073741823 | √ | null |
|
|
Report name - Name of the report |
||||
| ReportDesc | nvarchar | 1073741823 | √ | null |
|
|
Report description - Detailed description of the report purpose and content |
||||
| BillingTypeID | int | 4 | √ | null |
|
|
Billing type reference - Links to billing type for billing-related reports |
||||
| Temp_ID | int | 4 | √ | null |
|
|
Template ID - Reference to report template |
||||
| Type | int | 4 | √ | null |
|
|
Report type - Type of report (Standard, Custom, Dashboard, etc.) |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the report |
||||
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Date when the report was created |
||||
| criteriaStr | varchar | 2147483647 | √ | null |
|
|
Criteria string - Serialized criteria and filter settings for the report |
||||
| int | 4 | √ | null |
|
|
Share level - Sharing level or permissions for the report |
|||||
| DateUpdated | smalldatetime | 16 | √ | (getdate()) |
|
|
Last update date - Date when the report was last updated |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the report |
||||
| htmlStr | text | 2147483647 | √ | null |
|
|
HTML string - HTML formatting and layout definition for the report |
||||
| sqlQuery | text | 2147483647 | √ | null |
|
|
SQL query - SQL query used to generate the report data |
||||
| reportForm | varchar | 1000 | √ | null |
|
|
Report form - Form or template used for report display |
||||
| reportProcName | varchar | 300 | √ | null |
|
|
Report procedure name - Stored procedure name for report generation |
||||
| category | int | 4 | √ | null |
|
|
Category reference - Category classification for the report |
||||
| catType | int | 4 | √ | null |
|
|
Category type - Type of category classification |
||||
| fkreportid | int | 4 | √ | null |
|
|
Parent report reference - Links to parent report for hierarchical reports |
||||
| pageName | varchar | 100 | √ | null |
|
|
Page name - Name of the page where report is displayed |
||||
| Documentation | ntext | 1073741823 | √ | null |
|
|
Report documentation - Documentation and help text for the report |
||||
| GetFormId | int | 4 | √ | (NULL) |
|
|
Get form ID - Reference to form used for data input |
||||
| PublishBy | int | 4 | √ | null |
|
|
Published by user - UserID of the person who published the report |
||||
| PublishToId | int | 4 | √ | (NULL) |
|
|
Publish to ID - Target identifier for report publishing |
||||
| FilterGridReport | nvarchar | 6000 | √ | null |
|
|
Filter grid configuration - Configuration for report filtering grid |
||||
| LayerGridReport | nvarchar | 6000 | √ | null |
|
|
Layer grid configuration - Configuration for report layer grid |
||||
| FormattedReportLayout | varbinary | 2147483647 | √ | null |
|
|
Formatted report layout - Binary data for formatted report layout |
||||
| LayerItemMarketId | int | 4 | √ | null |
|
|
Layer item market ID - Market-specific layer item identifier |
||||
| TypeLoadPage | nvarchar | 1000 | √ | null |
|
|
Type load page - Page type for loading the report |
||||
| UniqueCode | varchar | 50 | √ | null |
|
|
Unique code - Unique code identifier for the report |
||||
| DetailsKeyField | nvarchar | 600 | √ | null |
|
|
Details key field - Key field for report details |
||||
| DetailsReportId | int | 4 | √ | null |
|
|
Details report reference - Links to detailed report |
||||
| TabsConfigurations | nvarchar | 1073741823 | √ | null |
|
|
Tabs configurations - Configuration for report tabs and sections |
||||
| DeleteDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the report was marked as deleted |
||||
| CustomQuery | nvarchar | 1073741823 | √ | null |
|
|
Custom query - Custom SQL query for advanced reporting |
||||
| CustomQueryXML | varchar | 2147483647 | √ | null |
|
|
Custom query XML - XML configuration for custom queries |
||||
| DataSourceID | int | 4 | √ | null |
|
|
Data source reference - Links to data source for report data |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Reports | Primary key | Asc | ReportID |
Relationships
Close relationships within degrees of separation
