5. The Database Tables
Interchange catalogs are centralized around the database. You can alter any of the standard databases, add new databases, or remove unneeded databases
The foundation catalog includes the following tables, organized here by content:
- Your site content data
-
area.txt
cat.txt
downloadable.txt
merchandising.txt
options.txt
pricing.txt
products.txt
products.txt.category
- Customer data
-
access.asc
gift_certs.txt
userdb.txt
- Transaction-related data
-
inventory.txt
orderline.txt
order_returns.txt
transactions.txt
- Third-party relationship data
-
affiliate.txt
banner.txt
- Site administrative data
-
component.txt
files.txt
ichelp.txt
icmenu.txt
locale.txt
mv_metadata
route.txt
shipping.asc
variable.txt
- Ancillary data
-
2ndDayAir.csv
450.csv
country.txt
Ground.csv
NextDayAir.csv
salestax.asc
state.txt
The following dictionary lists and describes each table used in the Foundation demo.