dbo.QBMTree
Menu items of the navigation hierarchy.
TableType TUsage CONFIGURATIONRows 2856SizeMB 4.36
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMTree | varchar(38) | no | Menu item | PKUID |
UID_QBMTreeParent | varchar(38) | yes | Parent menu item | FKUID |
UID_QBMTreeReference | varchar(38) | yes | Menu item link | FKUID |
UID_DialogImage | varchar(38) | yes | Icon | FKUID |
UID_QBMLaunchAction | varchar(38) | yes | Launchpad action | FKUID |
UID_DialogTable | varchar(38) | yes | Table | FKUID |
UID_DialogDashBoardDef | varchar(38) | yes | Statistic | FKUID |
Ident_QBMTree | nvarchar(510) | no | Menu item | |
ActivationFKList | nvarchar(512) | yes | FK object to activate (data node) | |
Caption | nvarchar(510) | yes | Caption | |
ConfigurationFlags | int(4) | yes | Configuration flag | bitmask |
Description | nvarchar(1024) | yes | Description | |
ElementAlignment | nvarchar(64) | yes | Alignment | limited |
ElementColor | nvarchar(32) | yes | Background color | |
GaugeType | nvarchar(32) | yes | Diagram type | limited |
HelpKey | nvarchar(200) | yes | Online help link | |
IsDeactivated | bit(1) | yes | Disabled | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
IsDistinct | bit(1) | yes | Unique | |
IsOverrideColumnDefault | bit(1) | yes | Do not merge columns | |
IsPrivateNode | bit(1) | yes | Show under "My %Globals.QIM_ProductNameShort%" | |
IsRecursion | bit(1) | yes | Recursive calling | |
ItemLimit | int(4) | yes | max. similar elements count | |
InitScript | nvarchar(-1) | yes | Initialization script | |
NodeType | nchar(2) | no | Entry type | limited |
OrderBy | nvarchar(510) | yes | Order by | |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
SortOrder | nvarchar(16) | yes | Sort order | |
StateScript | nvarchar(-1) | yes | Overlay icon definition | |
VarDefinition | nvarchar(-1) | yes | Variable definitions | |
WhereClause | nvarchar(-1) | yes | Condition | |
XObjectKey | varchar(138) | no | Object key | |
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 | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL602 | QBMTree.UID_DialogImage | DialogImage.UID_DialogImage |
| QBM_RFRL603 | QBMTree.UID_QBMLaunchAction | QBMLaunchAction.UID_QBMLaunchAction |
| QBM_RFRL604 | QBMTree.UID_DialogTable | DialogTable.UID_DialogTable |
| QBM_RFRL607 | QBMTreeHasTreeResult.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL610 | QBMGroupHasTree.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL611 | QBMProductHasTree.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL613 | QBMTreeHasSheet.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL617 | QBMProduct.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL622 | QBMTreeHasUIDashBoard.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL624 | QBMTreeHasColumn.UID_QBMTree | QBMTree.UID_QBMTree |
| QBM_RFRL625 | QBMTree.UID_DialogDashBoardDef | DialogDashBoardDef.UID_DialogDashBoardDef |
Triggers
GEN_T15DEEC8A50F75D67B073289CE SQL_TRIGGER
GEN_T2C271D89F1A296AB16D1FC0A3 SQL_TRIGGER
GEN_T3FCB64DD6D73A5B03C2F86DC2 SQL_TRIGGER
GEN_T4277AB5984A6F0AAB59A4CEF2 SQL_TRIGGER
GEN_T511C0F8605EA1F127F66341B0 SQL_TRIGGER
GEN_T66D9921CDD76E444A98E27373 SQL_TRIGGER
QBM_TDAssembly_QBMTree SQL_TRIGGER
QBM_TIAssembly_QBMTree SQL_TRIGGER
QBM_TIQBMTree SQL_TRIGGER
QBM_TUAssembly_QBMTree SQL_TRIGGER
QBM_TUQBMTree 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_ZPrePropDashBoardDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropSheet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropTable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T15DEEC8A50F75D67B073289CE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C271D89F1A296AB16D1FC0A3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3FCB64DD6D73A5B03C2F86DC2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T511C0F8605EA1F127F66341B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogImage | referenced by foreign key from table | QBM_RFRL602: QBMTree.UID_DialogImage -> DialogImage.UID_DialogImage |
| QBMLaunchAction | referenced by foreign key from table | QBM_RFRL603: QBMTree.UID_QBMLaunchAction -> QBMLaunchAction.UID_QBMLaunchAction |
| DialogTable | referenced by foreign key from table | QBM_RFRL604: QBMTree.UID_DialogTable -> DialogTable.UID_DialogTable |
| QBMTreeHasTreeResult | foreign key references table | QBM_RFRL607: QBMTreeHasTreeResult.UID_QBMTree -> QBMTree.UID_QBMTree |
| QBMGroupHasTree | foreign key references table | QBM_RFRL610: QBMGroupHasTree.UID_QBMTree -> QBMTree.UID_QBMTree |
| QBMProductHasTree | foreign key references table | QBM_RFRL611: QBMProductHasTree.UID_QBMTree -> QBMTree.UID_QBMTree |
| QBMTreeHasSheet | foreign key references table | QBM_RFRL613: QBMTreeHasSheet.UID_QBMTree -> QBMTree.UID_QBMTree |
| QBMProduct | foreign key references table | QBM_RFRL617: QBMProduct.UID_QBMTree -> QBMTree.UID_QBMTree |
| QBMTreeHasUIDashBoard | foreign key references table | QBM_RFRL622: QBMTreeHasUIDashBoard.UID_QBMTree -> QBMTree.UID_QBMTree |
| QBMTreeHasColumn | foreign key references table | QBM_RFRL624: QBMTreeHasColumn.UID_QBMTree -> QBMTree.UID_QBMTree |
| DialogDashBoardDef | referenced by foreign key from table | QBM_RFRL625: QBMTree.UID_DialogDashBoardDef -> DialogDashBoardDef.UID_DialogDashBoardDef |
| dbo.QBM_ZPrePropDashBoardDef | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropSheet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropTable | source text reference | creates object-layer jobs via QBM_PJobCreate*, 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 |
| cs-designer-editors-designer-infosheeteditor-infosheeteditor.cs | decompiled C# reference | classes InfoSheetEditor; methods OnDisposeOrPrepareForCaching, ResetLayout, OnLayoutChanged, _InitializeComponent, cbxTable_MouseDoubleClick, cbxObject_MouseDoubleClick; references DialogGroup, DialogImage, DialogObject, DialogObjectHasSheet, DialogSheet, DialogTable; markers reads entity values, writes entity values, references DB/Dialog objects |