dbo.ADSDomain
Active Directory domains
TableType TUsage USERDATARows 1SizeMB 0.088
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSDomain | varchar(38) | no | Domain | PKUID |
UID_AERoleOwner | varchar(38) | yes | Target system manager | FKUID |
Ident_Domain | nvarchar(64) | no | Domain | |
UID_TSBAccountDef | varchar(38) | yes | Account definition (initial) | FKUID |
Description | nvarchar(2048) | yes | Description | |
MinPasswordLength | int(4) | yes | Min. password length | |
MinPasswordAge | int(4) | yes | Min. password lifetime | |
MaxPasswordAge | int(4) | yes | Max. password lifetime | |
MaxBadPasswordsAllowed | int(4) | yes | Max. failed logins | |
PasswordHistoryLength | int(4) | yes | Password history | |
AutoUnlockInterval | int(4) | yes | Block duration [min] | |
LockoutObservationInterval | int(4) | yes | Reset account [min] | |
DefaultHomeDrive | nchar(4) | yes | Default home drive | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
dc | nvarchar(128) | yes | Domain name (pre Win2000) | |
DistinguishedName | nvarchar(800) | yes | Distinguished name | |
ObjectGUID | varchar(36) | yes | Object GUID | |
ADSDomainName | nvarchar(510) | yes | Full domain name | |
IsADSComplexPassword | bit(1) | yes | Complex passwords | |
XTouched | nchar(2) | yes | Processing status | |
ObjectClass | nvarchar(510) | yes | Object class | |
XObjectKey | varchar(138) | no | Object key | |
CanonicalName | nvarchar(800) | yes | Canonical name | |
DisplayName | nvarchar(256) | yes | Display name | |
NamespaceManagedBy | nvarchar(32) | yes | Synchronized by | limited |
IsRecyclerEnabled | bit(1) | yes | Enable recycle bin | |
msDSdeletedObjectLifetime | int(4) | yes | Retention time | |
AccountToPersonMatchingRule | nvarchar(-1) | yes | Search criteria for automatic identity assignment | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_ADSDomainSubType | varchar(38) | yes | Domain subtype | FKUID |
UID_ADSDomainParent | varchar(38) | yes | Parent domain | FKUID |
UID_ADSForest | varchar(38) | no | Forest | FKUID |
ObjectKeyManager | varchar(138) | yes | Account manager | |
MatchPatternDisplay | nvarchar(-1) | yes | Mapping rule category | |
UID_TSBAccountDefContact | varchar(38) | yes | Contact definition (initial) | FKUID |
StructuralObjectClass | nvarchar(512) | yes | Structural object class | |
ObjectSID | nvarchar(510) | yes | Object SID | |
msDSExpirePasswdOnSCardOnlyAcc | bit(1) | yes | Rolling public key only user's NTLM secrets | |
UID_ADSMachineRIDMaster | varchar(38) | yes | Domain RID master | FKUID |
AdUserName | nvarchar(1024) | yes | User name for running CMDLets | |
AdUserPassword | varchar(990) | yes | Password for running CMDLets | |
IsArsWorkflowsEnabled | bit(1) | yes | Execute Active Roles workflows | |
UseARSDeprovUserByDefault | bit(1) | yes | User accounts deleted by Active Roles workflows | |
UseARSDeprovGroupByDefault | bit(1) | yes | Groups deleted by Active Roles workflows |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL1500 | ADSDomain.UID_ADSMachineRIDMaster | ADSMachine.UID_ADSMachine |
| ADS_RFRL1623 | DomainTrustsDomain.UID_ADSDomainTrusts | ADSDomain.UID_ADSDomain |
| ADS_RFRL1783 | ADSDomain.UID_ADSDomainSubType | ADSDomainSubType.UID_ADSDomainSubType |
| ADS_RFRL1784 | ADSPolicy.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2546 | ADSDomain.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| ADS_RFRL2558 | ADSContact.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2564 | ADSAccount.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2565 | ADSGroup.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2570 | ADSDomain.UID_ADSForest | ADSForest.UID_ADSForest |
| ADS_RFRL2571 | ADSMachine.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2575 | ADSDomain.UID_TSBAccountDefContact | TSBAccountDef.UID_TSBAccountDef |
| ADS_RFRL2578 | ADSDomain.UID_AERoleOwner | BaseTree.UID_Org |
| ADS_RFRL751 | ADSContainer.UID_ADSDomain | ADSDomain.UID_ADSDomain |
Triggers
ADS_TATTUDomain SQL_TRIGGER
ADS_TCPLUDomain SQL_TRIGGER
ADS_TDADSDomain SQL_TRIGGER
ADS_TIADSDomain SQL_TRIGGER
ADS_TRMBUDomain SQL_TRIGGER
ADS_TUDomain SQL_TRIGGER
GEN_T1B98589ACF9DE22E455004458 SQL_TRIGGER
GEN_T298164B550C782C69D43D3180 SQL_TRIGGER
GEN_T3C95DEB35C372E97D68C244BA SQL_TRIGGER
GEN_T4F7746CD21D271FDBA218D52A SQL_TRIGGER
GEN_T5FC547C7BA1E6461F29A09065 SQL_TRIGGER
GEN_T67DDFD12F8BC123556E5D1451 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_FTBD06BC392C446FFD04D09C27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA69C7D693E3A511EB0EEF22 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO23E9A1A9473A3635194231 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD1FF94E385FADA2276090E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_FGIDomainTrustExists | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_FGIDomainTrustExists | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| dbo.ADS_FGIDomainTrustExists | SQL expression dependency | dbo · UID_ADSForest · OBJECT_OR_COLUMN |
| dbo.ADS_ZAccountInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P868803F97F7D407AF1FDCB2CB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA72A423016BA139FFC3D8EDFF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD75EFC2994CF76773E86FDA0A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_FTDomainTree | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_FTDomainTree | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| dbo.ADS_FTDomainTree | SQL expression dependency | dbo · Ident_Domain · OBJECT_OR_COLUMN |
| dbo.ADS_FTDomainTree | SQL expression dependency | dbo · UID_ADSDomainParent · OBJECT_OR_COLUMN |
| dbo.GEN_FT621FC79B97DAA6A151B9A8A2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA3AD537967B99F82C7D2C1DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TDDomainTrustsDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIDomainTrustsDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1278801ADF47EAB5ED6CBA574 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T16854EEB4DCCB6D28FD3846C0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T17D30243209A821B4595E467A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1A53B5FF8BC2525A724319139 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AF9738269E36D4BD687D6339 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1B98589ACF9DE22E455004458 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D01571F7BC5055F3A7389C93 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20FD7E6E6BD9B58A3ACFC862C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T22194AF12D6CB9D9BADC3CFBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T236F0F75AB9F7309F1342269A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T239F21D783D386786BEB87121 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T23A4B7EB7C690E7779D0EA6E5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25023756BABB2911A175F2728 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2548431FC8000F88E6670D504 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T298164B550C782C69D43D3180 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C95DEB35C372E97D68C244BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5FC547C7BA1E6461F29A09065 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VAERoleADSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VDomainCollection | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VDomainCollection | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| dbo.ADS_VDomainCollection | SQL expression dependency | dbo · Ident_Domain · OBJECT_OR_COLUMN |
| dbo.ADS_VDomainCollection | SQL expression dependency | dbo · UID_ADSDomainParent · OBJECT_OR_COLUMN |
| dbo.ADS_VDomainRelation | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VDomainTrustExists | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VDomainTrustExists | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| dbo.ADS_VDomainTrustExists | SQL expression dependency | dbo · UID_ADSForest · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.ADS_VElementManagerValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VGroupMemberValid_Account | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VGroupMemberValid_Contact | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VGroupMemberValid_Group | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VGroupMemberValid_Machine | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVUniqueItems | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMSystemMetering | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBAccountDefAndAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBAERoleForRoot | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBGroupToTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDomainAndContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVPersonAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVUNSDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSRoot | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSMachine | referenced by foreign key from table | ADS_RFRL1500: ADSDomain.UID_ADSMachineRIDMaster -> ADSMachine.UID_ADSMachine |
| DomainTrustsDomain | foreign key references table | ADS_RFRL1623: DomainTrustsDomain.UID_ADSDomainTrusts -> ADSDomain.UID_ADSDomain |
| ADSDomainSubType | referenced by foreign key from table | ADS_RFRL1783: ADSDomain.UID_ADSDomainSubType -> ADSDomainSubType.UID_ADSDomainSubType |
| ADSPolicy | foreign key references table | ADS_RFRL1784: ADSPolicy.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| TSBAccountDef | referenced by foreign key from table | ADS_RFRL2546: ADSDomain.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| ADSContact | foreign key references table | ADS_RFRL2558: ADSContact.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSAccount | foreign key references table | ADS_RFRL2564: ADSAccount.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSGroup | foreign key references table | ADS_RFRL2565: ADSGroup.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSForest | referenced by foreign key from table | ADS_RFRL2570: ADSDomain.UID_ADSForest -> ADSForest.UID_ADSForest |
| ADSMachine | foreign key references table | ADS_RFRL2571: ADSMachine.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| TSBAccountDef | referenced by foreign key from table | ADS_RFRL2575: ADSDomain.UID_TSBAccountDefContact -> TSBAccountDef.UID_TSBAccountDef |
| BaseTree | referenced by foreign key from table | ADS_RFRL2578: ADSDomain.UID_AERoleOwner -> BaseTree.UID_Org |
| ADSContainer | foreign key references table | ADS_RFRL751: ADSContainer.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| dbo.ADS_FGIDomainTrustExists | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ADS_ZAccountInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZContactInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ADS_FTDomainTree | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.ADS_TDDomainTrustsDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TIDomainTrustsDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-ads-customizer-ads-customizer-adsaccount.cs | decompiled C# reference | classes ADSAccount, MP, _003C_003Ec__DisplayClass10_0, _003C_003Ec__DisplayClass11_0; methods _003CRemoveMemberShips_003Eb__0, _003CUpdatePrimaryGroup_003Eb__0, _003CCheckMove_003Eb__0, MoveNext, SetStateMachine, FormatMVPValues; references ADSAccount, ADSAccountInADSGroup, ADSContainer, ADSDomain, ADSGroup, Person; markers reads entity values, references DB/Dialog objects |
| cs-ads-customizer-ads-customizer-adscontact.cs | decompiled C# reference | classes ADSContact; methods MoveNext, SetStateMachine, OnSavingAsync, OnSavedAsync; references ADSContact, ADSContainer, ADSDomain; markers reads entity values, references DB/Dialog objects |
| cs-ads-customizer-ads-customizer-adsgroup.cs | decompiled C# reference | classes ADSGroup, _003C_003Ec__DisplayClass5_0, _003C_003Ec__DisplayClass8_0, _003C_003Ec__DisplayClass9_0; methods _003C_CheckAdsContainer_003Eb__0, _003C_CheckGroupTypeChanging_003Eb__0, _003C_CheckGroupTypeChanged_003Eb__0, MoveNext, SetStateMachine, _CheckObjectKeyManager; references ADSContact, ADSContainer, ADSDomain, ADSGroup; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-ads-customizer-ads-customizer-adsgrouplimit.cs | decompiled C# reference | classes ADSGroupLimit; methods MoveNext, SetStateMachine, OnSavingAsync; references ADSDomain, ADSGroup; markers references DB/Dialog objects |
| cs-ads-customizer-ads-customizer-adsmachine.cs | decompiled C# reference | classes ADSMachine; methods MoveNext, SetStateMachine, OnSavingAsync, OnSavedAsync, _CheckUidADSDomain, _CheckADSPrimaryGroup; references ADSContainer, ADSDomain, ADSGroup, ADSMachine, ADSMachineInADSGroup; markers reads entity values, references DB/Dialog objects |
| 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 |