This table stores all the items from the shopping cart that are applicable to the current coupon for the Coupon Decision Support system.
Column Name | Column Type | Column Description |
---|---|---|
CPWALLET_ID | BIGINT NOT NULL |
Primary Key. Foreign key to CPWALLET table. |
DISCAMT | DECIMAL (20,5) NOT NULL |
The discount amount for this item when this coupon is used. |
ORDERITEMS_ID | BIGINT NOT NULL |
Primary Key. Foreign key to ORDERITEMS table. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000281 | ORDERITEMS_ID | Non-Unique Index |
SQL030416035127950 | CPWALLET_ID, ORDERITEMS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_827 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_828 | CPWALLET_ID | CPWALLET | CPWALLET_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|