Schema PUBLIC

Table PMFM

Column Summary
Name SqlType Length Precision Scale Nullable Unique
PMFM_ID integer 255 19 2 false false
PMFM_DETECTION_THRESHOLD DECIMAL(38,7) 255 19 2 true false
PMFM_MAXIMUM_NUMBER_DECIMALS SMALLINT(12) 255 19 2 true false
PMFM_SIGNIF_FIGURES_NUMBER SMALLINT 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
PMFM_CM VARCHAR(2000) 255 19 2 true false
CREATION_DT TIMESTAMP 255 19 2 true false
UNIT_ID integer 255 19 2 false false
MATRIX_ID integer 255 19 2 false false
FRACTION_ID integer 255 19 2 false false
PAR_CD VARCHAR(40) 255 19 2 false false
METHOD_ID integer 255 19 2 false false
STATUS_CD VARCHAR(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


PMFM_CM


CREATION_DT


UNIT_ID


MATRIX_ID


FRACTION_ID


PAR_CD


METHOD_ID


STATUS_CD