The following database tables are used in the E-commerce module. As this is a very complex module, the topic is divided into the following content-based sections:

 

•Customers

•Products

•Orders

•Shopping cart

•Currencies

•Shipping and payment

•Discounts

•Taxes

 

Customers

 

•COM_Customer - contains records representing customers.

•CMS_User - contains records representing registered users.

•CMS_UserSite - contains records representing relationship between users and sites; a given user is assigned to a given site.

•COM_Address - contains records representing customer addresses.

•COM_CustomerCreditHistory - contains records representing customer credit history.

 

 

Pruducts

 

•COM_OptionCategory - contains records representing product option categories.

•COM_SKU - contains records representing products (SKUs).

•COM_SKUOptionCategory - contains records representing relationships between product option categories and SKUs, indicating that particular product option categories are available for a particular SKU.

•COM_Bundle - contains records representing relationships between products of the bundle product type and other products, indicating that these products are within these bundles.

•COM_SKUFile - contains records representing e-product files.

 

•COM_Manufacturer - contains records representing manufacturers.

•COM_Supplier - contains records representing suppliers.

•COM_Department - contains records representing departments.

•COM_UserDepartment - contains records representing relationships between users and departments, indicating that a particular user can manage products of a particular department.

 

•COM_InternalStatus - contains records representing product internal statuses.

•COM_PublicStatus - contains records representing product public statuses.

 

 

Orders

 

•COM_Order - contains records representing orders.

•COM_OrderItem - contains records representing order items.

•COM_OrderItemSKUFile - contains records representing relationships between order items and e-product files, indicating that a particular order item comes with a particular e-product file. This relationship is created when an order containing an e-product is paid.

•COM_OrderStatus - contains records representing order statuses.

•COM_OrderStatusUser - contains records representing relationships between order statuses and users, indicating that a particular user changed the status of a particular order (i.e. order status history).

 

 

Shopping cart

 

•COM_ShoppingCart - contains records representing shopping carts.

•COM_ShoppingCartSKU - contains records representing relationships between SKUs and shopping carts, indicating that particular SKUs are placed in a particular shopping cart.

•COM_Wishlist - contains records representing wishlists.

 

 

Currencies

 

•COM_Currency - contains records representing currencies.

•COM_ExchangeTable - contains records representing exchange tables.

•COM_CurrencyExchangeRate - contains records representing exchange rates.

 

 

Shipping and payment

 

•COM_PaymentOption - contains records representing payment options.

•COM_PaymentShipping - contains records representing relationships between payment and shipping, indicating that a given payment method is allowed for a given shipping.

•COM_ShippingOption - contains records representing shipping options.

•COM_ShippingCost - contains records representing shipping costs.

 

 

Discounts

 

•COM_VolumeDiscount - contains records representing volume discounts.

•COM_DiscountCoupon - contains records representing discount coupons.

•COM_SKUDiscountCoupon - contains records representing relationships between discount coupons and SKUs, indicating that particular discount coupons can be applied to a particular SKU.

•COM_DiscountLevel - contains records representing discount levels.

•COM_DiscountLevelDepartment - contains records representing relationships between discount levels and departments, indicating that a particular discount level can be applied to all products from a particular department.

 

 

Taxes

 

•COM_TaxClass - contains records representing tax classes.

•COM_TaxClassCountry - contains records representing relationships between tax classes and countries, indicating the value of a particular tax in a particular country.

•COM_TaxClassState - contains records representing relationships between tax classes and states, indicating the value of a particular tax in a particular state.

•COM_SKUTaxClasses - contains records representing relationships between tax classes and SKUs, indicating that particular tax classes are assigned to a particular SKU.

•COM_DepartmentTaxClass - contains records representing relationships between departments and tax classes, indicating that all new products in a particular department will have automatically assigned a particular tax.

•COM_ShippingOptionTaxClass - contains records representing relationships between shipping options and tax classes, indicating that particular taxes are assigned to a particular shipping.