群号：185686402，欢迎访问blog.ebuzz.cn
这篇文章主要介绍了BroadleafCommerce（以下简称BLC）的数据模型，因为官网曾一度无法访问，另外也是访问速度不是特别爽，于是做了制作了一个数据模型的文章。
一、ADMIN
1. 概要图
1.2 Change Sets
Tables
| Table | Related Entity | Description |
|---|
| BLC_SANDBOX | SandBox | Represents 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_ITEM | SandBoxItem | Represents a sandbox item. |
| SANDBOX_ITEM_ACTION | - | Cross reference table that points to an action. |
| BLC_SANDBOX_ACTION | SandBoxAction | Represents a sandbox action. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_ADMIN_USER | AdminUser | Represents an admin user. |
| BLC_SITE | Site | Represents a site. |
1.3 Modules
Tables
| Table | Related Entity | Description |
|---|
| BLC_ADMIN_MODULE | AdminModule | Represents an admin user. |
| BLC_ADMIN_SECTION_PERMISSION_XREF | - | Cross reference table that points to an admin permission. |
| BLC_ADMIN_SECTION | AdminSection | Represents an admin section. |
| BLC_ADMIN_PERMISSION | AdminPermission | Represents an admin user permission. |
1.4 Security
Tables
| Table | Related Entity | Description |
|---|
| BLC_ADMIN_USER | AdminUser | Represents an admin user. |
| BLC_ADMIN_USER_ROLE_XREF | - | Cross reference table that points to an admin user role. |
| BLC_ADMIN_ROLE | AdminRole | Represents an admin user role. |
| BLC_ADMIN_USER_PERMISSION_XREF | - | Cross reference table that points to an admin user permission. |
| BLC_ADMIN_PERMISSION | AdminPermission | Represents an admin user permission. |
| BLC_ADMIN_ROLE_PERMISSION_XREF | - | Cross reference table that points to an admin role permission. |
| BLC_ADMIN_PERMISSION_ENTITY | AdminPermissionQualifiedEntity | Represents an admin user permission entity. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_SANDBOX | SandBox | Represents a sandbox. |
二、Catalog
2.1 概要图
2.2 Catalog Category
Tables
| Table | Related Entity | Description |
|---|
| BLC_CATEGORY | Category | Represents a category. |
| BLC_CATEGORY_ATTRIBUTE | CategoryAttribute | Defines 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_SALE | RelatedProduct | Represents the products in the category. |
| BLC_PRODUCT_UP_SALE | RelatedProduct | Represents the products in the category. |
| BLC_PRODUCT_FEATURED | PromotableProduct | Represents the products in the category. |
| BLC_CAT_SITE_MAP_GEN_CFG | CategorySiteMapGeneratorConfiguration | CategorySiteMapGenerator is controlled by this configuration. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_PRODUCT | Product | A 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_MEDIA | Media | Represents a media object. |
2.2 Catalog Product
Tables
| Table | Related Entity | Description |
|---|
| BLC_PRODUCT | Product | A 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_ATTRIBUTE | ProductAttribute | Defines attributes for a product. |
| BLC_SKU_XREF | - | Cross reference table that points to the skus for the product. |
| BLC_PRODUCT_BUNDLE | ProductBundle | Represents 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_VALUE | ProductOptionValue | Defines the value of a Product Option. |
| BLC_PRODUCT_OPTION | ProductOption | Designates a Product Option. |
| BLC_PRODUCT_CROSS_SALE | RelatedProduct | Represents the products in the category. |
| BLC_PRODUCT_UP_SALE | RelatedProduct | Represents the products in the category. |
| BLC_PRODUCT_FEATURED | PromotableProduct | Represents the products in the category. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_CATEGORY | Category | Represents a category. |
| BLC_SKU | Sku | A 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
| Table | Related Entity | Description |
|---|
| BLC_REVIEW_DETAIL | ReviewDetail | Represents a review. |
| BLC_REVIEW_FEEDBACK | ReviewFeedback | Represents a the feedback for a review. |
| BLC_RATING_DETAIL | RatingDetail | Represents the detail of a rating. |
| BLC_RATING_SUMMARY | RatingSummary | Represents the summary of a rating. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_CUSTOMER | Customer | Represents a customer in Broadleaf Commerce. |
2.4 Catalog Search
Tables
| Table | Related Entity | Description |
|---|
| BLC_SEARCH_FACET | SearchFacet | Represents a search facet. |
| BLC_FIELD | Field | Represents a field of a search facet. |
| BLC_FIELD_SEARCH_TYPES | - | Designates if the field will be searchable. |
| BLC_SEARCH_FACET_RANGE | SearchFacetRange | Designates a range for a search facet. |
| BLC_SEARCH_FACET_XREF | RequiredFacetImpl | Cross references required search facets. |
| BLC_CAT_SEARCH_FACET_XREF | CategorySearchFacet | Cross references the search facet with categories. |
| BLC_CAT_SEARCH_FACET_EXCL_XREF | CategoryExcludedSearchFacet | Cross references the search facet with categories to be excluded. |
| BLC_SEARCH_INTERCEPT | SearchIntercept | Represents the search redirect. |
| BLC_URL_HANDLER | URLHandler | Represents the URL handler. |
| BLC_SEARCH_SYNONYM | SearchSynonym | Represents search synonym. |
| BLC_SHIPPING_RATE | ShippingRate | Represents a shipping rate. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_CATEGORY | Category | Represents a category. |
2.5 Catalog Sku
Tables
| Table | Related Entity | Description |
|---|
| BLC_SKU | Sku | A SKU is a specific item that can be sold including any specific attributes of the item such as color or size. |
| BLC_SKU_ATTRIBUTE | SkuAttribute | A SKU Attribute is a designator on a SKU that differentiates it from other similar SKUs (for example: Blue attribute for hat). |
| BLC_SKU_BUNDLE_ITEM | SkuBundleItem | Represents the sku being sold in a bundle. |
| BLC_PRODUCT_BUNDLE | ProductBundle | Represents the product being sold in a bundle. |
| BLC_SKU_FULFILLMENT_FLAT_RATES | - | Represents the sku fulfillment flat rates. |
| BLC_SKU_AVAILABILITY | SkuAvailability | Represents 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_VALUE | ProductOptionValue | Defines the value of a Product Option. |
| BLC_PRODUCT_OPTION | ProductOption | Designates a Product Option. |
| BLC_SKU_MEDIA_MAP | - | Maps the sku to a media object. |
| BLC_MEDIA | Media | Represents a media object. |
| BLC_SKU_FEE_XREF | - | Represents the cross reference between sku and a sku fee. |
| BLC_SKU_FEE | SkuFee | Represents a sku fee. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_PRODUCT | Product | A 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_OPTION | FulfillmentOption | Represents a fulfillment option. |
| BLC_CURRENCY | BroadleafCurrency | Contains currency information, such as code and if it's default |
三、CMS Model
3.1 概要图
3.2 CMS Field
3.3 CMS Page
Tables
| Table | Java Docs | Description |
|---|
| BLC_PAGE | Page | Represents a static html Page in Broadleaf. |
| BLC_PAGE_TEMPLATE | PageTemplate | Represents a Page template. |
| BLC_PAGE_FLD | PageField | Represents a Page Field. |
| BLC_PAGE_FLD_MAP | - | Maps a Page to a Field. |
| BLC_PAGE_RULE | PageRule | Represents a rule to be applied to a Page. |
| BLC_PAGE_RULE_MAP | - | Maps a Page to a Rule. |
| BLC_PAGE_ITEM_CRITERIA | PageItemCriteria | Represents a Page item criteria. |
| BLC_QUAL_CRIT_PAGE_XREF | - | Cross reference table that points to a Page item criteria. |
Related Tables
| Table | Java Docs | Description |
|---|
| BLC_ADMIN_USER | AdminUser | Represents an admin user. |
| BLC_SANDBOX | SandBox | Represents a sandbox. |
| BLC_LOCALE | Locale | Contains locale information, such as code and if it's default |
3.4 CMS Static Asset
Tables
| Table | Java Docs | Description |
|---|
| BLC_STATIC_ASSET | StaticAsset | Represents a Static Asset in Broadleaf. |
| BLC_IMG_STATIC_ASSET | ImageStaticAsset | Represents a Image Static Asset in Broadleaf. |
| BLC_STATIC_ASSET_DESC | StaticAssetDescription | Defines a Description for a Static Asset. |
| BLC_ASSET_DESC_MAP | - | Maps a Static Asset to a Description. |
| BLC_STATIC_ASSET_STRG | StaticAssetStorage | Represents a Static Asset Storage Object in Broadleaf. |
Related Tables
| Table | Java Docs | Description |
|---|
| BLC_ADMIN_USER | AdminUser | Represents an admin user. |
| BLC_SANDBOX | SandBox | Represents a sandbox. |
3.5 CMS Structured Content
Tables
| Table | Java Docs | Description |
|---|
| BLC_SC | StructuredContent | Represents a Broadleaf Structured Content object. |
| BLC_SC_TYPE | StructuredContentType | Designates a Structured Content type. |
| BLC_SC_FLD_TMPLT | StructuredContentFieldTemplate | Represents a Structured Content Field template. |
| BLC_SC_FLD | StructuredContentField | Represents a Structured Content Field. |
| BLC_SC_FLD_MAP | - | Maps a Structured Content Object to a Field. |
| BLC_SC_RULE | StructuredContentRule | Represents 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_CRITERIA | StructuredContentItemCriteria | Represents a Structured Content item criteria. |
| BLC_QUAL_CRIT_SC_XREF | - | Cross reference table that points to an item criteria. |
Related Tables
| Table | Java Docs | Description |
|---|
| BLC_ADMIN_USER | AdminUser | Represents an admin user. |
| BLC_SANDBOX | SandBox | Represents a sandbox. |
| BLC_LOCALE | Locale | Contains locale information, such as code and if it's default |
四、Customer Model
4.1 概要图
4.2 Customer Detail
Tables
| Table | Related Entity | Description |
|---|
| BLC_ADDRESS | Address | Contains address information, e.g. city, state, and postal code |
| BLC_CHALLENGE_QUESTION | ChallengeQuestion | Question to present the user for password recovery purposes |
| BLC_COUNTRY | Country | Contains country information, e.g. abbreviation and name |
| BLC_CUSTOMER | Customer | Represents a customer in Broadleaf |
| BLC_CUSTOMER_ADDRESS | CustomerAddress | Associates a customer to an address |
| BLC_CUSTOMER_ATTRIBUTE | CustomerAttribute | Holds name-value pairs of attributes for a customer |
| BLC_CUSTOMER_PASSWORD_TOKEN | CustomerForgotPasswordSecurityToken | Holds token information for password recovery purposes |
| BLC_CUSTOMER_PHONE | CustomerPhone | Associates a customer to a phone number |
| BLC_CUSTOMER_ROLE | CustomerRole | Associates a customer to a role |
| BLC_PHONE | Phone | Contains phone information, e.g. number and if it's active |
| BLC_CUSTOMER_PAYMENT | CustomerPayment | Contains customer payment information. |
| BLC_ROLE | Role | Contains role information, e.g. role name |
| BLC_STATE | State | Contains state information, e.g. abbreviation, name, and country |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_LOCALE | Locale | Contains locale information, such as code and if it's default |
五、Offer Model
5.1 概要图
5.2 Offer Detail
Tables
| Table | Related Entity | Description |
|---|
| BLC_OFFER | Offer | Represents an Offer in Broadleaf. |
| BLC_OFFER_CODE | OfferCode | Represents an Offer Code. |
| BLC_OFFER_AUDIT | OfferAudit | Represents an Offer Audit. |
| BLC_OFFER_CANDIDATE_FG_OFFER | CandidateFulfillmentGroupOffer | Represents an Offer candidate. |
| BLC_CANDIDATE_ITEM_OFFER | CandidateItemOffer | Represents an Offer Item candidate. |
| BLC_CANDIDATE_ORDER_OFFER | CandidateOrderOffer | Represents an Offer Order candidate. |
| BLC_ADDITIONAL_OFFER_INFO | - | Represents additional information for an Offer. |
| BLC_OFFER_INFO | OfferInfo | Links to the Offer Info fields. |
| BLC_OFFER_INFO_FIELDS | - | Represents an Offer Info fields. |
| BLC_OFFER_RULE | OfferRule | Represents a rule to be applied to an Offer. |
| BLC_OFFER_RULE_MAP | - | Maps an Offer to a Rule. |
| BLC_OFFER_ITEM_CRITERIA | OfferItemCriteria | Represents an Offer item criteria. |
| BLC_QUAL_CRIT_OFFER_XREF | CriteriaOfferXref | Cross 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. |
| Table | Related Entity | Description |
|---|
| BLC_FULFILLMENT_GROUP | FulfillmentGroup | Holds fulfillment information about an order. |
| BLC_ORDER_ITEM | OrderItem | An abstract representation of an item on an order. |
| BLC_ORDER | Order | Represents an order in Broadleaf |
六、Order Model
6.1 概要图
6.2 Order Detail
Tables
| Table | Related Entity | Description |
|---|
| BLC_BUNDLE_ORDER_ITEM | BundleOrderItem | Contains a group of discrete order items |
| BLC_BUND_ITEM_FEE_PRICE | BundleOrderItemFeePrice | Contains fee information for a bundle order item |
| BLC_DISCRETE_ORDER_ITEM | DiscreteOrderItem | Contains product, sku, and pricing information for an item on an order |
| BLC_DISC_ITEM_FEE_PRICE | DiscreteOrderItemFeePrice | Contains fee information for a discrete order item |
| BLC_DYN_DISCRETE_ORDER_ITEM | DynamicPriceDiscreteOrderItem | Contains discrete order item information that is dynamically priced |
| BLC_FG_ADJUSTMENT | FulfillmentGroupAdjustment | Contains offer information and amount applied to a fulfillment group |
| BLC_GIFTWRAP_ORDER_ITEM | GiftWrapOrderItem | Declares which discrete order items are gift-wrapped |
| BLC_ORDER | Order | Represents an order in Broadleaf |
| BLC_ORDER_ADJUSTMENT | OrderAdjustment.java | Contains offer information and amount applied to an order |
| BLC_ORDER_ATTRIBUTE | OrderAttribute | Contains arbitrary data about an order |
| BLC_ORDER_ITEM | OrderItem | An abstract representation of an item on an order |
| BLC_ORDER_ITEM_ADD_ATTR | n/a | Contains arbitrary data about a discrete order item |
| BLC_ORDER_ITEM_ADJUSTMENT | OrderItemAdjustment | Contains offer information and amount applied to an order item |
| BLC_ORDER_ITEM_ATTRIBUTE | OrderItemAttribute | Contains arbitrary data about an order item |
| BLC_ITEM_OFFER_QUALIFIER | OrderItemQualifier | Contains data about order item qualifies |
| BLC_ORDER_ITEM_PRICE_DTL | OrderItemPriceDetailImpl | Contains order item price detail information |
| BLC_ORDER_ITEM_DTL_ADJ | OrderItemPriceDetailAdjustmentImpl | Contains order item price detail adjustment information |
| BLC_PERSONAL_MESSAGE | PersonalMessage | Contains personal message information (e.g. from, to, message body) |
| BLC_ORDER_MULTISHIP_OPTION | OrderMultishipOption | Represents a given set of options for an OrderItem in an Order in the multiship context |
| BLC_ORDER_OFFER_CODE_XREF | n/a | Cross-reference from orders to offers |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_ADDRESS | Address | Contains address information, e.g. city, state, and postal code |
| BLC_CATEGORY | Category | Represents a category |
| BLC_CUSTOMER | Customer | Represents a customer in Broadleaf |
| BLC_FULFILLMENT_OPTION | FulfillmentOption | Holds information about a particular fulfillment implementation |
| BLC_FULFILLMENT_GROUP | FulfillmentGroup | Holds fulfillment information about an order |
| BLC_OFFER | Offer | Contains adjustment information and rules |
| BLC_PRODUCT | Product | Contains product information |
| BLC_PRODUCT_BUNDLE | ProductBundle | Contains data about a product bundle, e.g. bundle pricing |
| BLC_SKU | Sku | Contains information about an item that can be sold |
| BLC_SKU_BUNDLE_ITEM | SkuBundleItem | Contains bundle item metadata |
| BLC_CURRENCY | BroadleafCurrency | Contains currency information, such as code and if it's default |
| BLC_LOCALE | Locale | Contains locale information, such as code and if it's default |
6.3 Order Fulfillment
Tables
| Table | Related Entity | Description |
|---|
| BLC_ADDRESS | Address | Contains address information, e.g. city, state, and postal code |
| BLC_ORDER | Order | Represents an order in Broadleaf |
| BLC_PERSONAL_MESSAGE | PersonalMessage | Contains personal message information (e.g. from, to, message body) |
| BLC_PHONE | Phone | Represents a phone number in broadleaf |
| BLC_ORDER_ITEM | OrderItem | An abstract representation of an item on an order |
| BLC_CURRENCY | BroadleafCurrency | Contains currency information, such as code and if it's default |
6.4 Order Payment
Tables
| Table | Related Entity | Description |
|---|
| BLC_BANK_ACCOUNT_PAYMENT | BankAccountPayment | Contains data about a bank account used for payment |
| BLC_GIFT_CARD_PAYMENT | GiftCardPayment | Contains data about a gift card used for payment |
| BLC_CREDIT_CARD_PAYMENT | CreditCardPayment | Contains information about a credit card used for payment |
| BLC_ORDER_PAYMENT | OrderPayment | Contains payment information for an order |
| BLC_ORDER_PAYMENT_TRANSACTION | PaymentTransaction | Contains transaction information related to an Order Payment |
| BLC_TRANS_ADDITNL_FIELDS | n/a | Contains important Gateway Specific Payment Data for a particular Payment Transaction |
| BLC_PAYMENT_LOG | PaymentLog | Contains summary information for a payment instance |
| Table | Related Entity | Description |
|---|
| BLC_ADDRESS | Address | Contains address information, e.g. city, state, and postal code |
| BLC_CUSTOMER | Customer | Represents a customer in Broadleaf |
| BLC_ORDER | Order | Represents an order in Broadleaf |
| BLC_PHONE | Phone | Represents a phone in Broadleaf |
| BLC_CURRENCY | BroadleafCurrency | Contains currency information, such as code and if it's default |
6.5 Order Tax
Tables
| Table | Related Entity | Description |
|---|
| BLC_FG_FEE_TAX_XREF | n/a | Cross-reference from fulfillment group fees to tax details |
| BLC_FG_FG_TAX_XREF | n/a | Cross-reference from fulfillment group to tax details |
| BLC_FG_ITEM_TAX_XREF | n/a | Cross-reference from fulfillment group item to tax details |
| BLC_TAX_DETAIL | TaxDetail | Contains tax information |
| Table | Related Entity | Description |
|---|
| BLC_FULFILLMENT_GROUP_FEE | FulfillmentGroupFee | Contains fee information for a fulfillment group |
| BLC_FULFILLMENT_GROUP_ITEM | FulfillmentGroupItem | Contains information for items in a fulfillment group |
| BLC_FULFILLMENT_GROUP | FulfillmentGroup | Holds fulfillment information about an order |
| BLC_CURRENCY | BroadleafCurrency | Contains currency information, such as code and if it's default |
七、Other
7.1 Common
Tables
| Table | Related Entity | Description |
|---|
| BLC_STATE | State | Contains state information, e.g. abbreviation, name, and country |
| BLC_COUNTRY | Country | Contains country information, e.g. abbreviation and name |
| BLC_SITE | Site | Represents a site |
| BLC_ID_GENERATION | IdGeneration | Holds unique identifier data for various types |
| BLC_DATA_DRVN_ENUM | DataDrivenEnumeration | Holds the name for data-driven enumeration purposes |
| BLC_DATA_DRVN_ENUM_VAL | DataDrivenEnumerationValue | Holds value items for data-driven enumeration purpose |
| SEQUENCE_GENERATOR | n/a | Holds information for sequence generation |
| BLC_LOCALE | Locale | Contains locale information, such as code and if it's default |
| BLC_CURRENCY | BroadleafCurrency | Contains currency information, such as code and if it's default |
| BLC_TRANSLATION | Translation | Contains currency information, such as code and if it's default |
| BLC_MODULE_CONFIGURATION | ModuleConfiguration | Contains currency information, such as code and if it's default |
| BLC_SANDBOX | SandBox | Represents a Sandbox |
| BLC_SYSTEM_PROPERTY | SystemProperty | Represents a System Property (name/value pair) stored in the database |
| BLC_SANDBOX_MGMT | SandBoxManagement | required mostly as a workaround for an issue in Hibernate, see javadocs for more details |
| BLC_SITE_MAP_CFG | SiteMapConfiguration | drives 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_CFG | CustomUrlSiteMapGeneratorConfiguration | CustomSiteMapGenerator is controlled by this configuration |
| BLC_SITE_MAP_GEN_CFG | SiteMapGeneratorConfiguration | URL tag generation controlled by this configuration. See javadocs for more details. |
| BLC_SITE_MAP_URL_ENTRY | SiteMapUrlEntry | Represents a SiteMap URL Entry. |
Related Tables
| Table | Related Entity | Description |
|---|
| BLC_SANDBOX | SandBox | Contains sandbox instance data |
7.2 Email Tracking
Tables
| Table | Related Entity | Description |
|---|
| BLC_EMAIL_TRACKING | EmailTracking | Represents an Email Tracking object Broadleaf. |
| BLC_EMAIL_TRACKING_CLICKS | EmailTrackingClicks | Represents an Email Tracking object for clicks. |
| BLC_EMAIL_TRACKING_OPENS | EmailTrackingOpens | Represents an Email Tracking object for opens. |
7.3 Fulfillment
7.4 Social
Tables
| Table | Related Entity | Description |
|---|
| BLC_UserConnection | UserConnection | Represents a Spring Social User Connection. |
本文详细介绍了BroadleafCommerce的数据模型，涵盖ADMIN、Catalog、CMS Model、Customer Model、Offer Model、Order Model以及其他模块的表格和相关表格，为理解和使用BLC提供参考。
扫一扫
7206
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
