dbo.BaseTreeAssign
Role assignments
TableType TUsage CONFIGURATIONRows 18SizeMB 0.072
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_BaseTreeAssign | varchar(38) | no | Role assignment | PKUID |
UID_TaskHardware | varchar(38) | yes | Recalculation task (devices) | FKUID |
UID_TaskWorkDesk | varchar(38) | yes | Recalculation task (WorkDesk) | FKUID |
UID_TaskPerson | varchar(38) | yes | Recalculation task (Identity) | FKUID |
UID_TaskBaseTree | varchar(38) | yes | Recalculation task (BaseTree) | FKUID |
UID_DialogTableElement | varchar(38) | yes | Assignable objects (table) | FKUID |
IsITShopEnabled | bit(1) | yes | IT Shop | |
IsEsetEnabled | bit(1) | yes | System role | |
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 | |
UID_DialogTableMN | varchar(38) | yes | Many-to-many table | FKUID |
DelegationType | int(4) | yes | Delegation | limited |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsReusePossible | bit(1) | yes | Multi request possible | |
IsReusePossibleUS | bit(1) | yes | Multi requestable/unsubscribable | |
DisplayNameElement | nvarchar(128) | yes | Assignable objects (display name) | |
DisplayNameMN | nvarchar(128) | yes | Many-to-many table (display name) |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL4369 | BaseTreeAssign.UID_DialogTableElement | DialogTable.UID_DialogTable |
| QER_RFRL4370 | BaseTreeAssign.UID_DialogTableMN | DialogTable.UID_DialogTable |
| QER_RFRL4375 | BaseTreeAssign.UID_TaskHardware | QBMDBQueueTask.UID_Task |
Triggers
GEN_T1C03DC4A9DCC31F0518BCDA5C SQL_TRIGGER
GEN_T2B3CD51ADE946530F098BB7CC SQL_TRIGGER
GEN_T3D51EED8C2E74137170807CFA SQL_TRIGGER
GEN_T5CFB42680E5359810E8040BC2 SQL_TRIGGER
QER_TIBaseTreeAssign 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_FTPWOOrderPerson_000 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_001 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_010 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_011 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_100 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_101 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_110 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_111 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPwoValidDateRangesExist | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PIsForITShopFlagCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopBoardPrepareDelete | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderMove_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopPersonHasObjFill_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopProductNodeCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopProductNodeCreate_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopProductNodeMove | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_POrgRootAssignFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckWaiting | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T17011DD476CACE9AAF8AF34EB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T252FF6C841301AD991606BE24 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T39FC96DBDDABBD03234E9F00E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CFB42680E5359810E8040BC2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIDynamicGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUDynamicGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUOrgRootAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TIBaseTreeHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TIESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TIPersonHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TIWorkDeskHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUBaseTreeHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUPersonHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUWorkDeskHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VITShopOrderAssignment | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · UID_DialogTableElement · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · IsReusePossible · OBJECT_OR_COLUMN |
| DialogTable | referenced by foreign key from table | QER_RFRL4369: BaseTreeAssign.UID_DialogTableElement -> DialogTable.UID_DialogTable |
| DialogTable | referenced by foreign key from table | QER_RFRL4370: BaseTreeAssign.UID_DialogTableMN -> DialogTable.UID_DialogTable |
| QBMDBQueueTask | referenced by foreign key from table | QER_RFRL4375: BaseTreeAssign.UID_TaskHardware -> QBMDBQueueTask.UID_Task |
| dbo.QER_FTPWOOrderPerson_000 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_001 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_010 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_011 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_100 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_101 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_110 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_111 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIPwoValidDateRangesExist | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_PIsForITShopFlagCheck | source text reference | has TRY/CATCH error handling |
| dbo.QER_PITShopBoardPrepareDelete | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopOrderMove_bulk | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopPersonHasObjFill_b | source text reference | has TRY/CATCH error handling |
| dbo.QER_PITShopProductNodeCheck | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopProductNodeCreate_b | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopProductNodeMove | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_POrgRootAssignFill | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZITShopCheckValid | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopCheckWaiting | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_TIDynamicGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUDynamicGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUOrgRootAssign | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TIBaseTreeHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TIESetHasEntitlement | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TIPersonHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TIWorkDeskHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUBaseTreeHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUESetHasEntitlement | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUPersonHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUWorkDeskHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-dynamicgroup.cs | decompiled C# reference | classes DynamicGroup, _003C_003Ec__DisplayClass2_0; methods _003C_CheckObjectKeyBaseTree_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _CheckObjectKeyBaseTree, CheckWhereClause; references BasetreeAssign, DialogTable, DynamicGroup, OrgRoot, OrgRootAssign; markers reads entity values, references DB/Dialog objects |
| cs-qer-customizer-qer-customizer-itshophelperasync.cs | decompiled C# reference | classes ITShopHelperAsync, _003C_003Ec__DisplayClass14_0, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods _003C_CheckIsGroupAccount_003Eb__0, _003CHandlePersonHasAccountDef_003Eb__0, _003CGetValidAccountDef_003Eb__0, MoveNext, SetStateMachine, CreateAccountITShopOrder; references AccProduct, BasetreeAssign, BaseTreeHasObject, Delegation, DialogTable, ITShopOrg; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-orgbaseentitylogic.cs | decompiled C# reference | classes OrgBaseEntityLogic; methods MoveNext, SetStateMachine, ValidParentCheck, _CanAssign; references BasetreeAssign, DialogTable, OrgRoot, OrgRootAssign; markers reads entity values, references DB/Dialog objects |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-forms-qer-forms-formdynamicgroupmasterdata.cs | decompiled C# reference | classes FormDynamicGroupMasterData; methods OnInit, OnDispose, OnDesignChanged, OnResetForm, OnFormSizeChanged, OnFormLoad; references BasetreeAssign, DialogColumn, DialogSchedule, DialogTable, DynamicGroup, DynamicGroupHasImmediateColumn; markers reads entity values, references DB/Dialog objects |