Contains information about a virtual machines.
Column Name |
Key |
Datatype |
Null |
Description |
---|---|---|---|---|
VirtualMachineOID |
PK,FK |
binary(16) |
N |
internal ID number used as primary key. |
HostWorkstationOID |
|
binary(16) |
N |
identifies the workstation that hosts this VM. |
VMDisplayName |
|
nvarchar(100) |
|
The virtual machine display name. |
VMGuestOS |
|
nvarchar(100) |
|
The virtual machine operating system. |
VMType |
|
tinyint |
N |
The virtual machine type. |
VMEthernetAddress |
|
nvarchar(12) |
|
The virtual machine Ethernet address. |
VMUUID |
|
nvarchar(36) |
|
The virtual machine UID. |
NOTE:
VMType: 0=None, 1 = Unknown, 2 = VMware, 3 = VirtualPC
FK References:
FK_VirtualMachine_WkstnOID: HostWorkstationOID references NC_Workstation.WorkstationOID
Indexes:
IDX_VirtualMachine_WkstnOID: HostWorkstationOID
Check Constraints:
CK_VirtualMachine_VMType: VMType between 1 and 3 (inclusive)