These are the humble beginnings of some documentation that I'm putting together on Commerce Server. This material will largly consist of stuff that I discover or can only be found in obscure references.
Commerce Server 2007 Databases
<sitename>_marketing |
The data for ads and discounts. |
<sitename>_marketing_lists |
Mailing and distribution lists. |
<sitename>_productcatalog |
The product catalog and associated schema. |
<sitename>_profiles |
Profiles, such as User Object, Organization, etc |
<sitename>_transactionconfig |
Configuration for orders (Shipping methods, payment methods, allowed statuses, etc) |
<sitename>_transactions |
Storage for baskets and orders. |
I confess I have stolen this from here.
More information about the database is found in the Microsoft Commerce Server 2007 installation Guide