populate_data.sql

INSERT INTO "aircraft"("type", "squadron", "home_base", "role") 
VALUES
('F/A-18F Super Hornet', 'VX-31', 'China Lake', 'Strike Fighter'),
('EA-18G Growler', 'VX-23', 'Point Mugu', 'Electronic Warfare'),
('MQ-9 Reaper', 'Test Unit Alpha', 'Creech AFB', 'UAV'),
('F-35C Lightning II', 'VX-9', 'China Lake', 'Stealth Fighter'),
('P-8A Poseidon', 'VX-20', 'Patuxent River', 'Maritime Patrol');

INSERT INTO "test_ranges"("range_name", "region", "size_sq_miles", "operating_organization") 
VALUES
('China Lake Land Range', 'California Desert', 19000, 'NAWCWD'),
('Point Mugu Sea Range', 'Pacific Ocean', 36000, 'NAWCWD'),
('Fallon Test Range', 'Nevada', 12000, 'Naval Aviation'),
('Edwards Test Airspace', 'California', 18000, 'USAF Test Wing'),
('Pacific Missile Range', 'Hawaii', 20000, 'DoD Joint');

INSERT INTO "operators" ("name", "role", "organization", "clearance_level") 
VALUES
('Yasin Zahir', 'Flight Test Engineer', 'NAWCWD', 'secret'),
('Daniel Carter', 'Range Control Officer', 'NAWCWD', 'secret'),
('Maria Lopez', 'Weather Analyst', 'Naval Aviation', 'confidential'),
('James Patel', 'Systems Engineer', 'NAWCWD', 'secret'),
('Elena Morozov', 'Mission Planner', 'DoD Contractor', 'confidential');

INSERT INTO "missions" ("mission_code", "aircraft_id", "range_id", "mission_type", "mission_date", "start_time", "end_time") 
VALUES
('M001', 1, 1, 'Weapons Integration', '2026-02-01', '09:00', '10:15'),
('M002', 2, 2, 'Electronic Warfare Test', '2026-02-02', '11:30', '12:45'),
('M003', 3, 3, 'UAV Surveillance', '2026-02-03', '08:00', '10:00'),
('M004', 4, 1, 'Radar Cross Section Test', '2026-02-04', '13:20', '14:40'),
('M005', 1, 4, 'Flight Envelope Expansion', '2026-02-05', '07:15', '08:30');

INSERT INTO "weather_conditions"("mission_code", "temperature_f", "wind_speed_knots", "wind_gusts_knots", "wind_direction_deg", "visibility_miles", "precipitation_inches", "humidity_percent")
VALUES
('M001', 82, 12, 18, 210, 10, 0.0, 25),
('M002', 70, 20, 28, 190, 8, 0.1, 40),
('M003', 95, 10, 15, 180, 12, 0.0, 20),
('M004', 88, 30, 35, 200, 5, 0.0, 30),
('M005', 60, 8, 12, 150, 15, 0.0, 35);

INSERT INTO "mission_results" ("mission_code", "status", "primary_reason", "notes") 
VALUES
('M001', 'GO', 'Weather within limits', 'Successful weapons integration test'),
('M002', 'GO', 'System validation', 'Electronic warfare system behaved as expected'),
('M003', 'GO', 'Clear surveillance conditions', 'Long endurance UAV mission completed'),
('M004', 'NO_GO', 'High wind gusts', 'Unsafe takeoff conditions detected'),
('M005', 'GO', 'Stable conditions', 'Flight envelope expanded successfully');

INSERT INTO "mission_risk_assessments"("mission_code", "warnings_triggered", "risk_level", "decision", "explanation")
VALUES
('M001', 0, 'LOW', 'GO', 'All environmental parameters within limits'),
('M002', 1, 'MODERATE', 'GO', 'Moderate wind gusts detected'),
('M003', 0, 'LOW', 'GO', 'Clear flight conditions'),
('M004', 3, 'HIGH', 'NO_GO', 'Wind gusts exceeded safe launch threshold'),
('M005', 0, 'LOW', 'GO', 'Weather stable and safe for mission');

INSERT INTO "mission_logs"("mission_code", "operator_id", "system_notes") 
VALUES
('M001', 1, 'Initial mission evaluation logged'),
('M001', 2, 'Range control confirmed launch window'),
('M002', 3, 'Weather conditions reviewed'),
('M003', 1, 'UAV systems verified'),
('M004', 4, 'Abort decision recorded due to wind gusts'),
('M005', 5, 'Mission planning finalized');