Document all existing and working data types

[Ludee]

A lot of data types are already implemented but are not documented yet.

Create a table with existing and missing data types.

[jh-RLI]

using import sqlalchemy as sa the following data types are tested and working:

Mapping of common datatype names and sqlalchemy types:

• "bigint": sa.BIGINT
• "int": sa.INTEGER
• "integer": sa.INTEGER
• "varchar": sa.VARCHAR
• json": sa.JSON
• text": sa.TEXT
• "timestamp": sa.TIMESTAMP
• interval": sa.Interval
• "string": sa.String
• "float": sa.FLOAT
• "boolean": sa.Boolean
• "date": sa.Date
• "hstore": HSTORE
• "decimal": sa.DECIMAL
• "numeric": sa.NUMERIC

Spatial types

• "geometry point": Geometry("POINT", spatial_index=False)
• "geom": Geometry("GEOMETRY", spatial_index=False)
• "geometry": Geometry("GEOMETRY", spatial_index=False),