Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AccessLevel | Unknown | 0 | null |
|
|
Access level - Required permission level to access this file |
||
| DashboardFileID | Unknown | 0 | null |
|
|
Primary key - DashboardFile unique identifier for each dashboard file |
||
| DashboardID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| DashboardName | varchar | 100 | √ | null |
|
|
Dashboard name - Descriptive name of the dashboard configuration |
|
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Order in which files appear on the dashboard |
||
| XMLString | nvarchar | 1073741823 | √ | null |
|
|
XML configuration - XML string containing the dashboard layout, widgets, and configuration settings |
|
| DashboardDecs | varchar | 500 | √ | null |
|
|
Dashboard description - Detailed description of the dashboard’s purpose and content |
|
| AppsAssigned | varchar | 100 | √ | null |
|
|
Assigned applications - Comma-separated list of application IDs that are assigned to this dashboard |
|
| CreateBy | int | 4 | √ | null |
|
|
Creator reference - Reference to the user who created this dashboard configuration |
|
| DateCreateBy | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when this dashboard was created |
|
| UpdateBy | int | 4 | √ | null |
|
|
Last updater reference - Reference to the user who last modified this dashboard |
|
| DateUpdateBy | datetime | 16,3 | √ | null |
|
|
Last update date - Date and time when this dashboard was last modified |
|
| DataSourceStr | varchar | 100 | √ | null |
|
|
Data source string - Configuration string specifying the data sources used by this dashboard |
|
| DashboardOrder | int | 4 | √ | null |
|
|
Dashboard order - Numeric order for displaying dashboards in lists and navigation menus |
|
| DisplayName | Unknown | 0 | null |
|
|
Display name - User-friendly name shown on the dashboard |
||
| FileName | Unknown | 0 | null |
|
|
File name - Name of the file or document |
||
| FilePath | Unknown | 0 | null |
|
|
File path - Location of the file in the system |
||
| FileType | Unknown | 0 | null |
|
|
File type - Type of file (Document, Report, Image, etc.) |
||
| GetFormId | int | 4 | √ | null |
|
|
Form reference - Reference to a form used for collecting dashboard parameters or filters |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this file is currently displayed on dashboards |
||
| IsTemplate | bit | 1 | √ | null |
|
|
Template flag - Whether this dashboard serves as a template for creating new dashboards |
|
| PublishToId | int | 4 | √ | null |
|
|
Publication target - Reference to the target audience or group for dashboard publication |
|
| PublishBy | int | 4 | √ | null |
|
|
Publisher reference - Reference to the user who published this dashboard |
|
| LayerItemMarketId | int | 4 | √ | null |
|
|
Layer market reference - Reference to market-specific layer configurations for multi-market dashboards |
|
| Type | nvarchar | 20 | √ | null |
|
|
Dashboard type - Type classification of the dashboard (Executive, Operational, Analytical, etc.) |
|
| Settings | nvarchar | 1073741823 | √ | null |
|
|
Dashboard settings - JSON or XML string containing advanced dashboard settings and preferences |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this dashboard was marked as deleted or archived |
|
| ReadOnly | bit | 1 | √ | null |
|
|
Read-only flag - Whether this dashboard is read-only and cannot be modified by users |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DashboardFile | Primary key | Asc | DashboardID |