WebSphere Commerce database table: TCPITMAP

WebSphere Commerce database table: TCPITMAP

This table stores all of the items from the shopping cart that are applicable to the current coupon for the Coupon Decision Support system.
Column Descriptions
Column Name Column Type Description
CPWALLET_ID BIGINT NOT NULL Foreign key to CPWALLET table. This is a primary key.
ORDERITEMS_ID BIGINT NOT NULL Foreign key to ORDERITEMS table. This is a primary key.
DISCAMT DECIMAL (20,5) NOT NULL The discount amount for this item when this coupon is used.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235258950 CPWALLET_ID+ORDERITEMS_ID Primary Key
I0000281 ORDERITEMS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_828 CPWALLET_ID CPWALLET CPWALLET_ID Cascade
F_827 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Related reference

E-coupon data model

Column Name	Column Type	Description
CPWALLET_ID	BIGINT NOT NULL	Foreign key to CPWALLET table. This is a primary key.
ORDERITEMS_ID	BIGINT NOT NULL	Foreign key to ORDERITEMS table. This is a primary key.
DISCAMT	DECIMAL (20,5) NOT NULL	The discount amount for this item when this coupon is used.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL060903235258950	CPWALLET_ID+ORDERITEMS_ID	Primary Key
I0000281	ORDERITEMS_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_828	CPWALLET_ID	CPWALLET	CPWALLET_ID	Cascade
F_827	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade