SoftwareItemMachine
M:n SoftwareItem to Machine relation, for Items that are linked to specific machines.
erDiagram
Machine ||--o{ SoftwareItemMachine : "MachineID"
SoftwareItem ||--o{ SoftwareItemMachine : "SoftwareItemID"
SoftwareItemAssignmentReason ||--o{ SoftwareItemMachine : "SoftwareItemAssignmentReasonID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this relation was created |
| CreatedBy |
string |
User that created this relation |
| ExtraData |
string |
Reserved for future use |
| ID |
numeric |
Internal ID for the SoftwareItemMachine entity (Primary Key) |
| LastModification |
datetime |
Date/Time this relation was last modified |
| LastModifiedBy |
string |
User that last modified this relation |
| MachineID |
numeric |
Internal ID that references the Machine entity (Foreign Key) |
| Res1 |
string |
Reserved for future use |
| Res2 |
string |
Reserved for future use |
| SoftwareItemAssignmentReasonID |
numeric |
Internal ID that references the SoftwareItemAssignmentReason entity (Foreign Key) |
| SoftwareItemID |
numeric |
Internal ID that references the SoftwareItem entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| 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. |
| SoftwareItemAssignmentReasonID |
SoftwareItemAssignmentReason |
Defines reasons why a software item is assigned to a user, group or machine |
| SoftwareItemID |
SoftwareItem |
Software items hold customer specific information about software objects |