dbo.ADSContainer
Active Directory containers
TableType TUsage USERDATARows 215SizeMB 0.488
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSContainer | varchar(38) | no | Container | PKUID |
UID_AERoleOwner | varchar(38) | yes | Target system manager | FKUID |
UID_ParentADSContainer | varchar(38) | yes | Parent container | 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 | |
cn | nvarchar(220) | no | Name | |
Description | nvarchar(2048) | yes | Description | |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
Locality | nvarchar(128) | yes | Location | |
ObjectClass | nvarchar(512) | yes | Object class | |
ObjectGUID | varchar(36) | yes | Object GUID | |
ou | nvarchar(220) | yes | OU | |
PostalCode | nvarchar(32) | yes | Zip code | |
State | nvarchar(64) | yes | State or province | |
Street | nvarchar(-1) | yes | Street | |
IsSystemContainer | bit(1) | yes | System container | |
ShowInAdvancedViewOnly | bit(1) | yes | Extended function | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
UID_ADSCountryCode | varchar(38) | yes | Country ID | FKUID |
DomainDisplayName | nvarchar(256) | yes | Domain | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_ADSDomain | varchar(38) | no | Domain | FKUID |
ObjectKeyManager | varchar(138) | yes | Account manager | |
IsProtectedFromAccidentalDel | bit(1) | yes | Protected from accidental deletion | |
StructuralObjectClass | nvarchar(512) | yes | Structural object class |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2559 | ADSContact.UID_ADSContainer | ADSContainer.UID_ADSContainer |
| ADS_RFRL2579 | ADSContainer.UID_AERoleOwner | BaseTree.UID_Org |
| ADS_RFRL4359 | ADSContainer.UID_ADSCountryCode | DialogCountry.UID_DialogCountry |
| ADS_RFRL751 | ADSContainer.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL753 | ADSAccount.UID_ADSContainer | ADSContainer.UID_ADSContainer |
| ADS_RFRL755 | ADSMachine.UID_ADSContainer | ADSContainer.UID_ADSContainer |
| ADS_RFRL759 | ADSGroup.UID_ADSContainer | ADSContainer.UID_ADSContainer |
| ADS_RFRL881 | ADSAccount.UID_ADSContainerDisabled | ADSContainer.UID_ADSContainer |
Triggers
ADS_TATTUADSContainer SQL_TRIGGER
ADS_TCPLUADSContainer SQL_TRIGGER
ADS_TDADSContainer SQL_TRIGGER
ADS_TIADSContainer SQL_TRIGGER
ADS_TUADSContainer SQL_TRIGGER
GEN_T1376E9353976875BE84E46029 SQL_TRIGGER
GEN_T25685408F252F90B3911CB704 SQL_TRIGGER
GEN_T38CFEF2406530087143D2DBC7 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_FTEAE19993A21305768BC67BA1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9EF81AB6EE40C7C1070D2B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD067DDDE01113A49AB7F4F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P4A3DAB9B7D76F4026E32FF0AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT621FC79B97DAA6A151B9A8A2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1278801ADF47EAB5ED6CBA574 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1376E9353976875BE84E46029 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1603BDFF9396E4E301A6A5255 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1A53B5FF8BC2525A724319139 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20C3366B9D322CD1C80FCEDAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | 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_T2548431FC8000F88E6670D504 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25685408F252F90B3911CB704 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T38CFEF2406530087143D2DBC7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VAERoleADSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VContainerCollection | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VContainerCollection | SQL expression dependency | dbo · UID_ADSContainer · OBJECT_OR_COLUMN |
| dbo.ADS_VContainerCollection | SQL expression dependency | dbo · UID_ParentADSContainer · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| dbo.ADS_VElementManagerValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVContainerAndMembers | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVUniqueItems | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDomainAndContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSContact | foreign key references table | ADS_RFRL2559: ADSContact.UID_ADSContainer -> ADSContainer.UID_ADSContainer |
| BaseTree | referenced by foreign key from table | ADS_RFRL2579: ADSContainer.UID_AERoleOwner -> BaseTree.UID_Org |
| DialogCountry | referenced by foreign key from table | ADS_RFRL4359: ADSContainer.UID_ADSCountryCode -> DialogCountry.UID_DialogCountry |
| ADSDomain | referenced by foreign key from table | ADS_RFRL751: ADSContainer.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSAccount | foreign key references table | ADS_RFRL753: ADSAccount.UID_ADSContainer -> ADSContainer.UID_ADSContainer |
| ADSMachine | foreign key references table | ADS_RFRL755: ADSMachine.UID_ADSContainer -> ADSContainer.UID_ADSContainer |
| ADSGroup | foreign key references table | ADS_RFRL759: ADSGroup.UID_ADSContainer -> ADSContainer.UID_ADSContainer |
| ADSAccount | foreign key references table | ADS_RFRL881: ADSAccount.UID_ADSContainerDisabled -> ADSContainer.UID_ADSContainer |
| dbo.ADS_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, 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-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 |