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