Database asset groups dependencies

All WebSphere Commerce database assets are divided into groups for creation and loading. These groups are a logically related set of tables. The order in which these database asset groups are organized is important to data loading, since certain objects must exist before loading the relationship between objects.

When loading database assets in XML format for your store, you can choose to load only selected groups. These groups consist of the database assets, such as catalog or fulfillment. Before loading data groups as instructed in :

Each database asset group draws its information from WebSphere Commerce database tables. Database assets have dependencies within their own group. That is, a database asset group cannot draw data in other XML files from a different data group, and each group is independent minus the foreign keys. However, if the database asset group needs to refer to the external data defined in another group, then you need to provide that data manually. This means that the data from one group has an external dependency on data defined outside of its domain, that is, on another database asset group. External dependencies occur when a database asset group has a foreign key relationship to the primary key of a table in another group. To load a database asset group, its external dependencies must be satisfied. To use an example from the following chart, one of the external dependencies for the store database asset group is fulfillment.FFMCENTER.FFMCENTER_ID, which indicates that the fulfillment database assets must already exist in the WebSphere Commerce database before you can load the store database asset group.

Consider the following chart before you begin your loading process. Each group of database assets is dependent on other database tables, from which the data is loaded.

Some points to remember:

External dependencies Related tables from the database asset XML files Related locale-specific tables from the database asset XML files
Access control database assets bootstrap.LANGUAGE.LANGUAGE_ID (root and store owner organizations), bootstrap.MEMBER.MEMBER_ID (root and store owner organizations) accesscontrol.xmlACACTACTGP, ACACTGRP, ACACTION, ACPOLICY, ACRESCGRY, ACRESGPRES, ACRESGRP accesscontrol.xmlACACGPDESC, ACACTDESC, ACPOLDESC, ACRSCGDES, ACRESGPDES
Business policy database assets bootstrap.LANGUAGE.LANGUAGE_ID, boostrap.MEMBER.MEMBER_ID, store.STOREENT.STOREENT_ID (store owner organization) businesspolicy.xmlPOLICY, POLICYCMD businesspolicy.xmlPOLICYDESC
Campaign database assets store.STOREENT.STOREENT_ID campaign.xmlCAMPAIGN, COLLATERAL, EMSPOT campaign.xmlCOLLDESC
Catalog database assets bootstrap.LANGUAGE.LANGUAGE_ID, bootstrap.MEMBER.MEMBER_ID (store owner organization), store.STOREENT.STOREENT_ID, shipping.CALCODE.CALCODE_ID, tax.CALCODE.CALCODE_ID catalog.xmlBASEITEM, CATALOG, CATENTREL, CATENTRY, CATGROUP, CATGRPREL, CATTOGRP, ITEMSPC, ITEMVERSN, RA, RADETAIL, STOREITEM, STORITMFFC, VERSIONSPC offering.xml CATGRPTPC, MGPTRDPSCN, OFFER, OFFERPRICE, TRADEPOSCN storefulfill.xml INVENTORY store-catalog.xml DISPCGPREL, DISPENTREL, STORECAT, STORECENT, STORECGRP store-catalog-shipping.xml CATENTCALCD, CATENTSHIPstore-catalog-tax.xml CATENTCALD catalog.xmlATTRIBUTE, ATTRVALUE, BASEITMDSC, CATALOGDSC, CATENTDESC, CATGRPDESC, PKGATTR, PKGATTRVAL,
Command database assets store.STOREENT.STOREENT_ID command.xmlCMDREG, VIEWREG N/A
Contract database assets store.STOREENT.STOREENT_ID The contract database tables are not loaded directly and follow a different process than the other WebSphere Commerce data groups.
Currency database assets store.STOREENT.STOREENT_ID currency.xmlCURCVLIST currency.xmlCURCONVERT, CURLIST
Fulfillment database assets bootstrap.LANGUAGE.LANGUAGE_ID, boostrap.MEMBER.MEMBER_ID (store owner organization) fulfillment.xmlFFMCENTER, STADDRESS fulfillment.xmlFFMCENTDS
Organization database assets bootstrap.LANGUAGE.LANGUAGE_ID (root and store owner organizations), boostrap.MEMBER.MEMBER_ID (root and store owner organizations) organization.xmlADDRBOOK, ADDRESS, MBRREL, MEMBER, ORGENTITY N/A
Shipping database assets bootstrap.LANGUAGE.LANGUAGE_ID, bootstrap.MEMBER.MEMBER_ID (store owner organization), fulfillment.FFMCENTER.FFMCENTER_ID, store.STOREENT.STOREENT_ID shipping.xmlCALCODE, CALRULE, CRULESCALE, JURST, JURSTGPREL, JURSTGROUP, SHIPMODE, STENCALUSG shipping.xml SHPJCRULE, SHPARRANGE shipping.xmlCALCODEDSC, CALRANGE, CALRLOOKUP, CALSCALE, SHPMODEDSC
Store database assets bootstrap.LANGUAGE.LANGUAGE_ID, bootstrap.MEMBER.MEMBER_ID (store owner organization), bootstrap.SETCURR.SETCURR_ID, fulfillment.FFMCENTER.FFMCENTER_ID store.xmlINVADJCODE, RTNREASON, STORE, STORENT, STORELANG, VENDOR store.xmlFFMCENTDS, INVADJDESC, RTNRSNDESC, STADDRESS, STOREENTDS, STORLANGDS, VENDORDESC
Store default database assets shipping.SHIPMODE.SHIPMODE_ID (if applicable, this file must be loaded first), contract.CONTRACT.CONTRACT_ID, store.STOREENT.STOREENT_ID store-default.xmlSTOREDEF N/A
Tax database assets bootstrap.LANGUAGE.LANGUAGE_ID, boostrap.MEMBER.MEMBER_ID (store owner organization), store.STOREENT.STOREENT_ID, fulfillment.FFMCENTER.FFMCENTER_ID, store.STOREENT.STOREENT_ID tax.xmlCALCODE, CALRANGE, CALRLOOKUP, CALRULE, CALSCALE, CRULESCALE, JURST, JURSTGROUP, JURSTGPREL, STENCALUSG, TAXCGRY, TAXJCRULE taxfulfill.xmlTAXJCRULE tax.xmlCALCODEDSC, CALSCALEDS, TAXCGRYDS

Feedback