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 - 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.asc
route.txt
shipping.asc
variable.txt - Shipping and tax
-
2ndDayAir.csv
450.csv
country.txt
Ground.csv
NextDayAir.csv
salestax.asc
state.txt
You may also see symbolic links pointing to index tables, for example products.category.txt linking to products.txt.10. These are automatically generated indexes, in this case into the products table to speed category searches. See Dictionary Indexing With INDEX in the database documentation for details about auto-indexing of text databases.
The following dictionary lists and describes each table used in the Foundation demo.