Friday, 21 April 2017

shared-table concept _ATG_repository

shared-table concept.

1)A table is shared maximum between two repositories in the same repository.
2) This concept will be used in case of many to many relationships.
3)shared-table-sequence attribute is used in the table tag.And the value might be 1 or 2.
4)In one side the value is 1 and other side the value is 2
5)In versioned repository there is sec_asset_version along with asset_version property as  the same table is modified by two repository items.To understand which side modifies the table , two assets version are requried.
5)The following tables are shared tables

     dcs_cat_chldprd
     dcs_prd_chldsku
   
6)In the above example, tables category side item updates(increase) asset_version  and product side item updates(increases ) the sec_asset_version. And also at product side, configured as writable=false. So in BCC we can modify the parent categorys of product.
   Same is applicable for prodcution and chile relations ships.  At SKU side, the parent products cannot be modfied at BCC as it is configured as writable=false
   

   
   
7)Table propertis of  dcs_cat_chldprd (category_id,fixedChildProducts,child_prd_id,parentCategories, asset_version,sec_asset_version)