def simplified_type(field_type)
case field_type
when /int|bigint|smallint|tinyint/i then :integer
when /numeric/i then (@scale.nil? || @scale == 0) ? :integer : :decimal
when /float|double|decimal|money|real|smallmoney/i then :decimal
when /datetime|smalldatetime/i then :datetime
when /timestamp/i then :timestamp
when /time/i then :time
when /text|ntext/i then :text
when /binary|image|varbinary/i then :binary
when /char|nchar|nvarchar|string|varchar/i then :string
when /bit/i then :boolean
when /uniqueidentifier/i then :string
end
end