←Main

Database

The database is the foundation of HelpdeskAI.
It stores all persistent data required for the agent to operate predictably, trace actions, and demonstrate real-world helpdesk workflows.

In this section, you will:

• review the database structure,
• create each table step by step,
• and populate the database with sample data used in the demo.

⚠️ Important
If you follow the steps in this section exactly, you will end up with the same database schema and sample data as used in the HelpdeskAI demo application.

---

What You’ll Build

By the end of this section, you will have:

• A fully configured database schema
• Tables for customers, FAQs, tickets, and ticket messages
• Proper relationships between tables
• Sample data ready for agent workflows

---

Prerequisites

Before continuing, make sure you have:

• Access to Axellero Studio
• Permission to create and modify databases
• Completed the Introduction section
• Basic familiarity with tables and columns

---

Database Walkthrough

Overview of Tables

The HelpdeskAI database consists of the following tables:

• customers
  Stores users interacting with the helpdesk system

• faqs
  Stores predefined questions and answers used for automation

• tickets
  Stores support requests created by users

• ticket_messages
  Stores structured conversation summaries linked to tickets

Each table has a single responsibility and is connected through explicit references.

---

Step 1 — Creating database schema

Database module is a part of Axellero studio which is used to creating and configuring database for HelpdeskAI.

---

Step 2 — Populate database with sample static data

Database contains tables that store static values like statuses, departments and etc. These tables are referenced in main tables, and may contain additional information about types and specific codes