Avolutions\Database\ColumnType

The ColumnType class contains constants which describes the type of the database column.

Constants

Property	Value	Description
BIGINT	'BIGINT'	A large integer
BINARY	'BINARY'	A fixed-length binary string
BIT	'BIT'	A bit field
BLOB	'BLOB'	A small BLOB
BOOLEAN	'BOOLEAN'	A boolean field
CHAR	'CHAR'	A fixed-length non-binary (character) string
DATE	'DATE'	A date value in YYYY-MM-DD format
DATETIME	'DATETIME'	A date and time value in YYYY-MM-DD hh:mm:ss format
DECIMAL	'DECIMAL'	A fixed-point number
DOUBLE	'DOUBLE'	A double-precision floating point number
ENUM	'ENUM'	An enumeration, each column value may be assigned one enumeration member
FLOAT	'FLOAT'	A single-precision floating point number
INT	'INT'	A standard integer
LONGBLOB	'LONGBLOB'	A large BLOB
LONGTEXT	'LONGTEXT'	A large non-binary string
MEDIUMBLOB	'MEDIUMBLOB'	A medium-sized BLOB
MEDIUMINT	'MEDIUMINT'	A medium-sized integer
MEDIUMTEXT	'MEDIUMTEXT'	A medium-sized non-binary string
SET	'SET'	A set, each column value may be assigned zero or more SET members
SMALLINT	'SMALLINT'	A small integer
TEXT	'TEXT'	A small non-binary string
TIME	'TIME'	A time value in hh:mm:ss format
TIMESTAMP	'TIMESTAMP'	A timestamp value in YYYY-MM-DD hh:mm:ss format
TINYBLOB	'TINYBLOB'	A very small BLOB (binary large object)
TINYINT	'TINYINT'	A very small integer
TINYTEXT	'TINYTEXT'	A very small non-binary string
VARBINARY	'VARBINARY'	A variable-length binary string
VARCHAR	'VARCHAR'	A variable-length non-binary string
YEAR	'YEAR'	A year value in YYYY or YY format

const BIGINT = 'BIGINT'

const BINARY = 'BINARY'

const BIT = 'BIT'

const BLOB = 'BLOB'

const BOOLEAN = 'BOOLEAN'

const CHAR = 'CHAR'

const DATE = 'DATE'

const DATETIME = 'DATETIME'

const DECIMAL = 'DECIMAL'

const DOUBLE = 'DOUBLE'

const ENUM = 'ENUM'

const FLOAT = 'FLOAT'

const INT = 'INT'

const LONGBLOB = 'LONGBLOB'

const LONGTEXT = 'LONGTEXT'

const MEDIUMBLOB = 'MEDIUMBLOB'

const MEDIUMINT = 'MEDIUMINT'

const MEDIUMTEXT = 'MEDIUMTEXT'

const SET = 'SET'

const SMALLINT = 'SMALLINT'

const TEXT = 'TEXT'

const TIME = 'TIME'

const TIMESTAMP = 'TIMESTAMP'

const TINYBLOB = 'TINYBLOB'

const TINYINT = 'TINYINT'

const TINYTEXT = 'TINYTEXT'

const VARBINARY = 'VARBINARY'

const VARCHAR = 'VARCHAR'

const YEAR = 'YEAR'