ER Diagram

[Inderjeet singh Narang, modificado 13 Anos atrás.]

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, modificado 13 Anos atrás.]

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, modificado 8 Anos atrás.]

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, modificado 8 Anos atrás.]

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.