Database Table: CPPMNORD

This table contains the minimum purchase amount in the shopping cart for this coupon to be applicable to.

Column Name Column Type Column Description
CPPMN_ID INTEGER
NOT NULL
Foreign key to the CPPMN table.
ORDERMAX DECIMAL (20,5)
NULL
Maximum purchase amount in the shopping cart.
ORDERMIN DECIMAL (20,5)
NOT NULL
Minimum purchase amount in the shopping cart.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034917160 CPPMN_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_273 CPPMN_ID CPPMN CPPMN_ID Cascade

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