dbo.LDPMachine
LDAP computers
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_LDPMachine | varchar(38) | no | Computer | PKUID |
UID_Hardware | varchar(38) | yes | Device | FKUID |
UID_LDAPContainer | varchar(38) | yes | Container | FKUID |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
ObjectClass | nvarchar(2048) | yes | Object class | |
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 | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
cn | nvarchar(128) | yes | Name | |
StructuralObjectClass | nvarchar(512) | yes | Structural object class | |
UID_LDPDomain | varchar(38) | no | Domain | FKUID |
Relations
| FK | From | To |
|---|---|---|
| LDP_RFRL2453 | LDPMachine.UID_Hardware | Hardware.UID_Hardware |
| LDP_RFRL2554 | LDPMachine.UID_LDPDomain | LDPDomain.UID_LDPDomain |
Triggers
GEN_T13F11A5B62DAA3051A01E8B5F SQL_TRIGGER
GEN_T2E665EA3780D6E4DA3CD23E5F SQL_TRIGGER
GEN_T38328B47AD5B1C3F81CC38009 SQL_TRIGGER
GEN_T5B02F7943DEB671EC9B4DCDE4 SQL_TRIGGER
GEN_T64C750E556C65FA151B3DE18A SQL_TRIGGER
LDP_TILDPMachine SQL_TRIGGER
LDP_TULDPMachine 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.LDP_RLDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZAllForOneHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZAllForOneWorkDesk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZWorkDeskInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AED260340D040570CA4B3A61 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T223962B688CF6CCA1B0A830C6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4FCB6A4B24280E57D68698951 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5AD66EB14BA05645CF6CF0E9C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5B02F7943DEB671EC9B4DCDE4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CFD1B173A2279589C6E3B7AB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TIBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDPMachine | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDPMachine | SQL expression dependency | 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.QERVHardwareAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDirectAssignWrong | SQL expression dependency | OBJECT_OR_COLUMN |
| Hardware | referenced by foreign key from table | LDP_RFRL2453: LDPMachine.UID_Hardware -> Hardware.UID_Hardware |
| LDPDomain | referenced by foreign key from table | LDP_RFRL2554: LDPMachine.UID_LDPDomain -> LDPDomain.UID_LDPDomain |
| dbo.LDP_RLDPMachineInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZAllForOneHardware | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_ZAllForOneWorkDesk | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_ZLDPMachineInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZWorkDeskInLDAPGroup | source text reference | inserts DBQueue tasks, 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_TILDPMachine | 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_TUHardware | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDPMachine | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |