Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
LAHD_LAH_Date varchar (6) VARCHAR2 (6 CHAR) varchar(6) varchar (6) false Date of data collection YYMMDD
LAHD_LAH_Hardware varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Metric identifier as is defined in LAH
LAHD_Client smallint NUMBER(38,0) smallint smallint false Client
LAHD_OType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Type of the object
LAHD_OName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the object for which the metric was collected
LAHD_Count bigint NUMBER(38,0) bigint bigint false The amount of metric units that were counted for the given Metric identifiers.
LAHD_SType varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Subtype of object
LAHD_LAH_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Metric name

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_LAHD_Date_Hardware LAHD_LAH_Date, LAHD_LAH_Hardware false false false false
NK_LAHD_Date LAHD_LAH_Date false false false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File