Magento 2 available install schema columns type

1. Type boolean

TYPE_BOOLEAN = ‘boolean’;

Boolean: These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true.
Example

addColumn(
            'post_id',
            Table::TYPE_BOOLEAN,
            null,
            [ 'identity' => false, 'nullable' => false, 'primary' => true ],
            'Post ID'
        )

2. Type smallint

TYPE_SMALLINT = ‘smallint’;

Example

addColumn(
            'post_id',
            Table::TYPE_SMALLINT,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

3. Type integer

TYPE_INTEGER = ‘integer’;

Example

addColumn(
            'post_id',
            Table::TYPE_INTEGER,
            null,
            ['nullable' => false],
            'Post ID'
        )

4. Type bigint

TYPE_BIGINT = ‘bigint’;

Example

addColumn(
            'post_id',
            Table::TYPE_BIGINT,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

5. Type float

TYPE_FLOAT = ‘float’;

Example

addColumn(
            'post_id',
            Table::TYPE_FLOAT,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

6. Type numeric

TYPE_NUMERIC = ‘numeric’;

Example

addColumn(
            'post_id',
            Table::TYPE_NUMERIC,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

7. Type decimal

TYPE_DECIMAL = ‘decimal’;

Example

addColumn(
            'post_id',
            Table::TYPE_DECIMAL,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

8. Type date

TYPE_DATE = ‘date’;

Example

addColumn(
            'data',
            Table::TYPE_DATE,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

9. Type timestamp

TYPE_TIMESTAMP = ‘timestamp’;

Example

->addColumn(
            'creation_time',
            Table::TYPE_TIMESTAMP,
            null,
            ['nullable' => false, 'default' => \Magento\Framework\DB\Ddl\Table::TIMESTAMP_INIT],
            'Creation Time'
        )

10. Type datetime

Capable to support date-time from 1970 + auto-triggers in some RDBMS

TYPE_DATETIME = ‘datetime’;

Example

addColumn(
            'data',
            Table::TYPE_DATETIME,
            null,
            [ 'nullable' => false ],
            'Post ID'
        )

11. Type text

Capable to support long date-time before 1970

TYPE_TEXT = ‘text’;

Example

addColumn(
            'data',
            Table::TYPE_TEXT,
            255,
            [ 'nullable' => false],
            'Post ID'
        )

12. Type blob

TYPE_BLOB = ‘blob’;

Example

addColumn(
            'data',
            Table::TYPE_BLOB ,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

13. Type varbinary

Used for back compatibility, when query param can’t use statement options

TYPE_VARBINARY = ‘varbinary’;

Example

addColumn(
            'data',
            Table::TYPE_VARBINARY,
            null,
            [ 'nullable' => false],
            'Post ID'
        )

That’s all.