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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034917160 | CPPMN_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_273 | CPPMN_ID | CPPMN | CPPMN_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|