Chatlayer Documentation
Get in touchAbout Chatlayer
  • Welcome
  • What's new
  • Send feedback
  • start quickly
    • Leadzy tutorial
      • 0. Introduction
      • 1. New bot, new block
      • 2. Understand your users
      • 3. Collect and display user input
      • 4. Steer the conversation with Conditions
      • 5. Empower your bot with Actions
      • 6. Set up a channel and publish your bot
    • Templates
      • Banking
      • E-Commerce Returns
      • E-Bike Shop
      • E-Scooter Support
      • Feedback
      • Find Nearest Location
      • GPT
      • 🆕Gym
      • Job applications
      • Knowledge base AI template
      • Lead generation
      • 🆕NPS
      • Restaurant
      • Retail
  • navigation
    • Analytics
      • Dashboard
      • Customers
      • Conversations
      • User flow
      • Intents
      • 🆕Funnels [Beta]
    • Bot builder
      • Flows
        • Canvas functionalities
        • Collaborate with team members
        • Manage your flows
        • 🆕[Beta] Export and import flows
      • Bot dialogs view
      • Translations
      • Events
    • NLP
      • Dashboard
      • Intents
      • Expressions
      • Entities
      • Train
      • NLP settings
      • Improve
    • Knowledge base AI
      • Add content to your KBAI
      • Build your KBAI flow
      • Use your KBAI source URL in a button
      • Use tags to limit your KBAI content
      • 🆕Use Tables to store your KBAI questions
      • 🆕Manage handover where KBAI is unsatisfactory
    • History
      • Conversations
      • Execution logs
      • Versions
    • Channels
    • Tables
      • Create a table with records
      • Column types
      • Operate on your records
        • Insert record
        • Update record
        • Retrieve record
        • Delete record
      • API
    • Settings
      • Bot settings
      • Offloading
      • Variables
      • Voice
      • Import/Export
  • build your bot
    • Conversation design
      • Plan your bot
      • Conversation design workflow
    • Flow logic
      • Blocks
        • Message
        • Condition
        • Collect input
        • Action
      • Go-to connections
    • 🆕Emulator
    • Tips & best practices
      • Route your flow depending on the time
      • Improve the Not understood block
        • How to create better not understood messages
        • Not understood counter
        • Not understood Google search
      • Go to previous block
      • Recognizing a returning user
      • Skip introduction message
      • Route your flow depending on the channel
      • Reuse flows
      • Connect two bots to each other
  • understand users
    • Natural language processing (NLP)
      • Basic NLP concepts
      • Detect information with entities
        • Match entities
        • Contextual entities
        • System entities
        • Composite entities
      • NLP best practices
        • Word order and diversity of expressions
      • AI intent booster
      • Train your NLP
      • Context
      • NLP import & export
      • Sentiment analysis
    • Languages
      • Supported languages
      • Make your bot multilingual
      • Change language within the conversation
  • set up channels
    • Add a channel to your bot
    • All channels
      • 🚨Facebook Messenger [Deprecated soon]
        • Facebook Admin Removal
        • Facebook Webview Whitelisting
        • Facebook Messenger API updates for Europe
      • 🚨Google Assistant [Deprecated soon]
      • Webhook
      • Web
        • 🚨Web V1 [Deprecated]
          • Customize web widget
          • Live example web widget
        • 🆕Web V2
          • 🆕From Web V1 to V2
          • 🆕Web V2 methods and options
    • Sinch Conversation API
      • Configure your Sinch Conversation API
      • 🆕 Make the most of RCS with Carousels
      • WhatsApp Business API
  • integrate & code
    • API calls
      • Configure your API integration
      • Advanced API features
      • V1 API Reference
      • Custom integrations 101
    • Code editor
      • [Example] Sending data to Airtable (POST)
      • [Example] Retrieving data from Airtable (GET)
      • [Example] Making SOAP requests
    • App integrations
      • Airtable
      • Freshdesk
      • Freshdesk Messaging
      • 🆕Gmail
      • Intercom
      • Mailgun
      • OpenAI: GPT-3, ChatGPT and GPT-4
      • Salesforce
      • 🆕Slack
      • Topdesk
      • Zendesk Support
      • Zendesk Sunshine (beta)
    • 🆕Expression syntax
    • Human handover & live chat
      • Sinch Contact Pro
      • #Interact
      • Genesys Cloud
      • Offloading Webhook
      • Salesforce Service Cloud
      • Sparkcentral by Hootsuite
      • Zendesk Chat
    • Chatlayer messages specifications
  • Publish
    • Publish your bot
      • Publish a flow
  • Analyze & maintain
    • Analytics definitions
    • Data retention
    • Maintenance
    • Session
    • Track events for analytics
  • VOICE
    • 🆕Send bot response as audio
    • Voicebots
      • Create a voicebot
      • Voicebot-specific actions
      • Test your voicebot
      • From chat to voice
  • access & support
    • Identity & Access
      • Single Sign-On (SAML SSO)
    • Billing & subscription
    • Get in touch
    • Chatlayer glossary
    • SaaS Regions & IP Ranges
    • Status
    • Debug your bot
      • No correct response
      • Collect input not working
      • Video isn't working
Powered by GitBook
On this page
  • Integer
  • Boolean
  • Timestamp
  • Text
  • UUID
  • Numeric
  • JSONB (JSON Binary)

Was this helpful?

  1. navigation
  2. Tables

Column types

Each column type in your Tables serves specific data storage needs, and choosing the right type is crucial for optimizing performance, storage efficiency, and query capabilities of your table.

PreviousCreate a table with recordsNextOperate on your records

Last updated 9 months ago

Was this helpful?

Please note that Tables cannot be exported at yet.

Integer

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

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.

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.

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.

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.

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.

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.


Looking for a quick and easy bot template to play with Tables? The is a representative use case.

Gym bot
bot export
The list of the table column types.