1. Home
  2. Development
  3. RE: Specify the relationships of the Lifer tables in the database

RE: Specify the relationships of the Lifer tables in the database

thumbnail
ali yeganeh, modified 5 Years ago.
Specify the relationships of the Lifer tables in the database
Regular Member Posts: 148 Join Date: 5/1/19 Recent Posts
Hi
How do I specify when installing liferay, define table relationships at database level?
thumbnail
Olaf Kock, modified 5 Years ago.
RE: Specify the relationships of the Lifer tables in the database
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts
ali yeganeh:

How do I specify when installing liferay, define table relationships at database level?
If you refer to Liferay's own tables: You don't. You're just ensuring that Liferay can create them but otherwise stay out of them. Completely. They're not yours and you have no business changing anything about their structure, relationships, content or storage.
thumbnail
ali yeganeh, modified 5 Years ago.
RE: Specify the relationships of the Lifer tables in the database
Regular Member Posts: 148 Join Date: 5/1/19 Recent Posts
Olaf Kock:

ali yeganeh:

How do I specify when installing liferay, define table relationships at database level?
If you refer to Liferay's own tables: You don't. You're just ensuring that Liferay can create them but otherwise stay out of them. Completely. They're not yours and you have no business changing anything about their structure, relationships, content or storage.
I need ERD to understand liferay better
What is your suggestion to get ERD?
thumbnail
Christoph Rabel, modified 5 Years ago.
RE: Specify the relationships of the Lifer tables in the database
Liferay Legend Posts: 1555 Join Date: 9/24/09 Recent Posts
There is no ERD.
Liferay just has plain tables. All the logic ("foreign keys" and relationships) are in the Liferay code. So, looking into the Liferay table structure is very seldom helpful to understand how things are connected.
thumbnail
ali yeganeh, modified 5 Years ago.
RE: Specify the relationships of the Lifer tables in the database
Regular Member Posts: 148 Join Date: 5/1/19 Recent Posts
Thanks dear friend
thumbnail
Olaf Kock, modified 5 Years ago.
RE: Specify the relationships of the Lifer tables in the database
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts
ali yeganeh:

I need ERD to understand liferay better
What is your suggestion to get ERD?
You don't need an ER diagram to understand Liferay better. There are plenty of other ways that don't make you assume you know the storage structure of the data.
I don't have any suggestions for getting an ERD (quite the opposite: I have the strong suggestion to run the other direction if you ever see one). I'd have a couple of suggestions to understand Liferay better though. You could start with Liferay University (or Passport, the flat rate offer for the same content). The documentation is another one, not to mention following these forums and trying out a lot yourself.
thumbnail
ali yeganeh, modified 5 Years ago.
RE: Specify the relationships of the Lifer tables in the database
Regular Member Posts: 148 Join Date: 5/1/19 Recent Posts
Thanks for your guidance