inv_chassis

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ComputerID INT 10 null
Manufacturer VARCHAR 255 null
ProductName VARCHAR 255 null
products.ProductName Implied ConstraintR
Version VARCHAR 255 null
SerialNumber VARCHAR 255 null
UUID VARCHAR 32 null
SKUNumber VARCHAR 255 null
Family VARCHAR 255 null
ChassisType VARCHAR 255 null
ChassisLock TINYINT 3 null
AssetTag VARCHAR 255 null
HeightUnits INT 10 null
SystemBootState INT 10 null
PowerSupplyBootState INT 10 null
ThermalBootState INT 10 null
MBProduct VARCHAR 255 null
MBSerialNumber VARCHAR 255 null
MBVersion VARCHAR 255 null
MBManufacturer VARCHAR 255 null
DateUpdated TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

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

Relationships

Close relationships within degrees of separation