inv_bios

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ComputerID INT 10 null
BIOSVendor VARCHAR 255 null
BIOSVersion VARCHAR 255 null
BIOSDate VARCHAR 255 null
BIOSSize INT 10 null
SYSBIOSVersion DECIMAL 10,2 null
EMBCTLVersion DECIMAL 10,2 null
SMBiosVersion DECIMAL 10,2 null
DMIVersion INT 10 null
ACPISupport TINYINT 3 null
APMSupport TINYINT 3 null
AGPSupport TINYINT 3 null
PCMCIASupport TINYINT 3 null
SmartBattery TINYINT 3 null
UEFISupport TINYINT 3 null
USBLegacySupport TINYINT 3 null
PCISupport TINYINT 3 null
VLVESASupport TINYINT 3 null
ESCDSupport TINYINT 3 null
NetBootSupport TINYINT 3 null
I2OBootSupport TINYINT 3 null
VirtualMachine TINYINT 3 null
PowerOnReason INT 10 null
BIOSChar INT 10 null
Portable TINYINT 3 null
VMhost VARCHAR 255 null
VMType VARCHAR 255 null
VMName VARCHAR 255 null
DateUpdated TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ComputerID

Diagram producer might be missing

No diagrams were produced please see application output for any errors