Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
PMMAV_PMMA_Idnr int NUMBER(38,0) int int false Identification of metrics values
PMMAV_Key varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Key of metric
PMMAV_Value int NUMBER(38,0) int int false Value of metric
PMMAV_Timestamp datetime DATE timestamp timestamp true Timestamp of measured metric. Must not be after PMMA_Timestamp of FK_PMMAV_PMMA row.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_PMMAV PMMAV_PMMA_Idnr, PMMAV_Key true true true false
NK_PMMAV_Timestamp PMMAV_Timestamp false false false false

Foreign Keys:

Name Local References Foreign References
FK_PMMAV_PMMA PMMAV_PMMA_Idnr PMMA_Idnr

Return to the Index File