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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031224160 | 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 Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |