Base Store :

It is the basic building block of the e-commerce set up. The base store defines many of the key aspects of your ecommerce presence, such as languages, warehouses, currencies, product catalogs , tax handling, and more. Carts and orders created via the storefront are also associated with a base store.

Order process and return order process is also associated with the base store and not with the base site.

Base store is equivalent to a physical store.

Base Site(CMSSite) :

Basesite is the online entity which will have all the content related to the store. Base site & base store have many to many relationship. All the product data is associated with the store and all the content related data will be driven through base site.

Base Store & Base Site Attributes

--

--

You know until now I thought that composite unique keys are formed just by including unique=true for multiple attributes. My ignorance amazes me.

To define composite unique keys, we need to add new unique index in indexes element.

Consider this category table. Category code along with the catalogVersion makes the primary key.

<itemtype code="Category" 
generate="true"
jaloclass="de.hybris.platform.category.jalo.Category"
extends="GenericItem"
autocreate="true">
<deployment table="Categories" typecode="142"/>
............
...............
<indexes>
<index name="codeIDX" unique="false">
<key attribute="code"/>
</index>
<index name="versionIDX" unique="false">
<key attribute="catalogVersion"/>
</index>
<index name="codeVersionIDX" unique="true">
<key attribute="code"/>
<key attribute="catalogVersion"/>
</index>

</indexes>
</itemtype>

I have always felt proud about my data modeling knowledge. Now looking back, I shudder at my level of ignorance.

--

--

Priyanka Manikkoth

Priyanka Manikkoth

Coder by occupation, dreamer by choice