Owner's Manual

190 Reporting
DeviceId* int 4 No The Foreign Key to the
Device Table.
VolumeNumber* int 4 Yes Instance number of
the volume entry.
Vol umeDrive Lett er nvarchar 64 Yes The volume's path (or
drive letter) according
to the operating
system.
Vol umeLa bel nvarchar 256 Yes The user-definable
label for this volume.
Vol umeSize int 4 Yes The size of the volume
in megabytes.
Firmware Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
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 Table.
MemoryDeviceChassisIndex* int 4 No This attribute defines
the index (one based)
of the associated
chassis.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description