dbo.DialogGroup
Permissions groups
TableType TUsage CONFIGURATIONRows 123SizeMB 0.104
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogGroup | varchar(38) | no | Permissions group | PKUID |
GroupName | nvarchar(128) | no | Permissions group | |
Description | nvarchar(510) | yes | Description | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
CustomRemarks | nvarchar(510) | yes | Remarks | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
GroupNumber | int(4) | yes | Permissions group sequential number | |
GroupBitPattern | varbinary(200) | yes | Permissions group binary patterns | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsRoleBasedOnly | bit(1) | yes | Only use for role based authentication |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL104 | DialogGroupHasMethod.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL115 | DialogGroupInProductLimited.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL218 | DialogGroupHasSheet.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL23 | DialogUserInGroup.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL24 | DialogTableGroupRight.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL243 | DialogGroupHasFeature.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL258 | DialogGroupCollection.UID_DialogGroupParent | DialogGroup.UID_DialogGroup |
| QBM_RFRL26 | DialogColumnGroupRight.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL339 | DialogGroupInGroup.UID_DialogGroupParent | DialogGroup.UID_DialogGroup |
| QBM_RFRL360 | QBMGroupHasLimitedSQL.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL481 | DialogGroupHasAEDS.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL531 | QBMMissingDisplayRight.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QBM_RFRL609 | QBMGroupHasTree.UID_DialogGroup | DialogGroup.UID_DialogGroup |
| QER_RFRL2561 | BaseTree.UID_DialogGroup | DialogGroup.UID_DialogGroup |
Triggers
GEN_T2F1C1572DF228E75CD84A993E SQL_TRIGGER
GEN_T3F102A114834387237F69BD5E SQL_TRIGGER
GEN_T47DB3E4819AA1EC6493303DA7 SQL_TRIGGER
GEN_T5B6E4C3C082CC1D61CC2222EB SQL_TRIGGER
GEN_T6B3672C24C755A97D0E146856 SQL_TRIGGER
QBM_TDDialogGroup SQL_TRIGGER
QBM_TIDialogGroup SQL_TRIGGER
QBM_TUDialogGroup SQL_TRIGGER
QER_TIDialogGroup SQL_TRIGGER
QER_TUDialogGroup 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.QER_FGIAERoleValidForGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDialogUserInGroupCorrect | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZGroupNumber | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZGroupPattern | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T11BF199F06C60E078B4343CAC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EE418218AF1ECDE940023FBC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25023523AFA916DD1875B69C8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T279BA087A2ED6055CB2A68415 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5B6E4C3C082CC1D61CC2222EB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIDialogUserInGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUDialogGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVCustomInfo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemInfo | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogGroupHasMethod | foreign key references table | QBM_RFRL104: DialogGroupHasMethod.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogGroupInProductLimited | foreign key references table | QBM_RFRL115: DialogGroupInProductLimited.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogGroupHasSheet | foreign key references table | QBM_RFRL218: DialogGroupHasSheet.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogUserInGroup | foreign key references table | QBM_RFRL23: DialogUserInGroup.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogTableGroupRight | foreign key references table | QBM_RFRL24: DialogTableGroupRight.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogGroupHasFeature | foreign key references table | QBM_RFRL243: DialogGroupHasFeature.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogGroupCollection | foreign key references table | QBM_RFRL258: DialogGroupCollection.UID_DialogGroupParent -> DialogGroup.UID_DialogGroup |
| DialogColumnGroupRight | foreign key references table | QBM_RFRL26: DialogColumnGroupRight.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogGroupInGroup | foreign key references table | QBM_RFRL339: DialogGroupInGroup.UID_DialogGroupParent -> DialogGroup.UID_DialogGroup |
| QBMGroupHasLimitedSQL | foreign key references table | QBM_RFRL360: QBMGroupHasLimitedSQL.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| DialogGroupHasAEDS | foreign key references table | QBM_RFRL481: DialogGroupHasAEDS.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| QBMMissingDisplayRight | foreign key references table | QBM_RFRL531: QBMMissingDisplayRight.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| QBMGroupHasTree | foreign key references table | QBM_RFRL609: QBMGroupHasTree.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| BaseTree | foreign key references table | QER_RFRL2561: BaseTree.UID_DialogGroup -> DialogGroup.UID_DialogGroup |
| dbo.QER_FGIAERoleValidForGroup | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_PDialogUserInGroupCorrect | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDynamicUserForPerson | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PUserDetectByGroupList | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZGroupCollection | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZGroupNumber | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZGroupPattern | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUDialogGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIDialogUserInGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUDialogGroup | 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 |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-webinstaller-base-vi-webdesigner-installer-tasks-createupdateusertask.cs | decompiled C# reference | classes CreateUpdateUserTask; methods GenerateUserName, CreateUser, DatabaseHasRequiredGroup, RunInternal, SetAuthString, AuthString; references DialogGroup, DialogUser, DialogUserInGroup; markers reads entity values, writes entity values, references DB/Dialog objects |