BroadleafCommerce数据模型

群号：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