dbo.ADSMachineInADSSite
Active Directory computers: site assignments
TableType TUsage USERDATARows 1SizeMB 0.024
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSMachine | varchar(38) | no | Computer | PKFKUID |
UID_ADSSite | varchar(38) | no | Site | PKFKUID |
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 |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL1301 | ADSMachineInADSSite.UID_ADSSite | ADSSite.UID_ADSSite |
| ADS_RFRL1302 | ADSMachineInADSSite.UID_ADSMachine | ADSMachine.UID_ADSMachine |
Triggers
GEN_T3E35FCAC0092C74F9F2167EF9 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_T5721EB8EE65CDF36B3D9F00F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5C23759E952DF136181115CCB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · UID_ADSMachine · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| ADSSite | referenced by foreign key from table | ADS_RFRL1301: ADSMachineInADSSite.UID_ADSSite -> ADSSite.UID_ADSSite |
| ADSMachine | referenced by foreign key from table | ADS_RFRL1302: ADSMachineInADSSite.UID_ADSMachine -> ADSMachine.UID_ADSMachine |