BroadleafCommerce数据模型

群号：185686402，欢迎访问blog.ebuzz.cn

这篇文章主要介绍了BroadleafCommerce（以下简称BLC）的数据模型，因为官网曾一度无法访问，另外也是访问速度不是特别爽，于是做了制作了一个数据模型的文章。

一、ADMIN

1. 概要图

1.2 Change Sets

Tables

TableRelated EntityDescriptionBLC_SANDBOXSandBoxRepresents a sandbox.BLC_ADMIN_USER_SANDBOX-Cross reference table that points to an admin user.BLC_SITE_SANDBOX-Cross reference table that points to a site.BLC_SANDBOX_ITEMSandBoxItemRepresents a sandbox item.SANDBOX_ITEM_ACTION-Cross reference table that points to an action.BLC_SANDBOX_ACTIONSandBoxActionRepresents a sandbox action.

Related Tables

TableRelated EntityDescriptionBLC_ADMIN_USERAdminUserRepresents an admin user.BLC_SITESiteRepresents a site.

1.3 Modules

Tables

TableRelated EntityDescriptionBLC_ADMIN_MODULEAdminModuleRepresents an admin user.BLC_ADMIN_SECTION_PERMISSION_XREF-Cross reference table that points to an admin permission.BLC_ADMIN_SECTIONAdminSectionRepresents an admin section.BLC_ADMIN_PERMISSIONAdminPermissionRepresents an admin user permission.

1.4 Security

Tables

TableRelated EntityDescriptionBLC_ADMIN_USERAdminUserRepresents an admin user.BLC_ADMIN_USER_ROLE_XREF-Cross reference table that points to an admin user role.BLC_ADMIN_ROLEAdminRoleRepresents an admin user role.BLC_ADMIN_USER_PERMISSION_XREF-Cross reference table that points to an admin user permission.BLC_ADMIN_PERMISSIONAdminPermissionRepresents an admin user permission.BLC_ADMIN_ROLE_PERMISSION_XREF-Cross reference table that points to an admin role permission.BLC_ADMIN_PERMISSION_ENTITYAdminPermissionQualifiedEntityRepresents an admin user permission entity.

Related Tables

TableRelated EntityDescriptionBLC_SANDBOXSandBoxRepresents a sandbox.

二、Catalog

2.1 概要图

2.2 Catalog Category

Tables

TableRelated EntityDescriptionBLC_CATEGORYCategoryRepresents a category.BLC_CATEGORY_ATTRIBUTECategoryAttributeDefines attributes for a category.BLC_CATEGORY_IMAGE-Represents a URL to an image for the category.BLC_CATEGORY_XREF-Cross reference table that points to the subcategories of each category.BLC_PRODUCT_CROSS_SALERelatedProductRepresents the products in the category.BLC_PRODUCT_UP_SALERelatedProductRepresents the products in the category.BLC_PRODUCT_FEATUREDPromotableProductRepresents the products in the category.BLC_CAT_SITE_MAP_GEN_CFGCategorySiteMapGeneratorConfigurationCategorySiteMapGenerator is controlled by this configuration.

Related Tables

TableRelated EntityDescriptionBLC_PRODUCTProductA product is a general description of an item that can be sold (for example: a hat). Products are not sold or added to a cart.BLC_MEDIAMediaRepresents a media object.

2.2 Catalog Product

Tables

TableRelated EntityDescriptionBLC_PRODUCTProductA product is a general description of an item that can be sold (for example: a hat). Products are not sold or added to a cart.BLC_PRODUCT_ATTRIBUTEProductAttributeDefines attributes for a product.BLC_SKU_XREF-Cross reference table that points to the skus for the product.BLC_PRODUCT_BUNDLEProductBundleRepresents the product being sold in a bundle.BLC_SKU_OPTION_VALUE_XREF-Represents the cross reference between sku and a product option value.BLC_PRODUCT_OPTION_VALUEProductOptionValueDefines the value of a Product Option.BLC_PRODUCT_OPTIONProductOptionDesignates a Product Option.BLC_PRODUCT_CROSS_SALERelatedProductRepresents the products in the category.BLC_PRODUCT_UP_SALERelatedProductRepresents the products in the category.BLC_PRODUCT_FEATUREDPromotableProductRepresents the products in the category.

Related Tables

TableRelated EntityDescriptionBLC_CATEGORYCategoryRepresents a category.BLC_SKUSkuA SKU is a specific item that can be sold including any specific attributes of the item such as color or size.

2.3 Catalog Reviews

Tables

TableRelated EntityDescriptionBLC_REVIEW_DETAILReviewDetailRepresents a review.BLC_REVIEW_FEEDBACKReviewFeedbackRepresents a the feedback for a review.BLC_RATING_DETAILRatingDetailRepresents the detail of a rating.BLC_RATING_SUMMARYRatingSummaryRepresents the summary of a rating.

Related Tables

TableRelated EntityDescriptionBLC_CUSTOMERCustomerRepresents a customer in Broadleaf Commerce.

2.4 Catalog Search

Tables

TableRelated EntityDescriptionBLC_SEARCH_FACETSearchFacetRepresents a search facet.BLC_FIELDFieldRepresents a field of a search facet.BLC_FIELD_SEARCH_TYPES-Designates if the field will be searchable.BLC_SEARCH_FACET_RANGESearchFacetRangeDesignates a range for a search facet.BLC_SEARCH_FACET_XREFRequiredFacetImplCross references required search facets.BLC_CAT_SEARCH_FACET_XREFCategorySearchFacetCross references the search facet with categories.BLC_CAT_SEARCH_FACET_EXCL_XREFCategoryExcludedSearchFacetCross references the search facet with categories to be excluded.BLC_SEARCH_INTERCEPTSearchInterceptRepresents the search redirect.BLC_URL_HANDLERURLHandlerRepresents the URL handler.BLC_SEARCH_SYNONYMSearchSynonymRepresents search synonym.BLC_SHIPPING_RATEShippingRateRepresents a shipping rate.

Related Tables

TableRelated EntityDescriptionBLC_CATEGORYCategoryRepresents a category.

2.5 Catalog Sku

Tables

TableRelated EntityDescriptionBLC_SKUSkuA SKU is a specific item that can be sold including any specific attributes of the item such as color or size.BLC_SKU_ATTRIBUTESkuAttributeA SKU Attribute is a designator on a SKU that differentiates it from other similar SKUs (for example: Blue attribute for hat).BLC_SKU_BUNDLE_ITEMSkuBundleItemRepresents the sku being sold in a bundle.BLC_PRODUCT_BUNDLEProductBundleRepresents the product being sold in a bundle.BLC_SKU_FULFILLMENT_FLAT_RATES-Represents the sku fulfillment flat rates.BLC_SKU_AVAILABILITYSkuAvailabilityRepresents the availability of the sku.BLC_SKU_FULFILLMENT_EXCLUDED-Represents if a sku fulfillment is to be excluded.BLC_SKU_OPTION_VALUE_XREF-Represents the cross reference between sku and a product option value.BLC_PRODUCT_OPTION_VALUEProductOptionValueDefines the value of a Product Option.BLC_PRODUCT_OPTIONProductOptionDesignates a Product Option.BLC_SKU_MEDIA_MAP-Maps the sku to a media object.BLC_MEDIAMediaRepresents a media object.BLC_SKU_FEE_XREF-Represents the cross reference between sku and a sku fee.BLC_SKU_FEESkuFeeRepresents a sku fee.

Related Tables

TableRelated EntityDescriptionBLC_PRODUCTProductA product is a general description of an item that can be sold (for example: a hat). Products are not sold or added to a cart.BLC_FULFILLMENT_OPTIONFulfillmentOptionRepresents a fulfillment option.BLC_CURRENCYBroadleafCurrencyContains currency information, such as code and if it's default

三、CMS Model

3.1 概要图

3.2 CMS Field

Tables

TableRelated EntityDescriptionBLC_FLD_DEFFieldDefinitionDefines a Broadleaf Field.BLC_FLD_GROUPFieldGroupRepresents a Field Group.BLC_FLD_ENUMFieldEnumerationRepresents a Field Enumeration.BLC_FLD_ENUM_ITEMFieldEnumerationItemDefines a Field Enumeration Item.

3.3 CMS Page

Tables

TableJava DocsDescriptionBLC_PAGEPageRepresents a static html Page in Broadleaf.BLC_PAGE_TEMPLATEPageTemplateRepresents a Page template.BLC_PAGE_FLDPageFieldRepresents a Page Field.BLC_PAGE_FLD_MAP-Maps a Page to a Field.BLC_PAGE_RULEPageRuleRepresents a rule to be applied to a Page.BLC_PAGE_RULE_MAP-Maps a Page to a Rule.BLC_PAGE_ITEM_CRITERIAPageItemCriteriaRepresents a Page item criteria.BLC_QUAL_CRIT_PAGE_XREF-Cross reference table that points to a Page item criteria.

Related Tables

TableJava DocsDescriptionBLC_ADMIN_USERAdminUserRepresents an admin user.BLC_SANDBOXSandBoxRepresents a sandbox.BLC_LOCALELocaleContains locale information, such as code and if it's default

3.4 CMS Static Asset

Tables

TableJava DocsDescriptionBLC_STATIC_ASSETStaticAssetRepresents a Static Asset in Broadleaf.BLC_IMG_STATIC_ASSETImageStaticAssetRepresents a Image Static Asset in Broadleaf.BLC_STATIC_ASSET_DESCStaticAssetDescriptionDefines a Description for a Static Asset.BLC_ASSET_DESC_MAP-Maps a Static Asset to a Description.BLC_STATIC_ASSET_STRGStaticAssetStorageRepresents a Static Asset Storage Object in Broadleaf.

Related Tables

TableJava DocsDescriptionBLC_ADMIN_USERAdminUserRepresents an admin user.BLC_SANDBOXSandBoxRepresents a sandbox.

3.5 CMS Structured Content

Tables

TableJava DocsDescriptionBLC_SCStructuredContentRepresents a Broadleaf Structured Content object.BLC_SC_TYPEStructuredContentTypeDesignates a Structured Content type.BLC_SC_FLD_TMPLTStructuredContentFieldTemplateRepresents a Structured Content Field template.BLC_SC_FLDStructuredContentFieldRepresents a Structured Content Field.BLC_SC_FLD_MAP-Maps a Structured Content Object to a Field.BLC_SC_RULEStructuredContentRuleRepresents a rule to be applied to a Structured Content object.BLC_SC_RULE_MAP-Maps a Structured Content Object to a Rule.BLC_SC_ITEM_CRITERIAStructuredContentItemCriteriaRepresents a Structured Content item criteria.BLC_QUAL_CRIT_SC_XREF-Cross reference table that points to an item criteria.

Related Tables

TableJava DocsDescriptionBLC_ADMIN_USERAdminUserRepresents an admin user.BLC_SANDBOXSandBoxRepresents a sandbox.BLC_LOCALELocaleContains locale information, such as code and if it's default

四、Customer Model

4.1 概要图

4.2 Customer Detail

Tables

TableRelated EntityDescriptionBLC_ADDRESSAddressContains address information, e.g. city, state, and postal codeBLC_CHALLENGE_QUESTIONChallengeQuestionQuestion to present the user for password recovery purposesBLC_COUNTRYCountryContains country information, e.g. abbreviation and nameBLC_CUSTOMERCustomerRepresents a customer in BroadleafBLC_CUSTOMER_ADDRESSCustomerAddressAssociates a customer to an addressBLC_CUSTOMER_ATTRIBUTECustomerAttributeHolds name-value pairs of attributes for a customerBLC_CUSTOMER_PASSWORD_TOKENCustomerForgotPasswordSecurityTokenHolds token information for password recovery purposesBLC_CUSTOMER_PHONECustomerPhoneAssociates a customer to a phone numberBLC_CUSTOMER_ROLECustomerRoleAssociates a customer to a roleBLC_PHONEPhoneContains phone information, e.g. number and if it's activeBLC_CUSTOMER_PAYMENTCustomerPaymentContains customer payment information.BLC_ROLERoleContains role information, e.g. role nameBLC_STATEStateContains state information, e.g. abbreviation, name, and country

Related Tables

TableRelated EntityDescriptionBLC_LOCALELocaleContains locale information, such as code and if it's default

五、Offer Model

5.1 概要图

5.2 Offer Detail

Tables

TableRelated EntityDescriptionBLC_OFFEROfferRepresents an Offer in Broadleaf.BLC_OFFER_CODEOfferCodeRepresents an Offer Code.BLC_OFFER_AUDITOfferAuditRepresents an Offer Audit.BLC_OFFER_CANDIDATE_FG_OFFERCandidateFulfillmentGroupOfferRepresents an Offer candidate.BLC_CANDIDATE_ITEM_OFFERCandidateItemOfferRepresents an Offer Item candidate.BLC_CANDIDATE_ORDER_OFFERCandidateOrderOfferRepresents an Offer Order candidate.BLC_ADDITIONAL_OFFER_INFO-Represents additional information for an Offer.BLC_OFFER_INFOOfferInfoLinks to the Offer Info fields.BLC_OFFER_INFO_FIELDS-Represents an Offer Info fields.BLC_OFFER_RULEOfferRuleRepresents a rule to be applied to an Offer.BLC_OFFER_RULE_MAP-Maps an Offer to a Rule.BLC_OFFER_ITEM_CRITERIAOfferItemCriteriaRepresents an Offer item criteria.BLC_QUAL_CRIT_OFFER_XREFCriteriaOfferXrefCross reference table that points to an Offer item criteria.BLC_TAR_CRIT_OFFER_XREF-Cross reference table that points to an Offer target item criteria.

Related Tables

TableRelated EntityDescriptionBLC_FULFILLMENT_GROUPFulfillmentGroupHolds fulfillment information about an order.BLC_ORDER_ITEMOrderItemAn abstract representation of an item on an order.BLC_ORDEROrderRepresents an order in Broadleaf

六、Order Model

6.1 概要图

6.2 Order Detail

Tables

TableRelated EntityDescriptionBLC_BUNDLE_ORDER_ITEMBundleOrderItemContains a group of discrete order itemsBLC_BUND_ITEM_FEE_PRICEBundleOrderItemFeePriceContains fee information for a bundle order itemBLC_DISCRETE_ORDER_ITEMDiscreteOrderItemContains product, sku, and pricing information for an item on an orderBLC_DISC_ITEM_FEE_PRICEDiscreteOrderItemFeePriceContains fee information for a discrete order itemBLC_DYN_DISCRETE_ORDER_ITEMDynamicPriceDiscreteOrderItemContains discrete order item information that is dynamically pricedBLC_FG_ADJUSTMENTFulfillmentGroupAdjustmentContains offer information and amount applied to a fulfillment groupBLC_GIFTWRAP_ORDER_ITEMGiftWrapOrderItemDeclares which discrete order items are gift-wrappedBLC_ORDEROrderRepresents an order in BroadleafBLC_ORDER_ADJUSTMENTOrderAdjustment.javaContains offer information and amount applied to an orderBLC_ORDER_ATTRIBUTEOrderAttributeContains arbitrary data about an orderBLC_ORDER_ITEMOrderItemAn abstract representation of an item on an orderBLC_ORDER_ITEM_ADD_ATTRn/aContains arbitrary data about a discrete order itemBLC_ORDER_ITEM_ADJUSTMENTOrderItemAdjustmentContains offer information and amount applied to an order itemBLC_ORDER_ITEM_ATTRIBUTEOrderItemAttributeContains arbitrary data about an order itemBLC_ITEM_OFFER_QUALIFIEROrderItemQualifierContains data about order item qualifiesBLC_ORDER_ITEM_PRICE_DTLOrderItemPriceDetailImplContains order item price detail informationBLC_ORDER_ITEM_DTL_ADJOrderItemPriceDetailAdjustmentImplContains order item price detail adjustment informationBLC_PERSONAL_MESSAGEPersonalMessageContains personal message information (e.g. from, to, message body)BLC_ORDER_MULTISHIP_OPTIONOrderMultishipOptionRepresents a given set of options for an OrderItem in an Order in the multiship contextBLC_ORDER_OFFER_CODE_XREFn/aCross-reference from orders to offers

Related Tables

TableRelated EntityDescriptionBLC_ADDRESSAddressContains address information, e.g. city, state, and postal codeBLC_CATEGORYCategoryRepresents a categoryBLC_CUSTOMERCustomerRepresents a customer in BroadleafBLC_FULFILLMENT_OPTIONFulfillmentOptionHolds information about a particular fulfillment implementationBLC_FULFILLMENT_GROUPFulfillmentGroupHolds fulfillment information about an orderBLC_OFFEROfferContains adjustment information and rulesBLC_PRODUCTProductContains product informationBLC_PRODUCT_BUNDLEProductBundleContains data about a product bundle, e.g. bundle pricingBLC_SKUSkuContains information about an item that can be soldBLC_SKU_BUNDLE_ITEMSkuBundleItemContains bundle item metadataBLC_CURRENCYBroadleafCurrencyContains currency information, such as code and if it's defaultBLC_LOCALELocaleContains locale information, such as code and if it's default

6.3 Order Fulfillment

Tables

TableRelated EntityDescriptionBLC_DYN_DISCRETE_ORDER_ITEMDynamicPriceDiscreteOrderItemContains discrete order item information that is dynamically pricedBLC_FULFILLMENT_GROUPFulfillmentGroupHolds fulfillment information about an orderBLC_FULFILLMENT_GROUP_FEEFulfillmentGroupFeeContains fee information for a fulfillment groupBLC_FULFILLMENT_GROUP_ITEMFulfillmentGroupItemContains information for items in a fulfillment groupBLC_FULFILLMENT_OPTIONFulfillmentOptionHolds information about a particular fulfillment implementationBLC_FULFILLMENT_OPTION_FIXEDFixedPriceFulfillmentOptionContains single-price data for order fulfillmentBLC_FULFILLMENT_OPT_BANDED_PRCBandedPriceFulfillmentOptionContains fulfillment option data by price bandBLC_FULFILLMENT_OPT_BANDED_WGTBandedWeightFulfillmentOptionContains fulfillment option data by weight bandBLC_FULFILLMENT_PRICE_BANDFulfillmentPriceBandContains pricing bands based on retail price of a fulfillment groupBLC_FULFILLMENT_WEIGHT_BANDFulfillmentWeightBandContains pricing bands based on weight of a fulfillment group

Related Tables

TableRelated EntityDescriptionBLC_ADDRESSAddressContains address information, e.g. city, state, and postal codeBLC_ORDEROrderRepresents an order in BroadleafBLC_PERSONAL_MESSAGEPersonalMessageContains personal message information (e.g. from, to, message body)BLC_PHONEPhoneRepresents a phone number in broadleafBLC_ORDER_ITEMOrderItemAn abstract representation of an item on an orderBLC_CURRENCYBroadleafCurrencyContains currency information, such as code and if it's default

6.4 Order Payment

Tables

TableRelated EntityDescriptionBLC_BANK_ACCOUNT_PAYMENTBankAccountPaymentContains data about a bank account used for paymentBLC_GIFT_CARD_PAYMENTGiftCardPaymentContains data about a gift card used for paymentBLC_CREDIT_CARD_PAYMENTCreditCardPaymentContains information about a credit card used for paymentBLC_ORDER_PAYMENTOrderPaymentContains payment information for an orderBLC_ORDER_PAYMENT_TRANSACTIONPaymentTransactionContains transaction information related to an Order PaymentBLC_TRANS_ADDITNL_FIELDSn/aContains important Gateway Specific Payment Data for a particular Payment TransactionBLC_PAYMENT_LOGPaymentLogContains summary information for a payment instance

Related Tables

TableRelated EntityDescriptionBLC_ADDRESSAddressContains address information, e.g. city, state, and postal codeBLC_CUSTOMERCustomerRepresents a customer in BroadleafBLC_ORDEROrderRepresents an order in BroadleafBLC_PHONEPhoneRepresents a phone in BroadleafBLC_CURRENCYBroadleafCurrencyContains currency information, such as code and if it's default

6.5 Order Tax

Tables

TableRelated EntityDescriptionBLC_FG_FEE_TAX_XREFn/aCross-reference from fulfillment group fees to tax detailsBLC_FG_FG_TAX_XREFn/aCross-reference from fulfillment group to tax detailsBLC_FG_ITEM_TAX_XREFn/aCross-reference from fulfillment group item to tax detailsBLC_TAX_DETAILTaxDetailContains tax information

Related Tables

TableRelated EntityDescriptionBLC_FULFILLMENT_GROUP_FEEFulfillmentGroupFeeContains fee information for a fulfillment groupBLC_FULFILLMENT_GROUP_ITEMFulfillmentGroupItemContains information for items in a fulfillment groupBLC_FULFILLMENT_GROUPFulfillmentGroupHolds fulfillment information about an orderBLC_CURRENCYBroadleafCurrencyContains currency information, such as code and if it's default

七、Other

7.1 Common

Tables

TableRelated EntityDescriptionBLC_STATEStateContains state information, e.g. abbreviation, name, and countryBLC_COUNTRYCountryContains country information, e.g. abbreviation and nameBLC_SITESiteRepresents a siteBLC_ID_GENERATIONIdGenerationHolds unique identifier data for various typesBLC_DATA_DRVN_ENUMDataDrivenEnumerationHolds the name for data-driven enumeration purposesBLC_DATA_DRVN_ENUM_VALDataDrivenEnumerationValueHolds value items for data-driven enumeration purposeSEQUENCE_GENERATORn/aHolds information for sequence generationBLC_LOCALELocaleContains locale information, such as code and if it's defaultBLC_CURRENCYBroadleafCurrencyContains currency information, such as code and if it's defaultBLC_TRANSLATIONTranslationContains currency information, such as code and if it's defaultBLC_MODULE_CONFIGURATIONModuleConfigurationContains currency information, such as code and if it's defaultBLC_SANDBOXSandBoxRepresents a SandboxBLC_SYSTEM_PROPERTYSystemPropertyRepresents a System Property (name/value pair) stored in the databaseBLC_SANDBOX_MGMTSandBoxManagementrequired mostly as a workaround for an issue in Hibernate, see javadocs for more detailsBLC_SITE_MAP_CFGSiteMapConfigurationdrives the building of the SiteMap. It contains general properties that drive the creation of the SiteMap such as directory paths, etc.BLC_CUST_SITE_MAP_GEN_CFGCustomUrlSiteMapGeneratorConfigurationCustomSiteMapGenerator is controlled by this configurationBLC_SITE_MAP_GEN_CFGSiteMapGeneratorConfigurationURL tag generation controlled by this configuration. See javadocs for more details.BLC_SITE_MAP_URL_ENTRYSiteMapUrlEntryRepresents a SiteMap URL Entry.

Related Tables

TableRelated EntityDescriptionBLC_SANDBOXSandBoxContains sandbox instance data

7.2 Email Tracking

Tables

TableRelated EntityDescriptionBLC_EMAIL_TRACKINGEmailTrackingRepresents an Email Tracking object Broadleaf.BLC_EMAIL_TRACKING_CLICKSEmailTrackingClicksRepresents an Email Tracking object for clicks.BLC_EMAIL_TRACKING_OPENSEmailTrackingOpensRepresents an Email Tracking object for opens.

7.3 Fulfillment

Tables

TableRelated EntityDescriptionBLC_FULFILLMENT_OPTIONFulfillmentOptionHolds information about a particular fulfillment implementation.BLC_FULFILLMENT_OPT_BANDED_PRCBandedPriceFulfillmentOptionLinks to a list of Fulfillment Price Bands.BLC_FULFILLMENT_OPT_BANDED_WGTBandedWeightFulfillmentOptionLinks to a list of Fulfillment Weight Bands.BLC_FULFILLMENT_OPTION_FIXEDFixedPriceFulfillmentOptionRepresents a Fixed Fulfillment Option.BLC_FULFILLMENT_PRICE_BANDFulfillmentPriceBandRepresents a Fulfillment Price Band.BLC_FULFILLMENT_WEIGHT_BANDFulfillmentWeightBandRepresents a Fulfillment Weight Band.

7.4 Social

Tables

TableRelated EntityDescriptionBLC_UserConnectionUserConnectionRepresents a Spring Social User Connection.