MachineCluster
m:n relation between machines and clusters.
erDiagram
Cluster ||--o{ MachineCluster : "ClusterID"
Machine ||--o{ MachineCluster : "MachineID"
Fields
| Field |
Type |
Description |
| ClusterID |
numeric |
Internal ID that references the Cluster entity (Foreign Key) |
| Created |
datetime |
Date/Time this relation was created in the database |
| CreatedGUID |
guid |
GUID of the scan that created this relation |
| ID |
numeric |
Internal ID for the MachineCluster entity (Primary Key) |
| LastScan |
datetime |
Date/Time this relation was last scanned |
| LastScanGUID |
guid |
GUID of the last scan for this relations |
| MachineID |
numeric |
Internal ID that references the Machine entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| ClusterID |
Cluster |
Cluster information |
| MachineID |
Machine |
Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet. |