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