2019-07-17 11:47:52.467 UTC [28314] inovace@matador_sales STATEMENT:  INSERT INTO target_route ( route_id, target_category, target_contribution, status, creation_date, created_by ) VALUES ('3023', 'FF', '15', '1', '2019-07-17 17:47:52', '101010') RETURNING id
2019-07-17 11:47:52.469 UTC [28314] inovace@matador_sales ERROR:  insert or update on table "route_target_achievement" violates foreign key constraint "route_target_achievement_route_id_fk"
2019-07-17 11:47:52.469 UTC [28314] inovace@matador_sales DETAIL:  Key (route_id)=(3023) is not present in table "route".
2019-07-17 11:47:52.469 UTC [28314] inovace@matador_sales STATEMENT:  INSERT INTO route_target_achievement ( route_id, category, target_quantity, target_amount, achieved_quantity, achieved_amount, progress_in_percentage, time_passed, lppc, pc, year, month ) VALUES ('3023', 'FF', '0', '0', '0', '0', '0', '0', '0', '0', '2019', '7') RETURNING id
2019-07-17 11:47:52.531 UTC [28314] inovace@matador_sales ERROR:  insert or update on table "target_route" violates foreign key constraint "target_route_route_id_fk"
2019-07-17 11:47:52.531 UTC [28314] inovace@matador_sales DETAIL:  Key (route_id)=(3023) is not present in table "route".
2019-07-17 11:47:52.531 UTC [28314] inovace@matador_sales STATEMENT:  INSERT INTO target_route ( route_id, target_category, target_contribution, status, creation_date, created_by ) VALUES ('3023', 'NB', '10', '1', '2019-07-17 17:47:52', '101010') RETURNING id
2019-07-17 11:47:52.533 UTC [28314] inovace@matador_sales ERROR:  insert or update on table "route_target_achievement" violates foreign key constraint "route_target_achievement_route_id_fk"
2019-07-17 11:47:52.533 UTC [28314] inovace@matador_sales DETAIL:  Key (route_id)=(3023) is not present in table "route".
2019-07-17 11:47:52.533 UTC [28314] inovace@matador_sales STATEMENT:  INSERT INTO route_target_achievement ( route_id, category, target_quantity, target_amount, achieved_quantity, achieved_amount, progress_in_percentage, time_passed, lppc, pc, year, month ) VALUES ('3023', 'NB', '0', '0', '0', '0', '0', '0', '0', '0', '2019', '7') RETURNING id