What Are the Marketing System Database Tables?

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The Marketing System stores data in SQL database tables in the marketing, marketing_lists, and DirectMailer databases. By default, these database names are prefixed by the name of your site, followed by the "_" character (for example, "YourSite_marketing"). However, the user can choose different names for the databases during unpacking.

Most marketing tables are stored in the marketing database, and list-oriented tables are stored in the marketing_lists database. The DirectMailer database contains the DirectMail list manager temporary working tables and execution status information. The dml_job_errors table contains individual job execution errors.

Marketing System Database Tables

Marketing Database Tables
mktg_ad_item
mktg_basket_display
mktg_campaign
mktg_campaign_item
mktg_creative
mktg_creative_property
mktg_creative_property_value
mktg_creative_size
mktg_creative_type
mktg_customer
mktg_dm_attachment
mktg_dm_item
mktg_dm_subject
mktg_event_type
mktg_expression
mktg_expression_category
mktg_expression_depends
mktg_industry_code
mktg_order_discount
mktg_order_discount_condition
mktg_order_discount_expression
mktg_page_group
mktg_page_group_xref
mktg_performance_total
mktg_promocode
mktg_promocode_defn
mktg_promocode_generation
mktg_promocode_generation_error
mktg_promocode_history
mktg_promocode_transactions
mktg_target
mktg_version
mktg_virtual_directory
upld_chunks
upld_imports

Marketing_Lists Database Tables
mktg_lm_master
mktg_lm_master_operations
mktg_lm_operation_errors
mktg_lm_{listid}_list

DirectMailer database tables
dml_job_errors
dml_jobs
mktg_lm_{jobid}_list

See Also

Other Resources

Working with Marketing System Components

Marketing System Database Tables