dbo.LDAPContainer
LDAP containers
TableType TUsage USERDATARows 19SizeMB 0.064
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_LDAPContainer | varchar(38) | no | LDAP container | PKUID |
UID_AERoleOwner | varchar(38) | yes | Target system manager | FKUID |
UID_ParentLDAPContainer | varchar(38) | yes | Parent container | FKUID |
cn | nvarchar(510) | yes | Name | |
ObjectClass | nvarchar(2048) | yes | Object class | |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
BuildingName | nvarchar(-1) | yes | Building name | |
BusinessCategory | nvarchar(-1) | yes | Business unit | |
Description | nvarchar(-1) | yes | Description | |
DestinationIndicator | nvarchar(-1) | yes | Location ID | |
DisplayName | nvarchar(510) | yes | Display name | |
FacsimileTelephoneNumber | nvarchar(-1) | yes | Fax | |
InternationalISDNNumber | nvarchar(-1) | yes | International ISDN No. | |
LabeledURI | nvarchar(-1) | yes | Links (named URI format) | |
PhysicalDeliveryOfficeName | nvarchar(-1) | yes | Office | |
PostalAddress | nvarchar(-1) | yes | Address | |
PostalCode | nvarchar(80) | yes | Zip code | |
PostOfficeBox | nvarchar(128) | yes | Mailbox | |
PreferredDeliveryMethod | nvarchar(128) | yes | Preferred delivery | |
RegisteredAddress | nvarchar(-1) | yes | Registered address | |
SearchGuide | nvarchar(-1) | yes | Search form | |
SeeAlso | nvarchar(-1) | yes | See also | |
ST | nvarchar(128) | yes | State or province | |
Street | nvarchar(-1) | yes | Street | |
TelephoneNumber | nvarchar(-1) | yes | Phone | |
TeletexTerminalIdentifier | nvarchar(128) | yes | Teletex ID | |
TelexNumber | nvarchar(128) | yes | Telex | |
UserPassword | varchar(990) | yes | Password | |
X121Address | nvarchar(30) | yes | X.121 address | |
XTouched | nchar(2) | yes | Processing status | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
ModifyTimeStamp | nvarchar(60) | yes | LDAP date last changed | |
ObjectGUID | varchar(40) | yes | Object GUID | |
XObjectKey | varchar(138) | no | Object key | |
DomainDisplayName | nvarchar(256) | yes | Domain | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_LDPDomain | varchar(38) | no | Domain | FKUID |
StructuralObjectClass | nvarchar(512) | yes | Structural object class |
Relations
| FK | From | To |
|---|---|---|
| LDP_RFRL1329 | LDAPAccount.UID_LDAPContainer | LDAPContainer.UID_LDAPContainer |
| LDP_RFRL1332 | LDAPGroup.UID_LDAPContainer | LDAPContainer.UID_LDAPContainer |
| LDP_RFRL1336 | LDAPContainer.UID_LDPDomain | LDPDomain.UID_LDPDomain |
| LDP_RFRL2555 | LDAPContainer.UID_AERoleOwner | BaseTree.UID_Org |
Triggers
GEN_T11BEF81E5A5069B4FFC98ED7E SQL_TRIGGER
GEN_T2B63B2CEA59A44FBCB31C630D SQL_TRIGGER
GEN_T33FB0DEFE0549132F508381B3 SQL_TRIGGER
LDP_TATTULDAPContainer SQL_TRIGGER
LDP_TCPLULDAPContainer SQL_TRIGGER
LDP_TDLDAPContainer SQL_TRIGGER
LDP_TILDAPContainer SQL_TRIGGER
LDP_TULDAPContainer 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_FTEAD3B3D4A4AAE3E77B7F745E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO3077299134008999AC844A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF9B5B0718078CC8E220CB4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P96DE6C8F5BE12F18D75820E01 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT621FC79B97DAA6A151B9A8A2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T11BEF81E5A5069B4FFC98ED7E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1278801ADF47EAB5ED6CBA574 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13F11A5B62DAA3051A01E8B5F | 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_T2B63B2CEA59A44FBCB31C630D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2E665EA3780D6E4DA3CD23E5F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T33FB0DEFE0549132F508381B3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_VAERoleLDAPContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_VContainerCollection | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_VContainerCollection | SQL expression dependency | dbo · UID_LDAPContainer · OBJECT_OR_COLUMN |
| dbo.LDP_VContainerCollection | SQL expression dependency | dbo · UID_ParentLDAPContainer · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · UID_LDPDomain · OBJECT_OR_COLUMN |
| dbo.TSBVDomainAndContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVPersonAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| LDAPAccount | foreign key references table | LDP_RFRL1329: LDAPAccount.UID_LDAPContainer -> LDAPContainer.UID_LDAPContainer |
| LDAPGroup | foreign key references table | LDP_RFRL1332: LDAPGroup.UID_LDAPContainer -> LDAPContainer.UID_LDAPContainer |
| LDPDomain | referenced by foreign key from table | LDP_RFRL1336: LDAPContainer.UID_LDPDomain -> LDPDomain.UID_LDPDomain |
| BaseTree | referenced by foreign key from table | LDP_RFRL2555: LDAPContainer.UID_AERoleOwner -> BaseTree.UID_Org |
| dbo.LDP_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZLDPMachineInLDAPGroup | source text reference | has TRY/CATCH error handling |