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)