ais
Tables (7)
AIS_DYN_MSG_A
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — TIMESTAMP — Primary key — NOT NULL
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- MESSAGE_TYPE — INTEGER — NOT NULL
- SOURCE_LATITUDE — DECIMAL(9,6) — NOT NULL
- SOURCE_LONGITUDE — DECIMAL(10,6) — NOT NULL
- POSITION_ACCURACY — INTEGER
- SOG — DECIMAL(6,2)
- COG — DECIMAL(6,2)
- TRUE_HEADING — DECIMAL(5,1)
- RECEIVED_SLOT_NUM — INTEGER
- 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 — TIMESTAMP — Primary key — NOT NULL
- STATION_MMSI — VARCHAR(9) — NOT NULL
- MESSAGE_TYPE — INTEGER — NOT NULL
- SOURCE_LATITUDE — DECIMAL(9,6) — NOT NULL
- SOURCE_LONGITUDE — DECIMAL(10,6) — NOT NULL
- POSITION_ACCURACY — INTEGER
- SOG — DECIMAL(6,2)
- COG — DECIMAL(6,2)
- ALTITUDE — DECIMAL(7,2)
- RECEIVED_SLOT_NUM — INTEGER
- COMM_STATE_SELECTOR — VARCHAR(20)
- 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 — TIMESTAMP — Primary key — NOT NULL
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- MESSAGE_TYPE — INTEGER — NOT NULL
- SHIP_CLASS — VARCHAR(20)
- SHIP_NAME — VARCHAR(100)
- SHIP_TYPE — VARCHAR(20)
- CALL_SIGN — VARCHAR(20)
- SHIP_LENGTH — DECIMAL(6,1)
- SHIP_WIDTH — DECIMAL(6,1)
- POSITION_FIX_DEVICE — INTEGER
- IMO_NUM — VARCHAR(10)
- STATIC_DRAUGHT — DECIMAL(5,2)
- DESTINATION — VARCHAR(100)
- ETA — TIMESTAMP
- PART_NUMBER — INTEGER
- RECEIVED_SLOT_NUM — INTEGER
INTERRO_REQ
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — TIMESTAMP — Primary key — NOT NULL
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- MESSAGE_TYPE — INTEGER — NOT NULL
- 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 — CHAR(1)
- REQ_MSG_RECEIVED_TIME_1 — TIMESTAMP
- REQ_MSG_RECEIVED_FLAG_2 — CHAR(1)
- REQ_MSG_RECEIVED_TIME_2 — TIMESTAMP
- RECEIVED_SLOT_NUM — INTEGER
NMEA_TYPE
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — TIMESTAMP — Primary key — NOT NULL
- TALKER_ID — VARCHAR(5) — Primary key — NOT NULL
- SENTENCE_ID — VARCHAR(10) — Primary key — NOT NULL
- TOTAL_SENTENCES_NUM — INTEGER
- SENTENCE_NUM — INTEGER
- SEQUENTIAL_IDENTIFIER — INTEGER
- CHANNEL — VARCHAR(5)
- SOURCE_MMSI — VARCHAR(9)
- NUMBER_FILL_BIT — INTEGER
SIGNAL_INFORMATION
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- TOA — TIMESTAMP — Primary key — NOT NULL
- TALKER_ID — VARCHAR(5) — Primary key — NOT NULL
- SENTENCE_ID — VARCHAR(10) — Primary key — NOT NULL
- SLOT_NUM — INTEGER
- RSSI — DECIMAL(6,2)
- SNR — DECIMAL(6,2)
STATION_CTRL_MSG
- SOURCE_MMSI — VARCHAR(9) — Primary key — NOT NULL
- DATETIME_RECEIVED — TIMESTAMP — Primary key — NOT NULL
- STATION_MMSI — VARCHAR(9) — Primary key — NOT NULL
- MESSAGE_TYPE — INTEGER — NOT NULL
- 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
- DESTINAION_ID_C — VARCHAR(9)
- OFFSET_C — INTEGER
- SLOT_NUM_C — INTEGER
- TIME_OUT_C — INTEGER
- INCREMENT_C — INTEGER
- DESTINAION_ID_D — VARCHAR(9)
- OFFSET_D — INTEGER
- SLOT_NUM_D — INTEGER
- TIME_OUT_D — INTEGER
- INCREMENT_D — INTEGER
- LATITUDE_A — DECIMAL(9,6)
- LONGITUDE_A — DECIMAL(10,6)
- LATITUDE_B — DECIMAL(9,6)
- LONGITUDE_B — DECIMAL(10,6)
- 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