Name Type MSSql Type Oracle Type DB2 Nullable Description
PMID_Idnr int NUMBER(38,0) int false Identification of issue definition
PMID_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) false Issue name
PMID_TrigExpr varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT false Triggering boolean expression
PMID_Severity smallint NUMBER(38,0) smallint false Severity of issue (1-low to 3-high)
PMID_MSG_Idnr int NUMBER(38,0) int false MLS id
PMID_Quitted smallint NUMBER(38,0) smallint false Is this issue quitted by the user (0: quit missing, 1: is quitted)
PMID_Count int NUMBER(38,0) int false Counted issues in this interval (for compressing)
PMID_Interval int NUMBER(38,0) int false Interval of issue definition in minutes (for compressing)
PMID_Threshold smallint NUMBER(38,0) smallint true Threshold of metrics matching to discover issue (n out of 100)
PMID_Active smallint NUMBER(38,0) smallint true Issue discovering active/inactive

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_PMID PMID_Idnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File