Difference between revisions of "Developers - Database Schema"

From Zen Cart(tm) Wiki
Jump to: navigation, search
m
m
Line 7: Line 7:
 
== Database Schema Diagrams (Work in Progress)==
 
== Database Schema Diagrams (Work in Progress)==
 
: [[Schema Diagram for the whole Database]]
 
: [[Schema Diagram for the whole Database]]
: [[Schema Diagram for Product Info|Product Info]]
+
: [[Developers_-_Database_Schema#Product Info|Product Info]]
: [[Schema Diagram for Sales/Special Pricing Details|Sales/Special Pricing Details]]
+
: [[Developers_-_Database_Schema#Sales.2FSpecial_Pricing_Details|Sales/Special Pricing Details]]
: [[Schema diagram for Product_Type Extra Information|Product_Type Extra Information]]
+
: [[Developers_-_Database_Schema#Product Type Extra Information|Product Type Extra Information]]
: [[Schema Diagram for CMS / Content Management|CMS / Content Management]]
+
: [[Developers_-_Database_Schema#CMS / Content Management|CMS / Content Management]]
 
: [[Developers_-_Database_Schema#Customer_Information|Customer Information]]
 
: [[Developers_-_Database_Schema#Customer_Information|Customer Information]]
: [[Schema Diagram for Customer Interaction|Customer Interaction]]
+
: [[Developers_-_Database_Schema#Customer Interaction|Customer Interaction]]
: [[Schema Diagram for Customers Stored Shopping Carts|Customers Stored Shopping Carts]]
+
: [[Developers_-_Database_Schema#Customers Stored Shopping Carts|Customers Stored Shopping Carts]]
: [[Schema Diagram for Order History|Order History]]
+
: [[Developers_-_Database_Schema#Order History|Order History]]
: [[Schema diagram for PayPal|PayPal™]]
+
: [[Developers_-_Database_Schema#PayPal.E2.84.A2|PayPal™]]
: [[Schema Diagram for Admin Audit Trail|Admin Audit Trail]]
+
: [[Developers_-_Database_Schema#Admin Audit Trail|Admin Audit Trail]]
: [[Schema Diagram for Coupon and Gift Certificate Config/Tracking|Coupon and Gift Certificate Config/Tracking]]
+
: [[Developers_-_Database_Schema#Coupon and Gift Certificate Config/Tracking|Coupon and Gift Certificate Config/Tracking]]
: [[Schema Diagram for System Configuration|System Configuration]]
+
: [[Developers_-_Database_Schema#System Configuration|System Configuration]]
: [[Schema Diagram for Tax/Zone Configuration|Tax/Zone Configuration]]
+
: [[Developers_-_Database_Schema#Tax/Zone Configuration|Tax/Zone Configuration]]
: [[Schema Diagram for Other|Other]]
+
: [[Developers_-_Database_Schema#Other|Other]]
  
 
== Table List in Alphabetical Order ==
 
== Table List in Alphabetical Order ==
Line 149: Line 149:
  
  
=== product_type Extra Information ===
+
=== Product Type Extra Information ===
 
:[[Table media_clips|media_clips]]
 
:[[Table media_clips|media_clips]]
 
:[[Table media_manager|media_manager]]
 
:[[Table media_manager|media_manager]]

Revision as of 01:25, 22 July 2010

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.

Database Schema Diagrams (Work in Progress)

Schema Diagram for the whole Database
Product Info
Sales/Special Pricing Details
Product Type Extra Information
CMS / Content Management
Customer Information
Customer Interaction
Customers Stored Shopping Carts
Order History
PayPal™
Admin Audit Trail
Coupon and Gift Certificate Config/Tracking
System Configuration
Tax/Zone Configuration
Other

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 *


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


See also:

Database Changelog