Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DashboardID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each dashboard configuration, auto-incrementing integer |
|
| DashboardName | varchar | 100 | √ | null |
|
|
Dashboard name - Display name of the dashboard for user identification and navigation |
|
| XMLString | nvarchar | 1073741823 | √ | null |
|
|
Dashboard layout XML - XML configuration defining dashboard layout, widgets, and visual arrangement |
|
| DashboardDecs | varchar | 500 | √ | null |
|
|
Dashboard description - Detailed description of dashboard purpose and content |
|
| AppsAssigned | varchar | 100 | √ | null |
|
|
Assigned applications - List of applications this dashboard is associated with |
|
| CreateBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this dashboard |
|
| DateCreateBy | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this dashboard was first created |
|
| UpdateBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to this dashboard |
|
| DateUpdateBy | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this dashboard was most recently updated |
|
| DataSourceStr | varchar | 100 | √ | null |
|
|
Data source identifier - Identifier for the primary data source used by this dashboard |
|
| DashboardOrder | int | 4 | √ | null |
|
|
Display order - Numeric order for sorting dashboards in user interface |
|
| IsTemplate | bit | 1 | √ | null |
|
|
Template flag - Boolean indicating if this dashboard serves as a template for creating new dashboards |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this dashboard was logically deleted |
|
| GetFormId | int | 4 | √ | null |
|
|
Associated form - Reference to form associated with this dashboard |
|
| LayerItemMarketId | int | 4 | √ | null |
|
|
Market layer reference - Reference to market or layer context for multi-tenant dashboard management |
|
| PublishBy | int | 4 | √ | null |
|
|
Publisher user - User ID who published this dashboard |
|
| PublishToId | int | 4 | √ | null |
|
|
Publication target - Reference to entity or user this dashboard is published to |
|
| Settings | nvarchar | 1073741823 | √ | null |
|
|
Dashboard settings - JSON or structured configuration for dashboard behavior and appearance |
|
| Type | nvarchar | 20 | √ | null |
|
|
Dashboard type - Classification of dashboard type (e.g., Executive, Operational, Analytical) |
|
| ReadOnly | bit | 1 | √ | null |
|
|
Read-only flag - Boolean indicating if dashboard is read-only and cannot be modified by users |
|
| ShowCaseTab | bit | 1 | √ | null |
|
|
Case tab visibility - Boolean controlling whether case-related tab is displayed |
|
| ShowCaseListing | bit | 1 | √ | null |
|
|
Case listing visibility - Boolean controlling whether case listing is displayed |
|
| ShowDefaultCaseForm | bit | 1 | √ | null |
|
|
Default case form visibility - Boolean controlling whether default case form is displayed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DashboardFile | Primary key | Asc | DashboardID |