ER Diagram

[Inderjeet singh Narang, geändert vor 13 Jahren.]

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, geändert vor 13 Jahren.]

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, geändert vor 8 Jahren.]

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, geändert vor 8 Jahren.]

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.