WebSphere Commerce database table: EMLRCPTS

This table records the recipients of an e-mail activity.

Column Descriptions

Column Name	Column Type	Description
EMLPROMO_ID	INTEGER NOT NULL	Foreign key to the EMLPROMO table.
COUNT	INTEGER NOT NULL	The total number of email addresses to which the e-mail activity was sent.
RECIPIENTS	CLOB	Contains the e-mail address and ID information of the users to which the e-mail activity was sent.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235155730	EMLPROMO_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_960	EMLPROMO_ID	EMLPROMO	EMLPROMO_ID	Cascade