| Column Summary | ||||||
|---|---|---|---|---|---|---|
| Name | SqlType | Length | Precision | Scale | Nullable | Unique |
| MON_LOC_ID | NUMBER(18) | 255 | 19 | 2 | false | false |
| MON_LOC_NM | VARCHAR2(100) | 255 | 19 | 2 | false | false |
| MON_LOC_BATHYM | NUMBER(38,7) | 255 | 19 | 2 | true | false |
| MON_LOC_CM | VARCHAR2(2000) | 255 | 19 | 2 | true | false |
| MON_LOC_LB | VARCHAR2(50) | 255 | 19 | 2 | true | false |
| MON_LOC_UT_FORMAT | NUMBER(38,15) | 255 | 19 | 2 | true | false |
| MON_LOC_DAYLIGHT_SAVING_TIME | VARCHAR2(1) | 255 | 19 | 2 | true | false |
| MON_LOC_POSITION_PATH_NM | VARCHAR2(100) | 255 | 19 | 2 | true | false |
| MON_LOC_CREATION_DT | DATE | 255 | 19 | 2 | true | false |
| UPDATE_DT | TIMESTAMP | 255 | 19 | 2 | false | false |
| STATUS_CD | VARCHAR2(40) | 255 | 19 | 2 | false | false |
| HARBOUR_CD | VARCHAR2(40) | 255 | 19 | 2 | true | false |
| POS_SYSTEM_ID | NUMBER(18) | 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