Joomla Stack Exchange is a question and answer site for Joomla! administrators, users, developers and designers. It only takes a minute to sign up.
Sign up to join this community
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?
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.
