Support

Akeeba Ticket System

#42515 Mapping of ATS Database

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
5.4.1
PHP version
n/a
Akeeba Ticket System version
n/a

Latest post by nicholas on Monday, 08 December 2025 01:19 CST

atolli

Hello back again. i like to know if in your documentation there is a schematic of the database and tables used - a picture paints a 1000 words,

Thank you and have a great week.

nicholas
Akeeba Staff
Manager

No, we do not have that. The table names and their field names are very much self-explanatory and follow Joomla's conventions.

Also note that there are no foreign in our tables or Joomla's tables. That's a deliberate choice Joomla has made. Handling relations in software instead of the database layer itself allows it to fire plugin events when a database record is created, updated, or deleted. This is what makes it such a powerful CMS and allows for features like custom fields and tags (which are handled by Joomla itself; we don't interface with these database tables directly in our code!). 

Also note that since Joomla and ATS are compatible with both MySQL and PostgreSQL, and the fact that these two RDBMS don't have 1:1 mapping of field types, the schemas are functionally equivalent but not identical. A diagram would always be diverging from the schema unless we kept separate diagrams for each RDBMS, quadrupling the work we have to do for every schema change. That's a lot of error-prone work without any benefits for us, only downsides.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!