Users Guide

78 Reporting and Task Management
DepreciationPercentage nvarchar 64 Yes The depreciation percentage.
DepreciationMethod nvarchar 64 Yes The depreciation method.
RegistrationIsRegistered nvarchar 64 Yes The registration is registered.
ContactInfo Table
DeviceId* int 4 No The foreign key to the Device
Ta b l e.
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
Ta b l e.
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.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description