migrations improved to fix all foreign key issues. forecast submission now works