Database Table: CPPMNCAT

This table contains the purchase conditions for a category-level promotion. If the purchase condition type in CPPMN table was C, then this table is used to find out all the items that are required for this coupon to be redeemed. There can be more than one category condition for a given promotion. All the purchase conditions for a coupon are combined using the AND operator.

Column Name Column Type Column Description
CATALOG_ID BIGINT
NOT NULL
This is the catalog ID. Foreign key to the CATALOG table.
CATGROUP_ID BIGINT
NOT NULL
Primary key. This is category ID. Foreign key to the CATGROUP table.
CPPMN_ID INTEGER
NOT NULL
Primary key. This is the promotion ID. Foreign key to the CPPMN table.
MAXQTY DOUBLE
NULL
This is the maximum quantity of items in the category to be bought to satisfy the condition.
MAXVALUE DECIMAL (20,5)
NULL
This is the maximum order value of items in the category to be bought to satisfy the condition.
MINQTY DOUBLE
NULL
This is the minimum quantity of items in the category to be bought to satisfy the condition.
MINVALUE DECIMAL (20,5)
NULL
This is the minimum order value of items in the category to be bought to satisfy the condition.
QTYMEASURE CHARACTER (16)
NOT NULL
Specifies the quantity measure for the item.
Indexes:
Index Name Indexed Column Names Index Type
I0000287 CATALOG_ID, CATGROUP_ID Non-Unique Index
SQL030416034916250 CPPMN_ID, CATALOG_ID, CATGROUP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_976 CPPMN_ID CPPMN CPPMN_ID Cascade
F_977 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_978 CATALOG_ID CATALOG CATALOG_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable