added routes and id columns for relationships