dbo.TSBBehavior
Manage levels
TableType TUsage USERDATARows 2SizeMB 0.024
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_TSBBehavior | varchar(38) | no | Manage level | PKUID |
Ident_TSBBehavior | nvarchar(128) | yes | Manage level | |
Description | nvarchar(-1) | 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 |
PTDInheritGroup | bit(1) | yes | Retain groups if temporarily disabled | |
PTDLockAccount | bit(1) | yes | Disable user accounts if temporarily disabled | |
PFDInheritGroup | bit(1) | yes | Retain groups if permanently disabled | |
PFDLockAccount | bit(1) | yes | Disable user accounts if permanently disabled | |
PMDInheritGroup | bit(1) | yes | Retain groups on deferred deletion | |
PMDLockAccount | bit(1) | yes | Disable user accounts if deletion is deferred | |
PSIInheritGroup | bit(1) | yes | Retain groups on security risk | |
PSILockAccount | bit(1) | yes | Lock user account on security risk | |
ADAInheritGroup | bit(1) | yes | Retain groups if user account disabled | |
ITDataUsage | int(4) | yes | IT operating data overwrites | limited |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2556 | ADSAccount.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
| ADS_RFRL2562 | ADSContact.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
| LDP_RFRL2551 | LDAPAccount.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
| TSB_RFRL2554 | TSBAccountDef.UID_TSBBehaviorDefault | TSBBehavior.UID_TSBBehavior |
| TSB_RFRL2556 | TSBAccountDefHasBehavior.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
| TSB_RFRL2557 | UNSAccountB.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
Triggers
ADS_TUTSBBehavior SQL_TRIGGER
GEN_T2D0570914ADE9ABE358F5DA16 SQL_TRIGGER
GEN_T386561077DF4907B037C4E5D5 SQL_TRIGGER
GEN_T438B1AEC4B542409D1B03F623 SQL_TRIGGER
GEN_T55029CA63D7971D63E1F96BAA SQL_TRIGGER
GEN_T62216F0F3800818A407A341E4 SQL_TRIGGER
LDP_TUTSBBehavior SQL_TRIGGER
TSB_TUTSBBehavior 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.ADS_ZAccountInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUTSBBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1278801ADF47EAB5ED6CBA574 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2548431FC8000F88E6670D504 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T55029CA63D7971D63E1F96BAA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUTSBBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUTSBBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSAccount | foreign key references table | ADS_RFRL2556: ADSAccount.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| ADSContact | foreign key references table | ADS_RFRL2562: ADSContact.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| LDAPAccount | foreign key references table | LDP_RFRL2551: LDAPAccount.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| TSBAccountDef | foreign key references table | TSB_RFRL2554: TSBAccountDef.UID_TSBBehaviorDefault -> TSBBehavior.UID_TSBBehavior |
| TSBAccountDefHasBehavior | foreign key references table | TSB_RFRL2556: TSBAccountDefHasBehavior.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| UNSAccountB | foreign key references table | TSB_RFRL2557: UNSAccountB.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| dbo.ADS_ZAccountInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZContactInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZAccountInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | source text reference | has TRY/CATCH error handling |
| dbo.ADS_TUTSBBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TUTSBBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUTSBBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-ads-forms-ads-forms-formadsaccountmasterdata.cs | decompiled C# reference | classes FormADSAccountMasterData; methods OnInit, _ActivateForm, _AdaptTasks, FormTask_MoveToDomain, FormTask_MoveContainer, FormTask_Unlock; references ADSAccount, ADSAccountInADSGroup, ADSContainer, ADSDomain, ADSGroup, Delegation; markers reads entity values, writes 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-tsb-customizer-tsb-customizer-tsbaccountdeflogic.cs | decompiled C# reference | classes TSBAccountDefLogic, _003C_003Ec__DisplayClass10_0, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003CCheckTSBBahavior_003Eb__0, _003CCheckUniqueAccount_003Eb__0, _003CCheckUniqueAccount_003Eb__1, _003CExistsPersonHasTSBAccountDef_003Eb__0, _003CAssignAccountDef_OnSaving_003Eb__0, _003CRevokeAccountDef_003Eb__0; references Person, PersonHasTSBAccountDef, TSBAccountDef, TSBAccountDefHasBehavior, TSBBehavior, TSBPersonUsesAccount; markers reads entity values, references DB/Dialog objects |