| 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. |
JPA_GENERATED_KEYS