dbo.TSBPersonUsesAccount
Authorization to use shared user accounts
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_TSBPersonUsesAccount | varchar(38) | no | Authorization to use | PKUID |
ObjectKeyAccount | varchar(138) | no | User account | |
UID_Person | varchar(38) | no | Identity | FKUID |
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 |
|---|---|---|
| TSB_RFRL1200 | TSBPersonUsesAccount.UID_Person | Person.UID_Person |
Triggers
ADS_TDTSBPersonUsesAccount SQL_TRIGGER
ADS_TITSBPersonUsesAccount SQL_TRIGGER
GEN_T19A29DFB4BAC18F420DE61685 SQL_TRIGGER
GEN_T2F5BB23305889F65F798A6581 SQL_TRIGGER
GEN_T329A555ED082C48042FC2081D SQL_TRIGGER
LDP_TDTSBPersonUsesAccount SQL_TRIGGER
LDP_TITSBPersonUsesAccount SQL_TRIGGER
TSB_TDTSBPersonUsesAccount SQL_TRIGGER
TSB_TITSBPersonUsesAccount 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.TSB_FTAccountsForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIADSAccountInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIADSContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSAccountInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T32514535467CA6605935F38FB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T36FEBED331274562FD6B80DBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T371F0FB4B613E6EFC97664261 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3A8F504113EF5159F55B39C8A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | TSB_RFRL1200: TSBPersonUsesAccount.UID_Person -> Person.UID_Person |
| dbo.TSB_FTAccountsForPerson | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ADS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.ADS_TIADSAccountInADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TIADSContactInADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUADSAccountInADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUADSContactInADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TILDAPAccountInLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPAccountInLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBHasUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBHasUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBHasUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBHasUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBHasUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBHasUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBHasUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBHasUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBInUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBInUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBInUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBInUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| 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 |