Owner's Manual

Reporting 205
ContactInfo Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
ContactName* nvarchar 64 No The contact name.
ContactInformation nvarchar 64 Yes The information for
this contact.
ContactDescription nvarchar 64 Yes The description for
this contact.
Cluster Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
ClusterIndex* int 4 No The cluster index.
ClusterType int 4 Yes The cluster type.
ClusterTypeName nvarchar 64 Yes The cluster type name.
ClusterName nvarchar 255 Yes The cluster name.
ClusterDescription nvarchar 255 Yes The cluster
description.
FRU Information Table
DeviceId* int 4 No The device ID.
FRUChassisindex* int 4 No The field replaceable
unit (FRU) chassis
index.
FRUIndex* int 4 No The FRU index.
FRUDeviceName nvarchar 255 Yes The FRU device name.
FRUManufacturer nvarchar 255 Yes The FRU
manufacturer name.
FRUSerialNumber nvarchar 255 Yes The FRU serial
number.
FRUPartNumber nvarchar 255 Yes The FRU part number.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description