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:

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.

2ndDayAir.csv

450.csv

Ground.csv

NextDayAir.csv

access.asc

affiliate

area

banner

cat

country

downloadable

files

inventory.txt

locale.txt

merchandising.txt

mv_metadata

options

order_returns.txt

orderline.txt

pricing

products

route.txt

salestax.asc

shipping.asc

state.txt

transactions.txt

userdb.txt

variable.txt