Owner's Manual

70 Reporting and Task Management
Volume Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
VolumeNumber* int 4 Yes Instance number of the volume
entry.
VolumeDriveLetter nvarchar 64 Yes The volume's path (or drive
letter) according to the
operating system.
VolumeLabel nvarchar 256 Yes The user-definable label for this
volume.
VolumeSize int 4 Yes The size of the volume in
megabytes.
Firmware Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
FirmwareChassisIndex* int 4 No The firmware chassis index
(zero based).
FirmwareIndex* int 4 No The firmware index (zero
based).
FirmwareType nvarchar 64 Yes The firmware type.
FirmwareName nvarchar 64 Yes The name of the firmware.
FirmwareVersion nvarchar 64 Yes The firmware version.
MemoryDevice Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
MemoryDeviceChassisIndex* int 4 No This attribute defines the index
(one based) of the associated
chassis.
MemoryDeviceIndex* int 4 No This attribute defines the index
(one based) of the memory
device.
MemoryDeviceName nvarchar 256 Yes This attribute defines the
location of the memory device.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description