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