Schema PUBLIC

Table FIELD_OBSERVATION

Column Summary
Name SqlType Length Precision Scale Nullable Unique
FIELD_OBSERV_ID integer 255 19 2 false false
FIELD_OBSERV_NM VARCHAR(100) 255 19 2 true false
FIELD_OBSERV_CM VARCHAR(2000) 255 19 2 true false
FIELD_OBSERV_VALID_DT TIMESTAMP 255 19 2 true false
FIELD_OBSERV_QUALIF_DT TIMESTAMP 255 19 2 true false
FIELD_OBSERV_QUALIF_CM VARCHAR(2000) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
REMOTE_ID integer 255 19 2 true false
SURVEY_ID integer 255 19 2 false false
REC_DEP_ID integer 255 19 2 false false
OBSERV_TYP_CD VARCHAR(40) 255 19 2 false false
QUAL_FLAG_CD VARCHAR(40) 255 19 2 false false
Primary Key
Name Columns
FIELD_OBSERVAPK FIELD_OBSERV_ID
Foreign Keys
Name Referenced Table Columns
FIELD_OBSERVATION_SURVEY_IDC SURVEY SURVEY_ID
FIELD_OBSERVATION_REC_DEP_IDC DEPARTMENT REC_DEP_ID
FIELD_OBSERVATION_OBSERV_TYP_C OBSERVATION_TYPOLOGY OBSERV_TYP_CD
FIELD_OBSERVATION_QUAL_FLAG_CC QUALITY_FLAG QUAL_FLAG_CD

Column Detail

FIELD_OBSERV_ID

FIELD_OBSERV_NM

FIELD_OBSERV_CM

FIELD_OBSERV_VALID_DT

FIELD_OBSERV_QUALIF_DT

FIELD_OBSERV_QUALIF_CM

UPDATE_DT

REMOTE_ID

SURVEY_ID

REC_DEP_ID

OBSERV_TYP_CD

QUAL_FLAG_CD