dbo.DialogDashBoardDef
Statistics definitions
TableType TUsage CONFIGURATIONRows 284SizeMB 0.816
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogDashBoardDef | varchar(38) | no | Statistics definition | PKUID |
UID_DialogSchedule | varchar(38) | yes | Calculation schedule | FKUID |
Ident_DialogDashboardDef | nvarchar(256) | yes | Statistic | |
DisplayName | nvarchar(510) | yes | Display name | |
QueryDefinition | nvarchar(-1) | yes | Measurements query | |
QueryDefinition100 | nvarchar(-1) | yes | Base measurements query | |
GreenLimit | float(8) | yes | Threshold green | |
RedLimit | float(8) | yes | Threshold red | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
IsInActive | bit(1) | yes | Disabled | |
Description | nvarchar(2048) | yes | Description | |
DisplayUnit | nvarchar(64) | yes | Unit of measure | |
HistoryLength | int(4) | yes | Measurement runs to archive | |
TimeScaleUnit | nvarchar(32) | yes | Time scale | limited |
AccessWhereClause | nvarchar(-1) | yes | Condition | |
AggregateFunction | nvarchar(32) | yes | Aggregate function | limited |
AggregateFunction100 | nvarchar(32) | yes | Base aggregate function | limited |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
IsAdHoc | bit(1) | yes | Instant calculation | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsManual | bit(1) | yes | Imported statistic data | |
DashBoardType | nvarchar(64) | yes | Type of statistic definition | limited |
Relations
| FK | From | To |
|---|---|---|
| POL_RFRL2701 | QERPolicy.UID_DialogDashBoardDef | DialogDashBoardDef.UID_DialogDashBoardDef |
| QBM_RFRL277 | DialogDashBoardContent.UID_DialogDashBoardDef | DialogDashBoardDef.UID_DialogDashBoardDef |
| QBM_RFRL282 | DialogDashBoardDef.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| QBM_RFRL620 | QBMUIDashBoard.UID_DialogDashBoardDef | DialogDashBoardDef.UID_DialogDashBoardDef |
| QBM_RFRL625 | QBMTree.UID_DialogDashBoardDef | DialogDashBoardDef.UID_DialogDashBoardDef |
Triggers
GEN_T2A4C08D7CE36785E0F0AD21B6 SQL_TRIGGER
GEN_T45B973B22E443E311DC624F95 SQL_TRIGGER
GEN_T52B623E98B77D7EEC159471C3 SQL_TRIGGER
GEN_T60BB61717FF0BA588E7CAFCFE SQL_TRIGGER
QBM_TDDialogDashBoardDef SQL_TRIGGER
QBM_TIDialogDashBoardDef SQL_TRIGGER
QBM_TUDialogDashBoardDef SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_PDashBoardDefine | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZDashBoardContentCalculate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropDashBoardDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZScheduleStartDashBoard | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T52B623E98B77D7EEC159471C3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogDashBoardDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA01F94D607195A9A87B68BCE6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA069870B4274AFAC6017F1169 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA2B98AF76AF01B756256DF4E9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA539E50D2BBE45F0D35A7B5A4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA878CB920EF45EDB8005B70C7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA9F1EDF45283C99A1678704A1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB89D1AB23CE5F463104A7FBF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAC4081D6E69EBB3BF8B9811D1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD556A200D3339BEBE96BA827 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADFA5C21800A24F742D79294A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAEA19C74B75C865167B4EE0A2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAF4D1C28435E831D612FA45F2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAF942AF99824DA4074F421EA5 | SQL expression dependency | OBJECT_OR_COLUMN |
| QERPolicy | foreign key references table | POL_RFRL2701: QERPolicy.UID_DialogDashBoardDef -> DialogDashBoardDef.UID_DialogDashBoardDef |
| DialogDashBoardContent | foreign key references table | QBM_RFRL277: DialogDashBoardContent.UID_DialogDashBoardDef -> DialogDashBoardDef.UID_DialogDashBoardDef |
| DialogSchedule | referenced by foreign key from table | QBM_RFRL282: DialogDashBoardDef.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| QBMUIDashBoard | foreign key references table | QBM_RFRL620: QBMUIDashBoard.UID_DialogDashBoardDef -> DialogDashBoardDef.UID_DialogDashBoardDef |
| QBMTree | foreign key references table | QBM_RFRL625: QBMTree.UID_DialogDashBoardDef -> DialogDashBoardDef.UID_DialogDashBoardDef |
| dbo.QBM_PDashBoardDefine | source text reference | has TRY/CATCH error handling |
| dbo.QBM_ZDashBoardContentCalculate | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropDashBoardDef | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZScheduleStartDashBoard | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_TUDialogDashBoardDef | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-common-customizer-vi-common-customizer-dialogdashboarddef.cs | decompiled C# reference | classes DialogDashboardDef, _003C_003Ec__DisplayClass1_0, _003C_003Ec__DisplayClass1_1; methods _003C_CheckQueryDefinitionAsync_003Eb__3, MoveNext, SetStateMachine, _CheckQueryDefinitionAsync, _CheckAccessWhereClauseAsync; references DialogDashBoardContent, DialogDashboardDef; markers references DB/Dialog objects |
| cs-common-customizer-vi-common-customizer-dialogtree.cs | decompiled C# reference | classes DialogTree, _003C_003Ec__DisplayClass4_0; methods _003C_SetIsDeactivatedRecursive_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _SetIsDeactivatedRecursive; references DialogDashboardDef, DialogImage, DialogObject, DialogTable, QBMLaunchAction; markers reads entity values, references DB/Dialog objects |
| cs-designer-editors-designer-collectioneditor-dialogdashboarddefeditor.cs | decompiled C# reference | classes DialogDashBoardDefEditor; methods OnDisposeOrPrepareForCaching, InitializeComponent, ControllerDocumentChanged, ControllerDocumentSaving, Activator_Changed, _InitializeComponent; references DialogDashboardDef, DialogSchedule; markers writes entity values, references DB/Dialog objects |
| cs-designer-editors-designer-collectioneditor-dialogscheduleeditor.cs | decompiled C# reference | classes DialogScheduleEditor; methods OnDisposeOrPrepareForCaching, InitializeComponent, SaveEditorObject, ControllerDocumentSaving, ControllerDocumentChanged, ControllerDocumentSaved; references DialogDashboardDef, DialogSchedule; markers references DB/Dialog objects |
| cs-pol-forms-pol-forms-formqerpolicymasterdata.cs | decompiled C# reference | classes FormQERPolicyMasterData; methods OnInit, InitializeComponent, OnFormSizeChanged, OnFormLoad, OnFormUnload, _DisconnectUIEngineUserSettings; references AERole, DialogDashboardDef, DialogReport, DialogRichMail, DialogSchedule, DialogTable; markers reads entity values, references DB/Dialog objects |