Skip to main content

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.