Database definitions

Defines database table schema, name, and context in Optimizely Configured Commerce.

The following table provides the database definitions for Configured Commerce.

Table Schema	Table Name	Context	Description
AppDict	AdminActionConfiguration	Security/Configuration	Stores configurations for actions available in the Admin Console, which require specific permissions by role. For example, only users with the ISC_Admin, ISC_ContentAdmin, ISC_ContentApprover, or ISC_System role can approve and publish content revisions.
AppDict	AdminActionPermission	Security/Configuration	Indicates which roles are allowed or disallowed to take the actions in the [dbo].[AdminActionConfiguration] table.
AppDict	EntityConfiguration	Security/Configuration	The Application Dictionary controls field names, field labels, language options, field length, and security access based on assigned User Roles. Only make changes in this area if you are confident and understand the implications of the change.
AppDict	EntityPermission	Security/Configuration	Entities are the top-level data constructs in the system and loosely relate to a SQL table. This permission table is used override the default entity permissions established by Configured Commerce.
AppDict	PropertyAttributeConfiguration	Security/Configuration	This table allows implementers to override specific behaviors or constraints on properties available in the Admin Console forms. For example, you can change the default value, display width, or maximum value of a form field.
AppDict	PropertyConfiguration	Security/Configuration	Properties are the fields within a given entity. This table holds property configurations that override the default configurations provided by Configured Commerce.
AppDict	PropertyPermission	Security/Configuration	Permissions may be overridden by the implementer by role so that a given field (entity property) may be set as read-only or hidden.
dbo	__MigrationHistory	Entity Framework Migrations	This is a .NET table for handling Entity Framework migrations. This table is not managed by Configured Commerce.
dbo	AdminUserProfile	Security	Users have roles assigned to them and are able to interact with the Admin Console.
dbo	AdminUserProfilePassword	Security	This is used for keeping track of the last several passwords used for PCI compliance.
dbo	AdminUserProfilePreference	System	This table is used to store various user preferences within the Admin Console, such as column order on a grid.
dbo	Affiliate	Marketing	Affiliates are used to connect with third-party affiliate online marketing programs. Custom development is required to leverage this feature.
dbo	ApplicationDictionary	Application	OBSOLETE - These configurations have been moved to the [AppDict].[EntityConfiguration], [AppDict].[PropertyConfiguration], and other related tables in the [AppDict] schema.
dbo	ApplicationLog	Application	The Application Logs are used to research application issues. When errors arise in the application, they are generally persisted to this log.
dbo	ApplicationMessage	Application	Application Messages allow you to view existing site messages and/or create new messages, which are used to communicate with all or a specific set of customers. The messages can be delivered on all websites or a specific website. Messages are configured to be sent automatically when an action is required.
dbo	AspNetRoles	Security	Part of ASP.NET Identity services which is used for all of our authentication. The roles table holds the specific roles defined in the application, both system-defined (such as ISC_Admin, ISC_Integration) and user-defined. These roles can be used in either the website through extension or the Admin Console through security configuration in the Application Dictionary.
dbo	AspNetUserClaims	Security	Part of ASP.NET Identity used for SSO/login through another provider, such as Facebook.
dbo	AspNetUserLogins	Security	Part of ASP.NET Identity used for SSO/login through another provider, such as Facebook.
dbo	AspNetUserRoles	Security	Part of ASP.NET Identity used to associate users to their assigned roles.
dbo	AspNetUsers	Security	Part of ASP.NET Identity used to identify users in the system. This table holds information associated with their login name, password, and email. Additional information that is Configured Commerce-specific is contained in the [dbo.UserProfile] and [dbo.AdminUserProfile] tables.
dbo	AttributeType	Products	Attributes are used to assign search, facet, and comparison values for products. The attribute type is the category of the attribute, such as "Color" or "Size", where the attribute values are the specific values available within an attribute type.
dbo	AttributeValue	Products	The list of possible values is for an Attribute Type, such as "Red", "Green", and "Blue" for the "Color" attribute.
dbo	Audit	System	This table is used to capture certain events on the Storefront and Admin Console for auditing and PCI-compliance. It will contain successful and failed login information, application settings being changed, password change requests, integration job definition changes, role assignment, and user creation.
dbo	BudgetCalendar	Budget	Budget calendars are periods defined by a customer within which the budgets are enforced and on which budget reporting is based.
dbo	CacheKeySuffix	Cache	This table is used as part of the caching strategy and is shared by web servers in a farm so that caching can be invalidated and reloaded. This is primarily used for Content Management System (CMS) caching.
dbo	CacheState	Cache	This table is used as part of the caching strategy and is used to implement e-tag caching.
dbo	Carrier	Shipping	These records are shipping carriers available within the website, such as FedEx, UPS, or company truck. Carriers contain information like shipping services or package information used to calculate shipping charges for an order.
dbo	CarrierPackage	Shipping	This is a set of predefined packages for parcel shipping calculations which are used by the OrderPackager plug-in. The standard packager uses maximum weight to "pack up the order" and emulate the packages to send into a parcel carrier to obtain shipping rates.
dbo	CarrierZone	Shipping	For carriers where the rate table will be entered directly into Configured Commerce, the CarrierZone* tables are used to define delivery zones by postal code range and rates by zone and weight. This can be used for truck/LTL carriers or local parcel services that do no use an API to calculate the rates.
dbo	CarrierZonePostalCodeRange	Shipping	Used by the system to determine which zone a given postal code range is in from the source shipping location to help calculate rates.
dbo	CarrierZoneRate	Shipping	Used by the system to determine the rates by zone and weight for carriers, where Configured Commerce is calculating the shipping charges.
dbo	Category	Categories	Categories are a site-specific product classification and grouping mechanism that drives a website's navigation. As products are created, they need to be assigned to a Category. Dynamic Categories allow for the same types of classification and grouping, but they automatically add products to a category based on a set of criteria and rules specified by the user.
dbo	CategoryAttributeType	Categories	By assigning AttributeTypes to a category, it will expose the attributes to products in those categories. For those attribute types that are filterable, the filters for that category will be presented when you go to that category.
dbo	CategoryAttributeValue	Categories	This construct is a hook that requires custom development to use and is not guaranteed to be in future releases. The intent is to allow the user to assign specific values to a given category for faceting.
dbo	CategoryProduct	Categories	This table defines the products that are assigned to a given category.
dbo	CategoryRelatedProduct	Categories	This table is used to establish category cross sells, but is more flexible. The data contains the category and any products related to it in addition to the type of relationship, as defined in the System List named "ProductRelationship".
dbo	CategoryTaxExemption	Categories	Used to define entire categories of product which are tax exempt while using the internal Configured Commerce tax engine.
dbo	Configuration	Advanced Configuration	Initial table that defines an advanced, rules-based configuration for products.
dbo	ConfigurationConditionFilter	Advanced Configuration	This table is not currently used by the application and should not be used.
dbo	ConfigurationOption	Advanced Configuration	Defines the specific input values (options) for an advanced configuration.
dbo	ConfigurationOptionCondition	Advanced Configuration	Defines a specific condition for which different values will be available for a given option.
dbo	ConfigurationPage	Advanced Configuration	Defines a page of inputs (options) for an advanced configuration.
dbo	ConfigurationQueryResult	Advanced Configuration	Query results are currently only accessible through integration and are used to store a table/spreadsheet of values from which selections may be conditioned and filtered.
dbo	ConfigurationQueryResultField	Advanced Configuration	This table defines the different fields in a query, analogous to the columns in a spreadsheet.
dbo	ConfigurationQueryResultValue	Advanced Configuration	This table stores the actual values for each row of a query result, in XML format.
dbo	Content	Content Management	Content stores the embedded content entries for Products, Categories, Specifications, and so on. This content is anchored to a parent entity through a ContentManager.
dbo	ContentItem	Content Management	This is the primary CMS entry for a content item managed through the CMS. This describes on which page the item lives, where on the page the item lives, and workflow information.
dbo	ContentItemField	Content Management	ContentItemField stores the actual content or content item property for CMS.
dbo	ContentManager	Content Management	The content managers associate the parent of the content to all of the current and pending content revisions and variations for the parent. For example, the Product Content control will display all of the Content items that have the same ContentManager.
dbo	ContentPageState	Content Management	Used by CMS to know the current state of a given content-managed page. This table also helps manage future published content.
dbo	Country	System	A list of valid countries that are used for address validation, state/province management for a country and which countries are available on a given website.
dbo	CreditCardTransaction	Orders	When a credit card is processed, a transaction is recorded for audit and history purposes.
dbo	Currency	Multi-Currency	Currencies provide the flexibility of having different currencies that can be assigned to websites.
dbo	CurrencyRate	Multi-Currency	Used by the pricing system to determine the current exchange rate to the base currency to allow for price conversions.
dbo	Customer	Customers	Records that represent the customer Bill To and Ship To instances for a given customer. Users are assigned to the customer records and purchase on their behalf.
dbo	CustomerBudget	Customers	Allows for capturing the specific budget by period for a customer, Ship To, or user, which is then applied to budget restrictions and workflow.
dbo	CustomerCarrier	Customers	Allows assigning customers to specific carriers. This is not currently used by the system in a standard way and we do not advise using it.
dbo	CustomerCostCode	Customers	Used by the order system to allow for a customer to establish specific cost codes to be assigned to individual order lines for tracking purposes. These can often represent a project or department and is available to the order submission process to capture the data in the ERP order.
dbo	CustomerOrder	Orders	The primary order/cart construct in the system. This is used for carts, completed orders, orders in workflow, saved orders, and quotes.
dbo	CustomerOrderTax	Taxes	When dual tax jurisdictions are configured, this table will store each of the tax jurisdictions that are applied to a customer order.
dbo	CustomerOrderGiftCard	CUSTOM	The intent of this table is to associate a gift card purchased to a specific customer order.
dbo	CustomerOrderPromotion	Orders	Captures the promotions processed against a given customer order.
dbo	CustomerProduct	Customers	Defines the customer-specific name of a given product so that they can order by their internal product identifiers. This also captures a default unit of measure with which a customer orders a specific product.
dbo	CustomerProductSet	Customers/Custom	This construct allows the Configured Commerce administrator to establish a group of products to a named set. This is a custom extension to allow for things like "Customer Favorites".
dbo	CustomerProductSetProduct	Customers	Represents the specific products that belong to a CustomerProductSet.
dbo	CustomerRestrictionGroup	Customers	Part of the restriction group functionality to include/exclude certain products by customer. The entry here defines an override to the default behavior defined in the Restriction Group.
dbo	CustomerRestrictionGroupProduct	Customers	Allows for refining the override behavior of a restriction group to specific products within the group. If no products exist, the entire group acts as the override. If any products are listed, only those products are part of the override.
dbo	CustomerSalesperson	Customers/Custom	Allows a many-to-many relationship between customers and sales reps. This is not currently used in the system for any standard behavior.
dbo	CustomerUserProfile	Customers	Used to assign Users to Customers and to establish a default customer and cost code for the user.
dbo	CustomProperty	Extensions	This table stores all of the custom properties in the system. The [ParentId] and [ParentTable] indicate to which other table and record this property belongs.
dbo	DashboardPanelPosition	Storefront	Stores user preferences related to the order of the panels displayed on the Storefront dashboard.
dbo	DatabaseScript	System	This table mimics the idea behind the Entity Framework [dbo].[__MigrationHistory] table. On startup, Configured Commerce executes database scripts to allow for data migrations and schema changes. A script will only ever be executed once because this table keeps track of if and when a script was executed.
dbo	Dealer	Dealers	This represents the different locations where the products are sold and is used in the Store Locator control.
dbo	DealerCategory	Dealers	Defines the categories of products that a specific location carries. Useful to either display the brands a location carries or the locations that carry a given brand.
dbo	DealerProduct	Dealers/Custom	Creates the ability to assign individual products to a dealer as opposed to a category. Requires customization to use.
dbo	Document	Products	List of document paths associated with a product.
dbo	ELMAH_Error	System	Used by a third-party error-tracking system to record system errors that are not specifically coded for within the application. This table includes valuable debugging information and can be used for troubleshooting site problems. See https://elmah.github.io/ for additional information.
dbo	EmailList	Communication	Email Lists contain the names and email addresses which are used to send out Email Templates. This table defines a name for an email list to which email addresses are subscribed.
dbo	EmailMessage	Communication	This table stores attempts made by Configured Commerce to send outbound email messages.
dbo	EmailMessageAddress	Communication	Stores the sender and recipient email addresses used for a given email message.
dbo	EmailMessageDeliveryAttempt	Communication	Works with the email system to help ensure that email messages are sent. This controls the retry queue to make sure sending an email message is attempted several times before giving up.
dbo	EmailSubscriber	Communication	This is a list of email addresses that can be assigned to different email lists.
dbo	EmailSubscriberEmailList	Communication	Contains the list of specific subscribers and the email lists to which they are subscribed.
dbo	EmailTemplate	Communication	Email Templates are reusable emails that can be sent to customers, informing them of notices such as product updates or special pricing opportunities. These Email Templates are sent out using recipient lists created in the Email Lists, which can be found Marketing > Communication section in the Admin Console.
dbo	GiftCard	CUSTOM DEV	Gift cards are an extension construct within the system, but have some built-in functionality. This table stores the actual gift cards in the system, whether or not they have been sold, and what remains of their balance.
dbo	GiftCardTransaction	CUSTOM DEV	This table stores all of transactions made with a gift card until the balance reaches zero or the card expires.
dbo	GlobalSynonym	PunchOut	This is used to map certain values for constructs, such as Currency or UnitOfMeasure, for incoming documents in PunchOut. The list of types is defined by the System List named "GlobalSynonymType".
dbo	HtmlRedirect	Site	Use URL Redirects when it is necessary to redirect from a legacy URL to a new URL.
dbo	IntegrationConnection	Integration	Contains configuration data for all of the remote data source connections for the integration architecture, if it is being used. An Internal connection is defined automatically for import/export functions.
dbo	IntegrationJob	Integration	Contains a history of jobs that have been run using the Configured Commerce Integration Architecture.
dbo	IntegrationJobLog	Integration	Provides a detailed list of information, warning, error, and debugging messages for a specific integration job.
dbo	IntegrationJobParameter	Integration	Details the parameters used when an integration job is executed.
dbo	InvoiceHistory	History	Header of an invoice used for presentation on the Storefront.
dbo	InvoiceHistoryLine	History	Detail of an invoice for Invoice History.
dbo	InvoiceHistoryTax	Taxes	When dual tax jurisdictions are configured, this table will store each of the tax jurisdictions that were applied to an invoice.
dbo	JobDefinition	Integration	The Job Definitions table and associated tables define the integration process for a given integration using metadata.
dbo	JobDefinitionParameter	Integration	Defines the job-level parameters used for an integration job.
dbo	JobDefinitionStep	Integration	Defines each step within an integration job definition.
dbo	JobDefinitionStepFieldMap	Integration	Defines the field mapping for a refresh or submit job.
dbo	JobDefinitionStepParameter	Integration	Defines the step-level parameters used for an integration job.
dbo	Language	System	System list of languages that can be used by the system. This list is used for defining which languages are used by a website to display all content and messages.
dbo	LocalTaxRate	Taxes	Identifies specific tax rates by zip code and controls whether or not freight is included when using the Configured Commerce tax engine.
dbo	LocalTaxRateTaxExemption	Taxes	Defines the tax exemptions that apply for a specific local tax jurisdiction when using the Configured Commerce tax engine.
dbo	Message	Communication	Dashboard Messages are displayed on the website to users in their Account Dashboard. They can be used to notify users about events such as planned downtime for the site due to maintenance.
dbo	MessageAudit	Communication	Captures messages that have been generated by system processes, such as RFQ, and can expose the message log/history.
dbo	MessageStatus	Communication	Uses the MessageTarget to expose the message to all of the expected recipients and track if the message has been read or not.
dbo	MessageTarget	Communication	Defines the different target audiences for a message.
dbo	OrderHistory	History	This table is used for displaying order history on the site and is initially populated from web orders being placed. It is then augmented and updated using integration refresh jobs.
dbo	OrderHistoryLine	History	The order lines that go along with the order history records.
dbo	OrderHistoryTax	Taxes	When dual tax jurisdictions are configured, this table will store each of the tax jurisdictions that were applied to a customer order.
dbo	OrderLine	Orders	The order lines that are part of a CustomerOrder.
dbo	OrderLineConfigurationValue	Orders	Used as part of the Advanced Configuration capability of the system. This table holds the actual values selected for a specific configuration option.
dbo	OrderLineRequisition	Orders	This table facilitates the detailed requisitions made by requisitioners. These are aggregated to a requisition order, but this provides the detail of the quantity and use making the request.
dbo	OrderLineRfq	Orders	Holds the quantity breaks and quotes prices for a price quote.
dbo	OrderPromotionCode	Orders	Defines the specific promotions applied against an order.
dbo	PaymentMethod	System	Payment Methods are one of the ways in which Configured Commerce captures and secures funds for the items or services sold on a website. The two primary types of payment methods are credit cards and purchase orders. These can be configured in the Sales > Payment Methods section of the Admin Console.
dbo	Persona	Personas	Personas are used to define groups of users that can be targeted with specific content.
dbo	Plugin	System	This is an internal table used primarily to support the integration architecture by injecting the available integration processors from a given Integration Connection.
dbo	PriceMatrix	Pricing	A Price Matrix is a way to create unique pricing rules for specific products, customers, product groups, or customer groups.
dbo	Product	Products	Products are the items sold on a website and is a primary construct in the E-commerce ecosystem. Many other tables reference or are children of this table.
dbo	ProductAttributeValue	Products	Used to assign specific values of attributes to a product. The list is generated based on the attribute types assigned to a category and the categories to which a product is assigned.
dbo	ProductKitSection	Products	For products that are configured but do not use the Advanced Configuration option (kits and bundles), this defines the options groups for which to promt. By way of example, if we are configuring a Computer, the sections may be "Case", "Motherboard", and "Memory".
dbo	ProductKitSectionOption	Products	These are the available options within a section for a kit.
dbo	ProductRelatedProduct	Products	This table is the generic version of cross sells and accessories. It can be used for any relationship between different products, such as BOM list or replacement parts. The relationships available are defined by the System List named "ProductRelationship".
dbo	ProductTaxExemption	Products	Indicates the products that are subject to a specific tax exemption when using the Configured Commerce tax engine.
dbo	ProductUnitOfMeasure	Products	Used to define the alternate units of measure for a product and the conversion factors to state in stocking units.
dbo	ProductWarehouse	Products	This table holds the current inventory by warehouse and product.
dbo	Promotion	Promotions	Promotions are used to incentivize customers by offering discounts on orders or shipping or giving away free/promotional products. Promotions are configurable using a rules engine.
dbo	PromotionResult	Promotions	The results part of the promotion indicates how the promotion is applied. Examples include free shipping, % off order, and amount off order.
dbo	PromotionRule	Promotions	OBSOLETE - This has been replaced by the generic rules engine, specifically [dbo].[RuleClause].
dbo	PunchOutCustomerUserProfileMap	PunchOut	Used by PunchOut to connect a User Profile in the request cXML to a specific customer.
dbo	PunchOutOrderRequest	PunchOut	Records the actual cXML request during a punchout session and helps with auditing the process.
dbo	PunchOutOrderRequestExtrinsic	PunchOut	Enumerates the extrinsic (custom) fields defined by the order information in the cXML and persists them for future reference and audit.
dbo	PunchOutOrderRequestItemOut	PunchOut	Order details that are sent with the request.
dbo	PunchOutOrderRequestItemOutExtrinsic	PunchOut	Describes the extrinsic (custom) fields included in the order detail lines that are sent with the request and persists them for future reference and audit.
dbo	PunchOutOrderRequestMessage	PunchOut	This is a collection of messages that are sent back to the caller for issues found on the received order, such as invalid unit of measure or invalid product.
dbo	PunchOutSession	PunchOut	Records key information about a specific PunchOut session, including the order within Configured Commerce that was created or modified during the session.
dbo	PunchOutSessionAccess	PunchOut	This is an audit of the requests coming in during a PunchOut session. This records the date/time of the request and IP address from which the request originated.
dbo	PunchOutSessionExtrinsic	PunchOut	Enumerates the extrinsic (custom) fields defined by the session information in the cXML request.
dbo	PunchOutSessionItemIn	PunchOut	This is used specifically for inspect/edit modes to recall the cart back into the session.
dbo	PunchOutSetupRequest	PunchOut	Records an audit of the PunchOut setup request as provided by the trading partner.
dbo	ReportOrderHistoryLineView	Analytics	This is a view used for analytics exports.
dbo	ReportOrderHistoryView	Analytics	This is a view used for analytics exports.
dbo	RestrictionGroup	Categories	Restriction Groups are used to classify sets of products that have restricted access and can be defined as "EVERYBODY except" as a default (include by default) or "NOBODY except" (exclude by default). This is used in conjunction with [dbo].[CustomerRestrictionGroup] to allow overriding the default behavior by customer.
dbo	RuleClause	Rules	Used by the rules manager to define the specific implementation of a set of rules contained within a rule manager. For example, Persona uses a rules manager to define a persona and its specific parameters.
dbo	RuleManager	Rules	The rule manager is the parent of the rule clauses and is associated with the parent item such as Carrier, Persona, or Promotion.
dbo	RuleType	Rules	Rule Types are the top-level construct of the rules engine and defines the entities that can use specific rules. Except for the built-in rule types (dynamic categories, promotions, personas, and shipping rules), it can be extended for generic use elsewhere in the system where a set of rules defines a true/false answer.
dbo	RuleTypeOption	Rules	These are the specific rules that are set up and made available for constructing rule clauses. These options have some generic entries (Object, Custom Properties) or specific implementations using the CriteriaTypes, which have the actual server-side evaluation code in them along with certain display rules.
dbo	Salesperson	Customer	Sales Representatives are used primarily when working with the Request for Quote (RFQ) feature. When a quote is submitted, the Sales Representative can enter a quote or a calculate value, which is then provided back to the user for acceptance. Sales representatives can also be set up as users. When they log in, all of the customers associated with the sales rep are available for selection. This allows the sales representative to place orders on behalf of the customer.
dbo	SeqBatchNumber	System	OBSOLETE
dbo	SeqContentKey	System	Used to track the next available sequence for a ContentItem.
dbo	SeqCustomerNumber	System	Used by the system to assign the next automatically assigned customer number.
dbo	SeqOrderNumber	System	Used by the system to assign the next automatically assigned order number.
dbo	ShipCharge	Shipping	Used by the carrier/shipping engine to add additional charges to a carrier or service.
dbo	Shipment	History	This table is created through integration and tracks the shipments that have been made against orders. This represents the shipment header.
dbo	ShipmentPackage	History	This table contains one or more individual packages that were sent with a shipment, along with the tracking number.
dbo	ShipmentPackageLine	History	This table records the shipped contents of each package, which is entirely optional in the system.
dbo	ShippingRestriction	Orders	Used to define specific products that cannot be sold in specific jurisdictions. Currently this is only supported at the state level. For example, liquor cannot be shipped to Kentucky, so this product will be excluded from the cart.
dbo	ShipRate	Shipping	This is used as part of the shipping engine when the shipping charges are maintained within Configured Commerce based on the order value vs. weight.
dbo	ShipRule	Shipping	OBSOLETE - This has been replaced with the rules engine, specifically [dbo].[RuleClause].
dbo	ShipVia	Shipping	Represents the carrier service. For example, if the carrier is FedEx, the ShipVia could be "Express" or "2nd Day AM".
dbo	Specification	Products	Specifications are a set of content-managed additional information associated with a product. Typically, each specification is shown as a separate tab on the product detail page.
dbo	State	System	States is a standardized table that is associated with specific countries. This table is used throughout address capture, including on the order address page.
dbo	StateTaxExemption	Taxes	This associates specific states with being tax exempt if using the Configured Commerce tax engine.
dbo	StyleClass	Products	Used to define a group of similar items that have the same traits. An example would be t-shirts that have Color and Size as traits or pants Waist, Inseam, and Color as traits.
dbo	StyleTrait	Products	These are analogous to attribute types and represent the groups of values that will ultimately help resolve a set of attributes to a specific product. As stated above, Color and Size are examples of StyleTraits.
dbo	StyleTraitValue	Products	These are the actual values that are available within a style trait, such as the valid list of Colors within the Color style trait.
dbo	StyleTraitValueProduct	Products	This table associates the specific StyleTrait values to a specific product.
dbo	Subscription	CUSTOM DEV	Subscriptions are designed to allow a customer to purchase a set of products that are shipped on a regular basis. Some of this is available in the standard site, but much of it will require additional development. Fortunately, there are many constructs that enable subscriptions. This table represents the subscription order and includes the start/end date of the subscription, who purchased the product, where the product should be shipped, the cycle and the subscription parent product associated with the subscription.
dbo	SubscriptionLine	CUSTOM DEV	Defines the specific products and quantities to ship at a given price.
dbo	SubscriptionProduct	CUSTOM DEV	This defines a list of shippable products within a subscription product. For example, the subscribed product may be "Oil Change Kit" and the products would include 4 cans of oil, a drain pan, and an oil filter.
dbo	SystemList	System	System Lists allow you to customize the predefined lists, such as RMA codes and devices types. You can also create your own lists to extend platform capabilities.
dbo	SystemListValue	System	The specific values associated with a system list, such as "CrossSells" or "Accessories" within the "ProductRelationship" system list.
dbo	TaxExemption	Taxes	Tax Exemptions allow the user to create specific exemptions from tax and then associate them with products, categories, and customers, if using the Configured Commerce tax engine.
dbo	TranslationDictionary	Multi-Language	Single word or short phrase translation records for text, such as Product Attributes, Payment Terms, and Units of Measure.
dbo	TranslationProperty	Multi-Language	Translation records for fields such as Product Name, Application Messages, and Page titles. This is used for longer, unique strings.
dbo	UserPaymentProfile	Orders	This is not currently implemented in the site, but will be used to store credit card tokens so that a buyer can re-use a credit card. Credit card numbers are not stored.
dbo	UserProfile	Security	Users have roles assigned to them and are able to interact with the Storefront based on the assigned roles. Users must be assigned to a customer before they have access to the Storefront.
dbo	UserProfileWebsite		Keeps track of which Storefront users have access to specific WebSites. This acts as a mapping between [dbo].[UserProfile] and [dbo].[WebSite].
dbo	Vendor	Products	This represents the list of providers for the product table. Each record could be a manufacturer or supplier. A product can be associated with a vendor.
dbo	Warehouse	Products	Warehouses are used to define the location of a given inventory site, calculate shipping costs, and define product/warehouse inventory.
dbo	WarehouseAlternate	Products	This is a list of alternate warehouses from which inventory should be aggregated when determining the available inventory. For example, if I have a warehouse in Minneapolis, Milwaukee, and Chicago, I may want to have Milwaukee act as an alternate for both Minneapolis and Chicago. Then we can aggregate inventory from it to those other locations when determining how we show inventory availability on the site.
dbo	WebPage	Content Management	OBSOLETE - This was replaced by the CMS.
dbo	WebPageContent	Content Management	OBSOLETE - This was replaced by the CMS.
dbo	WebSite	Websites	Websites are a primary construct in the application to define the URLs that point to a given site and the unique category structure within the site. Alternate sites and microsites are all defined here.
dbo	WebSiteAllowedCustomers	Websites	Assigns websites to customers when restricted access to the website is in place.
dbo	WebSiteCarrier	Websites	Assigns carriers to websites. Only these carriers will be available to the website.
dbo	WebSiteCountry	Websites	Assigns countries to websites. Only addresses within these countries will be allowed.
dbo	WebSiteCurrency	Websites	Assigns currencies to websites. Only the currencies selected will be available on the site.
dbo	WebSiteDealer	Websites	Assigns dealers/locations to websites and is used within the dealer locator.
dbo	WebSiteLanguage	Websites	Assigns languages to websites. Only the languages selected will be available on the site.
dbo	WebSiteProductCrossSell	Websites	This is a set of specific products set up as cross sells and shown in the website cross-sell carrousel on the home page.
dbo	WebSitePromotion	Websites	Assigns promotions to websites. Only these promotions will be available on the site.
dbo	WebsiteSitemap	Websites	This table is generated from an integration processor and contains the actual sitemap along with related data based on some configuration options.
dbo	WebSiteState	Websites	Assigns states to websites. Only the states assigned will be available for Ship To addresses on the site.
dbo	WishList	Wish Lists	WishLists are lists of products associated to either a customer or a user that acts as a holding place for buyers to set aside a set of products in which they are interested. Buyers can have multiple wishlists, which can be used for "favorite products" or commonly re-ordered products, as if it were a template order.
dbo	WishListProduct	Wish Lists	This is the specific list of products associated with a wish list.
identity	ClientClaims	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientCorsOrigins	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientCustomGrantTypes	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientIdPRestrictions	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientPostLogoutRedirectUris	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientRedirectUris	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	Clients	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientScopes	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ClientSecrets	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	Consents	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	ScopeClaims	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	Scopes	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
identity	Tokens	Security/SSO	Part of Identity Server 3 - additional information at https://github.com/IdentityServer/IdentityServer3.
search	SearchBoost	Search	Search Boosting increases or decreases the visibility of a particular field within a search query. Category Boosting increases or decreases the visibility of a Category within a search query. Product Boosting increases or decreases the visibility of a Product within a search query.
search	SearchStopword	Search	Stopwords are common words that are ignored when they are included within a search query. The most common stopwords are already included in the platform. To improve search results, it may be helpful to add additional stopwords, such as "cheap" or "quality", as these can introduce unnecessary noise into a search query.
search	SearchSynonym	Search	Synonyms are used to manage alternate word forms that may be entered in a search query. For example, connect keywords such as "sofa" and "couch" to help search queries find relevant products.
search	SearchTermRedirect	Search	Redirects link a specific search term to a specific URL.

Updated over 1 year ago