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