
INSERT INTO "lqbz"."sys_oss_config"("oss_config_id","tenant_id","config_key","access_key","secret_key","bucket_name","prefix","endpoint","domain_name","is_https","region","access_policy","status","ext1","version","create_by","create_time","update_by","update_time","remark") VALUES(5,0,'local','eco-local','eco-local','eco-bucket','','localhost','','N','','1','1','',8,1,TO_DATE('2024-06-25 15:35:13.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-26 11:07:04.099000','YYYY-MM-DD HH24:MI:SS.FF'),'');

INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216728698285953024,1,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','001','机体','JT-001','1','成飞','1',null,0,0,2,null,TO_DATE('2024-11-20 14:23:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:11:58.744000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216728760453926912,216728698285953024,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','002','机翼','JY-002','2','2','2',null,0,0,2,null,TO_DATE('2024-11-20 14:23:43.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:13:10.972000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216732570068946944,216728698285953024,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','003','机身','JS-003','3','3','3',null,0,0,2,null,TO_DATE('2024-11-20 14:38:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:17:42.232000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216742264703520768,216728760453926912,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','004','翼梁','YL-004','4','4','4',null,0,0,0,null,TO_DATE('2024-11-20 15:17:22.781000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:17:22.781000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216742531020853248,216728698285953024,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','005','尾翼','WY-005','005','5','5',null,0,0,0,null,TO_DATE('2024-11-20 15:18:26.276000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:18:26.276000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216742710969077760,1,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','006','操作系统','006','6','成飞','6',null,0,0,1,null,TO_DATE('2024-11-20 15:19:09.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-26 23:05:18.294000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216742837473480704,216742710969077760,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','007','方向舵','007','7','7','7',null,0,0,0,null,TO_DATE('2024-11-20 15:19:39.340000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:19:39.340000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216742953534066688,216742710969077760,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','008','升降舵','008','8','8','8',null,0,0,0,null,TO_DATE('2024-11-20 15:20:07.011000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:20:07.011000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216743032512811008,216742710969077760,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','009','减速板','009','9','9','9',null,0,0,0,null,TO_DATE('2024-11-20 15:20:25.841000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:20:25.841000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216743213111152640,216743032512811008,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','010','XX开关','010','10','10','10',null,0,0,0,null,TO_DATE('2024-11-20 15:21:08.899000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:21:08.899000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216743730642128896,1,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','011','机载设备','011','11','1','11',null,0,0,0,null,TO_DATE('2024-11-20 15:23:12.288000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:23:12.288000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(216743959579824128,1,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','012','起落装置','012','12','12','12',null,0,0,0,null,TO_DATE('2024-11-20 15:24:06.871000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-20 15:24:06.871000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(219034276295282688,216743730642128896,null,'','ed5c70c2f7e94bcba3cd61d5248c4e9e','JZ111','发动机','发动机111','图号11','成飞','',null,0,0,0,null,TO_DATE('2024-11-26 23:05:00.929000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-26 23:05:00.929000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(224658410014482432,1,null,'','0a4c37960f284f0480e990a3a28e320d','11','机载设备','11','11','11','',null,0,0,0,null,TO_DATE('2024-12-12 11:33:18.907000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-12 11:33:18.907000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(224658469548433408,224658410014482432,null,'','0a4c37960f284f0480e990a3a28e320d','22','发动机','22','22','22','',null,0,0,0,null,TO_DATE('2024-12-12 11:33:33.092000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-12 11:33:33.092000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(224658518374326272,1,null,'','0a4c37960f284f0480e990a3a28e320d','33','操作系统','33','33','33','',null,0,0,1,null,TO_DATE('2024-12-12 11:33:44.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-12 11:33:54.573000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_configuration_t"("id","parent_id","parent_name","ancestors","aircraft_type","con_code","name","specs_model","drawing_number","supplier","remarks","tenant_id","order_num","del_flag","version","create_by","create_time","update_by","update_time") VALUES(224658706497249280,224658518374326272,null,'','0a4c37960f284f0480e990a3a28e320d','444','方向舵','44','44','','',null,0,0,0,null,TO_DATE('2024-12-12 11:34:29.585000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-12 11:34:29.585000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "lqbz"."als_air_install_t"("id","air_id","air_model_id","config_id","devices_encode","devices_code","devices_name","specs_model","drawing_number","category","quantity","install_time","software_version","repairable","complete_set","service_life","rated_life","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(219556887911653376,'dfc9d75b6db0404ca8a1305a0b628ea9','ed5c70c2f7e94bcba3cd61d5248c4e9e','216742953534066688','测试航材','航材代码11','测试航材','测试航材','测试航材','飞发','2','2024-11-28','1','1','1','1',2,'',null,0,1,null,TO_DATE('2024-11-28 09:41:41.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-28 16:41:52.816000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_air_install_t"("id","air_id","air_model_id","config_id","devices_encode","devices_code","devices_name","specs_model","drawing_number","category","quantity","install_time","software_version","repairable","complete_set","service_life","rated_life","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(224725344391159808,'00d420bfac734e57891ceece49655d95','0a4c37960f284f0480e990a3a28e320d','224658706497249280','HC_TB20240001','','航材发动机TB2024','HC_TB2024','','飞发','','','','1','1','1',1,'',null,0,0,null,TO_DATE('2024-12-12 15:59:17.297000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-12 15:59:17.297000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462351810560,'0','','J100',null,0,0,0,0,1,TO_DATE('2024-07-29 10:28:57.008000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.008000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462376976384,'175357462351810560','J100','3',null,2,0,0,0,1,TO_DATE('2024-07-29 10:28:57.014000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.014000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462389559296,'175357462351810560','J100','4',null,3,0,0,0,1,TO_DATE('2024-07-29 10:28:57.017000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.017000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462402142208,'175357462351810560','J100','5',null,4,0,0,0,1,TO_DATE('2024-07-29 10:28:57.020000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.020000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462423113728,'175357462351810560','J100','6',null,5,0,0,0,1,TO_DATE('2024-07-29 10:28:57.025000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.025000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462439890944,'175357462351810560','J100','7',null,6,0,0,0,1,TO_DATE('2024-07-29 10:28:57.029000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.029000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357462465056768,'175357462351810560','J100','8',null,7,0,0,0,1,TO_DATE('2024-07-29 10:28:57.035000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:28:57.035000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673623097344,'0','','J20',null,1,0,1,0,1,TO_DATE('2024-07-29 10:29:47.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 17:10:40.475000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673644068864,'175357673623097344','J20','3',null,2,0,0,0,1,TO_DATE('2024-07-29 10:29:47.384000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:29:47.384000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673656651776,'175357673623097344','J20','4',null,3,0,0,0,1,TO_DATE('2024-07-29 10:29:47.387000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:29:47.387000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673694400512,'175357673623097344','J20','5',null,4,0,0,0,1,TO_DATE('2024-07-29 10:29:47.396000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:29:47.396000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673711177728,'175357673623097344','J20','6',null,5,0,0,0,1,TO_DATE('2024-07-29 10:29:47.400000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:29:47.400000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673723760640,'175357673623097344','J20','7',null,6,0,0,0,1,TO_DATE('2024-07-29 10:29:47.403000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:29:47.403000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_aircraft_t"("id","parent_id","parent_name","name","ancestors","order_num","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(175357673769897984,'175357673623097344','J20','8',null,7,0,0,0,1,TO_DATE('2024-07-29 10:29:47.414000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-07-29 10:29:47.414000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "lqbz"."als_fault_statistics_t"("id","statistics_date","war_zone","army","division","groups","squadron","aircraft_num","aircraft_model","factory_num","machine_type","machine_num","machine_model","machine_name","landing_gear","major","faulty_parts_name","faulty_parts_model","faulty_parts_num","engine_model","engine_num","engine_serial_num","faulty_parts_position","faulty_phenomenon","faulty_place","find_opportunity","systems","timing_type","faulty_parts_manufacturer","faulty_parts_renovate","installation_time","total_work_time","repair_time","replacement_parts_model","replacement_parts_num","replacement_parts_manufacturer","replacement_total_work_time","replacement_parts_renovate","replacement_repair_time","faulty_abnormal_code","faulty_parts_install_date","faulty_reason","faulty_nature","faulty_responsibility","faulty_consequence","handling_suggestions","influence_frequency","error_fly_frequency","identification_method","discovered_people","exclusion_method","exclusion_people","examine_people","examine_time","exclusion_date","exclusion_work_time","exclusion_people_num","exclusion_time","is_achievement","need_test_fly","repair_status","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225413732395577344,TO_DATE('2024-12-02','YYYY-MM-DD'),'华东','第一军','第二师','第三团','第四中队','J10A','轰01','F0001','发动机','E123','T9876','喷嘴','1','特设','燃油喷嘴','FMJ-01','FSN-001','WSE-12','ENG-01','1','左侧','燃油喷嘴泄漏','机场A','地面检查','动力','单独计时','国产厂A','国产厂C','25：24：59','231：18：23','45：24：33','FMJ-02','FSN-002','国产厂C','124：24：23','国产厂D','24：24：27','FC001',TO_DATE('2024-12-02','YYYY-MM-DD'),'制造原因','一般故障','一般责任','无影响','更换部件','0','0','排除故障','张三','更换部件','李四','王五',TO_DATE('2024-12-02 00:00:00.000000','YYYY-MM-DD HH24:MI:SS.FF'),TO_DATE('2024-12-02','YYYY-MM-DD'),'2：00:00','3','2：00：00','否','否','已完成',null,0,0,0,1,TO_DATE('2024-12-14 13:34:41.789000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-14 13:34:41.789000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_fault_statistics_t"("id","statistics_date","war_zone","army","division","groups","squadron","aircraft_num","aircraft_model","factory_num","machine_type","machine_num","machine_model","machine_name","landing_gear","major","faulty_parts_name","faulty_parts_model","faulty_parts_num","engine_model","engine_num","engine_serial_num","faulty_parts_position","faulty_phenomenon","faulty_place","find_opportunity","systems","timing_type","faulty_parts_manufacturer","faulty_parts_renovate","installation_time","total_work_time","repair_time","replacement_parts_model","replacement_parts_num","replacement_parts_manufacturer","replacement_total_work_time","replacement_parts_renovate","replacement_repair_time","faulty_abnormal_code","faulty_parts_install_date","faulty_reason","faulty_nature","faulty_responsibility","faulty_consequence","handling_suggestions","influence_frequency","error_fly_frequency","identification_method","discovered_people","exclusion_method","exclusion_people","examine_people","examine_time","exclusion_date","exclusion_work_time","exclusion_people_num","exclusion_time","is_achievement","need_test_fly","repair_status","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225413732865339392,TO_DATE('2024-12-02','YYYY-MM-DD'),'华东','第七军','第三师','第三团','第一中队','j-10','轰01','F0002','起落架','E124','AC-03','螺旋桨','1','机电','液压泵','HP-02','HPN-001','WSE-13','ENG-02','2','左前','电源故障','机场A','飞行中','飞控','单独计时','国产厂A','国产厂C','25：24：60','115:30:00','10:15:00','FMJ-03','FSN-003','国产厂C','72：24：24','国产厂D','33：24：28','FC002',TO_DATE('2024-12-02','YYYY-MM-DD'),'设计原因','一般故障','一般责任','无影响','更换部件','0','0','排除故障','李四','更换部件','李四','王五',TO_DATE('2024-12-02 00:00:00.000000','YYYY-MM-DD HH24:MI:SS.FF'),TO_DATE('2024-12-02','YYYY-MM-DD'),'0:54:17','1','2：00：01','否','否','排故中',null,0,0,0,1,TO_DATE('2024-12-14 13:34:41.899000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-14 13:34:41.899000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_fault_statistics_t"("id","statistics_date","war_zone","army","division","groups","squadron","aircraft_num","aircraft_model","factory_num","machine_type","machine_num","machine_model","machine_name","landing_gear","major","faulty_parts_name","faulty_parts_model","faulty_parts_num","engine_model","engine_num","engine_serial_num","faulty_parts_position","faulty_phenomenon","faulty_place","find_opportunity","systems","timing_type","faulty_parts_manufacturer","faulty_parts_renovate","installation_time","total_work_time","repair_time","replacement_parts_model","replacement_parts_num","replacement_parts_manufacturer","replacement_total_work_time","replacement_parts_renovate","replacement_repair_time","faulty_abnormal_code","faulty_parts_install_date","faulty_reason","faulty_nature","faulty_responsibility","faulty_consequence","handling_suggestions","influence_frequency","error_fly_frequency","identification_method","discovered_people","exclusion_method","exclusion_people","examine_people","examine_time","exclusion_date","exclusion_work_time","exclusion_people_num","exclusion_time","is_achievement","need_test_fly","repair_status","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225413733083443200,TO_DATE('2024-12-03','YYYY-MM-DD'),'华东','第一军','第二师','第二团','第一中队','H001','轰04','F0003','液压泵','E125','T9877','喷嘴','1','机械','燃油泵','AC-03','ACS-001','WSE-14','ENG-03','3','右侧','漏油','机场A','机务准备','飞控','单独计时','国产厂A','国产厂C','25：25：22','231：18：24','45：24：34','FMJ-04','FSN-004','国产厂C','153：24：25','国产厂D','24：24：29','FC003',TO_DATE('2024-12-03','YYYY-MM-DD'),'维护原因','一般故障','一般责任','无影响','更换部件','0','0','排除故障','张三','更换部件','李四','王五',TO_DATE('2024-12-03 00:00:00.000000','YYYY-MM-DD HH24:MI:SS.FF'),TO_DATE('2024-12-03','YYYY-MM-DD'),'0:54:17','2','2：00：02','否','否','已完成',null,0,0,0,1,TO_DATE('2024-12-14 13:34:41.951000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-14 13:34:41.951000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "lqbz"."als_lifetime_spare_parts_t"("id","air_id","air_model_id","config_id","component_name","component_model","component_num","factory_date","current_install_aircraft","work_time","rated_lifetime","remaining_lifetime","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225494777866383360,'00d420bfac734e57891ceece49655d95','0a4c37960f284f0480e990a3a28e320d','224658706497249280','1111','2222','333',TO_DATE('2024-12-14','YYYY-MM-DD'),'444','555','6666','7777',null,null,0,0,null,TO_DATE('2024-12-14 18:56:44.538000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-14 18:56:44.538000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_lifetime_spare_parts_t"("id","air_id","air_model_id","config_id","component_name","component_model","component_num","factory_date","current_install_aircraft","work_time","rated_lifetime","remaining_lifetime","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225495596946845696,'00d420bfac734e57891ceece49655d95','0a4c37960f284f0480e990a3a28e320d','224658469548433408','qqq','www','eee',TO_DATE('2024-12-13','YYYY-MM-DD'),'rrr','ttt','yyy','uuu',null,null,0,0,null,TO_DATE('2024-12-14 18:59:59.817000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-14 18:59:59.817000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_lifetime_spare_parts_t"("id","air_id","air_model_id","config_id","component_name","component_model","component_num","factory_date","current_install_aircraft","work_time","rated_lifetime","remaining_lifetime","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225512894269136896,'00d420bfac734e57891ceece49655d95','0a4c37960f284f0480e990a3a28e320d','224658469548433408','111','222','333',TO_DATE('2024-12-15','YYYY-MM-DD'),'444','555','666','777',null,0,0,0,1,TO_DATE('2024-12-14 20:08:43.823000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-14 20:08:43.823000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_lifetime_spare_parts_t"("id","air_id","air_model_id","config_id","component_name","component_model","component_num","factory_date","current_install_aircraft","work_time","rated_lifetime","remaining_lifetime","remarks","tenant_id","del_flag","version","create_by","create_time","update_by","update_time") VALUES(225512894634041344,'ee111','轰03','发动机','qqq','www','eee',TO_DATE('2024-12-15','YYYY-MM-DD'),'rrr','ttt','yyy','uuu',null,0,0,0,1,TO_DATE('2024-12-14 20:08:43.907000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-14 20:08:43.907000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(224424786149142528,'升降仓故障诊断','5','http://127.0.0.1:8888/gzzd','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值","氧气输出流量","氧气浓度","供氧压力","氧分压值"]','1','',null,4,0,null,TO_DATE('2024-12-11 20:04:58.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-19 11:42:45.928000','YYYY-MM-DD HH24:MI:SS.FF'),'216742953534066688');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(224698212478853120,'方向舵故障诊断','5','http://127.0.0.1:8888/gzzd','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值"]','1','',null,4,0,null,TO_DATE('2024-12-12 14:11:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-19 11:18:18.983000','YYYY-MM-DD HH24:MI:SS.FF'),'224658706497249280');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(225015258781519872,'方向舵退化评估','6','http://127.0.0.1:8888/thpg','','["时间","发动机排气温度","燃油流量","氧气输出流量","氧气浓度","供氧压力"]','1','',null,1,0,null,TO_DATE('2024-12-13 11:11:18.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-19 11:40:45.970000','YYYY-MM-DD HH24:MI:SS.FF'),'224658706497249280');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(224424786149242528,'方向舵故障诊断','5','http://127.0.0.1:8888/gzzd','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值","氧气输出流量","氧气浓度","供氧压力","氧分压值"]','1','',null,4,0,null,TO_DATE('2024-12-11 20:04:58.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-19 11:42:45.928000','YYYY-MM-DD HH24:MI:SS.FF'),'224658706497249280');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(226924909472949248,'傅里叶变换去噪','1','http://127.0.0.1:8888/qz','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值"]','1','',null,0,0,null,TO_DATE('2024-12-18 17:39:41.696000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-18 17:39:41.696000','YYYY-MM-DD HH24:MI:SS.FF'),'');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(226924939412949248,'寿命预测','6','http://127.0.0.1:8888/smyc','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值"]','1','',null,1,0,null,TO_DATE('2024-12-18 17:39:41.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-18 17:58:11.122000','YYYY-MM-DD HH24:MI:SS.FF'),'224658706497249280');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(226924939843949258,'线性插值','3','http://127.0.0.1:8888/bq','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值"]','1','',null,1,0,null,TO_DATE('2024-12-18 17:39:41.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-18 17:57:40.962000','YYYY-MM-DD HH24:MI:SS.FF'),'');
INSERT INTO "lqbz"."als_model_t"("id","name","TYPE","url","param","column_data","status","remark","tenant_id","version","del_flag","create_by","create_time","update_by","update_time","part_id") VALUES(226924934572949249,'噪声添加','2','http://127.0.0.1:8888/kc','','["时间","发动机排气温度","燃油流量","高压压气机转子转数","风扇转子转速","机匣频率","机匣振幅","机匣加速","喘振值"]','1','',null,1,0,null,TO_DATE('2024-12-18 17:39:41.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-12-18 17:57:32.314000','YYYY-MM-DD HH24:MI:SS.FF'),'');

INSERT INTO "lqbz"."als_part_replacement_t"("id","aircraft_type","aircraft_code","before_equipment_code","before_equipment_name","before_model_number","after_equipment_code","after_equipment_name","after_model_number","quantity","remarks","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(219026602426044416,'j-10','dfc9d75b6db0404ca8a1305a0b628ea9','编码','名称1','型号','后编码','后名称','后规格','2','',null,0,0,null,TO_DATE('2024-11-26 22:34:31.336000','YYYY-MM-DD HH24:MI:SS.FF'),null,TO_DATE('2024-11-26 22:34:31.336000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(224329080503783424,'JC-20241211134427',null,'JG001','警告001','描述','0',0,2,0,1,TO_DATE('2024-12-11 13:44:40.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-11 17:49:49.286000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(224329081615273984,'JC-20241211134427',null,'JG002','警告002','描述2','1',0,0,0,1,TO_DATE('2024-12-11 13:44:40.890000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-11 13:44:40.890000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(225019003770740736,'JC-20241213112552',null,'JG001','警告001','描述','1',0,0,0,1,TO_DATE('2024-12-13 11:26:11.151000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-13 11:26:11.151000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(225019004550881280,'JC-20241213112552',null,'JG002','警告002','描述2','1',0,0,0,1,TO_DATE('2024-12-13 11:26:11.335000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-13 11:26:11.335000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(225022485361827840,'JC-20241213113944',null,'JG001','警告001','描述','1',0,1,0,1,TO_DATE('2024-12-13 11:40:01.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-13 17:57:56.100000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(225022486204882944,'JC-20241213113944',null,'JG002','警告002','描述2','1',0,0,0,1,TO_DATE('2024-12-13 11:40:01.427000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-13 11:40:01.427000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(225116106576601088,'JC-20241213175027',null,'JG001','警告001','描述','1',0,0,0,1,TO_DATE('2024-12-13 17:52:02.263000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-13 17:52:02.263000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "lqbz"."als_warning_t"("id","sortie_no","aircraft_id","code","name","describe","status","tenant_id","version","del_flag","create_by","create_time","update_by","update_time") VALUES(225116107440627712,'JC-20241213175027',null,'JG002','警告002','描述2','1',0,0,0,1,TO_DATE('2024-12-13 17:52:02.468000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-12-13 17:52:02.468000','YYYY-MM-DD HH24:MI:SS.FF'));
