dbo.QBMTreeResult
Result lists of menu items in the navigation hierarchy.
TableType TUsage CONFIGURATIONRows 639SizeMB 0.6
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMTreeResult | varchar(38) | no | Result list | PKUID |
UID_DialogImage | varchar(38) | yes | Icon | FKUID |
UID_DialogObject | varchar(38) | yes | Object | FKUID |
Ident_QBMTreeResult | nvarchar(510) | no | Result list | |
ActivationFKList | nvarchar(512) | yes | FK object to activate (list) | |
CanInsert | bit(1) | yes | Insertion in list permitted | |
CanDelete | bit(1) | yes | Deletion from list permitted | |
Caption | nvarchar(256) | yes | List header | |
ConfigurationFlags | int(4) | yes | Configuration flag | bitmask |
Description | nvarchar(1024) | yes | Description | |
InsertValuesScript | nvarchar(-1) | yes | Insert values | |
IsDeactivated | bit(1) | yes | Disabled | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
IsOverrideColumnDefault | bit(1) | yes | Do not merge columns | |
ItemDisplayPattern | nvarchar(510) | yes | Display template | |
ItemLimit | int(4) | yes | max. elements | |
OrderBy | nvarchar(510) | yes | Order by | |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
SortOrder | nvarchar(16) | yes | Sort order | |
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_RFRL605 | QBMTreeResult.UID_DialogImage | DialogImage.UID_DialogImage |
| QBM_RFRL606 | QBMTreeResult.UID_DialogObject | DialogObject.UID_DialogObject |
| QBM_RFRL608 | QBMTreeHasTreeResult.UID_QBMTreeResult | QBMTreeResult.UID_QBMTreeResult |
| QBM_RFRL615 | QBMTreeResultHasSheet.UID_QBMTreeResult | QBMTreeResult.UID_QBMTreeResult |
| QBM_RFRL618 | QBMTreeResultHasColumn.UID_QBMTreeResult | QBMTreeResult.UID_QBMTreeResult |
Triggers
GEN_T28D55C8F598BD8572BAAB87FA SQL_TRIGGER
GEN_T42C8560982DD023110E519160 SQL_TRIGGER
GEN_T5A8F133823DC6301A46D0D639 SQL_TRIGGER
GEN_T6345A59BE7294D5DD5F6AB7A3 SQL_TRIGGER
QBM_TDAssembly_QBMTreeResult SQL_TRIGGER
QBM_TIAssembly_QBMTreeResult SQL_TRIGGER
QBM_TIQBMTreeResult SQL_TRIGGER
QBM_TUAssembly_QBMTreeResult SQL_TRIGGER
QBM_TUQBMTreeResult 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_ZPrePropObject | 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.QBM_ZPrePropTreeResult | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5A8F133823DC6301A46D0D639 | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogImage | referenced by foreign key from table | QBM_RFRL605: QBMTreeResult.UID_DialogImage -> DialogImage.UID_DialogImage |
| DialogObject | referenced by foreign key from table | QBM_RFRL606: QBMTreeResult.UID_DialogObject -> DialogObject.UID_DialogObject |
| QBMTreeHasTreeResult | foreign key references table | QBM_RFRL608: QBMTreeHasTreeResult.UID_QBMTreeResult -> QBMTreeResult.UID_QBMTreeResult |
| QBMTreeResultHasSheet | foreign key references table | QBM_RFRL615: QBMTreeResultHasSheet.UID_QBMTreeResult -> QBMTreeResult.UID_QBMTreeResult |
| QBMTreeResultHasColumn | foreign key references table | QBM_RFRL618: QBMTreeResultHasColumn.UID_QBMTreeResult -> QBMTreeResult.UID_QBMTreeResult |
| dbo.QBM_ZPrePropObject | 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 |
| dbo.QBM_ZPrePropTreeResult | 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 |