Rule-based sales category and rule data model

This data model shows the relationship between database tables that contain information about rule-based sales categories and the rules for those categories. Rule-based sales categories are a type of sales category that uses a search-based, user-defined rule with HCL Commerce search to find and automatically assign catalog entries to the category.

Click any of the database table boxes to see more information about that table.

The data for rule-based sales categories and for the rules that belong to the categories are included in catalog and marketing tables. The catalog tables include the data for the category and the marketing tables include the data for the rule.

Image mapCATENTRYCATGPENRELMBRGRPMEMBERSTOREENTDISPCGPRELCATALOGCATGRPPSCATGRPRULECATGROUPCATGRPDESCLANGUAGECATGRPATTRCATGRPRELSTORECGRPDEVICEFMTDMACTIVITYDMTRIGLSTNDMELEMENTDMELEMENTNVPEMSPOT