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