Difference between revisions of "Developers - Database Schema"

From Zen Cart(tm) Wiki
Jump to: navigation, search
 
(13 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{Template:menuBarDevelopers}}
 
{{Template:menuBarDevelopers}}
'''See also:'''
 
:[[DB_changelog|Database changelog]]
 
 
 
 
'''This is a work in progress - not all tables have been described yet.'''<br />
 
'''This is a work in progress - not all tables have been described yet.'''<br />
 
'''Feel free to help out by describing the missing tables.'''<br />
 
'''Feel free to help out by describing the missing tables.'''<br />
 
'''Tables with missing/incomplete information are marked with a <font color="red">*</font>.'''<br />
 
'''Tables with missing/incomplete information are marked with a <font color="red">*</font>.'''<br />
 
'''If you complete an incomplete table 100% please be sure to remove the <font color="red">'''*'''</font> from this page in both places.'''
 
'''If you complete an incomplete table 100% please be sure to remove the <font color="red">'''*'''</font> from this page in both places.'''
 +
 +
== Database Schema Diagrams (Work in Progress)==
 +
: [[Schema Diagram for the whole Database]]
 +
: [[Developers_-_Database_Schema#Product Info|Product Info]]
 +
: [[Developers_-_Database_Schema#Sales.2FSpecial_Pricing_Details|Sales/Special Pricing Details]]
 +
: [[Developers_-_Database_Schema#Product Type Extra Information|Product Type Extra Information]]
 +
: [[Developers_-_Database_Schema#CMS / Content Management|CMS / Content Management]]
 +
: [[Developers_-_Database_Schema#Customer_Information|Customer Information]]
 +
: [[Developers_-_Database_Schema#Customers Stored Shopping Carts|Customers Stored Shopping Carts]]
 +
: [[Developers_-_Database_Schema#Customer Interaction|Customer Interaction]]
 +
: [[Developers_-_Database_Schema#Order History|Order History]]
 +
: [[Developers_-_Database_Schema#PayPal.E2.84.A2|PayPal&trade;]]
 +
: [[Developers_-_Database_Schema#Admin Audit Trail|Admin Audit Trail]]
 +
: [[Developers_-_Database_Schema#Coupon and Gift Certificate Config/Tracking|Coupon and Gift Certificate Config/Tracking]]
 +
: [[Developers_-_Database_Schema#System Configuration|System Configuration]]
 +
: [[Developers_-_Database_Schema#Tax/Zone Configuration|Tax/Zone Configuration]]
 +
: [[Developers_-_Database_Schema#Other|Other]]
 +
 +
== Table List in Alphabetical Order ==
 +
:[[Table address_book|address_book]]
 +
:[[Table address_format|address_format]]
 +
:[[Table admin|admin]]
 +
:[[Table admin_activity_log|admin_activity_log]]
 +
:[[Table authorizenet|authorizenet]]
 +
:[[Table banners|banners]]
 +
:[[Table banners_history|banners_history]]
 +
:[[Table categories|categories]]
 +
:[[Table categories_description|categories_description]]
 +
:[[Table configuration|configuration]] <font color="red">'''*'''</font>
 +
:[[Table configuration_group|configuration_group]]
 +
:[[Table counter|counter]]
 +
:[[Table counter_history|counter_history]] <font color="red">'''*'''</font>
 +
:[[Table countries|countries]]
 +
:[[Table coupons|coupons]]
 +
:[[Table coupons_description|coupons_description]]
 +
:[[Table coupon_email_track|coupon_email_track]]
 +
:[[Table coupon_gv_customer|coupon_gv_customer]]
 +
:[[Table coupon_gv_queue|coupon_gv_queue]]
 +
:[[Table coupon_redeem_track|coupon_redeem_track]]
 +
:[[Table coupon_restrict|coupon_restrict]]
 +
:[[Table currencies|currencies]]
 +
:[[Table customers|customers]]
 +
:[[Table customers_basket|customers_basket]]
 +
:[[Table customers_basket_attributes|customers_basket_attributes]]
 +
:[[Table customers_info|customers_info]]
 +
:[[Table customers_wishlist|customers_wishlist]]
 +
:[[Table db_cache|db_cache]]
 +
:[[Table email_archive|email_archive]]
 +
:[[Table ezpages|ezpages]]
 +
:[[Table featured|featured]]
 +
:[[Table files_uploaded|files_uploaded]]
 +
:[[Table geo_zones|geo_zones]]
 +
:[[Table get_terms_to_filter|get_terms_to_filter]]
 +
:[[Table group_pricing|group_pricing]]
 +
:[[Table languages|languages]]
 +
:[[Table layout_boxes|layout_boxes]]
 +
:[[Table manufacturers|manufacturers]]
 +
:[[Table manufacturers_info|manufacturers_info]]
 +
:[[Table media_clips|media_clips]]
 +
:[[Table media_manager|media_manager]]
 +
:[[Table media_to_products|media_to_products]]
 +
:[[Table media_types|media_types]]
 +
:[[Table meta_tags_categories_description|meta_tags_categories_description]]
 +
:[[Table meta_tags_products_description|meta_tags_products_description]]
 +
:[[Table music_genre|music_genre]]
 +
:[[Table newsletters|newsletters]]
 +
:[[Table orders|orders]] <font color="red">'''*'''</font>
 +
:[[Table orders_products|orders_products]] <font color="red">'''*'''</font>
 +
:[[Table orders_products_attributes|orders_products_attributes]] <font color="red">'''*'''</font>
 +
:[[Table orders_products_download|orders_products_download]] <font color="red">'''*'''</font>
 +
:[[Table orders_status|orders_status]]
 +
:[[Table orders_status_history|orders_status_history]]
 +
:[[Table orders_total|orders_total]] <font color="red">'''*'''</font>
 +
:[[Table paypal|paypal]] <font color="red">'''*'''</font>
 +
:[[Table paypal_payment_status|paypal_payment_status]]
 +
:[[Table paypal_payment_status_history|paypal_payment_status_history]] <font color="red">'''*'''</font>
 +
:[[Table paypal_session|paypal_session]] <font color="red">'''*'''</font>
 +
:[[Table paypal_testing|paypal_testing]] <font color="red">'''*'''</font>
 +
:[[Table products|products]] <font color="red">'''*'''</font>
 +
:[[Table products_attributes|products_attributes]] <font color="red">'''*'''</font>
 +
:[[Table products_attributes_download|products_attributes_download]] <font color="red">'''*'''</font>
 +
:[[Table products_description|products_description]] <font color="red">'''*'''</font>
 +
:[[Table products_discount_quantity|products_discount_quantity]] <font color="red">'''*'''</font>
 +
:[[Table products_notifications|products_notifications]]
 +
:[[Table products_options|products_options]] <font color="red">'''*'''</font>
 +
:[[Table products_options_types|products_options_types]]
 +
:[[Table products_options_values|products_options_values]] <font color="red">'''*'''</font>
 +
:[[Table products_options_values_to_products_options|products_options_values_to_products_options]] <font color="red">'''*'''</font>
 +
:[[Table products_to_categories|products_to_categories]] <font color="red">'''*'''</font>
 +
:[[Table product_music_extra|product_music_extra]] <font color="red">'''*'''</font>
 +
:[[Table product_types|product_types]] <font color="red">'''*'''</font>
 +
:[[Table product_types_to_category|product_types_to_category]] <font color="red">'''*'''</font>
 +
:[[Table product_type_layout|product_type_layout]] <font color="red">'''*'''</font>
 +
:[[Table project_version|project_version]]
 +
:[[Table project_version_history|project_version_history]]
 +
:[[Table query_builder|query_builder]] <font color="red">'''*'''</font>
 +
:[[Table record_artists|record_artists]] <font color="red">'''*'''</font>
 +
:[[Table record_artists_info|record_artists_info]] <font color="red">'''*'''</font>
 +
:[[Table record_company|record_company]] <font color="red">'''*'''</font>
 +
:[[Table record_company_info|record_company_info]] <font color="red">'''*'''</font>
 +
:[[Table reviews|reviews]] <font color="red">'''*'''</font>
 +
:[[Table reviews_description|reviews_description]] <font color="red">'''*'''</font>
 +
:[[Table salemaker_sales|salemaker_sales]] <font color="red">'''*'''</font>
 +
:[[Table sessions|sessions]] <font color="red">'''*'''</font>
 +
:[[Table specials|specials]] <font color="red">'''*'''</font>
 +
:[[Table tax_class|tax_class]] <font color="red">'''*'''</font>
 +
:[[Table tax_rates|tax_rates]] <font color="red">'''*'''</font>
 +
:[[Table template_select|template_select]] <font color="red">'''*'''</font>
 +
:[[Table upgrade_exceptions|upgrade_exceptions]] <font color="red">'''*'''</font>
 +
:[[Table whos_online|whos_online]] <font color="red">'''*'''</font>
 +
:[[Table zones|zones]] <font color="red">'''*'''</font>
 +
:[[Table zones_to_geo_zones|zones_to_geo_zones]] <font color="red">'''*'''</font>
  
  
== Table list ordered by data ==
+
== Table List Ordered by Data ==
=== Product info ===
+
=== Product Info ===
 
:[[Table categories|categories]]
 
:[[Table categories|categories]]
 
:[[Table categories_description|categories_description]]
 
:[[Table categories_description|categories_description]]
Line 22: Line 130:
 
:[[Table products_description|products_description]] <font color="red">'''*'''</font>
 
:[[Table products_description|products_description]] <font color="red">'''*'''</font>
 
:[[Table products_discount_quantity|products_discount_quantity]] <font color="red">'''*'''</font>
 
:[[Table products_discount_quantity|products_discount_quantity]] <font color="red">'''*'''</font>
 +
:[[Table products_notifications|products_notifications]]
 
:[[Table products_options|products_options]] <font color="red">'''*'''</font>
 
:[[Table products_options|products_options]] <font color="red">'''*'''</font>
:[[Table products_options_types|products_options_types]] <font color="red">'''*'''</font>
+
:[[Table products_options_types|products_options_types]]
 
:[[Table products_options_values|products_options_values]] <font color="red">'''*'''</font>
 
:[[Table products_options_values|products_options_values]] <font color="red">'''*'''</font>
 
:[[Table products_options_values_to_products_options|products_options_values_to_products_options]] <font color="red">'''*'''</font>
 
:[[Table products_options_values_to_products_options|products_options_values_to_products_options]] <font color="red">'''*'''</font>
Line 34: Line 143:
 
:[[Table reviews_description|reviews_description]] <font color="red">'''*'''</font>
 
:[[Table reviews_description|reviews_description]] <font color="red">'''*'''</font>
  
=== Sales/special pricing details ===
+
 
 +
=== Sales/Special Pricing Details ===
 
:[[Table featured|featured]]
 
:[[Table featured|featured]]
 
:[[Table salemaker_sales|salemaker_sales]] <font color="red">'''*'''</font>
 
:[[Table salemaker_sales|salemaker_sales]] <font color="red">'''*'''</font>
 
:[[Table specials|specials]] <font color="red">'''*'''</font>
 
:[[Table specials|specials]] <font color="red">'''*'''</font>
  
=== product_type extra information ===
+
 
 +
=== Product Type Extra Information ===
 
:[[Table media_clips|media_clips]]
 
:[[Table media_clips|media_clips]]
 
:[[Table media_manager|media_manager]]
 
:[[Table media_manager|media_manager]]
Line 51: Line 162:
 
:[[Table record_company_info|record_company_info]] <font color="red">'''*'''</font>
 
:[[Table record_company_info|record_company_info]] <font color="red">'''*'''</font>
  
=== CMS / Content-Management ===
+
 
 +
=== CMS / Content Management ===
 
:[[Table ezpages|ezpages]]
 
:[[Table ezpages|ezpages]]
  
=== Customer info ===
+
 
 +
=== Customer Information ===
 
:[[Table address_book|address_book]]
 
:[[Table address_book|address_book]]
 
:[[Table customers|customers]]
 
:[[Table customers|customers]]
 
:[[Table customers_info|customers_info]]
 
:[[Table customers_info|customers_info]]
:[[Table group_pricing|group_pricing]]
 
  
=== Customer interaction ===
 
:[[Table email_archive|email_archive]]
 
:[[Table products_notifications|products_notifications]] <font color="red">'''*'''</font>
 
  
=== Customers stored shopping carts ===
+
=== Customers Stored Shopping Carts ===
 
:[[Table customers_basket|customers_basket]]
 
:[[Table customers_basket|customers_basket]]
 
:[[Table customers_basket_attributes|customers_basket_attributes]]
 
:[[Table customers_basket_attributes|customers_basket_attributes]]
  
=== Order history ===
+
 
 +
=== Customer Interaction ===
 +
:[[Table email_archive|email_archive]]
 +
:[[Table group_pricing|group_pricing]]
 +
:[[Table products_notifications|products_notifications]]
 +
 
 +
 
 +
=== Order History ===
 
:[[Table files_uploaded|files_uploaded]]
 
:[[Table files_uploaded|files_uploaded]]
 
:[[Table orders|orders]] <font color="red">'''*'''</font>
 
:[[Table orders|orders]] <font color="red">'''*'''</font>
Line 74: Line 190:
 
:[[Table orders_products_attributes|orders_products_attributes]] <font color="red">'''*'''</font>
 
:[[Table orders_products_attributes|orders_products_attributes]] <font color="red">'''*'''</font>
 
:[[Table orders_products_download|orders_products_download]] <font color="red">'''*'''</font>
 
:[[Table orders_products_download|orders_products_download]] <font color="red">'''*'''</font>
:[[Table orders_status|orders_status]]
 
 
:[[Table orders_status_history|orders_status_history]]
 
:[[Table orders_status_history|orders_status_history]]
 
:[[Table orders_total|orders_total]] <font color="red">'''*'''</font>
 
:[[Table orders_total|orders_total]] <font color="red">'''*'''</font>
 +
and
 +
:[[Table paypal|paypal]] <font color="red">'''*'''</font>
 +
:[[Table paypal_payment_status_history|paypal_payment_status_history]] <font color="red">'''*'''</font>
 +
:[[Table paypal_session|paypal_session]] <font color="red">'''*'''</font>
  
=== Paypal ===
+
 
 +
=== PayPal&trade; ===
 
:[[Table paypal|paypal]] <font color="red">'''*'''</font>
 
:[[Table paypal|paypal]] <font color="red">'''*'''</font>
 
:[[Table paypal_payment_status|paypal_payment_status]]
 
:[[Table paypal_payment_status|paypal_payment_status]]
Line 85: Line 205:
 
:[[Table paypal_testing|paypal_testing]] <font color="red">'''*'''</font>
 
:[[Table paypal_testing|paypal_testing]] <font color="red">'''*'''</font>
  
=== Admin audit trail ===
+
 
 +
=== Admin Audit Trail ===
 
:[[Table admin_activity_log|admin_activity_log]]
 
:[[Table admin_activity_log|admin_activity_log]]
 
:[[Table authorizenet|authorizenet]]
 
:[[Table authorizenet|authorizenet]]
Line 95: Line 216:
 
:[[Table email_archive|email_archive]]
 
:[[Table email_archive|email_archive]]
  
=== Coupon and gift certificate config/tracking ===
+
 
 +
=== Coupon and Gift Certificate Config/Tracking ===
 
:[[Table coupon_email_track|coupon_email_track]]
 
:[[Table coupon_email_track|coupon_email_track]]
 
:[[Table coupon_gv_customer|coupon_gv_customer]]
 
:[[Table coupon_gv_customer|coupon_gv_customer]]
Line 104: Line 226:
 
:[[Table coupons_description|coupons_description]]
 
:[[Table coupons_description|coupons_description]]
  
=== System configuration ===
+
 
 +
=== System Configuration ===
 
:[[Table admin|admin]]
 
:[[Table admin|admin]]
 
:[[Table address_format|address_format]]
 
:[[Table address_format|address_format]]
Line 114: Line 237:
 
:[[Table languages|languages]]
 
:[[Table languages|languages]]
  
=== Tax/zone configuration ===
+
 
 +
=== Tax/Zone Configuration ===
 
:[[Table geo_zones|geo_zones]]
 
:[[Table geo_zones|geo_zones]]
 
:[[Table tax_classes|tax_classes]] <font color="red">'''*'''</font>
 
:[[Table tax_classes|tax_classes]] <font color="red">'''*'''</font>
Line 121: Line 245:
 
:[[Table zones|zones]] <font color="red">'''*'''</font>
 
:[[Table zones|zones]] <font color="red">'''*'''</font>
 
:[[Table countries|countries]]
 
:[[Table countries|countries]]
 +
  
 
=== Other ===
 
=== Other ===
Line 136: Line 261:
  
  
== Table list in alphabetical order ==
+
'''See also:'''
:[[Table address_book|address_book]]
+
:[[DB_changelog|Database Changelog]]
:[[Table address_format|address_format]]
 
:[[Table admin|admin]]
 
:[[Table admin_activity_log|admin_activity_log]]
 
:[[Table authorizenet|authorizenet]]
 
:[[Table banners|banners]]
 
:[[Table banners_history|banners_history]]
 
:[[Table categories|categories]]
 
:[[Table categories_description|categories_description]]
 
:[[Table configuration|configuration]] <font color="red">'''*'''</font>
 
:[[Table configuration_group|configuration_group]]
 
:[[Table counter|counter]]
 
:[[Table counter_history|counter_history]] <font color="red">'''*'''</font>
 
:[[Table countries|countries]]
 
:[[Table coupons|coupons]]
 
:[[Table coupons_description|coupons_description]]
 
:[[Table coupon_email_track|coupon_email_track]]
 
:[[Table coupon_gv_customer|coupon_gv_customer]]
 
:[[Table coupon_gv_queue|coupon_gv_queue]]
 
:[[Table coupon_redeem_track|coupon_redeem_track]]
 
:[[Table coupon_restrict|coupon_restrict]]
 
:[[Table currencies|currencies]]
 
:[[Table customers|customers]]
 
:[[Table customers_basket|customers_basket]]
 
:[[Table customers_basket_attributes|customers_basket_attributes]]
 
:[[Table customers_info|customers_info]]
 
:[[Table customers_wishlist|customers_wishlist]]
 
:[[Table db_cache|db_cache]]
 
:[[Table email_archive|email_archive]]
 
:[[Table ezpages|ezpages]]
 
:[[Table featured|featured]]
 
:[[Table files_uploaded|files_uploaded]]
 
:[[Table geo_zones|geo_zones]]
 
:[[Table get_terms_to_filter|get_terms_to_filter]]
 
:[[Table group_pricing|group_pricing]]
 
:[[Table languages|languages]]
 
:[[Table layout_boxes|layout_boxes]]
 
:[[Table manufacturers|manufacturers]]
 
:[[Table manufacturers_info|manufacturers_info]]
 
:[[Table media_clips|media_clips]]
 
:[[Table media_manager|media_manager]]
 
:[[Table media_to_products|media_to_products]]
 
:[[Table media_types|media_types]]
 
:[[Table meta_tags_categories_description|meta_tags_categories_description]]
 
:[[Table meta_tags_products_description|meta_tags_products_description]]
 
:[[Table music_genre|music_genre]]
 
:[[Table newsletters|newsletters]]
 
:[[Table orders|orders]] <font color="red">'''*'''</font>
 
:[[Table orders_products|orders_products]] <font color="red">'''*'''</font>
 
:[[Table orders_products_attributes|orders_products_attributes]] <font color="red">'''*'''</font>
 
:[[Table orders_products_download|orders_products_download]] <font color="red">'''*'''</font>
 
:[[Table orders_status|orders_status]]
 
:[[Table orders_status_history|orders_status_history]]
 
:[[Table orders_total|orders_total]] <font color="red">'''*'''</font>
 
:[[Table paypal|paypal]] <font color="red">'''*'''</font>
 
:[[Table paypal_payment_status|paypal_payment_status]]
 
:[[Table paypal_payment_status_history|paypal_payment_status_history]] <font color="red">'''*'''</font>
 
:[[Table paypal_session|paypal_session]] <font color="red">'''*'''</font>
 
:[[Table paypal_testing|paypal_testing]] <font color="red">'''*'''</font>
 
:[[Table products|products]] <font color="red">'''*'''</font>
 
:[[Table products_attributes|products_attributes]] <font color="red">'''*'''</font>
 
:[[Table products_attributes_download|products_attributes_download]] <font color="red">'''*'''</font>
 
:[[Table products_description|products_description]] <font color="red">'''*'''</font>
 
:[[Table products_discount_quantity|products_discount_quantity]] <font color="red">'''*'''</font>
 
:[[Table products_notifications|products_notifications]] <font color="red">'''*'''</font>
 
:[[Table products_options|products_options]] <font color="red">'''*'''</font>
 
:[[Table products_options_types|products_options_types]] <font color="red">'''*'''</font>
 
:[[Table products_options_values|products_options_values]] <font color="red">'''*'''</font>
 
:[[Table products_options_values_to_products_options|products_options_values_to_products_options]] <font color="red">'''*'''</font>
 
:[[Table products_to_categories|products_to_categories]] <font color="red">'''*'''</font>
 
:[[Table product_music_extra|product_music_extra]] <font color="red">'''*'''</font>
 
:[[Table product_types|product_types]] <font color="red">'''*'''</font>
 
:[[Table product_types_to_category|product_types_to_category]] <font color="red">'''*'''</font>
 
:[[Table product_type_layout|product_type_layout]] <font color="red">'''*'''</font>
 
:[[Table project_version|project_version]] <font color="red">'''*'''</font>
 
:[[Table project_version_history|project_version_history]] <font color="red">'''*'''</font>
 
:[[Table query_builder|query_builder]] <font color="red">'''*'''</font>
 
:[[Table record_artists|record_artists]] <font color="red">'''*'''</font>
 
:[[Table record_artists_info|record_artists_info]] <font color="red">'''*'''</font>
 
:[[Table record_company|record_company]] <font color="red">'''*'''</font>
 
:[[Table record_company_info|record_company_info]] <font color="red">'''*'''</font>
 
:[[Table reviews|reviews]] <font color="red">'''*'''</font>
 
:[[Table reviews_description|reviews_description]] <font color="red">'''*'''</font>
 
:[[Table salemaker_sales|salemaker_sales]] <font color="red">'''*'''</font>
 
:[[Table sessions|sessions]] <font color="red">'''*'''</font>
 
:[[Table specials|specials]] <font color="red">'''*'''</font>
 
:[[Table tax_class|tax_class]] <font color="red">'''*'''</font>
 
:[[Table tax_rates|tax_rates]] <font color="red">'''*'''</font>
 
:[[Table template_select|template_select]] <font color="red">'''*'''</font>
 
:[[Table upgrade_exceptions|upgrade_exceptions]] <font color="red">'''*'''</font>
 
:[[Table whos_online|whos_online]] <font color="red">'''*'''</font>
 
:[[Table zones|zones]] <font color="red">'''*'''</font>
 
:[[Table zones_to_geo_zones|zones_to_geo_zones]] <font color="red">'''*'''</font>
 

Latest revision as of 22:47, 10 February 2013

This is a work in progress - not all tables have been described yet.
Feel free to help out by describing the missing tables.
Tables with missing/incomplete information are marked with a *.
If you complete an incomplete table 100% please be sure to remove the * from this page in both places.

Database Schema Diagrams (Work in Progress)

Schema Diagram for the whole Database
Product Info
Sales/Special Pricing Details
Product Type Extra Information
CMS / Content Management
Customer Information
Customers Stored Shopping Carts
Customer Interaction
Order History
PayPal™
Admin Audit Trail
Coupon and Gift Certificate Config/Tracking
System Configuration
Tax/Zone Configuration
Other

Table List in Alphabetical Order

address_book
address_format
admin
admin_activity_log
authorizenet
banners
banners_history
categories
categories_description
configuration *
configuration_group
counter
counter_history *
countries
coupons
coupons_description
coupon_email_track
coupon_gv_customer
coupon_gv_queue
coupon_redeem_track
coupon_restrict
currencies
customers
customers_basket
customers_basket_attributes
customers_info
customers_wishlist
db_cache
email_archive
ezpages
featured
files_uploaded
geo_zones
get_terms_to_filter
group_pricing
languages
layout_boxes
manufacturers
manufacturers_info
media_clips
media_manager
media_to_products
media_types
meta_tags_categories_description
meta_tags_products_description
music_genre
newsletters
orders *
orders_products *
orders_products_attributes *
orders_products_download *
orders_status
orders_status_history
orders_total *
paypal *
paypal_payment_status
paypal_payment_status_history *
paypal_session *
paypal_testing *
products *
products_attributes *
products_attributes_download *
products_description *
products_discount_quantity *
products_notifications
products_options *
products_options_types
products_options_values *
products_options_values_to_products_options *
products_to_categories *
product_music_extra *
product_types *
product_types_to_category *
product_type_layout *
project_version
project_version_history
query_builder *
record_artists *
record_artists_info *
record_company *
record_company_info *
reviews *
reviews_description *
salemaker_sales *
sessions *
specials *
tax_class *
tax_rates *
template_select *
upgrade_exceptions *
whos_online *
zones *
zones_to_geo_zones *


Table List Ordered by Data

Product Info

categories
categories_description
product_type_layout *
product_types *
product_types_to_category *
products *
products_attributes *
products_attributes_download *
products_description *
products_discount_quantity *
products_notifications
products_options *
products_options_types
products_options_values *
products_options_values_to_products_options *
products_to_categories *
manufacturers
manufacturers_info
meta_tags_products_description
meta_tags_categories_description
reviews *
reviews_description *


Sales/Special Pricing Details

featured
salemaker_sales *
specials *


Product Type Extra Information

media_clips
media_manager
media_to_products
media_types
music_genre
product_music_extra *
record_artists *
record_artists_info *
record_company *
record_company_info *


CMS / Content Management

ezpages


Customer Information

address_book
customers
customers_info


Customers Stored Shopping Carts

customers_basket
customers_basket_attributes


Customer Interaction

email_archive
group_pricing
products_notifications


Order History

files_uploaded
orders *
orders_products *
orders_products_attributes *
orders_products_download *
orders_status_history
orders_total *

and

paypal *
paypal_payment_status_history *
paypal_session *


PayPal™

paypal *
paypal_payment_status
paypal_payment_status_history *
paypal_session *
paypal_testing *


Admin Audit Trail

admin_activity_log
authorizenet
banners_history
counter
counter_history *
coupon_email_track
coupon_redeem_track
email_archive


Coupon and Gift Certificate Config/Tracking

coupon_email_track
coupon_gv_customer
coupon_gv_queue
coupon_redeem_track
coupon_restrict
coupons
coupons_description


System Configuration

admin
address_format
configuration *
configuration_group
layout_boxes
template_select *
currencies
languages


Tax/Zone Configuration

geo_zones
tax_classes *
tax_rates *
zones_to_geo_zones *
zones *
countries


Other

banners
banners_history
get_terms_to_filter
newsletters
project_version *
project_version_history *
query_builder *
db_cache
sessions *
upgrade_exceptions *
whos_online *


See also:

Database Changelog