This is an example database

The schema is real, but it is not connected to a database. Sign in to import or connect your own.

Sign in to add yours

Support tickets

MySQL 8.0

Agents, customers, tickets, messages and tags for a support desk.

ExampleImportedVersion 8.0
5 tables20 columns6 primary keys5 foreign keysAdded Jul 18, 2025, 9:15:00 AM

Database rules

The AI follows these rules in every chat that uses this database.

  • First response time is the first message by a user with role 'agent' minus the ticket's created_at.
  • Resolved tickets have a non-null resolved_at.

5 tables, 20 columns — 6 primary keys and 5 foreign keys.