40mm

Tables (25)

ECS_Message_Queue

  • message_id — BIGINT
  • station_id — VARCHAR(50)
  • message_type — VARCHAR(50) — NOT NULL
  • target_system_type — VARCHAR(10) — NOT NULL
  • target_system_id — INT
  • message_data — BLOB
  • priority — TINYINT
  • message_status — VARCHAR(20)
  • retry_count — TINYINT
  • created_at — TIMESTAMP
  • processed_at — TIMESTAMP

Electron_UI_Visualization_Module

  • ui_id — BIGINT
  • session_id — BIGINT
  • unity_visualization_id — BIGINT
  • active_panel — VARCHAR(50)
  • layout_configuration — TEXT
  • user_permissions — TEXT
  • control_mode — VARCHAR(20)
  • displayed_systems — TEXT
  • alert_notifications — TEXT
  • performance_dashboard — TEXT
  • last_user_action — VARCHAR(200)
  • last_user_input_time — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Engagement_Control_Station

  • station_id — VARCHAR(50)
  • device_id — VARCHAR(50) — NOT NULL
  • station_name — VARCHAR(100)
  • ip_address — VARCHAR(15)
  • port_number — INT
  • operational_status — VARCHAR(20)
  • max_weapon_systems — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

IPUM_Contingency_Processor

  • contingency_id — INT
  • ipum_id — INT
  • contingency_type — VARCHAR(30) — NOT NULL
  • severity_level — VARCHAR(20) — NOT NULL
  • detected_at — TIMESTAMP
  • resolution_status — VARCHAR(20)

IPUM_Message_Receiver

  • receiver_id — INT
  • ipum_id — INT
  • message_queue_id — BIGINT
  • received_at — TIMESTAMP
  • processing_status — VARCHAR(20)

IPUM_Message_Transmitter

  • transmitter_id — INT
  • ipum_id — INT
  • destination_station_id — VARCHAR(50)
  • message_type — VARCHAR(30) — NOT NULL
  • message_content — TEXT
  • transmission_status — VARCHAR(20)
  • created_at — TIMESTAMP

IPUM_Power_Control_Unit

  • control_id — INT
  • ipum_id — INT
  • power_command_type — VARCHAR(30) — NOT NULL
  • target_load — DECIMAL(8,2)
  • execution_status — VARCHAR(20)
  • execution_start_time — TIMESTAMP
  • execution_end_time — TIMESTAMP
  • power_quality_metrics — TEXT
  • created_at — TIMESTAMP

Integrated_Power_Unit_Model

  • ipum_id — INT
  • unit_name — VARCHAR(100) — NOT NULL
  • station_id — VARCHAR(50)
  • model_version — VARCHAR(20)
  • power_status — VARCHAR(20)
  • current_load — DECIMAL(8,2)
  • max_capacity — DECIMAL(8,2) — NOT NULL
  • efficiency_rating — DECIMAL(4,2)
  • operating_temperature — DECIMAL(5,2)
  • fuel_level — DECIMAL(5,2)
  • maintenance_hours — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Performance_Metrics

  • metric_id — BIGINT
  • session_id — BIGINT
  • system_type — VARCHAR(10) — NOT NULL
  • system_id — INT — NOT NULL
  • metric_type — VARCHAR(30) — NOT NULL
  • metric_value — DECIMAL(15,6)
  • metric_unit — VARCHAR(20)
  • measurement_time — TIMESTAMP

Scenario_DB

  • scenario_id — INT
  • scenario_name — VARCHAR(200) — NOT NULL
  • scenario_type — VARCHAR(20) — NOT NULL
  • scenario_description — TEXT
  • target_profile — TEXT
  • environmental_conditions — TEXT
  • engagement_rules — TEXT
  • expected_outcomes — TEXT
  • difficulty_level — VARCHAR(20)
  • duration_minutes — INT
  • created_by — VARCHAR(100)
  • created_at — TIMESTAMP
  • is_active — BOOLEAN

Scenario_Management_Module

  • management_id — INT
  • scenario_id — INT
  • execution_status — VARCHAR(20)
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • current_phase — VARCHAR(100)
  • phase_progress — DECIMAL(5,2)
  • participants — TEXT
  • real_time_controls — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Simulation_Result_DB

  • result_id — BIGINT
  • session_id — BIGINT
  • processing_id — BIGINT
  • result_type — VARCHAR(30) — NOT NULL
  • result_data — TEXT
  • analysis_tags — TEXT
  • created_at — TIMESTAMP

Simulation_Result_Processing_Module

  • processing_id — BIGINT
  • session_id — BIGINT
  • processing_type — VARCHAR(20) — NOT NULL
  • data_source_type — VARCHAR(20) — NOT NULL
  • source_system_id — INT
  • raw_data — BLOB
  • processed_data — TEXT
  • processing_algorithm — VARCHAR(100)
  • processing_start_time — TIMESTAMP
  • processing_end_time — TIMESTAMP
  • processing_status — VARCHAR(20)

Simulation_Session

  • session_id — BIGINT
  • scenario_id — INT
  • session_name — VARCHAR(200)
  • participant_systems — TEXT
  • session_start_time — TIMESTAMP
  • session_end_time — TIMESTAMP
  • session_status — VARCHAR(20)
  • total_events — INT
  • performance_summary — TEXT

System_Health_Monitor

  • monitor_id — BIGINT
  • system_type — VARCHAR(10) — NOT NULL
  • system_id — INT — NOT NULL
  • cpu_usage — DECIMAL(5,2)
  • memory_usage — DECIMAL(5,2)
  • network_latency — DECIMAL(8,3)
  • error_count — INT
  • uptime_seconds — BIGINT
  • health_status — VARCHAR(20)
  • last_check_time — TIMESTAMP

Unity_Visualization_Module

  • visualization_id — BIGINT
  • session_id — BIGINT
  • wsm_id — INT
  • scene_type — VARCHAR(50) — NOT NULL
  • camera_position_x — DECIMAL(10,3)
  • camera_position_y — DECIMAL(10,3)
  • camera_position_z — DECIMAL(10,3)
  • target_position_x — DECIMAL(10,3)
  • target_position_y — DECIMAL(10,3)
  • target_position_z — DECIMAL(10,3)
  • weapon_azimuth — DECIMAL(6,2)
  • weapon_elevation — DECIMAL(6,2)
  • firing_status — VARCHAR(20)
  • ammunition_visible — INT
  • target_type — VARCHAR(50)
  • target_threat_level — VARCHAR(20)
  • engagement_outcome — VARCHAR(20)
  • weather_effects — TEXT
  • lighting_conditions — TEXT
  • render_quality — VARCHAR(20)
  • frame_rate — INT
  • last_updated — TIMESTAMP

WSM_Contingency_Processor

  • contingency_id — INT
  • wsm_id — INT
  • contingency_type — VARCHAR(30) — NOT NULL
  • severity_level — VARCHAR(20) — NOT NULL
  • contingency_description — TEXT
  • auto_recovery_attempted — BOOLEAN
  • manual_intervention_required — BOOLEAN
  • resolution_status — VARCHAR(20)
  • detected_at — TIMESTAMP
  • resolved_at — TIMESTAMP
  • resolution_notes — TEXT

WSM_Electro_Optical_Tracker

  • eots_id — INT
  • wsm_id — INT
  • target_id — VARCHAR(50)
  • tracking_status — VARCHAR(20)
  • target_azimuth — DECIMAL(6,2)
  • target_elevation — DECIMAL(6,2)
  • target_range — DECIMAL(8,2)
  • target_velocity — DECIMAL(6,2)
  • target_type — VARCHAR(20)
  • threat_level — VARCHAR(20)
  • video_stream_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

WSM_Fire_Control_Computer

  • fcc_id — INT
  • wsm_id — INT
  • eots_id — INT
  • ballistic_solution — TEXT
  • firing_parameters — TEXT
  • munition_info — TEXT
  • environmental_data — TEXT
  • sightline_deviation — DECIMAL(6,4)
  • baseline_deviation — DECIMAL(6,4)
  • solution_valid — BOOLEAN
  • calculation_time — TIMESTAMP
  • created_at — TIMESTAMP

WSM_Message_Receiver

  • receiver_id — INT
  • wsm_id — INT
  • message_queue_id — BIGINT
  • received_at — TIMESTAMP
  • processing_status — VARCHAR(20)
  • processing_result — TEXT

WSM_Message_Transmitter

  • transmitter_id — INT
  • wsm_id — INT
  • destination_station_id — VARCHAR(50)
  • message_type — VARCHAR(30) — NOT NULL
  • message_content — TEXT
  • transmission_status — VARCHAR(20)
  • retry_count — TINYINT
  • created_at — TIMESTAMP
  • sent_at — TIMESTAMP
  • acknowledged_at — TIMESTAMP

WSM_Status_Log

  • log_id — BIGINT
  • wsm_id — INT
  • previous_status — VARCHAR(50)
  • current_status — VARCHAR(50)
  • status_change_reason — VARCHAR(200)
  • performance_metrics — TEXT
  • created_at — TIMESTAMP

WSM_System_Control_Unit

  • control_id — INT
  • wsm_id — INT
  • control_command_type — VARCHAR(30) — NOT NULL
  • command_parameters — TEXT
  • execution_status — VARCHAR(20)
  • execution_start_time — TIMESTAMP
  • execution_end_time — TIMESTAMP
  • created_at — TIMESTAMP

WSM_Video_Transmitter

  • transmitter_id — INT
  • wsm_id — INT
  • eots_id — INT
  • stream_type — VARCHAR(20) — NOT NULL
  • video_format — VARCHAR(20)
  • resolution — VARCHAR(20)
  • frame_rate — INT
  • bitrate — INT
  • streaming_status — VARCHAR(20)
  • destination_ip — VARCHAR(15)
  • destination_port — INT
  • bandwidth_usage — DECIMAL(8,2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Weapon_System_Model

  • wsm_id — INT
  • system_name — VARCHAR(100) — NOT NULL
  • system_type — VARCHAR(20)
  • station_id — VARCHAR(50)
  • model_version — VARCHAR(20)
  • operational_mode — VARCHAR(20)
  • position_x — DECIMAL(10,3)
  • position_y — DECIMAL(10,3)
  • position_z — DECIMAL(10,3)
  • orientation_azimuth — DECIMAL(6,2)
  • orientation_elevation — DECIMAL(6,2)
  • ammunition_count — INT
  • ammunition_type — VARCHAR(50)
  • last_maintenance — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP