dbo.ADSContact
Active Directory contacts
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSContact | varchar(38) | no | Active Directory contact | PKUID |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
ObjectClass | nvarchar(512) | yes | Object class | |
UID_ADSDomain | varchar(38) | no | Domain | FKUID |
UID_ADSContainer | varchar(38) | yes | Container | FKUID |
ExtensionAttribute1 | nvarchar(-1) | yes | Attribute extension 01 | |
ExtensionAttribute2 | nvarchar(-1) | yes | Attribute extension 02 | |
ExtensionAttribute3 | nvarchar(-1) | yes | Attribute extension 03 | |
ExtensionAttribute4 | nvarchar(-1) | yes | Attribute extension 04 | |
ExtensionAttribute5 | nvarchar(-1) | yes | Attribute extension 05 | |
ExtensionAttribute6 | nvarchar(-1) | yes | Attribute extension 06 | |
ExtensionAttribute7 | nvarchar(-1) | yes | Attribute extension 07 | |
ExtensionAttribute8 | nvarchar(-1) | yes | Attribute extension 08 | |
ExtensionAttribute9 | nvarchar(-1) | yes | Attribute extension 09 | |
ExtensionAttribute10 | nvarchar(-1) | yes | Attribute extension 10 | |
ExtensionAttribute11 | nvarchar(-1) | yes | Attribute extension 11 | |
ExtensionAttribute12 | nvarchar(-1) | yes | Attribute extension 12 | |
ExtensionAttribute13 | nvarchar(-1) | yes | Attribute extension 13 | |
ExtensionAttribute14 | nvarchar(-1) | yes | Attribute extension 14 | |
ExtensionAttribute15 | nvarchar(-1) | yes | Attribute extension 15 | |
OtherFax | nvarchar(-1) | yes | Additional fax numbers | |
OtherHomePhone | nvarchar(-1) | yes | Additional private numbers | |
OtherIPPhone | nvarchar(-1) | yes | Additional IP phone numbers | |
OtherMailBox | nvarchar(-1) | yes | Additional email addresses | |
OtherMobile | nvarchar(-1) | yes | Additional mobile phone numbers | |
OtherPager | nvarchar(-1) | yes | Additional pager numbers | |
OtherTelephoneNumber | nvarchar(-1) | yes | Additional phone numbers | |
OtherWWW | nvarchar(-1) | yes | Additional webpages | |
Company | nvarchar(128) | yes | Company | |
UID_ADSCountryCode | varchar(38) | yes | Country ID | FKUID |
Department | nvarchar(128) | yes | Department | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(510) | yes | Display name | |
Mail | nvarchar(510) | yes | Email address | |
cn | nvarchar(220) | no | Name | |
Fax | nvarchar(128) | yes | Fax | |
HomePhone | nvarchar(128) | yes | Phone, private | |
GivenName | nvarchar(128) | yes | First name | |
Info | nvarchar(-1) | yes | Note | |
Initials | nvarchar(16) | yes | Initials | |
Locality | nvarchar(256) | yes | City | |
ipPhone | nvarchar(128) | yes | IP phone number | |
Mobile | nvarchar(128) | yes | Mobile phone | |
Pager | nvarchar(128) | yes | Pager | |
PhysicalDeliveryOfficeName | nvarchar(256) | yes | Office | |
PostalCode | nvarchar(80) | yes | Zip code | |
PostOfficeBox | nvarchar(80) | yes | Mailbox | |
StreetAddress | nvarchar(-1) | yes | Street | |
State | nvarchar(256) | yes | State or province | |
Surname | nvarchar(128) | yes | Last name | |
TelephoneNumber | nvarchar(128) | yes | Phone | |
Title | nvarchar(256) | yes | Job description | |
WWWHomePage | nvarchar(-1) | yes | Web page | |
PersonalTitle | nvarchar(128) | yes | Title | |
EmployeeID | nvarchar(32) | yes | Identity ID | |
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 |
MatchPatternForMembership | bigint(8) | yes | Category | |
UID_TSBBehavior | varchar(38) | yes | Manage level | FKUID |
UID_Person | varchar(38) | yes | Identity | FKUID |
UID_TSBAccountDef | varchar(38) | yes | Account definition | FKUID |
RiskIndexCalculated | float(8) | yes | Risk index (calculated) | |
IsGroupAccount | bit(1) | yes | Groups can be inherited | |
ObjectKeyManager | varchar(138) | yes | Account manager | |
ObjectGUID | varchar(36) | yes | Object GUID | |
EmployeeNumber | nvarchar(1024) | yes | Personnel number | |
EmployeeType | nvarchar(512) | yes | Employment | |
XDateSubItem | datetime(8) | yes | Dependencies modified on | |
StructuralObjectClass | nvarchar(512) | yes | Structural object class | |
IdentityType | varchar(32) | yes | Identity type | limited |
IsProtectedFromAccidentalDel | bit(1) | yes | Protected from accidental deletion | |
MSDsConsistencyGuid | nvarchar(512) | yes | Azure AD Connect anchor ID | |
NeverConnectToPerson | int(4) | yes | Not linked to an identity | bitmask |
IsNeverConnectManual | bit(1) | yes | No link to an identity required | |
GidNumber | int(4) | yes | Gid number | |
Gecos | nvarchar(800) | yes | Gecos | |
LoginShell | nvarchar(800) | yes | Login shell | |
UidPosix | varchar(128) | yes | UID POSIX | |
UidNumber | int(4) | yes | Uid number | |
UnixHomeDirectory | nvarchar(800) | yes | Unix home directory |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2558 | ADSContact.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2559 | ADSContact.UID_ADSContainer | ADSContainer.UID_ADSContainer |
| ADS_RFRL2560 | ADSContact.UID_ADSCountryCode | DialogCountry.UID_DialogCountry |
| ADS_RFRL2561 | ADSContact.UID_Person | Person.UID_Person |
| ADS_RFRL2562 | ADSContact.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
| ADS_RFRL2563 | ADSContact.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| ADS_RFRL2567 | ADSContactSecretary.UID_ADSContact | ADSContact.UID_ADSContact |
Triggers
ADS_TDADSContact SQL_TRIGGER
ADS_TIADSContact SQL_TRIGGER
ADS_TUADSContact SQL_TRIGGER
GEN_T1985C0FC0CC0D5B86611D3825 SQL_TRIGGER
GEN_T2CD40CDCB509E6E9BEC312B86 SQL_TRIGGER
GEN_T3A8F504113EF5159F55B39C8A SQL_TRIGGER
GEN_T52517C82D0D4BB957E98D85AB SQL_TRIGGER
GEN_T6E8C305712DAFEE9FFCEFAC3F 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_FTE10BCE32554C404BF46E35BC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA255A0285DD402BFAB93B25 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA8AEAF9E5D09259EDA878DF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE0243565BE6703FE18220D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE19993A21305768BC67BA1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO232AA5350399AF5B5E7FC8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6FE29BD24EE8070A0F58FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9EF81AB6EE40C7C1070D2B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOC7B20A6BD971728008EA89 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY6CF75B30295FEFA8CD3709 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYAFC2B1B0AA231EB7202E0A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD067DDDE01113A49AB7F4F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYEB1C7B5195AE3821552788 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_PAfterMigrationJobCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_RContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZPersonHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P52191672D9A949F56CEF49189 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P868803F97F7D407AF1FDCB2CB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P9B87544E1325D45A63B7E4C95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA3AD537967B99F82C7D2C1DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TDAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TDADSGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TDDomainTrustsDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIADSContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIADSGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIDomainTrustsDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSContact | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSContactInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUTSBBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T121B7714B112A3B433796664F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1376E9353976875BE84E46029 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T15C67D01E31022B8D23F298A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T167AFD581323C39403E508942 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T16EBCCB27CC38AC882DADA5B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1985C0FC0CC0D5B86611D3825 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T19A29DFB4BAC18F420DE61685 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AEF631BFB74E59F11389C4C1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1B98589ACF9DE22E455004458 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C1271AD74F987D1F0CFE855E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D2773C6ABA951AB4BE4AF3A3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1F8E0FB94B91F94E50F7E45AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25339C91831C72FA86A507314 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25685408F252F90B3911CB704 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T264A70C96C79383B7D820541D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2742638AB3522EB93ADDA7965 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2787F336E652E75860997C55A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T298164B550C782C69D43D3180 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2BA9223C3DCBE683F1DF50DC0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2E29897B2A4A2F0A2191126 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CD40CDCB509E6E9BEC312B86 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2E88F37C316E6934F2860C898 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2EBBC9B7E3BC2E0B9D52EF4C3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2F5BB23305889F65F798A6581 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T42CAE7CC4ED0C0A8ACA676A88 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T43769BDD8C7D76F7C2A028E81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4662F80C1CE95056225436E3D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4D8BBDD351E4C2AC00C3FA4C4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4EAA84DB630C36DAF8C529932 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T51DDFD519D0D0D4549F83A0EC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5235B5D157E9A787C04AA44AB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T52517C82D0D4BB957E98D85AB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T55FC26C26831774FF3216F3BB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5A02C0F960F6FC1162454A4D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5B2CFE3130A4D73386393DAC8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5BCA019FE5ACFBE9DAD6814C5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6847823D7A5D8DE4B2C625FC2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6B256F72E10E1B1C83DCFC983 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6B2EC76A1FB0905C349AC5CBA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6C5CC02FE16641E3F38C39032 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · UID_ADSContact · 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_Contact | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVContainerAndMembers | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVUniqueItems | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBAccountDefAndAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDirectAssignWrong | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVPersonAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSDomain | referenced by foreign key from table | ADS_RFRL2558: ADSContact.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSContainer | referenced by foreign key from table | ADS_RFRL2559: ADSContact.UID_ADSContainer -> ADSContainer.UID_ADSContainer |
| DialogCountry | referenced by foreign key from table | ADS_RFRL2560: ADSContact.UID_ADSCountryCode -> DialogCountry.UID_DialogCountry |
| Person | referenced by foreign key from table | ADS_RFRL2561: ADSContact.UID_Person -> Person.UID_Person |
| TSBBehavior | referenced by foreign key from table | ADS_RFRL2562: ADSContact.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| TSBAccountDef | referenced by foreign key from table | ADS_RFRL2563: ADSContact.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| ADSContactSecretary | foreign key references table | ADS_RFRL2567: ADSContactSecretary.UID_ADSContact -> ADSContact.UID_ADSContact |
| dbo.ADS_PAfterMigrationJobCreate | source text reference | creates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling |
| dbo.ADS_RContactInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZContactInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZPersonHasADSGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ADS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.ADS_TDAdsGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TDADSGroupCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TDDomainTrustsDomain | 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_TIADSGroupCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TIBaseTreeHasADSGroup | 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_TUADSContact | 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.ADS_TUAdsGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUBaseTreeHasADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUTSBBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| 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 |