This page has information about: tables

Stores user addresses.

Stores registered Application Tiers

Stores all brands. A brand is bound to a merchant.

Contains bundles. A bundle is a group of products, these groups are sold like normal products; special prices and stocks are defined.

Stores all carriers. A carrier is bound to a merchant.

Stores carriers localizations. 

Stores catalogs. A catalog is bound to a merchant.

Stores categories. Categories allow products to be organized within a catalog.

Stores categories hierarchy. Allows categories to be sorted together.

Stores categories localization. 

Stores associations between catalogs and currencies.

Stores catalogs localizations.

Stores continents.

Stores continents localizations.

Stores countries. A country is bound to a continent and has a currency.

Stores countries localizations.

Stores all the cultures used by WebStore.

Stores cultures localizations.

Stores all the currencies used by WebStore.

Stores currencies localizations.

Stores customers. A customer is a frontend user who placed at least one order.

Stores associations between customers and segments.

Stores discounts per merchant.

Stores discounts localizations.

This table will contains an items for each discount applied to an order

Stores all the extensions of the platform. Each extension is then linked to a store.

Stores extensions localizations.

Stores extensions packages.

Stores information about registration of an extension to a store.

Stores Generic Attributes. Generic Attributes are sub-parts of a Generic Type which allows you to create custom generic objects (GenericTypeInstances). A Generic Attribute has a base type, it can be required or not, it can also be a collection with lower and upper limits of items in it.

Stores GenericAttributes localizations.

Stores value of a Generic Type Instance for a given Generic Attribute in the given culture.

Stores possible values for enum GenericTypes.

Stores localizations for Generic Enum Values.

Stores Generic Types. A Generic Type allows you to create custom generic objects (GenericTypeInstances). 

Stores GenericTypeInstances. A Generic Type Instance is an instance of a generic type, with values defined for the type's attributes.

Stores Generic Type localizations.

Stores geographic zones per store. Geographic zones are then referenced as Tax zones or Shipping zones.

Stores geographic zones definitions, allowing to map them to real-world zones.

Stores platform settings in XML Format.

Stores all the languages used by WebStore.

Stores languages localizations.

Stores methods of linking products together.

Stores types of linking between products.

Stores logging events, depending on the logging level defined in the platform settings.

A logistic is a slot time for a warehouse. For example, if the website allow picking in a warehouse.

Stores all mails in the sending process. Can contain queued mails, sent mails, failed mails, etc.

Stores mail templates per store. Mail templates can be used for registration emails, placed order emails, etc.

Stores mail templates localizations.

Stores orders placed by customers.

Stores addresses bound to an order. These can be shipping or billing addresses, based on a user address or not.

Stores versions of orders. An order may be modified several times after it was placed: a new version is created each time.

Stores information about a payment. A payment is related to an order.

Stores all the products. This table is not dependant of any virtual catalog.

Stores product attributes.
These attributes may be attached to a ProductType and allow products to be extended.

Stores product attributes localizations.

Stores associations between ProductTypes and ProductAttributes. You can make a ProductAttribute required among the ProductType.

Stores base type for ProductAttributes (decimal, datetime, list, etc.)

Stores associations between products and catalogs.

Stores the associations between products and categories and allows to sort products within a category.

Stores values for an enum ProductAttribute. 
For example, if we create a Color ProductAttribute, this table will contain all the possible value (Red, Green, Yellow, ...)

Stores localizations for product enum values.

Stores values for the different kinds of product (normal, bundle, etc.) 

Stores linking between products. Linking has a type (Cross-selling, up-selling...) and a method (Least sold, most sold, random...).

Stores products localizations.

Stores sale price and cut price for a given product in a given catalog in a given currency, for a given quantity.

Stores the different type of product. These types are dynamic and have attributes, allowing to extend product. For example, types are T-Shirt, Shoes, etc. 

Stores values for product attributes.

Stores instances of ProductType for a specific Product.

Stores product types localizations.

Stores all regions used by WebStore.

Stores regions localizations.

Stores segments, allowing to sort customers depending on any criteria.

Stores merchants. Merchant is the highest-level object in WebStore.

Stores associations between merchants and cultures.

Stores shipments. A shipment is the action of sending a package of articles.

Store shipping items. A shipping item is a sub-part of a shipment.

Stores shipping rates. A shipping rate is based on a carrier, a warehouse, a destination. The criteria may be The quantity of articles, their weight, total price...

Stores shipping rates localizations.

Stores associations between shipping rates and tax categories.

Stores values for shipping rates. Values are expressed by range of the given criteria (see Shipping Rate), in a given currency.

Stores shipping zones. Shipping zones inherit geographic zones.

Stores the associations between shipping zones and catalogs.

Contains stores per merchant. A stores is also bound to an Application.

Stores associations between stores and catalogs of their associated merchant.

Store all configuration for a specific Store. A Store can have multiple configuration, for example a production configuration and a QA configuration. A configuration contains workerComponentConfiguration and custom configuration like the current Date (if we want to test future discount for example)

Stores associations between stores and cultures of their merchant.

Stores associations between stores and currencies of their associated catalogs.

Contains stores localizations.

Stores suppliers per merchant.

Stores tasks per merchant. A task has a trigger and a job definition, and can be retried a given number of times in case of failure.

Stores tasks execution schedules.

Stores tasks runs resulting of a task execution. A task execution may have several task run (failures, retries, etc.).

Stores tax categories. A tax category is bound to a tax type.

Stores tax categories localizations.

Stores associations between products and tax categories.

Stores tax rates for given tax categories and optional origin and destination geographic zones.

Stores tax types. Tax types can have tax categories.

Stores tax types localizations.

Stores tax zones. Tax zones inherit geographic zones.

Stores values for user titles.

Stores titles localizations.

Contains all voucher for a Discount. The availability of a voucher depend of the DiscountUtilization table.

Stores warehouses per merchant. Warehouses are the main part of product inventory management. They can be bound to a tax zone.

Stores warehouses localizations.

Stores associations between warehouses and products. Contains inventory information as well as its kind (unlimited or not).

Stores WebStore users. WebStore users are users who can log into the WebStore BackOffice. This table also stores preferences such as default cultures, merchant and stores.

Stores all the concrete implementation name of a WorkerComponentPattern. A WorkerComponent is a component which provides calculation like TaxCalculation or PriceCalculation, etc.

Stores WorkerComponentPatterns. A WorkerComponentPattern is a type of WorkerComponent, for example a component which calculates tax, etc. The number of component pattern is restricted by the number of WorkerComponentBases available on the magelia WebStore runtime.