ColumnType

The Propel data types.

values

• BOOLEAN

  True or false.

• STRING

  A variable-length string.

• FLOAT

  A 32-bit signed double-precision floating point number.

• DOUBLE

  A 64-bit signed double-precision floating point number.

• INT8

  An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.

• INT16

  A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.

• INT32

  A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.

• INT64

  A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.

• DATE

  A date without a timestamp. For example, "YYYY-MM-DD".

• TIMESTAMP

  A date with a timestamp. For example, "yyy-MM-dd HH:mm:ss".

• JSON

  A JavaScript Object Notation (JSON) document.