WebSphere Commerce database table: EMLBOUNCED

Reference > Database > WebSphere Commerce database tables > E

WebSphere Commerce database table: EMLBOUNCED

Records information about bounced messages for e-mail activities. Each row corresponds to a bounced message for a particular recipient of a particular e-mail activity.

Column Name Column Type Description
EMLPROMO_ID INTEGER NOT NULL The ID of the e-mail activity that was sent to the user, resulting in a bounced message.
USERS_ID BIGINT NOT NULL The ID of the target recipient.
STOREENT_ID INTEGER NOT NULL The ID of the store to which the e-mail activity belongs.
STATUSCODE VARCHAR(10) The status code returned in the DSN from the SMTP server.
LASTBOUNCE TIMESTAMP The time the last bounce for the user occurred from attempting to deliver the email activity.
LASTRETRY TIMESTAMP The timestamp of the latest attempt to deliver the e-mail activity.
RETRYCOUNT SMALLINT The number of times the activity delivery was attempted.
MAXRETRYHIT SMALLINT This column contains a flag that indicates whether the e-mail activity has reached the maximum re-try limit. Possible values include:
1 - This bounced message has reached its maximum number of retry attempts
0 - This bounced message has not reached its maximum number of retry attempts
EMLADDRINDEX SMALLINT NOT NULL This column indicates in which column the target e-mail address is found in the ADDRESS table. Possible values include:
1 - The e-mail address corresponds to the EMAIL1 column of the ADDRESS table
2 - The e-mail address corresponds to the EMAIL2 column of the ADDRESS table
EMAILADDRESS VARCHAR(256) This column contains the target e-mail address for which the delivery attempt resulted in a bounced message.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030331370 EMLPROMO_ID+USERS_ID Primary Key
I0000378 USERS_ID Non-Unique Index
I0000379 EMLPROMO_ID Non-Unique Index
I0000380 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1034 EMLPROMO_ID EMLPROMO EMLPROMO_ID Cascade
F_1036 STOREENT_ID STOREENT STOREENT_ID Cascade
F_1035 USERS_ID USERS USERS_ID Cascade
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
EMLPROMO_ID	INTEGER NOT NULL	The ID of the e-mail activity that was sent to the user, resulting in a bounced message.
USERS_ID	BIGINT NOT NULL	The ID of the target recipient.
STOREENT_ID	INTEGER NOT NULL	The ID of the store to which the e-mail activity belongs.
STATUSCODE	VARCHAR(10)	The status code returned in the DSN from the SMTP server.
LASTBOUNCE	TIMESTAMP	The time the last bounce for the user occurred from attempting to deliver the email activity.
LASTRETRY	TIMESTAMP	The timestamp of the latest attempt to deliver the e-mail activity.
RETRYCOUNT	SMALLINT	The number of times the activity delivery was attempted.
MAXRETRYHIT	SMALLINT	This column contains a flag that indicates whether the e-mail activity has reached the maximum re-try limit. Possible values include: 1 - This bounced message has reached its maximum number of retry attempts 0 - This bounced message has not reached its maximum number of retry attempts
EMLADDRINDEX	SMALLINT NOT NULL	This column indicates in which column the target e-mail address is found in the ADDRESS table. Possible values include: 1 - The e-mail address corresponds to the EMAIL1 column of the ADDRESS table 2 - The e-mail address corresponds to the EMAIL2 column of the ADDRESS table
EMAILADDRESS	VARCHAR(256)	This column contains the target e-mail address for which the delivery attempt resulted in a bounced message.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL100520030331370	EMLPROMO_ID+USERS_ID	Primary Key
I0000378	USERS_ID	Non-Unique Index
I0000379	EMLPROMO_ID	Non-Unique Index
I0000380	STOREENT_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1034	EMLPROMO_ID	EMLPROMO	EMLPROMO_ID	Cascade
F_1036	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_1035	USERS_ID	USERS	USERS_ID	Cascade