Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each widget |
|
| Name | nvarchar | 400 | √ | null |
|
|
Widget name - Display name of the widget |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Widget description - Detailed description of the widget’s purpose and functionality |
|
| Type | nvarchar | 20 | √ | null |
|
|
Widget type - Type of widget (Chart, Report, List, Custom, etc.) |
|
| SourceName | nvarchar | 1000 | √ | null |
|
|
Data source name - Name of the data source or query that feeds the widget |
|
| SourceID | nvarchar | 100 | √ | null |
|
|
Data source identifier - Identifier for the specific data source |
|
| Settings | nvarchar | 1073741823 | √ | null |
|
|
Widget settings - JSON or XML configuration settings for the widget |
|
| ParentID | nvarchar | 100 | √ | null |
|
|
Parent widget identifier - Links to parent widget for nested or grouped widgets |
|
| ContentStr | nvarchar | 1073741823 | √ | null |
|
|
Widget content - Static content or template for the widget |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the widget |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the widget was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the widget |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date and time when the widget was last updated |
|
| IndexNumber | int | 4 | √ | null |
|
|
Display order - Order in which widgets are displayed on the dashboard |
|
| DraftID | nvarchar | 100 | √ | null |
|
|
Draft identifier - Identifier for draft versions of the widget |
|
| ParentType | nvarchar | 20 | √ | null |
|
|
Parent type - Type of parent container (Dashboard, Tab, Panel, etc.) |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the widget was soft-deleted |
|
| TurnedOn | bit | 1 | √ | null |
|
|
Active status - Flag indicating if the widget is currently active and visible |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Widgets | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
