The following numeric types are available:
INTEGER: An integer value field (usually a 32-bit int) that stores integer values from -2147483648 to 2147483647"
SMALLINT: An integer value field (usually a 16-bit int) that stores integer values from (at least) -32768 to 32767
BIGINT: An integer value field (usually a 64-bit int) that stores integer values from -9223372036854775808 to 9223372036854775807
DOUBLE PRECISION: A floating point value with at least 15 digits of precision (typically a standard 64-bit floating-point value with 53 bits of precision)
FLOAT: A floating point value with at least 6 digits of precision (typically a standard 32-bit floating-point value with 24 bits of precision). This is sometimes known as a REAL, but a REAL is also sometimes an alias for a DOUBLE PRECISION
NUMERIC: A fixed-point numeric type. Also known as DECIMAL. This type is substantially slower than integer and floating-point types, but guarantees precision for the range of values it supports. The precision value is the total number of digits storable, and the scale is the number of digits stored after the decimal point. "12345.67" has precision 7 and scale 2.
The following character and data types are available:
VARCHAR: Stores a string of characters of up to size characters. Unlike a CHAR, a VARCHAR column is typically stored using the minimum storage space required, while a CHAR field pads shorter strings to always store values of size length.
CHAR: Stores a string of characters of up to size characters. Unlike a VARCHAR, a CHAR column is typically padded up to the specified size to make it a fixed-width column (the padding is removed on retrieval). Note that some databases implicitly convert CHAR columns to VARCHAR if other variable-size columns exist in the table.
TEXT: Stores large amounts of text data. Also sometimes known as a CLOB.
BLOB: Stores large amounts of binary data (bytes). Will result in a BYTEA under PostgreSQL.
The following date/time types are available:
DATE: A date field that does not include a time, such as "2008/07/14".
TIME: A field that stores just a time (e.g. "12:13:14").
TIMESTAMP: A field that stores a date and time (e.g. "2008/07/14 12:13:14"). Note that this is converted to a DATETIME when using MySQL.
The following other types are supported by Easik:
BOOLEAN: A column that stores true/false values. Note that this type may be converted to a small integer type by databases (such as MySQL) that do not fully support BOOLEAN data types.
Custom Data Type: This allows you to specify any data type supported by your database. Note that the type you enter here will not be checked for correctness: ensure that the provided type is valid for the SQL type(s) you intend to use.