Owner's Manual

190 Reporting
DeviceCardManufacturer nvarchar 64 Yes This attribute defines
the name of the
manufacturer of the
PCI device.
DeviceCardDescription nvarchar 256 Yes This attribute defines
the description of the
PCI device.
DeviceCardDataBuswidth nvarchar 64 Yes This attribute defines
the width of the data
bus of the PCI device.
DeviceCardBusSpeed int 4 Yes This attribute defines
the bus speed in MHz
of the PCI device. Zero
indicates the speed is
unknown.
DeviceCardAdapterSpeed int 4 Yes This attribute defines
the adapter speed of the
PCI device.
DeviceCardSlotLength nvarchar 64 Yes This attribute defines
the slot length of the
PCI device.
Enclosure Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
EnclosureNumber* int 4 No The instance number
of the enclosure entry.
EnclosurePartNumber nvarchar 64 Yes The part number of
the enclosure entry.
EnclosureSerialNumber nvarchar 64 Yes The serial number of
the enclosure entry.
EnclosureName nvarchar 256 Yes The enclosure's name.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description