MachineGroup
m:n relation between machines and groups.
erDiagram
Group ||--o{ MachineGroup : "GroupID"
Machine ||--o{ MachineGroup : "MachineID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this relation was created in the database |
| GroupID |
numeric |
Internal ID that references the Group entity (Foreign Key) |
| ID |
numeric |
Internal ID for the MachineGroup entity (Primary Key) |
| LastScan |
datetime |
Last scan of this relation |
| MachineID |
numeric |
Internal ID that references the Machine entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| GroupID |
Group |
Group of users or machines |
| 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. |