Hybris Data modeling

[Former Member]

How can I get the relation details of diff Hybris tables or itemtypes in out of the box ?

[Former Member]

And also during the initialization how Hybris are creating the tables in the database ,from which files ?

[Former Member]

moved from SAP Hybris Profile space

[Hari_prasad]

You should go through the core-items.xml file in platform extension, and find tag. Inside , you should check for cardinality option inside and . For example, if cardinality="one" for and cardinality="many", then it means relation is one to many. And if it is reversed, then it is many to one. Incase of both, if cardinality="many", then it is many to many. Also in case of many to many, they have used for creating new tables. As in this case, a third table is used for storing keys from from both source and target tables.

[former_member387866]

Hi Subhasis,

In the resources folder of every extension, there is an *-items.xml file, this file contains the relations node that defines the relations.

For Example look at \hybris\bin\ext-commerce\promotions\resources\promotions-items.xml.

To understand the building process, you should look at more of the education material.

Regards,
Luke

[Former Member]

Hello,

Maybe you will find also usefull https://help.hybris.com/6.6.0/hcd/3bcb251ae7a64ac19166215ac10d99d8.html , especially Generating Initialization and Update Scripts chapter.

Best regards,

[VinayKumarS]

go and check the core-items.xml file.