Schema PUBLIC

Table MONITORING_LOCATION

Column Summary
Name SqlType Length Precision Scale Nullable Unique
MON_LOC_ID integer 255 19 2 false false
MON_LOC_NM VARCHAR(100) 255 19 2 false false
MON_LOC_BATHYM DECIMAL(38,7) 255 19 2 true false
MON_LOC_CM VARCHAR(2000) 255 19 2 true false
MON_LOC_LB VARCHAR(50) 255 19 2 true false
MON_LOC_UT_FORMAT DOUBLE 255 19 2 true false
MON_LOC_DAYLIGHT_SAVING_TIME VARCHAR(1) 255 19 2 true false
MON_LOC_POSITION_PATH_NM VARCHAR(100) 255 19 2 true false
MON_LOC_CREATION_DT TIMESTAMP 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
STATUS_CD VARCHAR(40) 255 19 2 false false
HARBOUR_CD VARCHAR(40) 255 19 2 true false
POS_SYSTEM_ID integer 255 19 2 false false
Primary Key
Name Columns
MONITORING_LOPK MON_LOC_ID
Foreign Keys
Name Referenced Table Columns
MONITORING_LOCATION_STATUS_CDC STATUS STATUS_CD
MONITORING_LOCATION_HARBOUR_CC HARBOUR HARBOUR_CD
MONITORING_LOCATION_POS_SYSTEC POSITIONNING_SYSTEM POS_SYSTEM_ID

Column Detail

MON_LOC_ID

MON_LOC_NM

MON_LOC_BATHYM

MON_LOC_CM

MON_LOC_LB

MON_LOC_UT_FORMAT

MON_LOC_DAYLIGHT_SAVING_TIME

MON_LOC_POSITION_PATH_NM

MON_LOC_CREATION_DT

UPDATE_DT

STATUS_CD

HARBOUR_CD

POS_SYSTEM_ID