Detailed ERD
Tables
| Table | Related Entity | Description |
|---|---|---|
| BLC_CATEGORY_TRXREF | n/a | Cross references category to translation |
| BLC_CATEGORY_TR | CategoryTranslation.java | Holds the translation |
| BLC_PRODUCT_OPTION_VAL_TRXREF | n/a | Cross references product option value to translation |
| BLC_PROUCT_OPTION_VAL_TR | ProductOptionValueTranslation.java | Holds the translation |
| BLC_FULFILLMENT_OPTION_TRXREF | n/a | Cross references fulfillment to translation |
| BLC_FULFILLMENT_OPTION_TR | FulfillmentOptionTranslation.java | Holds the translation |
| BLC_PRODUCT_OPTION_TRXREF | n/a | Cross references product option to translation |
| BLC_PRODUCT_OPTION_TR | ProductOptionTranslation.java | Holds the translation |
| BLC_SKU_TRANSLATION_XREF | n/a | Cross references sku to translation |
| BLC_SKU_TRANSLATION | SkuTranslation.java | Holds the translation |
| BLC_SEARCH_FACET | n/a | Cross references search facet to translation |
| BLC_SEARCH_FACET_TRXREF | SearchFacetTranslation.java | Holds the translation |
Related Tables
| Table | Related Entity | Description |
|---|---|---|
| BLC_CATEGORY | Category | Contains 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. |
| BLC_PRODUCT_OPTION_VALUE | ProductOptionValue | Represents a product option value |
| BLC_PRODUCT_OPTION | ProductOption | Represents a product option |
| SEARCH_FACET | SearchFacet | Holds search facet information |
| BLC_FULFILLMENT_OPTION | FulfillmentOption | Represents an order Fullfillment option |