# Reference - Column Data Types

When creating Tables and Columns, each Column has a type property specifying the data type of the Column using an int code.

Specifying a type is only required when creating Columns in a regular Table. For custom Tables, Columns are created automatically with the most appropriate type based on the SQL expression specified for the custom Table.

Below is a table of primary supported data type codes. While other codes may be supported, they will be treated the same way as the codes below, thus only a limited list is provided.

Code	Type
8	Int
0	BigInt
5	Decimal
13	Real
6	Float
19	Timestamp
18	Text

Note that Sisense Datamodels do not have a specific representation for types such as bit or boolean - these are converted to the most appropriate supported data type, most commonly Text.