dbo.TSBAccountDef
Account definitions
TableType TUsage USERDATARows 2SizeMB 0.072
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_TSBAccountDef | varchar(38) | no | Account definition | PKUID |
UID_DialogTableAccountType | varchar(38) | yes | User account table | FKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
Ident_TSBAccountDef | nvarchar(128) | yes | Account definition | |
Description | nvarchar(-1) | yes | Description | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
IsForITShop | bit(1) | yes | IT Shop | |
IsITShopOnly | bit(1) | yes | Only use in IT Shop | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
RiskIndex | float(8) | yes | Risk index | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsAutoAssignToPerson | bit(1) | yes | Automatic assignment to identities | |
PTDInheritAccountDef | bit(1) | yes | Retain account definition if temporarily disabled | |
PFDInheritAccountDef | bit(1) | yes | Retain account definition if permanently disabled | |
PMDInheritAccountDef | bit(1) | yes | Retain account definition on deferred deletion | |
PSIInheritAccountDef | bit(1) | yes | Retain account definition on security risk | |
ObjectKeyTargetSystem | varchar(138) | no | Target system | |
UID_TSBBehaviorDefault | varchar(38) | yes | Manage level (initial) | FKUID |
UID_TSBAccountDefPredecessor | varchar(38) | yes | Required account definition | FKUID |
UID_QERResourceType | varchar(38) | yes | Resource type | FKUID |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2537 | ADSAccount.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| ADS_RFRL2546 | ADSDomain.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| ADS_RFRL2563 | ADSContact.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| ADS_RFRL2575 | ADSDomain.UID_TSBAccountDefContact | TSBAccountDef.UID_TSBAccountDef |
| LDP_RFRL2531 | LDAPAccount.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| LDP_RFRL2542 | LDPDomain.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL1468 | UNSRootB.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL2523 | PersonHasTSBAccountDef.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL2528 | TSBAccountDef.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL2536 | UNSAccountB.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL2554 | TSBAccountDef.UID_TSBBehaviorDefault | TSBBehavior.UID_TSBBehavior |
| TSB_RFRL2555 | TSBAccountDefHasBehavior.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL2559 | TSBITDataMapping.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL2564 | TSBAccountDef.UID_QERResourceType | QERResourceType.UID_QERResourceType |
| TSB_RFRL2565 | TSBAccountDef.UID_DialogTableAccountType | DialogTable.UID_DialogTable |
Triggers
GEN_T16854EEB4DCCB6D28FD3846C0 SQL_TRIGGER
GEN_T20FD7E6E6BD9B58A3ACFC862C SQL_TRIGGER
GEN_T38DB8BA19AF243BE5B3B9CE7C SQL_TRIGGER
GEN_T488AA0C1D59E51A359851E8FB SQL_TRIGGER
GEN_T531318728749FC47509159C8C SQL_TRIGGER
GEN_T66413571EC942E2EFDB4C557D SQL_TRIGGER
TSB_TATTUTSBAccountDef SQL_TRIGGER
TSB_TUTSBAccountDef 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.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA4016135529BB929BEC7812 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA4A5469920A88A862DC456E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA4D4D5421CC31A2B100D047 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA5025B50316612A9FC934B6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6DF38142688310E1CF5D0D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA9E586A06923CD160E03E59 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAAB5A6D24DC44B6BA4A9D69 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB1A242CBE16829A0713754 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAF07589AAAA0DEC628A9266 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO25F2BE28B359A147002484 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO7AD62C2E28328C7A2F99F7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO921D2C20632DB6993D8D70 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA8C482BC8C48F3C962FF50 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA951733A12082916D3851A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB80009FA08F681D63B4108 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD0D66D215B55F3F96C96AD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOF79E5B68763946AD37AC2D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOF8865C9F0579C831B69628 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY197EC6A22EFCA0F37E16F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY1C7461F2680F62B272D390 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY6899BC09F309C000CB6007 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY7166BBF7E8B4003DCA4B3D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY75C7B00B32C74FA8C734A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY7E63AC104BE0F8468C3926 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYAD3637368C48BBEA6B8D71 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYAF3582CAD04010AC5744C9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD1570666C15F0F46905354 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P80179191B9F74E79661E38B69 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD6497BB2C618C7A8F2D853CBF | 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_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZTSBAccountDefFlags | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FTTSBAccountDefPredecessor | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FTTSBAccountDefPredecessor | SQL expression dependency | dbo · UID_TSBAccountDef · OBJECT_OR_COLUMN |
| dbo.TSB_FTTSBAccountDefPredecessor | SQL expression dependency | dbo · UID_TSBAccountDefPredecessor · OBJECT_OR_COLUMN |
| dbo.GEN_T1278801ADF47EAB5ED6CBA574 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T16854EEB4DCCB6D28FD3846C0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E4E94597A6EBA1B0D7C6407B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EA7BE24A3331D721708CF413 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20FD7E6E6BD9B58A3ACFC862C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T236F0F75AB9F7309F1342269A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2548431FC8000F88E6670D504 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B9CF9B64341F82DEDEC64747 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T367B7685389BE0005337B435A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T38DB8BA19AF243BE5B3B9CE7C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T39B2E068B76181F1D019E7ABE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C95DEB35C372E97D68C244BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5237014B812FE6AEA1AB2CC3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T531318728749FC47509159C8C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T58E3A2887B8C428A1803E054E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIPersonHasTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0A0A71A674A33C86ABC06165 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA180FDBA5BB26AEF6CFCE1E19 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA5F73248CB850AC195FDC3FE8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB3C833748C1FAD6D12F4C6FA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD862BED8E8A88EB0FCC7BBF4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERAccProductUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVReportAllData | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · UID_TSBAccountDef · OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · Ident_TSBAccountDef · OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.TSB_VPersonHasRessWithPWO | SQL expression dependency | dbo · UID_QERResourceType · OBJECT_OR_COLUMN |
| dbo.TSB_VTSBAccountDefNoAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBAccountDefAndAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBGroupToTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSAccount | foreign key references table | ADS_RFRL2537: ADSAccount.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| ADSDomain | foreign key references table | ADS_RFRL2546: ADSDomain.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| ADSContact | foreign key references table | ADS_RFRL2563: ADSContact.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| ADSDomain | foreign key references table | ADS_RFRL2575: ADSDomain.UID_TSBAccountDefContact -> TSBAccountDef.UID_TSBAccountDef |
| LDAPAccount | foreign key references table | LDP_RFRL2531: LDAPAccount.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| LDPDomain | foreign key references table | LDP_RFRL2542: LDPDomain.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| UNSRootB | foreign key references table | TSB_RFRL1468: UNSRootB.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| PersonHasTSBAccountDef | foreign key references table | TSB_RFRL2523: PersonHasTSBAccountDef.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| AccProduct | referenced by foreign key from table | TSB_RFRL2528: TSBAccountDef.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSAccountB | foreign key references table | TSB_RFRL2536: UNSAccountB.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| TSBBehavior | referenced by foreign key from table | TSB_RFRL2554: TSBAccountDef.UID_TSBBehaviorDefault -> TSBBehavior.UID_TSBBehavior |
| TSBAccountDefHasBehavior | foreign key references table | TSB_RFRL2555: TSBAccountDefHasBehavior.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| TSBITDataMapping | foreign key references table | TSB_RFRL2559: TSBITDataMapping.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| QERResourceType | referenced by foreign key from table | TSB_RFRL2564: TSBAccountDef.UID_QERResourceType -> QERResourceType.UID_QERResourceType |
| DialogTable | referenced by foreign key from table | TSB_RFRL2565: TSBAccountDef.UID_DialogTableAccountType -> DialogTable.UID_DialogTable |
| 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_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasTSBAccountDef | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZTSBAccountDefFlags | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_FTTSBAccountDefPredecessor | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.TSB_TIBaseTreeHasTSBAccountDef | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIPersonHasTSBAccountDef | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUTSBAccountDef | source text reference | creates object-layer jobs via QBM_PJobCreate*, 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-accountitshoporderentitylogic.cs | decompiled C# reference | classes AccountITShopOrderEntityLogic, _003C_003Ec__DisplayClass2_0; methods _003CCreateITShopOrder_OnSaving_003Eb__0, MoveNext, SetStateMachine, CreateITShopOrder, CreateITShopOrder_OnSaving; references Person, TSBAccountDef, TSBVAccountTable; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-tsb-customizer-tsb-customizer-personhastsbaccountdef.cs | decompiled C# reference | classes PersonHasTSBAccountDef; methods MoveNext, SetStateMachine, _CreateItShopOrder; references Person, PersonHasTSBAccountDef, TSBAccountDef; markers 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 |