dbo.OrgType
Role types
TableType TUsage USERDATARows 1SizeMB 0.024
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_OrgType | varchar(38) | no | Role type | PKUID |
Ident_OrgType | nvarchar(128) | no | Role type | |
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 | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsPersonAssignOnce | bit(1) | yes | No multiple assignment of identities |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL3397 | BaseTree.UID_OrgType | OrgType.UID_OrgType |
| QER_RFRL779 | OrgRoot.UID_OrgType | OrgType.UID_OrgType |
| QER_RFRL800 | QEROrgRootHasOrgType.UID_OrgType | OrgType.UID_OrgType |
| QER_RFRL972 | PWODecisionMethod.UID_OrgType | OrgType.UID_OrgType |
Triggers
GEN_T23C1EBAB80677B0E01E2791E3 SQL_TRIGGER
GEN_T48082066FDF856309E1433564 SQL_TRIGGER
GEN_T509C4EBA4F13C8139182FEDB7 SQL_TRIGGER
GEN_T6153A043F30DAD20E2A4FD069 SQL_TRIGGER
QER_TUOrgType 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_TIPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUOrgType | SQL expression dependency | OBJECT_OR_COLUMN |
| BaseTree | foreign key references table | QER_RFRL3397: BaseTree.UID_OrgType -> OrgType.UID_OrgType |
| OrgRoot | foreign key references table | QER_RFRL779: OrgRoot.UID_OrgType -> OrgType.UID_OrgType |
| QEROrgRootHasOrgType | foreign key references table | QER_RFRL800: QEROrgRootHasOrgType.UID_OrgType -> OrgType.UID_OrgType |
| PWODecisionMethod | foreign key references table | QER_RFRL972: PWODecisionMethod.UID_OrgType -> OrgType.UID_OrgType |
| dbo.QER_TIPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUOrgType | source text reference | uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-pwodecisionmethod.cs | decompiled C# reference | classes PWODecisionMethod, _003C_003Ec__DisplayClass3_0; methods _003C_Check_PWODecisionSubMethod_003Eb__0, MoveNext, SetStateMachine, GetValidityMessages, GetMessages, _Check_PWODecisionSubMethod; references DialogRichMail, OrgType, PWODecisionMethod, PWODecisionSubMethod; markers reads entity values, references DB/Dialog objects |
| cs-qer-forms-qer-forms-formitshopassistant.cs | decompiled C# reference | classes FormITShopAssistant, ShopInfo; methods OnInit, _ApplyChanges, _FireEventOfDependedProducts, _GetFilterWhereClause, _LoadListViewFixedAssignments, _LoadListViewShops; references ITShopOrg, ITShopSrc, OrgRoot, OrgType; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |