Basic information on all hardware found in inventories
Fields
Field | Type | Description |
---|---|---|
device_count | INT | Number of devices that own that hardware |
hardware_id | BIGINT | Hardware code primary key |
hardware_type | INT | Hardware type code |
manufacturer | NVARCHAR (1024) | Hardware Manufacturer |
name | NVARCHAR (512) | Hardware Name |
type* | VARCHAR (15) | Hardware Type |
type_hardware_id* | INT | Hardware code foreign key |