dbo.LDAPAccount
LDAP user accounts
TableType TUsage USERDATARows 14SizeMB 0.104
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_LDAPAccount | varchar(38) | no | LDAP account | PKUID |
UID_Person | varchar(38) | yes | Identity | FKUID |
UID_LDAPCountryCode | varchar(38) | yes | Country ID | FKUID |
UID_LDAPContainer | varchar(38) | yes | Container | FKUID |
BusinessCategory | nvarchar(-1) | yes | Business unit | |
CarLicense | nvarchar(-1) | yes | Car license plate | |
cn | nvarchar(510) | yes | Name | |
ObjectClass | nvarchar(2048) | yes | Object class | |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
DepartmentNumber | nvarchar(-1) | yes | Department | |
Description | nvarchar(-1) | yes | Description | |
DestinationIndicator | nvarchar(-1) | yes | Location ID | |
DisplayName | nvarchar(510) | yes | Display name | |
EmployeeNumber | nvarchar(40) | yes | Personnel number | |
EmployeeType | nvarchar(512) | yes | Employment | |
FacsimileTelephoneNumber | nvarchar(-1) | yes | Fax | |
GivenName | nvarchar(128) | yes | First name | |
HomePhone | nvarchar(-1) | yes | Phone, private (2) | |
HomePostalAddress | nvarchar(-1) | yes | Address (private) | |
HomeTelephoneNumber | nvarchar(-1) | yes | Phone, private | |
Host | nvarchar(-1) | yes | Default PC | |
Initials | nvarchar(-1) | yes | Initials | |
InternationalISDNNumber | nvarchar(-1) | yes | International ISDN No. | |
JPegPhoto | varbinary(-1) | yes | Picture | |
LocalityName | nvarchar(-1) | yes | Location | |
Mail | nvarchar(800) | yes | Email address | |
MobileTelephoneNumber | nvarchar(-1) | yes | Mobile phone | |
OrganizationalStatus | nvarchar(40) | yes | Organizational position | |
OtherMailBox | nvarchar(-1) | yes | Additional email addresses | |
PagerTelephoneNumber | nvarchar(-1) | yes | Pager | |
PersonalTitle | nvarchar(144) | yes | Title | |
PhysicalDeliveryOfficeName | nvarchar(-1) | yes | Office | |
PostalAddress | nvarchar(-1) | yes | Address | |
PostalCode | nvarchar(60) | yes | Zip code | |
PostOfficeBox | nvarchar(128) | yes | Mailbox | |
PreferredLanguage | nvarchar(60) | yes | Preferred language | |
RegisteredAddress | nvarchar(-1) | yes | Registered address | |
RoomNumber | nvarchar(128) | yes | Room | |
SeeAlso | nvarchar(-1) | yes | See also | |
SN | nvarchar(128) | yes | Last name | |
ST | nvarchar(128) | yes | State or province | |
Street | nvarchar(-1) | yes | Street | |
TelephoneNumber | nvarchar(-1) | yes | Phone | |
TextEncodedOrAddress | nvarchar(-1) | yes | X.400 address | |
Title | nvarchar(128) | yes | Job description | |
UIDLDAP | nvarchar(800) | yes | User ID | |
UserID | nvarchar(800) | yes | Login name | |
UserPassword | varchar(990) | yes | Password | |
X121Address | nvarchar(30) | yes | X.121 address | |
UID_LDAPAccountManager | varchar(38) | yes | LDAP account manager | FKUID |
UID_LDAPAccountSecretary | varchar(38) | yes | Secretary | FKUID |
IsGroupAccount | bit(1) | yes | Groups can be inherited | |
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 | |
AccountDisabled | bit(1) | yes | Account is disabled | |
ModifyTimeStamp | nvarchar(60) | yes | LDAP date last changed | |
ObjectGUID | varchar(40) | yes | Object GUID | |
XObjectKey | varchar(138) | no | Object key | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
MatchPatternForMembership | bigint(8) | yes | Category | |
RiskIndexCalculated | float(8) | yes | Risk index (calculated) | |
AccountExpires | datetime(8) | yes | Account expiry date | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_TSBAccountDef | varchar(38) | yes | Account definition | FKUID |
IsPrivilegedAccount | bit(1) | yes | Privileged account | |
UID_TSBBehavior | varchar(38) | yes | Manage level | FKUID |
StructuralObjectClass | nvarchar(512) | yes | Structural object class | |
UID_LDPDomain | varchar(38) | no | Domain | FKUID |
ObjectSID | nvarchar(512) | yes | Object SID (AD) | |
IdentityType | varchar(32) | yes | Identity type | limited |
NeverConnectToPerson | int(4) | yes | Not linked to an identity | bitmask |
IsNeverConnectManual | bit(1) | yes | No link to an identity required | |
EduPersonAffiliation | nvarchar(2048) | yes | Affiliation | |
EduPersonEntitlement | nvarchar(-1) | yes | Permissions | |
EduPersonNickname | nvarchar(2048) | yes | Nickname | |
EduPersonOrgDN | nvarchar(800) | yes | Institution | |
EduPersonOrgUnitDN | nvarchar(2048) | yes | Institution units | |
EduPersonPrimaryAffiliation | nvarchar(512) | yes | Primary affiliation | |
EduPersonPrimaryOrgUnitDN | nvarchar(800) | yes | Institution unit (primary) | |
EduPersonPrincipalName | nvarchar(800) | yes | User identifier | |
EduPersonPrincipalNamePrior | nvarchar(2048) | yes | Prior user identifier | |
EduPersonScopedAffiliation | nvarchar(2048) | yes | Scoped affiliation | |
EduPersonTargetedId | nvarchar(2048) | yes | Unique alias | |
EduPersonAssurance | nvarchar(2048) | yes | Level of assurance | |
EduPersonUniqueId | nvarchar(800) | yes | Global identifier | |
EduPersonOrcId | nvarchar(2048) | yes | ORCID Id(s) | |
EduPersonAnalyticsTag | nvarchar(-1) | yes | Analytics tag |
Relations
| FK | From | To |
|---|---|---|
| LDP_RFRL1329 | LDAPAccount.UID_LDAPContainer | LDAPContainer.UID_LDAPContainer |
| LDP_RFRL1338 | LDAPAccount.UID_Person | Person.UID_Person |
| LDP_RFRL2531 | LDAPAccount.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| LDP_RFRL2551 | LDAPAccount.UID_TSBBehavior | TSBBehavior.UID_TSBBehavior |
| LDP_RFRL2552 | LDAPAccount.UID_LDPDomain | LDPDomain.UID_LDPDomain |
| LDP_RFRL4362 | LDAPAccount.UID_LDAPCountryCode | DialogCountry.UID_DialogCountry |
Triggers
GEN_T1D537653BB17FEE84E10167B6 SQL_TRIGGER
GEN_T2742E4E1AEA8F0848F930F1B3 SQL_TRIGGER
GEN_T32514535467CA6605935F38FB SQL_TRIGGER
GEN_T455B9E89343CAF31DA0DD5DE7 SQL_TRIGGER
GEN_T5C1779AB54E0F71C5A75DB3F0 SQL_TRIGGER
GEN_T64A50AEF036399D9B6E7640DE SQL_TRIGGER
GEN_T6BFC93B485E11FC6882DC1266 SQL_TRIGGER
LDP_TATTULDAPAccount SQL_TRIGGER
LDP_TDLDAPAccount SQL_TRIGGER
LDP_TILDAPAccount SQL_TRIGGER
LDP_TULDAPAccount 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_FTEA0D4ED3FA20B8B03D99F9EA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA3BA487D25E0B51EEA031BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA9D6B5B4563C99194FBEE76 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD3B3D4A4AAE3E77B7F745E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD7441E90FFE1AE74985684 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO3077299134008999AC844A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO441C2F873660C363A87E18 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO88C3252E4822EEB5E56129 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO8EA948B41AC2A60335AE0F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOADB5D482192FECE896DB8D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY3660BE5A72C51D09E109D2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY510EB2AF297B8F844C83DA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY95BE8166C29BD1FD6991CC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA5065182EC53F911A8AB59 | 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.GEN_P9B87544E1325D45A63B7E4C95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB2F935A721940C6E32DB7B15C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSR22A763BC995A30B9B4F4498 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_PAfterMigrationJobCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_RAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZPersonHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6719C6F395ED676A7D718650 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA3AD537967B99F82C7D2C1DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T148F6ED9F193FD4CBF6BA2B9C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T19A29DFB4BAC18F420DE61685 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1CC003F287E0713C2B7CC2D12 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D2773C6ABA951AB4BE4AF3A3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D537653BB17FEE84E10167B6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EC48139AE7E14D6C89E12AA8 | 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_T22396B6B345D17F94404E153A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T24CBF08E0CBCE9927C4191610 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2742E4E1AEA8F0848F930F1B3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T289440C5249682B41CC407075 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2E88F37C316E6934F2860C898 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2F5BB23305889F65F798A6581 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T455B9E89343CAF31DA0DD5DE7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4906297FA0095B928C0D22E5E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T553B9FB5AC14B225E0456AC15 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5C1779AB54E0F71C5A75DB3F0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5F6AD473564BCE54D231FDB20 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TDLDAPGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TIBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUTSBBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAEA53D18BA2BC134D8A5C2F78 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_LDAPAccount · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_Person · 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.TSBAccountDefAndAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVAccountIsPrivDetectRule | 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 |
| LDAPContainer | referenced by foreign key from table | LDP_RFRL1329: LDAPAccount.UID_LDAPContainer -> LDAPContainer.UID_LDAPContainer |
| Person | referenced by foreign key from table | LDP_RFRL1338: LDAPAccount.UID_Person -> Person.UID_Person |
| TSBAccountDef | referenced by foreign key from table | LDP_RFRL2531: LDAPAccount.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| TSBBehavior | referenced by foreign key from table | LDP_RFRL2551: LDAPAccount.UID_TSBBehavior -> TSBBehavior.UID_TSBBehavior |
| LDPDomain | referenced by foreign key from table | LDP_RFRL2552: LDAPAccount.UID_LDPDomain -> LDPDomain.UID_LDPDomain |
| DialogCountry | referenced by foreign key from table | LDP_RFRL4362: LDAPAccount.UID_LDAPCountryCode -> DialogCountry.UID_DialogCountry |
| dbo.LDP_PAfterMigrationJobCreate | source text reference | creates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling |
| dbo.LDP_RAccountInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZAccountInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZPersonHasLDAPGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_TDLDAPGroupCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TIBaseTreeHasLDAPGroup | 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_TILDAPGroupCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TUBaseTreeHasLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPAccount | 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.LDP_TULDAPGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TUTSBBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |