Olaf Kock 3 Years Ago If you're looking for a printable poster with *everything* you need to know about the database: It's attached to this article: https://liferay.dev/blogs/-/blogs/understanding-liferay-s-database (I've taken the liberty entering it as related asset, so the two articles are now linked) Please sign in to reply. Reply as... Cancel
Alberto Chaparro 3 Years Ago Thanks Sam! This diagram is really useful when diagnosing issues during the upgrade or building queries to extract some data. Olaf, I agree the Liferay API is the only way to modify the data however having some knowledge about how the data is stored is crucial to solving complex issues, especially for community users with no official Liferay support. I encourage everyone to add more tables and build the whole database diagram! Please sign in to reply. Reply as... Cancel
Rodrigo Coutinho 1 Year Ago - Edited Hi, i agree that one should not mess with the DB, however in my case i work in SQL and do not have nowledge of Java, but must report some audits and statistics about users, etc. So, to me, it is most useful to know something about the underlying table relastionships. Regards Please sign in to reply. Reply as... Cancel