Difference between revisions of "Developers - Database Schema"

From Zen Cart(tm) Wiki
Jump to: navigation, search
m
m
Line 8: Line 8:
 
'''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 * 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.'''
  
  
Line 32: Line 32:
 
:[[Table meta_tags_products_description|meta_tags_products_description]]
 
:[[Table meta_tags_products_description|meta_tags_products_description]]
 
:[[Table meta_tags_categories_description|meta_tags_categories_description]]
 
:[[Table meta_tags_categories_description|meta_tags_categories_description]]
:[[Table reviews|reviews]]
+
:[[Table reviews|reviews]] <font color="red">'''*'''</font>
:[[Table reviews_description|reviews_description]]
+
:[[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]]
+
:[[Table salemaker_sales|salemaker_sales]] <font color="red">'''*'''</font>
:[[Table specials|specials]]
+
:[[Table specials|specials]] <font color="red">'''*'''</font>
  
 
=== product_type extra information ===
 
=== product_type extra information ===
Line 47: Line 47:
 
:[[Table music_genre|music_genre]]
 
:[[Table music_genre|music_genre]]
 
:[[Table product_music_extra|product_music_extra]] <font color="red">'''*'''</font>
 
:[[Table product_music_extra|product_music_extra]] <font color="red">'''*'''</font>
:[[Table record_artists|record_artists]]
+
:[[Table record_artists|record_artists]] <font color="red">'''*'''</font>
:[[Table record_artists_info|record_artists_info]]
+
:[[Table record_artists_info|record_artists_info]] <font color="red">'''*'''</font>
:[[Table record_company|record_company]]
+
:[[Table record_company|record_company]] <font color="red">'''*'''</font>
:[[Table record_company_info|record_company_info]]
+
:[[Table record_company_info|record_company_info]] <font color="red">'''*'''</font>
  
 
=== CMS / Content-Management ===
 
=== CMS / Content-Management ===
Line 111: Line 111:
 
:[[Table configuration_group|configuration_group]]
 
:[[Table configuration_group|configuration_group]]
 
:[[Table layout_boxes|layout_boxes]]
 
:[[Table layout_boxes|layout_boxes]]
:[[Table template_select|template_select]]
+
:[[Table template_select|template_select]] <font color="red">'''*'''</font>
 
:[[Table currencies|currencies]]
 
:[[Table currencies|currencies]]
 
:[[Table languages|languages]]
 
:[[Table languages|languages]]
Line 117: Line 117:
 
=== Tax/zone configuration ===
 
=== Tax/zone configuration ===
 
:[[Table geo_zones|geo_zones]]
 
:[[Table geo_zones|geo_zones]]
:[[Table tax_classes|tax_classes]]
+
:[[Table tax_classes|tax_classes]] <font color="red">'''*'''</font>
:[[Table tax_rates|tax_rates]]
+
:[[Table tax_rates|tax_rates]] <font color="red">'''*'''</font>
:[[Table zones_to_geo_zones|zones_to_geo_zones]]
+
:[[Table zones_to_geo_zones|zones_to_geo_zones]] <font color="red">'''*'''</font>
:[[Table zones|zones]]
+
:[[Table zones|zones]] <font color="red">'''*'''</font>
 
:[[Table countries|countries]]
 
:[[Table countries|countries]]
  
Line 128: Line 128:
 
:[[Table get_terms_to_filter|get_terms_to_filter]]
 
:[[Table get_terms_to_filter|get_terms_to_filter]]
 
:[[Table newsletters|newsletters]] <font color="red">'''*'''</font>
 
:[[Table newsletters|newsletters]] <font color="red">'''*'''</font>
:[[Table project_version|project_version]]
+
:[[Table project_version|project_version]] <font color="red">'''*'''</font>
:[[Table project_version_history|project_version_history]]
+
:[[Table project_version_history|project_version_history]] <font color="red">'''*'''</font>
:[[Table query_builder|query_builder]]
+
:[[Table query_builder|query_builder]] <font color="red">'''*'''</font>
 
:[[Table db_cache|db_cache]]
 
:[[Table db_cache|db_cache]]
:[[Table sessions|sessions]]
+
:[[Table sessions|sessions]] <font color="red">'''*'''</font>
:[[Table upgrade_exceptions|upgrade_exceptions]]
+
:[[Table upgrade_exceptions|upgrade_exceptions]] <font color="red">'''*'''</font>
:[[Table whos_online|whos_online]]
+
:[[Table whos_online|whos_online]] <font color="red">'''*'''</font>
  
  
Line 212: Line 212:
 
:[[Table product_types_to_category|product_types_to_category]] <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 product_type_layout|product_type_layout]] <font color="red">'''*'''</font>
:[[Table project_version|project_version]]
+
:[[Table project_version|project_version]] <font color="red">'''*'''</font>
:[[Table project_version_history|project_version_history]]
+
:[[Table project_version_history|project_version_history]] <font color="red">'''*'''</font>
:[[Table query_builder|query_builder]]
+
:[[Table query_builder|query_builder]] <font color="red">'''*'''</font>
:[[Table record_artists|record_artists]]
+
:[[Table record_artists|record_artists]] <font color="red">'''*'''</font>
:[[Table record_artists_info|record_artists_info]]
+
:[[Table record_artists_info|record_artists_info]] <font color="red">'''*'''</font>
:[[Table record_company|record_company]]
+
:[[Table record_company|record_company]] <font color="red">'''*'''</font>
:[[Table record_company_info|record_company_info]]
+
:[[Table record_company_info|record_company_info]] <font color="red">'''*'''</font>
:[[Table reviews|reviews]]
+
:[[Table reviews|reviews]] <font color="red">'''*'''</font>
:[[Table reviews_description|reviews_description]]
+
:[[Table reviews_description|reviews_description]] <font color="red">'''*'''</font>
:[[Table salemaker_sales|salemaker_sales]]
+
:[[Table salemaker_sales|salemaker_sales]] <font color="red">'''*'''</font>
:[[Table sessions|sessions]]
+
:[[Table sessions|sessions]] <font color="red">'''*'''</font>
:[[Table specials|specials]]
+
:[[Table specials|specials]] <font color="red">'''*'''</font>
:[[Table tax_class|tax_class]]
+
:[[Table tax_class|tax_class]] <font color="red">'''*'''</font>
:[[Table tax_rates|tax_rates]]
+
:[[Table tax_rates|tax_rates]] <font color="red">'''*'''</font>
:[[Table template_select|template_select]]
+
:[[Table template_select|template_select]] <font color="red">'''*'''</font>
:[[Table upgrade_exceptions|upgrade_exceptions]]
+
:[[Table upgrade_exceptions|upgrade_exceptions]] <font color="red">'''*'''</font>
:[[Table whos_online|whos_online]]
+
:[[Table whos_online|whos_online]] <font color="red">'''*'''</font>
:[[Table zones|zones]]
+
:[[Table zones|zones]] <font color="red">'''*'''</font>
:[[Table zones_to_geo_zones|zones_to_geo_zones]]
+
:[[Table zones_to_geo_zones|zones_to_geo_zones]] <font color="red">'''*'''</font>

Revision as of 03:33, 19 July 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.
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

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