VIEW

Tables (8)

CTR_ZONE_SHIP_CNT (Untitled)

  • CTR_MMSI (Key) — VARCHAR(9) — Primary key — NOT NULL
  • SNAPSHOT_TIME (Field) — TIMESTAMP — NOT NULL
  • TOTAL_SHIP_CNT (Field2) — INTEGER
  • AIS_SHIP_CNT (Field3) — INTEGER
  • ASM_SHIP_CNT (Field4) — INTEGER
  • VDE_SHIP_CNT (Field5) — INTEGER

FOCUS_SHIP_SUMMARY

  • SOURCE_MMSI — BIGINT — NOT NULL
  • DATETIME_RECEIVED — TIMESTAMPTZ — NOT NULL
  • MANAGE_CENTER_ID — VARCHAR(32)
  • MAIN_RULE_ID — VARCHAR(64)
  • MAIN_RULE_NAME — VARCHAR(128)
  • FIRST_DETECTED_AT — TIMESTAMPTZ
  • LAST_DETECTED_AT — TIMESTAMPTZ
  • LAST_MSG_TYPE — SMALLINT
  • VIOLATION_COUNT_TOTAL — INTEGER
  • STATUS — VARCHAR(32)
  • REMARK — VARCHAR(512)
  • CREATED_AT — TIMESTAMPTZ
  • UPDATED_AT — TIMESTAMPTZ
  • CREATED_BY — VARCHAR(64)
  • UPDATED_BY — VARCHAR(64)

INTEGRITY_VIOLATION_EVENT_LOG

  • SOURCE_MMSI — BIGINT — NOT NULL
  • DATETIME_RECEIVED — TIMESTAMPTZ — NOT NULL
  • MSG_TYPE — SMALLINT — NOT NULL
  • RULE_ID — VARCHAR(64) — NOT NULL
  • RECEIVE_STATION_ID — VARCHAR(32)
  • DETAIL_JSON — JSONB

MSG_STATS_BY_MESSAGE

  • TIME_KEY — INTEGER — Primary key — NOT NULL
  • STATION_KEY — INTEGER — NOT NULL
  • CHANNEL_A_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

  • TIME_KEY — INTEGER — Primary key — NOT NULL
  • STATION_KEY — INTEGER — NOT NULL
  • MSG_TOTAL_COUNT — INTEGER
  • DYN_MSG_COUNT — INTEGER
  • STAT_MSG_COUNT — INTEGER
  • CTRL_MSG_COUNT — INTEGER

SHIP_TRACK

  • MMSI — BIGINT — NOT NULL
  • BASE_DATE — DATE — NOT NULL
  • RECV_TIME_UTC — TIMESTAMPTZ — NOT NULL
  • LATITUDE — NUMERIC(9,6) — NOT NULL
  • LONGITUDE — NUMERIC(9,6) — NOT NULL
  • SOG_KNOTS — NUMERIC(6,2)
  • COG_DEG — NUMERIC(6,2)
  • HEADING_DEG — NUMERIC(6,2)
  • NAV_STATUS — SMALLINT
  • ROT_DEG — NUMERIC(6,2)
  • MSG_TYPE — SMALLINT — NOT NULL
  • SOURCE_STATION — BIGINT
  • SRC_CHANNEL — VARCHAR(8)
  • QUALITY_FLAG — SMALLINT
  • INSERT_TIME — TIMESTAMPTZ — NOT NULL

SIGNAL_QUALITY_STATS

  • TIME_KEY — INTEGER — NOT NULL
  • STATION_KEY — INTEGER — NOT NULL
  • CHANNEL — VARCHAR(8)
  • SAMPLE_COUNT — INTEGER
  • AVG_RSSI — NUMERIC(6,2)
  • MAX_RSSI — NUMERIC(6,2)
  • AVG_SNR — NUMERIC(6,2)
  • BAD_SNR_COUNT — INTEGER

WEATHER_OBS

  • STATION_ID — VARCHAR(32) — NOT NULL
  • OBS_TIME — TIMESTAMPTZ — NOT NULL
  • WIND_SPEED_MS — NUMERIC(6,2)
  • WIND_DIR_DEG — NUMERIC(6,2)
  • GUST_SPEED_MS — NUMERIC(6,2)
  • LOCAL_PRESSURE_HPA — NUMERIC(7,2)
  • REL_HUMIDITY_PCT — NUMERIC(5,2)
  • AIR_TEMP_C — NUMERIC(5,2)
  • SEA_TEMP_C — NUMERIC(5,2)
  • MAX_WAVE_HEIGHT_M — NUMERIC(5,2)
  • SIG_WAVE_HEIGHT_M — NUMERIC(5,2)
  • MEAN_WAVE_HEIGHT_M — NUMERIC(5,2)
  • WAVE_PERIOD_S — NUMERIC(5,2)
  • WAVE_DIR_DEG — NUMERIC(6,2)