ER Diagram

[Inderjeet singh Narang，修改在13 年前。]

Hi,
Is there any document or link where I can get the lportal ER diagram for Liferay 5.2.x version.Any help will be greatly appriciated.

Thanks
Inderjeet

[Juan Fernández，修改在13 年前。]

Hi Inderjeet:

there's no offical ER diagram of our data base schema. I recommend you to use a reverse ingeneering tool to extract the diagram from the sql files (for example MySQL Workbench)

Feel free to contribute it back to the community creating a wiki page with the diagrams if you want to

Thanks!
Juan Fernández

[petar banicevic，修改在8 年前。]

I don't see any foreign keys in SQL files, therefore how do you envision that a reverse engineering tool can draw any kind of relationship only from PKs ??

[David H Nebinger，修改在8 年前。]

There are no FKs defined. There are no relationships defined, and no reverse engineering tool will be able to derive those relations because of the nature of how Liferay stores data.

Only the API is available for you, study the API and use it exclusively.