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 |