# 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.