Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each widget, auto-incrementing integer |
|
| Name | nvarchar | 400 | √ | null |
|
|
Widget name - Display name of the widget for user interface and administration |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Widget description - Detailed description of widget functionality and purpose |
|
| Type | nvarchar | 20 | √ | null |
|
|
Widget type - Classification of widget type (e.g., Chart, Report, List, Custom) for rendering |
|
| SourceName | nvarchar | 1000 | √ | null |
|
|
Data source name - Name of the data source or query that provides data for this widget |
|
| SourceID | nvarchar | 100 | √ | null |
|
|
Data source identifier - Unique identifier for the data source used by this widget |
|
| Settings | nvarchar | 1073741823 | √ | null |
|
|
Widget configuration - JSON or structured configuration data defining widget behavior and appearance |
|
| ParentID | nvarchar | 100 | √ | null |
|
|
Parent widget - Reference to parent widget for hierarchical widget organization |
|
| ContentStr | nvarchar | 1073741823 | √ | null |
|
|
Widget content - Static content or template for widgets that display fixed content |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this widget |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this widget was first created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to this widget |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this widget was most recently updated |
|
| IndexNumber | int | 4 | √ | null |
|
|
Display index - Numeric index for ordering widgets in dashboard layouts |
|
| DraftID | nvarchar | 100 | √ | null |
|
|
Draft identifier - Reference to draft version for widgets under development |
|
| ParentType | nvarchar | 20 | √ | null |
|
|
Parent type - Type classification of the parent entity containing this widget |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this widget was logically deleted |
|
| TurnedOn | bit | 1 | √ | null |
|
|
Active status - Boolean indicating if this widget is currently active and displayed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Widgets | Primary key | Asc | ID |