# Column types

<figure><img src="/files/AFNUUALcoroeEndvz6O6" 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](/navigation/settings/import-export.md) 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](/start-quickly/bot-templates/gym.md) is a representative use case.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.chatlayer.ai/navigation/tables/column-types.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
