Documentation

    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Welcome to the Live Chat Database Schema Reference

  • Article
  • 1 minutes to read

This guide provides a clear and accessible overview of the data structures that underpin Hornbill applications. Whether you’re building reports, defining metrics, integrating with our APIs, or simply exploring how your data is organized, this reference serves as the single source of truth for the Live Chat schema.

Each table is documented with detailed information, including field definitions, data types, relationships, and usage notes. The content is automatically generated and kept up to date with the latest state of our production database, ensuring you always have accurate and current insights at your fingertips.

Quick Start

To get started:

  1. Browse the Schema – Browse the tables and their descriptions to get a high-level understanding of key entities and their relationships.
  2. Search for a Table – Use the search bar to quickly locate a specific table or field.
  3. Explore Relationships – Navigate between related tables to understand how different parts of the system are connected.
  4. Check Usage Notes – Review any additional notes for tips on querying or understanding specific fields.

If you’re looking for something specific and can’t find it, please visit the Hornbill Community Forums for further guidance.

  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document