I´m still new to Joomla and to coding SQL.
I was thinking about how I should manage a big system I made with information that is saved in a sql table, that contains some user input and the "id" of an article.
If you or another administrator deletes an article, I guess I have to delete the row containing that articles id in my custom sql table too?
Is there a way to make a script that gets executed every time an article gets deleted? that way I could maybe get the article id and then remove it from my custom table.
How do you guys handle your custom sql tables that contains references to articles or users in Joomla?