SQL Server has smallint not shortint
Generation of Rails has_many/has_one associations is driven of foreign keys, not the intermediate references, so FKs that point at absorbed entities get processed