Developers - Database Schema
From Zen Cart(tm) Wiki
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.
[edit]
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
[edit]
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 *
[edit]
Table List Ordered by Data
[edit]
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 *
[edit]
Sales/Special Pricing Details
[edit]
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 *
[edit]
CMS / Content Management
[edit]
Customer Information
[edit]
Customer Interaction
[edit]
Customers Stored Shopping Carts
[edit]
Order History
- files_uploaded
- orders *
- orders_products *
- orders_products_attributes *
- orders_products_download *
- orders_status_history
- orders_total *
[edit]
PayPal™
[edit]
Admin Audit Trail
- admin_activity_log
- authorizenet
- banners_history
- counter
- counter_history *
- coupon_email_track
- coupon_redeem_track
- email_archive
[edit]
Coupon and Gift Certificate Config/Tracking
- coupon_email_track
- coupon_gv_customer
- coupon_gv_queue
- coupon_redeem_track
- coupon_restrict
- coupons
- coupons_description
[edit]
System Configuration
- admin
- address_format
- configuration *
- configuration_group
- layout_boxes
- template_select *
- currencies
- languages
[edit]
Tax/Zone Configuration
[edit]
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:
