The redhillonrails core plugin keeps foreign key constraints in sync in schema.rb. No such luck for triggers or views. But no reason someone couldn't add that functionality.