Schema Q2DBA

Table PMFM

Column Summary
Name SqlType Length Precision Scale Nullable Unique
PMFM_ID NUMBER(18) 255 19 2 false false
PMFM_DETECTION_THRESHOLD NUMBER(38,7) 255 19 2 true false
PMFM_MAXIMUM_NUMBER_DECIMALS NUMBER(12) 255 19 2 true false
PMFM_SIGNIF_FIGURES_NUMBER NUMBER(18) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 false false
UNIT_ID NUMBER(18) 255 19 2 false false
MATRIX_ID NUMBER(18) 255 19 2 false false
FRACTION_ID NUMBER(18) 255 19 2 false false
PAR_CD VARCHAR2(40) 255 19 2 false false
METHOD_ID NUMBER(18) 255 19 2 false false
STATUS_CD VARCHAR2(40) 255 19 2 false false
Primary Key
Name Columns
PMFMPK PMFM_ID
Foreign Keys
Name Referenced Table Columns
PMFM_UNIT_IDC UNIT UNIT_ID
PMFM_MATRIX_IDC MATRIX MATRIX_ID
PMFM_FRACTION_IDC FRACTION FRACTION_ID
PMFM_PAR_CDC PARAMETER PAR_CD
PMFM_METHOD_IDC METHOD METHOD_ID
PMFM_STATUS_CDC STATUS STATUS_CD

Column Detail

PMFM_ID

PMFM_DETECTION_THRESHOLD

PMFM_MAXIMUM_NUMBER_DECIMALS

PMFM_SIGNIF_FIGURES_NUMBER

UPDATE_DT

UNIT_ID

MATRIX_ID

FRACTION_ID

PAR_CD

METHOD_ID

STATUS_CD