Datatypes
=========

Currently this library uses `tableschema-sql-py` to convert table schema types to database types.

The following was written for v1.2.0 of `tableschema-sql-py`.

Follow this link to see the code that does that -- https://github.com/frictionlessdata/tableschema-sql-py/blob/0a4b600561c28b15661bea59254bd6c38f1b8787/tableschema_sql/mapper.py#L143-L168

(sa refers to sqlalchemy types)

- 'any': sa.Text
- 'array': JSONB
- 'boolean': sa.Boolean
- 'date': sa.Date
- 'datetime': sa.DateTime
- 'duration': sa.Text
- 'geojson': JSONB
- 'geopoint': sa.Text
- 'integer': sa.Integer
- 'number': sa.Numeric
- 'object': JSONB
- 'string': sa.Text
- 'time': sa.Time
- 'year': sa.Integer
- 'yearmonth': sa.Text

Known bug
---------

`date` and `datetimes` have a resolution bug. The application seems to assume you have a resolution of 1 millisecond so any times you send will have zeros appended to it.