dbo.OrgRootAssign
Role assignments
TableType TUsage USERDATARows 192SizeMB 0.104
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_OrgRoot | varchar(38) | no | Role class | PKFKUID |
UID_BaseTreeAssign | varchar(38) | no | Role assignment | PKFKUID |
IsAssignmentAllowed | bit(1) | yes | Assignments permitted | |
IsDirectAssignmentAllowed | bit(1) | yes | Direct assignment permitted | |
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 | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL4376 | OrgRootAssign.UID_OrgRoot | OrgRoot.UID_OrgRoot |
Triggers
GEN_T17011DD476CACE9AAF8AF34EB SQL_TRIGGER
GEN_T252FF6C841301AD991606BE24 SQL_TRIGGER
GEN_T3928310CF544E9BBA4CB9CA84 SQL_TRIGGER
GEN_T416D02EAFABA45779404B468B SQL_TRIGGER
GEN_T5E10CEB2978D95B344783D750 SQL_TRIGGER
GEN_T6107C713B5701F687A68D96F3 SQL_TRIGGER
QER_TUOrgRootAssign 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_FTAccountInheritFromOrg_L | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTAccountInheritFromOrg_L | SQL expression dependency | dbo · UID_OrgRoot · OBJECT_OR_COLUMN |
| dbo.QER_FTAccountInheritFromOrg_L | SQL expression dependency | dbo · UID_BaseTreeAssign · OBJECT_OR_COLUMN |
| dbo.QER_FTAccountInheritFromOrg_L | SQL expression dependency | dbo · IsAssignmentAllowed · OBJECT_OR_COLUMN |
| dbo.QER_FTPersonInheritFromOrg_L | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTPersonInheritFromOrg_L | SQL expression dependency | dbo · UID_OrgRoot · OBJECT_OR_COLUMN |
| dbo.QER_FTPersonInheritFromOrg_L | SQL expression dependency | dbo · UID_BaseTreeAssign · OBJECT_OR_COLUMN |
| dbo.QER_FTPersonInheritFromOrg_L | SQL expression dependency | dbo · IsAssignmentAllowed · OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZOrgHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR1D3CE88AB4C56FEAEBF7AE8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR305D4D7F2A38173319EDFC0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR389D46FFC014B447AC47E0B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR3E516DCA36D630E5BE25071 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR4326CD6ECEB74CC4646D7C1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR75C0DD7D4E17073DA543754 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR9D2BCCF9D509C3E513364BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSRD4F6BA16FA9E0E4DD80D9D5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSRE4CC1E1658A2684A403D3C4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSRE62C1B2CE658928ED45F329 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSREC7689917E2868982EC7FF8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSRFEB950B52E302351A52BD6E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZOrgHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PAssignmentCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderMove_bulk | 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_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZOrgHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3D51EED8C2E74137170807CFA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5E10CEB2978D95B344783D750 | 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 |
| OrgRoot | referenced by foreign key from table | QER_RFRL4376: OrgRootAssign.UID_OrgRoot -> OrgRoot.UID_OrgRoot |
| dbo.QER_FTAccountInheritFromOrg_L | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPersonInheritFromOrg_L | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ADS_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZOrgHasADSGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZOrgHasLDAPGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PAssignmentCheckValid | 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_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_PSlotResetOnInvalidRoot_L | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERAssign | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERResource | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERReuse | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERReuseUS | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.RPS_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZOrgHasRPSReport | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasTSBAccountDef | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB1 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB2 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB3 | source text reference | inserts DBQueue tasks, 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 |
| 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-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-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 |