Difference between revisions of "X-Cart:Database layout"
(Created page with 'The current MySQL diagram for any X-Cart version with extensive comments can be found in the '''sql/xcart_tables.sql''' file. The X-Cart database consists of four major clusters…') |
|||
| Line 4: | Line 4: | ||
* '''Customers''' — information on users registered with your store, including customers, providers, partners and administrators. | * '''Customers''' — information on users registered with your store, including customers, providers, partners and administrators. | ||
| − | * '''Products''' — product information | + | * '''Products''' — product information, such as name, description, images, price, weight, etc. |
| − | * '''Categories''' — product | + | * '''Categories''' — product category data. |
* '''Orders''' — order details, including product, buyer, delivery and payment details, as well as related discount and gift options. | * '''Orders''' — order details, including product, buyer, delivery and payment details, as well as related discount and gift options. | ||
| + | |||
| + | [[Image:XC444_DB_structure.png]] | ||
Each unit has its own a set of data tables that are linked within the unit and with related tables in other units. | Each unit has its own a set of data tables that are linked within the unit and with related tables in other units. | ||
| Line 12: | Line 14: | ||
=== Customers === | === Customers === | ||
| + | ... | ||
| + | |||
| + | === Products === | ||
| + | |||
| + | ... | ||
| + | |||
| + | === Categories === | ||
| + | ... | ||
=== Orders === | === Orders === | ||
Revision as of 18:53, 10 November 2011
The current MySQL diagram for any X-Cart version with extensive comments can be found in the sql/xcart_tables.sql file.
The X-Cart database consists of four major clusters:
- Customers — information on users registered with your store, including customers, providers, partners and administrators.
- Products — product information, such as name, description, images, price, weight, etc.
- Categories — product category data.
- Orders — order details, including product, buyer, delivery and payment details, as well as related discount and gift options.
Each unit has its own a set of data tables that are linked within the unit and with related tables in other units.
Contents
Customers
...
Products
...
Categories
...
Orders
In an X-Cart based store, customers purchase products by placing orders. An order is a collection of information about a purchase, which includes:
- Information on product items being purchased (product titles, quantities, prices).
- Information on the customer who is making the purchase (personal information, billing and shipping addresses, contact information).
- Information about the method of delivery selected by the customer (name of method, shipping cost).
- Information about the payment method selected by the customer (name of method, payment details).
- Discounts, coupon codes or gift certificates applied.
- Total amount.
Each order has its unique order id number and, at any moment in time, is characterized by a status.
