Schema PUBLIC

Table PHOTO

Column Summary
Name SqlType Length Precision Scale Nullable Unique
PHOTO_ID integer 255 19 2 false false
OBJECT_ID integer 255 19 2 false false
PHOTO_NM VARCHAR(100) 255 19 2 true false
PHOTO_DIR_DC VARCHAR(255) 255 19 2 true false
PHOTO_CM VARCHAR(2000) 255 19 2 true false
PHOTO_LK VARCHAR(255) 255 19 2 true false
PHOTO_DT TIMESTAMP 255 19 2 true false
PHOTO_VALID_DT TIMESTAMP 255 19 2 true false
PHOTO_QUALIF_DT TIMESTAMP 255 19 2 true false
PHOTO_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
SAMPLE_ID integer 255 19 2 true false
PHOTO_TYPE_CD VARCHAR(40) 255 19 2 true false
QUAL_FLAG_CD VARCHAR(40) 255 19 2 true false
OBJECT_TYPE_CD VARCHAR(40) 255 19 2 false false
REC_DEP_ID integer 255 19 2 false false
SURVEY_ID integer 255 19 2 true false
SAMPLING_OPER_ID integer 255 19 2 true false
Primary Key
Name Columns
PHOTOPK PHOTO_ID
Foreign Keys
Name Referenced Table Columns
PHOTO_SAMPLE_IDC SAMPLE SAMPLE_ID
PHOTO_PHOTO_TYPE_CDC PHOTO_TYPE PHOTO_TYPE_CD
PHOTO_QUAL_FLAG_CDC QUALITY_FLAG QUAL_FLAG_CD
PHOTO_OBJECT_TYPE_CDC OBJECT_TYPE OBJECT_TYPE_CD
PHOTO_REC_DEP_IDC DEPARTMENT REC_DEP_ID
PHOTO_SURVEY_IDC SURVEY SURVEY_ID
PHOTO_SAMPLING_OPER_IDC SAMPLING_OPERATION SAMPLING_OPER_ID

Column Detail

PHOTO_ID


OBJECT_ID


PHOTO_NM


PHOTO_DIR_DC


PHOTO_CM


PHOTO_LK


PHOTO_DT


PHOTO_VALID_DT


PHOTO_QUALIF_DT


PHOTO_QUALIF_CM


UPDATE_DT


REMOTE_ID


SAMPLE_ID


PHOTO_TYPE_CD


QUAL_FLAG_CD


OBJECT_TYPE_CD


REC_DEP_ID


SURVEY_ID


SAMPLING_OPER_ID