erd

Tables (31)

addr_ack_msg (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • ack_seq (Field) — BIGINT — Primary key — NOT NULL
  • schedule_seq_no (Field12) — BIGINT — Foreign key → addr_msg.schedule_seq — NOT NULL
  • source_mmsi (Field10) — varchar(9) — NOT NULL
  • message_type (Field3) — int — NOT NULL
  • datetime_received (Field11) — TIMESTAMP — NOT NULL
  • destination_id (Field5) — varchar(9) — NOT NULL
  • retransmit_flag (Field2) — int — NOT NULL
  • session_id (Field4) — int — NOT NULL
  • ack_mask (Field6) — int — NOT NULL
  • coding_rate (Field7) — int
  • channel_quality (Field8) — int
  • zero_padding (Field9) — int

addr_msg (CopyOfCopyOfCopyOfUntitled2)

  • schedule_seq (Field) — BIGINT — Primary key — NOT NULL
  • source_mmsi (Field10) — varchar(9) — NOT NULL
  • message_type (Field3) — int — NOT NULL
  • datetime_received (Field11) — TIMESTAMP — NOT NULL
  • destination_id (Field5) — varchar(9) — NOT NULL
  • retransmit_flag (Field2) — int — NOT NULL
  • session_id (Field4) — int — NOT NULL
  • data_count (Field6) — int — NOT NULL
  • asm_identifier (Field7) — int — NOT NULL
  • binary_data (Field8) — int — NOT NULL
  • spare_bits (Field9) — int

assign_check_msg (CopyOf..3)

  • assign_seq (Key) — BIGINT — Primary key — NOT NULL
  • station_mmsi (Field22) — varchar(9) — Foreign key → station_info.station_mmsi — NOT NULL
  • source_mmsi (Field4) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field8) — TIMESTAMP — NOT NULL
  • sog (Field) — double
  • cog (Field6) — double
  • true_heading (Field7) — double
  • destination_id_A (Field2) — varchr(9)
  • destination_id_B (Field3) — varchr(9)
  • slot_num (Field9) — int — NOT NULL

bb_control_area (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • bb_payload_seq (Key) — BIGINT — Foreign key → bb_payload.bb_payload_seq — NOT NULL
  • longitude1 (Field) — int — NOT NULL
  • latitude1 (Field2) — int — NOT NULL
  • longitude2 (Field3) — int — NOT NULL
  • latitude2 (Field4) — int — NOT NULL
  • padding (Field5) — int

bb_fragment (CopyOfCopyOfCopyOfCopyOfUntitled32)

  • bb_seq (Field) — BIGINT — Primary key — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field2) — int — NOT NULL
  • source_id (Field3) — varchar(9) — NOT NULL
  • control_station_id (Field6) — int — NOT NULL
  • bulletin_board_version (Field7) — int — NOT NULL
  • number_of_fragments (Field8) — int — NOT NULL

bb_payload (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • bb_payload_seq (Key) — BIGINT — Primary key — NOT NULL
  • bulletin_board_seq (Field2) — BIGINT — Foreign key → bb_fragment.bb_seq — NOT NULL
  • start_time_version (Field) — int — NOT NULL
  • validity_version (Field3) — int — NOT NULL
  • tdma_frame_size (Field4) — int — NOT NULL
  • protocol_version (Field5) — int — NOT NULL
  • service_area_point (Field6) — int — NOT NULL
  • authentication_integrity_seq (Field7) — int

channel_log (CopyOfUntitled)

  • channel_log_seq (Field) — BIGINT — Primary key — NOT NULL
  • source_mmsi (Field2) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • channel (Field3) — varchar(1) — NOT NULL
  • slot_num (Field6) — int — NOT NULL

com_state (CopyOfCopyOf..24)

  • dyn_msg_seq_a (Key2) — BIGINT — Foreign key → dyn_msg_a.dyn_msg_seq_a — NOT NULL
  • sync_state (Field) — int — NOT NULL
  • slot_time_out (Field2) — int
  • sub_msg (Field3) — int
  • slot_increment (Field4) — int
  • slot_num (Field5) — int
  • keep_flag (Field6) — int

controller_info (CopyOfCopyOf..2)

  • controller_id (Field2) — varchar(20) — Primary key — NOT NULL
  • controller_name (Field) — varchar(20) — NOT NULL
  • ctr_lat (Field3) — float
  • ctr_lon (Field4) — float
  • ctr_type (Field5) — varchar(10)

criterion_def (CopyOfCopyOfCopyOfUntitled22)

  • rule_code (Key) — varchar(10) — Primary key — NOT NULL
  • message_type (Field) — int — NOT NULL
  • rune_name (Field2) — varchar(10) — NOT NULL
  • severity (Field3) — varchar(8) — NOT NULL

data_fragment_msg (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • fragment_seq (Field) — BIGINT — Primary key — NOT NULL
  • allocation_seq (Field13) — BIGINT — Foreign key → resource_allocation_msg.allocation_seq — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field2) — int — NOT NULL
  • source_id (Field3) — varchar(9) — NOT NULL
  • session_id (Field6) — int — NOT NULL
  • destination_id (Field7) — int — NOT NULL
  • total_fragment (Field8) — int — NOT NULL
  • fragment_num (Field9) — int — NOT NULL
  • msg_fragment_num (Field11) — int — NOT NULL
  • continue_session (Field10) — int — NOT NULL
  • payload (Field12) — text

dyn_msg_a (CopyOfCopyOf..3)

  • dyn_msg_seq_a (Key) — BIGINT — Primary key — NOT NULL
  • station_mmsi (Field22) — varchar(9) — Foreign key → station_info.station_mmsi — NOT NULL
  • source_mmsi (Field4) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field8) — TIMESTAMP — NOT NULL
  • sog (Field) — double
  • cog (Field6) — double
  • true_heading (Field7) — double
  • latitude (Field2) — float
  • longitude (Field3) — float
  • slot_num (Field9) — int — NOT NULL

dyn_msg_non_a (CopyOfCopyOfCopyOf..3)

  • dyn_msg_seq (Key) — BIGINT — Primary key — NOT NULL
  • station_mmsi (Field22) — varchar(9) — Foreign key → station_info.station_mmsi — NOT NULL
  • source_mmsi (Field4) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field8) — TIMESTAMP — NOT NULL
  • latitude (Field2) — float
  • longitude (Field3) — float
  • sog (Field) — dobule
  • navigational_status (Field6) — int
  • manoeuvre_indicator (Field7) — int
  • slot_num (Field9) — int — NOT NULL

interro_req (Untitled)

  • interro_msg_seq (Field) — BIGINT — Primary key — NOT NULL
  • source_mmsi (Field2) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • destination_id (Field3) — TEXT
  • slot_offset (Field6) — int
  • slot_num (Field7) — int — NOT NULL

intg_eval (CopyOfCopyOfUntitled22)

  • eval_id (Key) — BIGINT — Primary key — NOT NULL
  • rule_code (Key2) — varchar(10) — Foreign key → criterion_def.rule_code — NOT NULL
  • signal_seq (Key3) — BIGINT — Foreign key → signal_agg.signal_seq — NOT NULL
  • message_type (Field) — int — NOT NULL
  • integrity_pass (Field2) — boolean — NOT NULL

logical_ch_def (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • pc_seq (Key2) — BIGINT — Foreign key → physical_ch_def.pc_seq — NOT NULL
  • tdma0_lc_count (Field) — int — NOT NULL
  • tdma1_lc_count (Field2) — int — NOT NULL
  • tdma2_lc_count (Field3) — int — NOT NULL
  • tdma3_lc_count (Field4) — int — NOT NULL
  • tdma4_lc_count (Field5) — int — NOT NULL
  • tdma5_lc_count (Field6) — int — NOT NULL
  • LC_function (Field7) — int — NOT NULL
  • LC_repeat (Field8) — int — NOT NULL

media_access_msg (CopyOfCopyOfUntitled3)

  • access_seq (Field) — BIGINT — Primary key — NOT NULL
  • source_mmsi (Field2) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field3) — int — NOT NULL
  • priority_level (Field6) — int — NOT NULL
  • access_interval (Field7) — int — NOT NULL
  • short_msg_limit (Field8) — int — NOT NULL
  • system_status (Field9) — int — NOT NULL

physical_ch_def (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • pc_seq (Key) — BIGINT — Primary key — NOT NULL
  • bulletin_seq (Key2) — BIGINT — Foreign key → bb_payload.bb_payload_seq — NOT NULL
  • physical_channels_num (Field) — int — NOT NULL
  • PC_num (Field2) — int — NOT NULL
  • bandwidth (Field3) — int — NOT NULL
  • Tx_flag (Field4) — int — NOT NULL
  • RA_selection_interval (Field5) — int — NOT NULL
  • short_message_limit (Field6) — int — NOT NULL

regoin_polygon (CopyOfCopyOfCopyOfCopyOf..32)

  • zone_id (Key) — varchar(20) — Primary key — NOT NULL
  • station_mmsi (Field22) — varchar(9) — Foreign key → station_info.station_mmsi — NOT NULL
  • zone_name (Field) — varchar(20) — NOT NULL
  • region (Field3) — varchar(10) — NOT NULL
  • polygon (Field4) — text — NOT NULL
  • zone_type (Field2) — varchar(30) — NOT NULL

resource_allocation_msg (CopyOfCopyOfCopyOfUntitled3)

  • allocation_seq (Field) — BIGINT — Primary key — NOT NULL
  • request_seq (Field13) — BIGINT — Foreign key → resource_request.request_seq — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field2) — int — NOT NULL
  • source_id (Field3) — varchar(9) — NOT NULL
  • destination_id (Field6) — varchar(9) — NOT NULL
  • logical_channel_tx (Field7) — int — NOT NULL
  • logical_channel_rx (Field8) — int — NOT NULL
  • link_id (Field9) — int — NOT NULL
  • tdma_frame_delay (Field10) — int — NOT NULL
  • session_id (Field11) — int — NOT NULL
  • cqi (Field12) — int — NOT NULL

resource_request (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • request_seq (Field) — BIGINT — Primary key — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field2) — int — NOT NULL
  • original_source_id (Field3) — int — NOT NULL
  • node_source_id (Field6) — int — NOT NULL
  • destination_id (Field7) — int — NOT NULL
  • original_destination_id (Field8) — int — NOT NULL
  • priority (Field9) — int
  • terminal_capabilities (Field11) — int — NOT NULL

sensor_feat (CopyOfCopyOfUntitled)

  • sensor_feat_seq (Field) — BIGINT — Primary key — NOT NULL
  • source_mmsi (Field2) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • sog (Field3) — double
  • cog (Field6) — double
  • latitude (Field7) — float
  • longitude (Field8) — float
  • turn_rate (Field9) — int
  • heading (Field10) — int
  • altitude (Field11) — int
  • slot_num (Field12) — int — NOT NULL

ship_info (CopyOfCopyOf..)

  • ship_mmsi (Field2) — varchar(9) — Primary key — NOT NULL
  • ship_type (Field22) — int — Foreign key → ship_type.ship_type — NOT NULL
  • imo_num (Field) — varchar(10)
  • call_sign (Field3) — varchar(6)
  • ship_name (Field4) — varchar(20)
  • ship_type (Field7) — int
  • ship_lenght (Field6) — int
  • ship_width (Field5) — int

ship_type (CopyOfCopyOfCopyOf..)

  • ship_type (Field2) — int — Primary key — NOT NULL
  • ship_group (Field6) — varchar(20) — NOT NULL
  • ship_classification (Field) — varchar(50) — NOT NULL

short_data_msg (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • short_msg_seq (Field) — BIGINT — Primary key — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field2) — int — NOT NULL
  • source_id (Field3) — int — NOT NULL
  • session_id (Field6) — int — NOT NULL
  • destination_id (Field7) — int — NOT NULL
  • retransmission_num (Field8) — int — NOT NULL
  • payload (Field9) — text

signal_agg (CopyOfCopyOfCopyOfUntitled2222)

  • signal_seq (Key) — BIGINT — Primary key — NOT NULL
  • station_mmsi (Key2) — varchar(9) — NOT NULL
  • source_mmsi (Field5) — varchar(9) — NOT NULL
  • TOA (Field) — TIMESTAMP — NOT NULL
  • first_slot_num (Field2) — int — NOT NULL
  • RSSI (Field3) — double — NOT NULL
  • SNR (Field4) — double — NOT NULL

stat_msg (CopyOfCopyOfCopyOfCopyOf..3)

  • stat_msg_seq (Key) — BIGINT — Primary key — NOT NULL
  • ship_mmsi (Field22) — varchar(9) — Foreign key → ship_info.ship_mmsi — NOT NULL
  • source_mmsi (Field4) — varchar(9) — NOT NULL
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field8) — TIMESTAMP — NOT NULL
  • ship_class (Field7) — varchar(1) — NOT NULL
  • ship_name (Field9) — varchar(20)
  • ship_type (Field) — int
  • call_sign (Field2) — varchar(6)
  • ship_length (Field3) — int
  • ship_width (Field6) — int
  • position_fix_device (Field10) — int
  • imo_num (Field11) — varchar(10)
  • static_draught (Field12) — int
  • eta (Field13) — date
  • part_number (Field14) — int
  • slot_num (Field15) — int — NOT NULL

station_ctrl_msg (..)

  • control_seq (Key) — BIGINT — Primary key — NOT NULL
  • destination_id_A (Field23) — varchr(9) — Foreign key → ship_info.ship_mmsi
  • destination_id_B (Field222) — varchr(9) — Foreign key → ship_info.ship_type
  • source_mmsi (Field) — varchar(9) — NOT NULL
  • message_type (Field6) — int — NOT NULL
  • datetime_received (Field12) — TIMESTAMP — NOT NULL
  • time_out (Field8) — int
  • increments (Field9) — int
  • latitude1 (Field10) — float
  • longitude1 (Field3) — float
  • latitude2 (Field2) — float
  • longitude2 (Field11) — float
  • slot_num (Field4) — int — NOT NULL

station_info (CopyOf..)

  • station_mmsi (Field2) — varchar(9) — Primary key — NOT NULL
  • controller_id (Field22) — varchar(20) — Foreign key → controller_info.controller_id — NOT NULL
  • site_lat (Field4) — float — NOT NULL
  • site_lon (Field5) — float — NOT NULL
  • coverage_rang (Field) — float — NOT NULL

station_msg (CopyOfCopyOfUntitled2)

  • station_msg_seq (Field) — BIGINT — Primary key — NOT NULL
  • message_type (Field3) — int — NOT NULL
  • talker_id (Field7) — varchar(2) — NOT NULL
  • formatter_id (Field8) — varchar(2) — NOT NULL
  • direction_enum (Field2) — int — NOT NULL
  • datetime (Field4) — TIMESTAMP — NOT NULL
  • data (Field5) — TEXT
  • slot_num (Field6) — int — NOT NULL

vde_ack_msg (CopyOfCopyOfCopyOfCopyOfUntitled3)

  • ack_seq (Field) — BIGINT — Primary key — NOT NULL
  • fragment_seq (Field14) — BIGINT — Foreign key → data_fragment_msg.fragment_seq
  • short_msg_seq (Field15) — BIGINT — Foreign key → short_data_msg.short_msg_seq
  • message_type (Field5) — int — NOT NULL
  • datetime_received (Field4) — TIMESTAMP — NOT NULL
  • length (Field2) — int — NOT NULL
  • source_id (Field3) — varchar(9) — NOT NULL
  • destination_id (Field6) — varchar(9) — NOT NULL
  • session_id (Field9) — int — NOT NULL
  • ack-nack_mask0 (Field10) — int — NOT NULL
  • ack-nack_mask1 (Field11) — int — NOT NULL
  • ack-nack_mask2 (Field12) — int — NOT NULL
  • cqi (Field7) — int — NOT NULL
  • acm_edn (Field8) — int — NOT NULL
  • power_setting (Field13) — int — NOT NULL