Overview

Table Name	Description
JPA_GENERATED_KEYS	Allows OpenJpa to generate unqiue primary keys for other DB tables
TADDRESS	This table represents a Customer Address.
TADVANCEDSEARCHQUERY	This table represents advanced search queries.
TAPPLIEDRULE	This table represents a rule that has been applied to an order.
TATTRIBUTE	This table reprents a customized property of an object such as Category, Product or Product Sku.
TBASEAMOUNT	This table holds information about base amounts.
TBRAND	This table represents product manufacturer/brand information.
TBUNDLECONSTITUENTX	This table represents the Product Bundle many-to-many relationship to a Consituent.
TBUNDLESELECTIONRULE	This table represents the available bundle constituent selection rules.
TCARTITEM	This table represents a quantity of SKUs in a shopping cart.
TCATALOG	This table represents a catalog.
TCATALOGSUPPORTEDLOCALE	This table represents a supported locale for a catalog.
TCATEGORY	This table represents a collection of related Products.
TCATEGORYATTRIBUTEVALUE	This table represents the Attribute Values for a given Category.
TCATEGORYDELETED	This table represents a deleted category.
TCATEGORYLDF	This table contains locale-dependent information about a Category.
TCATEGORYTYPE	This table represents the type of a Category, which determines the set of attributes that it has. An example of a category type would be Electronics.
TCATEGORYTYPEATTRIBUTE	This table represents a mapping of Category Attributes to a CategoryType
TCHANGEOPERATION	This table holds the details of a change persistence operation
TCHANGESET	This table holds information about change sets in the system.
TCHANGESETUSER	This table represents the users assigned to a change set.
TCHANGETRANSACTION	This table holds the details of a change business transaction
TCHANGETRANSACTIONMETADATA	This table holds meta data of change transaction.
TCMUSER	This table represents a person with an account in the system for accessing the Commerce Manager or web services.
TCMUSERCATALOG	This table represents the Catalogs assigned to a User
TCMUSERPRICELIST	Available price lists
TCMUSERROLEX	This table represents the UserRoles assigned to a Customer
TCMUSERSTORE	This table represents the Stores assigned to a User
TCMUSERWAREHOUSE	This table represents the Warehouses assigned to a User
TCSCONTENTSPACE	ContentSpace. Dynamic content delivery target.
TCSDYNAMICCONTENT	ContentSpace. Dynamic content.
TCSDYNAMICCONTENTDELIVERY	ContentSpace. Dynamic content delivery.
TCSDYNAMICCONTENTSPACE	Dynamic content delivery and target relation
TCSPARAMETERVALUE	ContentSpace. Represents localized value for parameter.
TCSPARAMETERVALUELDF	ContentSpace. Localized or default values for ParameterValue.
TCUSTOMER	This table respresents a Customer account.
TCUSTOMERAUTHENTICATION	This table respresents a Customer authentication.
TCUSTOMERCREDITCARD	This table represents a credit card stored by a Storefront customer.
TCUSTOMERDELETED	This table represents the audit of a deleted Customer.
TCUSTOMERGROUP	This table represents a customer group.
TCUSTOMERGROUPROLEX	This table represents the Role of a CustomerGroup.
TCUSTOMERGROUPX	This table represents the Customers assigned to a CustomerGroup.
TCUSTOMERPROFILEVALUE	This table represents the value of a customer profile.
TCUSTOMERSESSION	This table represents information about customers who may not be logged in.
TDATACHANGED	This table holds details of a set of changes.
TDIGITALASSETAUDIT	This table represents the audit of a DigitalAsset download attempt.
TDIGITALASSETS	This table represents a reference to digital good files stored on the file system.
TGIFTCERTIFICATE	This table represents a gift certificate.
TGIFTCERTIFICATETRANSACTION	This table represents gift certificate payment transactions.
TIMPORTBADROW	This table holds information about the bad rows of import jobs.
TIMPORTFAULT	This table holds information about import fault.
TIMPORTJOB	This table represents an import job.
TIMPORTJOBSTATUS	This table holds information about the status of the running import jobs.
TIMPORTMAPPINGS	This table represents the column to field mapping for an import job.
TIMPORTNOTIFICATION	Holds import notifications.
TIMPORTNOTIFICATIONMETADATA	Holds import notification meta data.
TINDEXBUILDSTATUS	This table holds information about build index statuses.
TINDEXNOTIFY	Holds indexer notifications.
TINVENTORY	This table represents the Inventory information for a ProductSku.
TINVENTORYALLOCATION	Holds information on allocated order sku quantities.
TINVENTORYAUDIT	This table contains an audit of inventory adjustment events.
TLINKEDCATEGORY	This table represents a collection of related Products in a linked Category.
TLOCALIZEDPROPERTIES	This table represents a list of localized properties. For example Brand names.
TMASTERCATEGORY	This table represents a collection of related Products in an unlinked Category.
TOBJECTGROUPMEMBER	This table holds information about business object group members.
TOBJECTMETADATA	This table holds history information of business object group member.
TORDER	This table represents a customer Order.
TORDERADDRESS	This table represents a copy of a customer Address created with an Order.
TORDERAUDIT	This table represents an event popup on an order.
TORDERITEMDATA	Contains key/value pairs of data on OrderSkus.
TORDERLOCK	This table is required for order locking functionality.
TORDERNUMBERGENERATOR	This table represents the next available order number.
TORDERPAYMENT	This table represents customer payments made against an Order.
TORDERRETURN	This table represents a customer''s order return.
TORDERRETURNSKU	This table represents the return of a quantity of SKUs for an order.
TORDERSHIPMENT	This table represents a customer''s order shipment.
TORDERSKU	This table represents an order for a quantity of SKUs.
TPASSWORDHISTORY	This table contains old passwords used by CM users and administrators in the past, but not active password.
TPAYMENTGATEWAY	This table represents the available payment gateways.
TPAYMENTGATEWAYPROPERTIES	This table represents all the associated properties for payment gateways.
TPICKLIST	This table represents a pick list created by CM user.
TPRICEADJUSTMENT	This table holds price adjustments in a price list.
TPRICELIST	This table holds information about price lists.
TPRICELISTASSIGNMENT	Assigns a pricelist descriptor to the certain catalog.
TPRODUCT	This table represents represents a merchandise product. A product must have at least 1 ProductSku associated in order to be sold.
TPRODUCTASSOCIATION	This table represents ProductAssociations between two products. Example of product associations are Cross-Sells, Up-Sells, Accessories.
TPRODUCTATTRIBUTEVALUE	This table represents the value of a Product Attribute.
TPRODUCTCATEGORY	This table represents the association between a Category and it''s contained Products.
TPRODUCTDELETED	This table represents an audit of deleted products.
TPRODUCTLDF	This table contains locale-dependent information about a Product.
TPRODUCTSKU	This table represents a variation of a merchandise product.
TPRODUCTSKUATTRIBUTEVALUE	This table represents the Attribute Values for a given Product.
TPRODUCTSKUOPTIONVALUE	This table represents the mapping of a ProductSKU to a SKUOptionValue.
TPRODUCTTYPE	This table represents the type of a Product, which determines the set of attributes that it has. An example of a product type would be shoes.
TPRODUCTTYPEATTRIBUTE	This table represents a mapping of Product Attributes to a ProductType.
TPRODUCTTYPESKUATTRIBUTE	This table represents a mapping of ProductSKU Attributes to a ProductType.
TPRODUCTTYPESKUOPTION	This table represents the mapping of SKU options to a ProductType.
TRMAGENERATOR	This table represents the next available rma.
TRULE	This table represents a Rule that can be applied by the Rules Engine.
TRULEELEMENT	This table represents the component of a Rule. For example a condition or an action.
TRULEEXCEPTION	This table represents an exception of either a Rule action or condition.
TRULEPARAMETER	This table represents a parameter of a rule condition, such as the category that a product must belong to to qualify for a promotion.
TRULESET	This table represents a set of promotion rules.
TRULESTORAGE	Holds compiled rule bases for rules.
TSELLINGCONTEXT	Selling context for dynamic content
TSELLINGCONTEXTCONDITION	Linking table between selling context and its conditions
TSETTINGDEFINITION	This table contains a metadata entry for every possible, global or store, configuration setting.
TSETTINGMETADATA	This table contains metadata entries for settings definitions.
TSETTINGVALUE	This table contains an entry for each implementation of a Setting definition.
TSFSEARCHLOG	This table represents a log of searches performed on the storefront.
TSHIPMENTTAX	This table represents the tax paid on a customers Shipment.
TSHIPPINGCOSTCALCULATIONMETHOD	This table represents a method to be used for shipping cost calculation; for example Fixed Price.
TSHIPPINGCOSTCALCULATIONPARAM	This table represents a parameter of a shipping cost calculation method, such as the dollar value of the fix base shipping cost.
TSHIPPINGREGION	This table represents a region that will be associated with one or more shipping services.
TSHIPPINGSERVICELEVEL	This table represents a ShippingOption, for example Next Day assoicated with a ShippingRegion.
TSHOPPINGCART	This table represents the state of a customers shopping cart.
TSHOPPINGITEMDATA	Contains key/value pairs of data on ShoppingItems.
TSKUOPTION	This table represents a SKU option that can be configured. For example size or color.
TSKUOPTIONVALUE	This table represents an available option value for a SKU option. Example option values include red, green, small, large, etc.
TSTORE	This table represents stores that exist within Elastic Path
TSTOREASSOCIATION	This table stores store login sharing associations.
TSTORECATALOG	This table represents a relation of catalogs associated with a particular store.
TSTORECREDITCARDTYPE	This table represents the supported credit card types for a particular store.
TSTOREPAYMENTGATEWAY	This table represents a relation of payment gateways associated with a store.
TSTORESUPPORTEDCURRENCY	This table represents a supported currency for a store.
TSTORESUPPORTEDLOCALE	This table represents a supported locale for a store.
TSTORETAXCODE	This table represents a relation of available tax code for a store.
TSTORETAXJURISDICTION	This table represents a relation of available tax jurisdictions for a store.
TSTOREWAREHOUSE	This table represents a relation between a store and a warehouse
TSYNONYM	Table stores synonyms for synonym groups.
TSYNONYMGROUPS	This table represents the synonym groups for a store.
TTAGALLOWEDVALUE	Allowed Values for Tag Definition
TTAGCONDITION	Condition keeps all the conditions in the system
TTAGDEFINITION	Tag Definition keeps all the tag definitions defined in the system
TTAGDICTIONARY	Tag Dictionary
TTAGDICTIONARYTAGDEFINITION	Tag Dictionary and Tag Definition relation
TTAGGROUP	Tag Group for Tag Definition
TTAGOPERATOR	Tag operator holds all all operators that may be used in condition building
TTAGVALUETYPE	Tag value type holds all info relevant to the type of data that may be submitted for tag definition
TTAGVALUETYPEOPERATOR	Tag Value Type and Tag Operator relation
TTAXCATEGORY	This table represents a category of tax, i.e. GST (Canada).
TTAXCODE	This table represents a TaxCode. For example goods and books.
TTAXJURISDICTION	This table represents a TaxJurisdiction, a geographical area i.e. Canada.
TTAXREGION	This table represents a TaxRegion, a geographical area with associated tax values
TTAXVALUE	This table represents a TaxValue for a given TaxJurisdiction and TaxCategory.
TTOPSELLER	This table represents a category of top selling products.
TTOPSELLERPRODUCTS	This table represents a rank of top selling products in the store.
TUSERROLE	This table represents a user''s role.
TUSERROLEPERMISSIONX	This table represents the level of permission assigned to a given UserRole.
TVALIDATIONCONSTRAINTS	This table represents a list of VALANG validation constraints.
TWAREHOUSE	This table represents warehouses where inventory is stored for stores.
TWAREHOUSEADDRESS	This table represents possible addresses of a warehouse.

Overview

152 Child Pages