Developers - Database Schema

From Zen Cart(tm) Wiki
Jump to: navigation, search

See also:

Column data sheet
Database changelog


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.


Table list ordered by data

Product info

categories
categories_description
product_type_layout
product_types
product_types_to_category
products
products_attributes
products_attributes_downloads
products_description
products_discount_quantity
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 info

address_book
customers
customers_info
group_pricing

Customer interaction

email_archive
products_notifications

Customers stored shopping carts

customers_basket
customers_basket_attributes

Order history

files_uploaded
orders *
orders_products
orders_products_attributes
orders_products_download
orders_status
orders_status_history
orders_total

Paypal

(part of order history)

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


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
product_music_extra
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
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