Column Types

Text Types

Propel Type	Desc	Example Default DB Type (MySQL)	Default PHP Native Type
CHAR	Fixed-length character data	CHAR	string
VARCHAR	Variable-length character data	VARCHAR	string
LONGVARCHAR	Long variable-length character data	TEXT	string

Numeric Types

Propel Type	Desc	Example Default DB Type (MySQL)	Default PHP Native Type
DECIMAL	Decimal data	DECIMAL	string (PHP int is limited)
TINYINT	Tiny integer	TINYINT	int
SMALLINT	Small integer	SMALLINT	int
INTEGER	Integer	INTEGER	int
BIGINT	Large integer	BIGINT	string (PHP int is limited)
FLOAT	Floating point number	FLOAT	double

Temporal (Date/Time) Types

Propel Type	Desc	Example Default DB Type (MySQL)	Default PHP Native Type
DATE	Date (e.g. YYYY-MM-DD)	DATE	DateTime object
TIME	Time (e.g. HH:MM:SS)	TIME	DateTime object
TIMESTAMP	Date + time (e.g. YYYY-MM-DD HH:MM:SS)	DATETIME	DateTime object

Other Types

• BOOLEAN
• ENUM columns accept values among a list of predefined ones. Set the value set using the valueSet attribute, separated by commas.