I have just connected the Hybris 6.2 to Oracle 11g Db. In the Sql developor i can see all the tables, however due to large number of table its been hard to find things. I found a table called CMSComponent but unable to find CMSParagraphComponent,CMSImageComponent , MiniCartComponent in it. Is it in some other table? More so if i create a new Component or any exisiting, where are they stored in database table?
Please any help is appreciated in understand the Hybris database structure!
To check where all instance of current ItemType stores
Go to HMC/BackOffice > System > Type > Search for your type and select it from result > go to
extended
tab > check forTable
attribute valueThe deployment tag is used to define database table while declaring itemType. So if you define deployment tag for your custom type then it's all instances will be stored in define table otherwise it will be stored in it's parent itemtype(defined using extends attribute). By default all itemType extends GenericItem so if you don't declare extends attribute for your itemsType it will be stored in genericitems table (declared for GenericItem)
Remember
Refer to this wiki for more detail example
Refer this post, explaining hybris database structure in detail