Database Schema

[Adelanto]

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 *