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. |
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 |
Name | Local References | Foreign References |
---|---|---|
FK_PMMAV_PMMA | PMMAV_PMMA_Idnr | PMMA_Idnr |
Return to the Index File