python

Column and data types in Sqlalchemy

Different data types for columns in Sqlalchemy that you can use while creating your models and tables.

Integer #integer type
SmallInteger #Small integer type
BigInteger #Big integer type
String #all string and character types
Text #variably sized string type
Boolean #Bool data type
Float #floating point data type
Enum #Generic Enum Type
Date #data type for datetime.date() objects
DateTime #data type for datetime.datetime() objects
Interval #data type for datetime.timedelta() objects
LargeBinary #large binary byte data
PickleType #Holds Python objects, which are serialized using pickle
Time #data type for datetime.time() objects
Was this helpful?