# Column types

<figure><img src="https://2786867680-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LLTwFwbOqJj4dDhg8Ju%2Fuploads%2FFu1aNNockcm0wKgAbib8%2FScreenshot%202024-03-14%20at%2013.56.27.png?alt=media&#x26;token=a6ca15f3-2ad0-4002-8d7f-ba38c869bd4b" alt=""><figcaption><p>The list of the table column types.</p></figcaption></figure>

{% hint style="danger" %}
Please note that Tables cannot be exported at[ bot export](https://docs.chatlayer.ai/navigation/settings/import-export) yet.
{% endhint %}

## **Integer**

An integer (`int`) is a data type used to store whole numbers (both positive and negative) without decimals.&#x20;

**Use cases**: It is commonly used for counting or indexing purposes, such as storing the quantity of items, age, or any other countable measure.

## **Boolean**

A boolean (`bool`) is a binary data type that can hold one of two possible values: **`true`** or **`false`**.&#x20;

**Use cases**: It is ideal for storing simple flags or status information, such as whether an account is active or if a user has accepted terms and conditions.

## Timestamp

A timestamp is a data type used to store date and time information. It can include both the date and the time of day, and it is often stored with time zone information.

**Use cases:** It is commonly used for recording events, such as creation or modification times of records, logging user activities, or scheduling tasks.

## **Text**

The text (`text`) data type is used for storing any kind of textual data, potentially of unlimited length.&#x20;

**Use cases**: Perfect for storing names, descriptions, or even whole articles. It accommodates characters, including letters, numbers, symbols, and spaces.

## **UUID**

A Universally Unique Identifier (`uuid`) is a 128-bit number used to uniquely identify information in computer systems.&#x20;

**Use cases**: Its primary use is in databases as a unique identifier for each record, ensuring that each entry is distinct, even across different databases or tables.

## **Numeric**

Numeric (`numeric`) is a data type that stores numbers with a lot of precision. It can handle numbers with a large number of digits before and after the decimal point.&#x20;

**Use cases**: It is used for storing exact values, such as financial data (e.g., prices, costs), scientific measurements, or any other field where precision is crucial.

## **JSONB (JSON Binary)**

JSONB (`jsonb`) is a format for storing JSON (JavaScript Object Notation) data in a binary format.&#x20;

**Use cases**: This type is useful for storing and querying structured, but schema-less data. It's ideal for flexible or evolving data models, such as user profiles, configurations, or any scenario where the data structure may vary or expand over time.

***

{% hint style="success" %}
Looking for a quick and easy bot template to play with Tables? The [Gym bot](https://docs.chatlayer.ai/start-quickly/bot-templates/gym) is a representative use case.
{% endhint %}