1

As it's obvious, joomla doesn't use relation views and foreign keys. It seems that everything is handling in the application level (not in the database).

For example, a reference value can be deleted , and still the foreign key can exists! It violates the databases rules. Isn't it?

2

Joomla tables were initially built on MyISAM database engine of MySQL which does not support foreign keys.

Recent versions of Joomla! switched to InnoDB engine which supports foreign keys/views however to keep backward compatibility there are no foreign keys introduced.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.