SQLite3 is awesome but turned out if you create a new RoR application with table and child table with child records and then rename or remove a column then all child records are deleted. This issue is currently present in both 8.1.3 release and edge versions.