Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DashboardID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each dashboard |
|
| DashboardName | varchar | 100 | √ | null |
|
|
Dashboard name - Name of the dashboard |
|
| XMLString | nvarchar | 1073741823 | √ | null |
|
|
XML configuration - XML string defining dashboard layout and components |
|
| DashboardDecs | varchar | 500 | √ | null |
|
|
Dashboard description - Description of the dashboard purpose and content |
|
| AppsAssigned | varchar | 100 | √ | null |
|
|
Assigned applications - Applications that have access to this dashboard |
|
| CreateBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the dashboard |
|
| DateCreateBy | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the dashboard was created |
|
| UpdateBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the dashboard |
|
| DateUpdateBy | datetime | 16,3 | √ | null |
|
|
Update date - Date when the dashboard was last updated |
|
| DataSourceStr | varchar | 100 | √ | null |
|
|
Data source string - Data source connection or configuration string |
|
| DashboardOrder | int | 4 | √ | null |
|
|
Display order - Order in which dashboard appears in lists |
|
| IsTemplate | bit | 1 | √ | null |
|
|
Template flag - Boolean indicating if this is a template dashboard |
|
| GetFormId | int | 4 | √ | null |
|
|
Form reference - Links to form associated with this dashboard |
|
| PublishBy | int | 4 | √ | null |
|
|
Published by user - UserID of the person who published the dashboard |
|
| PublishToId | int | 4 | √ | null |
|
|
Publish target - Target identifier for dashboard publishing |
|
| LayerItemMarketId | int | 4 | √ | null |
|
|
Layer item market ID - Market identifier for layered dashboard items |
|
| Settings | nvarchar | 1073741823 | √ | null |
|
|
Dashboard settings - JSON or serialized dashboard configuration settings |
|
| Type | nvarchar | 20 | √ | null |
|
|
Dashboard type - Type or category of the dashboard |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| ReadOnly | bit | 1 | √ | null |
|
|
Read-only flag - Boolean indicating if dashboard is read-only |
|
| ShowCaseTab | bit | 1 | √ | null |
|
|
Show case tab - Boolean controlling case tab visibility |
|
| ShowCaseListing | bit | 1 | √ | null |
|
|
Show case listing - Boolean controlling case listing visibility |
|
| ShowDefaultCaseForm | bit | 1 | √ | null |
|
|
Show default case form - Boolean controlling default case form visibility |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DashboardFile | Primary key | Asc | DashboardID |
Relationships
Close relationships within degrees of separation
