WebSphere Commerce database table: EMLBOUNCED

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 Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> EMLPROMO_ID+USERS_ID Primary Key
I0000378 USERS_ID Non-Unique Index
I0000379 EMLPROMO_ID Non-Unique Index
I0000380 STOREENT_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1034 EMLPROMO_ID EMLPROMO EMLPROMO_ID Cascade
F_1035 USERS_ID USERS USERS_ID Cascade
F_1036 STOREENT_ID STOREENT STOREENT_ID Cascade

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	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	Columns	Parent Table	Parent Columns	Type
F_1034	EMLPROMO_ID	EMLPROMO	EMLPROMO_ID	Cascade
F_1035	USERS_ID	USERS	USERS_ID	Cascade
F_1036	STOREENT_ID	STOREENT	STOREENT_ID	Cascade