Difference between revisions of "Developers - Database Schema"

From Zen Cart(tm) Wiki
Jump to: navigation, search
m
(added list ordered by data)
Line 5: Line 5:
  
 
'''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 tables that are missing, but follow these guidelines:
+
Feel free to help out by describing the missing tables.
:* Take a look at the [[Table_address_book|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.
 
  
  
 +
== Table list ordered by data ==
 +
=== Product info ===
 +
:[[Table categories|categories]]
 +
:[[Table categories_description|categories_description]]
 +
:[[Table product_type_layout|product_type_layout]]
 +
:[[Table product_types|product_types]]
 +
:[[Table product_types_to_category|product_types_to_category]]
 +
:[[Table products|products]]
 +
:[[Table products_attributes|products_attributes]]
 +
:[[Table products_attributes_downloads|products_attributes_downloads]]
 +
:[[Table products_description|products_description]]
 +
:[[Table products_discount_quantity|products_discount_quantity]]
 +
:[[Table products_options|products_options]]
 +
:[[Table products_options_types|products_options_types]]
 +
:[[Table products_options_values|products_options_values]]
 +
:[[Table products_options_values_to_products_options|products_options_values_to_products_options]]
 +
:[[Table products_to_categories|products_to_categories]]
 +
:[[Table manufacturers|manufacturers]]
 +
:[[Table manufacturers_info|manufacturers_info]]
 +
:[[Table meta_tags_products_description|meta_tags_products_description]]
 +
:[[Table meta_tags_categories_description|meta_tags_categories_description]]
 +
:[[Table reviews|reviews]]
 +
:[[Table reviews_description|reviews_description]]
 +
 +
=== Sales/special pricing details ===
 +
:[[Table featured|featured]]
 +
:[[Table salemaker_sales|salemaker_sales]]
 +
:[[Table specials|specials]]
 +
 +
=== product_type extra information ===
 +
:[[Table media_clips|media_clips]]
 +
:[[Table media_manager|media_manager]]
 +
:[[Table media_to_products|media_to_products]]
 +
:[[Table media_types|media_types]]
 +
:[[Table music_genre|music_genre]]
 +
:[[Table product_music_extra|product_music_extra]]
 +
:[[Table record_artists|record_artists]]
 +
:[[Table record_artists_info|record_artists_info]]
 +
:[[Table record_company|record_company]]
 +
:[[Table record_company_info|record_company_info]]
 +
 +
=== CMS / Content-Management ===
 +
:[[Table ezpages|ezpages]] (coming in v1.3)
 +
 +
=== Customer info ===
 +
:[[Table address_book|address_book]]
 +
:[[Table customers|customers]]
 +
:[[Table customers_info|customers_info]]
 +
:[[Table group_pricing|group_pricing]]
 +
 +
=== Customer interaction ===
 +
:[[Table email_archive|email_archive]]
 +
:[[Table products_notifications|products_notifications]]
 +
 +
=== Customers stored shopping carts ===
 +
:[[Table customers_basket|customers_basket]]
 +
:[[Table customers_basket_attributes|customers_basket_attributes]]
 +
 +
=== Order history ===
 +
:[[Table files_uploaded|files_uploaded]]
 +
:[[Table orders|orders]]
 +
:[[Table orders_products|orders_products]]
 +
:[[Table orders_products_attributes|orders_products_attributes]]
 +
:[[Table orders_products_download|orders_products_download]]
 +
:[[Table orders_status|orders_status]]
 +
:[[Table orders_status_history|orders_status_history]]
 +
:[[Table orders_total|orders_total]]
 +
 +
=== Paypal ===
 +
''(part of order history)''
 +
:[[Table paypal|paypal]]
 +
:[[Table paypal_payment_status|paypal_payment_status]]
 +
:[[Table paypal_payment_status_history|paypal_payment_status_history]]
 +
:[[Table paypal_session|paypal_session]]
 +
:[[Table paypal_testing|paypal_testing]]
 +
 +
=== Admin audit trail ===
 +
:[[Table admin_activity_log|admin_activity_log]]
 +
:[[Table authorizenet|authorizenet]]
 +
:[[Table banners_history|banners_history]]
 +
:[[Table counter|counter]]
 +
:[[Table counter_history|counter_history]]
 +
:[[Table coupon_email_track|coupon_email_track]]
 +
:[[Table coupon_redeem_track|coupon_redeem_track]]
 +
:[[Table email_archive|email_archive]]
 +
 +
=== Coupon and gift certificate config/tracking ===
 +
:[[Table coupon_email_track|coupon_email_track]]
 +
:[[Table coupon_gv_customer|coupon_gv_customer]]
 +
:[[Table coupon_gv_queue|coupon_gv_queue]]
 +
:[[Table coupon_redem_track|coupon_redem_track]]
 +
:[[Table coupon_restrict|coupon_restrict]]
 +
:[[Table coupons|coupons]]
 +
:[[Table coupons_description|coupons_description]]
 +
 +
=== System configuration ===
 +
:[[Table admin|admin]]
 +
:[[Table address_format|address_format]]
 +
:[[Table configuration|configuration]]
 +
:[[Table configuration_group|configuration_group]]
 +
:[[Table layout_boxes|layout_boxes]]
 +
:[[Table template_select|template_select]]
 +
:[[Table currencies|currencies]]
 +
:[[Table languages|languages]]
 +
 +
=== Tax/zone configuration ===
 +
:[[Table geo_zones|geo_zones]]
 +
:[[Table tax_classes|tax_classes]]
 +
:[[Table tax_rates|tax_rates]]
 +
:[[Table zones_to_geo_zones|zones_to_geo_zones]]
 +
:[[Table zones|zones]]
 +
:[[Table countries|countries]]
 +
 +
=== Other ===
 +
:[[Table banners|banners]]
 +
:[[Table banners_history|banners_history]]
 +
:[[Table get_terms_to_filter|get_terms_to_filter]]
 +
:[[Table project_version|project_version]]
 +
:[[Table project_version_history|project_version_history]]
 +
:[[Table query_builder|query_builder]]
 +
:[[Table db_cache|db_cache]]
 +
:[[Table sessions|sessions]]
 +
:[[Table upgrade_exceptions|upgrade_exceptions]]
 +
:[[Table whos_online|whos_online]]
 +
 +
 +
== Table list in alphabetical order ==
 
:[[Table address_book|address_book]]
 
:[[Table address_book|address_book]]
 
:[[Table address_format|address_format]]
 
:[[Table address_format|address_format]]

Revision as of 17:05, 2 January 2006

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.


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 (coming in v1.3)

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_redem_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
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
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_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