Developers - Database Schema

From Zen Cart(tm) Wiki
Revision as of 03:27, 12 December 2005 by APurpleMonkey.com (talk | contribs)
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 tables that are missing, but follow these guidelines:

  • Take a look at the address_book table first, to see how the main formatting should look.
  • Please do not add tables that don't come with a clean installation of Zen Cart.
  • If you want to describe a table that comes with a module, then add a new page for that module instead, and link from that page.


address_book
address_format
admin
admin_activity_log
authorizenet
banners
banners_history
categories
categories_description
configuration
configuration_group
counter
counter_history
countries
coupon_email_track
coupon_gv_customer
coupon_gv_queue
coupon_redeem_track
coupon_restrict
coupons
coupons_description
currencies
customers
customers_basket
customers_basket_attributes
customers_info
customers_wishlist
db_cache
email_archive
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_products_description
music_genre
newsletters
orders
orders_products
orders_products_attributes
orders_products_download
-- orders_session_info -- deleted in 1.2.2 (added in 1.2.1)
orders_status
orders_status_history
orders_total
paypal
-- paypal_ipn -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_address_status -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_mc_currency -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_orders -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_orders_memo -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_payment_status -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_payment_type -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_pending_reason -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_reason_code -- deleted in 1.2.1 (added in 1.2.0)
-- paypal_ipn_txn_type -- deleted in 1.2.1 (added in 1.2.0)
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