ERD_ALL
Tables (38)
ADDR_SAFETY_REL_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- SEQUENCE_NUM — INTEGER
- DESTINATION_ID — VARCHAR(9)
- RETRANSMIT_FLAG — INTEGER
- SAFETY_TEXT — VARCHAR(4000)
AIS_ADDR_BINARY_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- SEQUENCE_NUM — INTEGER
- DESTINATION_ID — VARCHAR(9)
- RETRANSMIT_FLAG — INTEGER
- DAC — INTEGER
- FI — INTEGER
- IFM — INTEGER
- ACK_REQ_FLAG — INTEGER
- TEXT_SEQUENCE_NUM — INTEGER
- TEXT_STRING — VARCHAR(4000)
- REQ_DAC_CODE — INTEGER
- REQ_FI_CODE — INTEGER
- DAC_CODE — INTEGER
- FI_AVAILABILITY — VARCHAR(10)
- FUNCTIONAL_DAC_MSG — VARCHAR(4000)
- FUNCTIONAL_FI_MSG — VARCHAR(4000)
- AI_AVAILABLE — VARCHAR(10)
- AI_RESPONSE — VARCHAR(4000)
AIS_DYN_MSG_A
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- SOURCE_LATITUDE — DOUBLE
- SOURCE_LONGITUDE — DOUBLE
- POSITION_ACCURACY — INTEGER
- SOG — DOUBLE
- COG — DOUBLE
- HEADING — DOUBLE
- SYNC_STATE — VARCHAR(20)
- SLOT_TIME_OUT — INTEGER
- SUB_MESSAGE — VARCHAR(4000)
AIS_DYN_MSG_NO_A
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- SOURCE_LATITUDE — DOUBLE
- SOURCE_LONGITUDE — DOUBLE
- POSITION_ACCURACY — INTEGER
- SOG — DOUBLE
- COG — DOUBLE
- ALTITUDE — DOUBLE
- COMM_STATE_SELECTOR — INTEGER
- SYNC_STATE — VARCHAR(20)
- SLOT_TIME_OUT — INTEGER
- SUB_MESSAGE — VARCHAR(4000)
- SLOT_INCREMENT — INTEGER
- SLOT_NUMBER — INTEGER
- KEEP_FLAG — CHAR(1)
AIS_STAT_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- SHIP_CLASS — VARCHAR(20)
- SHIP_NAME — VARCHAR(100)
- SHIP_TYPE — VARCHAR(20)
- CALL_SIGN — VARCHAR(20)
- SHIP_LENGTH — DOUBLE
- SHIP_WIDTH — DOUBLE
- POSITION_FIX_DEVICE — VARCHAR(20)
- IMO_NUM — VARCHAR(7)
- STATIC_DRAUGHT — DOUBLE
- DESTINATION — VARCHAR(200)
- ETA — VARCHAR(30)
- PART_NUMBER — INTEGER
ASM_0_BCAST_MSG (ASM_0_BCAST_AIS_ASM)
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- REPEAT_INDICATOR — INTEGER
- SESSION_ID — INTEGER
- DATA_COUNT — INTEGER
- BINARY_DATA — VARCHAR(4000)
ASM_5_ACK
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- REPEAT_INDICATOR — INTEGER
- SESSION_ID — INTEGER
- DESTINATION_ID — VARCHAR(9)
- ACK_NACK_MASK — INTEGER
- CODING_RATE_ADAPTION_REQ — INTEGER
- CHANNEL_QUALITY_INDICATOR — INTEGER
- ZERO_PADDING — INTEGER
ASM_6_GEO_MULTICAST
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- REPEAT_INDICATOR — INTEGER
- SESSION_ID — INTEGER
- LONGITUDE_1 — DOUBLE
- LATITUDE_1 — DOUBLE
- LONGITUDE_2 — DOUBLE
- LATITUDE_2 — DOUBLE
- DATA_COUNT — INTEGER
- SPARE_BITS — INTEGER
- ASM_IDENTIFIER — INTEGER
- BINARY_DATA — VARCHAR(4000)
ASM_SCHED_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- REPEAT_INDICATOR — INTEGER
- SESSION_ID — INTEGER
- DESTINATION_ID — VARCHAR(9)
- DATA_COUNT — INTEGER
- ASM_IDENTIFIER — INTEGER
- BINARY_DATA — VARCHAR(4000)
- TRANSMIT_BLOCK_COUNTER — INTEGER
- BLOCK_IDENTIFIER — INTEGER
- SLOT_INCREMENT_1 — INTEGER
- NUM_SLOTS_1 — INTEGER
- SLOT_INCREMENT_2 — INTEGER
- NUM_SLOTS_2 — INTEGER
- SLOT_INCREMENT_3 — INTEGER
- NUM_SLOTS_3 — INTEGER
ASM_UNSCHED_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED (Key) — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- REPEAT_INDICATOR — INTEGER
- SESSION_ID — INTEGER
- DESTINATION_ID — VARCHAR(9)
- DATA_COUNT — INTEGER
- ASM_IDENTIFIER — INTEGER
- BINARY_DATA — VARCHAR(4000)
COAST_STATION_INFO
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- CTR_MMSI (CTR_MMSI2) — VARCHAR(9) — Foreign key → CTR_STATION_INFO.CTR_MMSI
- COAST_LATITUDE — DOUBLE
- COAST_LONGITUDE — DOUBLE
- COVERAGE_RANG — DOUBLE
CTR_STATION_INFO
- CTR_MMSI — VARCHAR(9) — Primary key — NOT NULL
- CTR_STATION_NM — VARCHAR(100)
- CTR_LATITUDE — DOUBLE
- CTR_LONGITUDE — DOUBLE
- COUNTRY_NM — VARCHAR(100)
- TX_POWER_W — DOUBLE
- RCC_NM — VARCHAR(100)
CTR_ZONE_SHIP_CNT
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- SNAPSHOT_TIME — VARCHAR(30) — Primary key — NOT NULL
- TOTAL_SHIP_CNT — INTEGER
- AIS_SHIP_CNT — INTEGER
- ASM_SHIP_CNT — INTEGER
- VDE_SHIP_CNT — INTEGER
FOCUS_SHIP_SUMMARY
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- STAT_DATE — VARCHAR(30) — Primary key — NOT NULL
- MANAGE_CENTER_ID — VARCHAR(9)
- MAIN_RULE_ID — VARCHAR(50)
- MAIN_RULE_NAME — VARCHAR(200)
- FIRST_DETECTED_AT — VARCHAR(30)
- LAST_DETECTED_AT — VARCHAR(30)
- LAST_MSG_TYPE — INTEGER
- VIOLATION_COUNT_TOTAL — INTEGER
- STATUS — VARCHAR(20)
- REMARK — VARCHAR(4000)
- CREATED_AT — VARCHAR(30)
- UPDATED_AT — VARCHAR(30)
- CREATED_BY — VARCHAR(50)
- UPDATED_BY — VARCHAR(50)
INTEGRITY_VIOLATION_EVENT_LOG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- MSG_TYPE — INTEGER
- RULE_ID — VARCHAR(50)
- RECEIVE_STATION_ID — VARCHAR(9)
- DETAIL_JSON — TEXT
- RISK_SCORE (Field) — DOUBLE
- RISK_LEVEL (Field2) — VARCHAR(10)
INTERRO_REQ
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- DESTINATION_MMSI_1 — VARCHAR(9)
- MESSAGE_ID_1 — INTEGER
- SLOT_OFFSET_1_1 — INTEGER
- MESSAGE_ID_1_1 — INTEGER
- SLOT_OFFSET_1_2 — INTEGER
- MESSAGE_ID_1_2 — INTEGER
- SLOT_OFFSET_2 — INTEGER
- MESSAGE_ID_2 — INTEGER
- REQ_MSG_RECEIVED_FLAG_1 — INTEGER
- REQ_MSG_RECEIVED_TIME_1 — VARCHAR(30)
- REQ_MSG_RECEIVED_FLAG_2 — INTEGER
- REQ_MSG_RECEIVED_TIME_2 — VARCHAR(30)
MSG_STATS_BY_MESSAGE
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- STAT_TIME_UTC — VARCHAR(30) — Primary key — NOT NULL
- CHANNEL_A_COUNT — INTEGER
- CHANNEL_B_COUNT — INTEGER
- MSG_TOTAL_COUNT — INTEGER
- DYN_MSG_COUNT — INTEGER
- STAT_MSG_COUNT — INTEGER
- CTRL_MSG_COUNT — INTEGER
- QUERY_MSG_COUNT — INTEGER
- RESP_MSG_COUNT — INTEGER
- USED_SLOT_COUNT — INTEGER
MSG_STATS_BY_STATION
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- STAT_TIME_UTC — VARCHAR(30) — Primary key — NOT NULL
- MSG_TOTAL_COUNT — INTEGER
- DYN_MSG_COUNT — INTEGER
- STAT_MSG_COUNT — INTEGER
- CTRL_MSG_COUNT — INTEGER
NMEA_TYPE
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- TALKER_ID — VARCHAR(10)
- SENTENCE_ID — VARCHAR(10)
- TOTAL_SENTENCES_NUM — INTEGER
- SENTENCE_NUM — INTEGER
- SEQUENTIAL_IDENTIFIER — INTEGER
- CHANNEL — VARCHAR(5)
- SOURCE_MMSI — VARCHAR(9)
- NUMBER_FILL_BIT — INTEGER
- NMEA_CRC_OK (Field) — BOOLEAN
SHIP_INFO
- IMO_NO — VARCHAR(7) — Primary key — NOT NULL
- MMSI — VARCHAR(9)
- FLAG — VARCHAR(3)
- FLAG_NM — VARCHAR(100)
- GRS_TN — DOUBLE
- INT_TN — DOUBLE
- NET_TN — DOUBLE
- REG_PRT_AREA — VARCHAR(20)
- REG_PRT_AREA_NM — VARCHAR(100)
- REG_PRT_CTRY — VARCHAR(3)
- REG_PRT_CTRY_NM — VARCHAR(100)
- SHP_OPER_FLAG — VARCHAR(3)
- SHP_OPER_FLAG_NM — VARCHAR(100)
- SHP_OPER_ID — VARCHAR(50)
- VSSL_ALL_LEN — DOUBLE
- VSSL_WIDTH — DOUBLE
- VSSL_BUILD_DT — VARCHAR(10)
- VSSL_DEF_BRD — DOUBLE
- VSSL_DEPTH — DOUBLE
- VSSL_ENG_NM — VARCHAR(100)
- VSSL_KOR_NM — VARCHAR(100)
- VSSL_LEN — DOUBLE
- VSSL_NO — VARCHAR(50)
- VSSL_TP — VARCHAR(20)
- VSSL_TP_NM — VARCHAR(100)
- TANK_DOUBLE_HULL_YN — CHAR(1)
- CALL_LETTER — VARCHAR(20)
- INT_NAT_CERTIFICATE — VARCHAR(20)
- DEAD_WEIGHT — DOUBLE
- INT_NAT_CERTIFICATE_NM — VARCHAR(100)
- BF_CALL_LETTER — VARCHAR(20)
SHIP_TRACK
- MMSI — VARCHAR(9) — Primary key — NOT NULL
- POS_TIME_UTC — VARCHAR(30) — Primary key — NOT NULL
- BASE_DATE — VARCHAR(10)
- SOURCE_STATION — VARCHAR(9)
- LATITUDE — DOUBLE
- LONGITUDE — DOUBLE
- SOG — DOUBLE
- COG — DOUBLE
- HEADING — DOUBLE
- NAV_STATUS — INTEGER
- ROT_DEG — DOUBLE
- MSG_TYPE — INTEGER
SIGNAL_INFORMATION
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- TOA — VARCHAR(30) — Primary key — NOT NULL
- TALKER_ID — VARCHAR(10)
- SENTENCE_ID — VARCHAR(10)
- SLOT_NUM — INTEGER
- RSSI — DOUBLE
- SNR — DOUBLE
SIGNAL_QUALITY_STATS
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- STAT_TIME_UTC — VARCHAR(30) — Primary key — NOT NULL
- CHANNEL — VARCHAR(5)
- SAMPLE_COUNT — INTEGER
- AVG_RSSI — DOUBLE
- MAX_RSSI — DOUBLE
- AVG_SNR — DOUBLE
- BAD_SNR_COUNT — INTEGER
STATION_CTRL_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- DESTINAION_ID_A — VARCHAR(9)
- OFFSET_A — INTEGER
- SLOT_NUM_A — INTEGER
- TIME_OUT_A — INTEGER
- INCREMENT_A — INTEGER
- DESTINAION_ID_B — VARCHAR(9)
- OFFSET_B — INTEGER
- SLOT_NUM_B — INTEGER
- TIME_OUT_B — INTEGER
- INCREMENT_B — INTEGER
- OFFSET_C — INTEGER
- SLOT_NUM_C — INTEGER
- TIME_OUT_C — INTEGER
- INCREMENT_C — INTEGER
- OFFSET_D — INTEGER
- SLOT_NUM_D — INTEGER
- TIME_OUT_D — INTEGER
- INCREMENT_D — INTEGER
- LATITUDE_A — DOUBLE
- LONGITUDE_A — DOUBLE
- LATITUDE_B — DOUBLE
- LONGITUDE_B — DOUBLE
- CHANNEL_A — VARCHAR(5)
- CHANNEL_B — VARCHAR(5)
- TX_RX_MODE — VARCHAR(20)
- STATION_TYPE — VARCHAR(20)
- SHIP_TYPE — VARCHAR(20)
- REPORT_INTERVAL — INTEGER
- QUIET_TIME — INTEGER
- RECEIVED_SLOT_NUM — INTEGER
TB_ZN_SPCFSP
- GID — BIGINT — Primary key — NOT NULL
- OBJECTID — BIGINT
- OBJ_SN — BIGINT
- INST_CD — VARCHAR(20)
- BIZ_ZONE_CD — VARCHAR(20)
- FBCTN_YMD — VARCHAR(8)
- CLSF_CD — VARCHAR(20)
- LAYR_KORN_NM — VARCHAR(100)
- RFRNC_INFO_NO — VARCHAR(50)
- RFRNC_INFO_SCAL — VARCHAR(20)
- ZONE_EXPLN — VARCHAR(4000)
- REL_RGLT — VARCHAR(4000)
- REL_DEPT — VARCHAR(200)
- RVSN_YMD — VARCHAR(8)
- ZONE_NM — VARCHAR(200)
- ZONE_CDNT_VL — TEXT
- ID — VARCHAR(50)
- CTGRY_CD — VARCHAR(20)
- RGN_CD — VARCHAR(20)
- RGN_NM — VARCHAR(100)
- AG_GEOM — TEXT
TB_ZN_TRSF
- GID — NUMERIC(10) — Primary key — NOT NULL
- OBJECTID — VARCHAR(10)
- OBJ_SN — VARCHAR(10)
- INST_CD — VARCHAR(7)
- BIZ_ZONE_CD — VARCHAR(6)
- FBCTN_YMD — VARCHAR(8)
- CLSF_CD — VARCHAR(6)
- ZONE_NM — VARCHAR(100)
- RFRNC_INFO_NO — VARCHAR(50)
- RFRNC_INFO_SCAL — VARCHAR(100)
- RFRNC_INFO_NM — VARCHAR(100)
- REL_RGLT — VARCHAR(1000)
- REL_DEPT — VARCHAR(100)
- RVSN_YMD — VARCHAR(8)
- ZONE_EXPLN — VARCHAR(2000)
- ZONE_CDNT_VL — VARCHAR(2000)
- REL_IMG_PATH — VARCHAR(300)
- ID — VARCHAR(100)
- CTGRY_CD — VARCHAR(10)
- RGN_CD — VARCHAR(10)
- RGN_NM — VARCHAR(100)
- ADDR — VARCHAR(200)
- EXMN_SE — VARCHAR(50)
- EXMN_YR — VARCHAR(4)
- EXMN_INST — VARCHAR(200)
- AG_GEOM — TEXT
TL_VTMSA_A
- GID — BIGINT — Primary key — NOT NULL
- OBJ_SN — BIGINT
- INST_CD — VARCHAR(20)
- BIZ_ZONE_CD — VARCHAR(20)
- FBCTN_YMD — VARCHAR(8)
- CLSF_CD — VARCHAR(20)
- KORN_NM — VARCHAR(200)
- DFN_CN — VARCHAR(4000)
- LAW_NM — VARCHAR(400)
- DTL_CLAS_NM — VARCHAR(400)
- RFRNC_DOC — VARCHAR(400)
- RVSN_YMD — VARCHAR(8)
- ANCMNT_YMD — VARCHAR(8)
- REL_DEPT — VARCHAR(200)
- REL_DEPT_TELNO — VARCHAR(50)
- REL_FILE_NM — VARCHAR(400)
- RFRNC_SITE — VARCHAR(400)
- CMPTNC_KCGOFC_NM — VARCHAR(200)
- TRGT_CN — VARCHAR(4000)
- EXCL_RGN — VARCHAR(4000)
- AG_GEOM — TEXT
TL_VTSCEN_P
- GID — BIGINT — Primary key — NOT NULL
- OBJNUM — BIGINT
- PBINST — VARCHAR(20)
- INDCDE — VARCHAR(20)
- MNYMD — VARCHAR(8)
- CLFCDE — VARCHAR(20)
- NAME — VARCHAR(200)
- RN — VARCHAR(50)
- LV — VARCHAR(20)
- AG_GEOM — TEXT
VDE_0_MEDIA_ACCESS_CTRL
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- LENGTH — INTEGER
- MEDIA_ACCESS_PRIORITY_LEVEL — INTEGER
- RANDOM_ACCESS_SELECTION_INTERVAL — INTEGER
- SHORT_DATA_MESSAGE_LIMIT — INTEGER
- SYSTEM_STATUS — INTEGER
VDE_13_ACK_NACK
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- LENGTH — INTEGER
- DESTINATION_ID — VARCHAR(9)
- SESSION_ID — INTEGER
- ACK_NACK_MASK_0 — INTEGER
- ACK_NACK_MASK_1 — INTEGER
- ACK_NACK_MASK_2 — INTEGER
- CQI — INTEGER
- ACM_EDN — INTEGER
- POWER_SETTING — INTEGER
VDE_4_RESOURCE_ALLOC
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- LENGTH — INTEGER
- DESTINATION_ID — VARCHAR(9)
- LOGICAL_CHANNEL_TX — INTEGER
- LOGICAL_CHANNEL_RX — INTEGER
- LINK_ID — INTEGER
- TDMA_FRAME_DELAY — INTEGER
- SESSION_ID — INTEGER
- CQI — INTEGER
VDE_90_RESOURCE_REQ
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- TYPE — INTEGER
- LENGTH — INTEGER
- ORIG_SOURCE_ID — VARCHAR(9)
- NODE_SOURCE_ID — VARCHAR(9)
- NODE_DEST_ID — VARCHAR(9)
- ORIG_DEST_ID — VARCHAR(9)
- PRIORITY — INTEGER
- TERMINAL_CAPABILITIES — INTEGER
VDE_BB_FRAG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- LENGTH — INTEGER
- SOURCE_ID — VARCHAR(9)
- CONTROL_STATION_ID — VARCHAR(9)
- BB_VERSION — INTEGER
- NUM_FRAGMENTS — INTEGER
- BB_PAYLOAD — TEXT
VDE_FRAG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- LENGTH — INTEGER
- SOURCE_ID — VARCHAR(9)
- SESSION_ID — INTEGER
- DESTINATION_ID — VARCHAR(9)
- NUM_FRAGMENTS — INTEGER
- FRAGMENT_NO — INTEGER
- FRAG_NO_IN_SESSION — INTEGER
- FRAG_NO_IN_MESSAGE — INTEGER
- CONTINUE_SESSION_FLAG — INTEGER
- PAYLOAD — TEXT
VDE_SHORT_DATA
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — VARCHAR(30) — Primary key — NOT NULL
- REF_COL_NM (REF_COL_NM2) — VARCHAR(100) — Foreign key → VDI_INTEGRITY_CRITERION_MST.REF_COL_NM — NOT NULL
- REF_COL_NM — VARCHAR(100)
- STATION_MMSI — VARCHAR(9)
- MESSAGE_TYPE — INTEGER
- LENGTH — INTEGER
- SOURCE_ID — VARCHAR(9)
- SESSION_ID — INTEGER
- DESTINATION_ID — VARCHAR(9)
- RETRANSMISSION_NO — INTEGER
- PAYLOAD — VARCHAR(4000)
VDI_INTEGRITY_CRITERION_MST
- CRIT_ID — VARCHAR(50) — Primary key — NOT NULL — PK
- REF_COL_NM — VARCHAR(100) — Primary key — NOT NULL
- CRIT_CAT_L — VARCHAR(50)
- CRIT_CAT_M — VARCHAR(50)
- CRIT_CAT_S — VARCHAR(50)
- CRIT_NAME — VARCHAR(200)
- REF_TBL_NM — VARCHAR(100)
- CRIT_DESC — TEXT
VI_HRBARE_A
- GID — NUMERIC(10) — Primary key — NOT NULL
- OBJNUM — VARCHAR(10)
- PBINST — VARCHAR(20)
- INDCDE_1 — VARCHAR(50)
- INDCDE_2 — VARCHAR(50)
- INDCDE_3 — VARCHAR(50)
- MNYMD — VARCHAR(8)
- CLFCDE — VARCHAR(6)
- ENCLEV — VARCHAR(20)
- ENC_NO — VARCHAR(250)
- GUBUN — VARCHAR(20)
- NOBJNM — VARCHAR(200)
- OBJNAM — VARCHAR(100)
- STATUS — VARCHAR(6)
- INFORM — VARCHAR(200)
- NINFOM — VARCHAR(200)
- NTXTDS — VARCHAR(100)
- SCAMIN — NUMERIC(8)
- TXTDSC — VARCHAR(30)
- SORDAT — VARCHAR(20)
- SORIND — VARCHAR(100)
- AG_GEOM — TEXT
WEATHER_OBS
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- OBS_TIME — VARCHAR(30) — Primary key — NOT NULL
- WIND_SPEED_MS — DOUBLE
- WIND_DIR_DEG — DOUBLE
- GUST_SPEED_MS — DOUBLE
- LOCAL_PRESSURE_HPA — DOUBLE
- REL_HUMIDITY_PCT — DOUBLE
- AIR_TEMP_C — DOUBLE
- SEA_TEMP_C — DOUBLE
- MAX_WAVE_HEIGHT_M — DOUBLE
- SIG_WAVE_HEIGHT_M — DOUBLE
- MEAN_WAVE_HEIGHT_M — DOUBLE
- WAVE_PERIOD_S — DOUBLE
- WAVE_DIR_DEG — DOUBLE