The Personalization module uses the following tables to store information about targeted e-mail. The tables shown here correspond to external users. A parallel set of tables, with the prefix dpi, exists for internal users.
dps_mailing
This table contains information about any targeted e-mail campaigns that are sent to users.
Column | Data Type | Constraint | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier associated with this mailing campaign. |
| WVARCHAR(80) | NULL | The name of the mailing campaign. |
| WVARCHAR(80) | NULL | The subject line of the e-mail. |
| VARCHAR(255) | NULL | The unique ID of the ATG server (IP address: DRP port) that sent out the e-mail. |
| WVARCHAR(255) | NULL | The value of the “From” header in the e-mail. |
| WVARCHAR(255) | NULL | The value of the “Reply To” header in the e-mail. |
| VARCHAR(255) | NULL | The URL of the targeted e-mail template that is used for the e-mails in this campaign. |
| VARCHAR(255) | NULL | The URL of a template containing an alternative text version of an HTML message. |
| VARCHAR(40) | NULL | An ID that distinguishes all mailings created from the same invocation of a |
| LONG VARCHAR | NULL | The value of the “CC” header in this e-mail. |
| LONG VARCHAR | NULL | The value of the “BCC” header in this e-mail. |
| INT | NULL | Determines whether or not the e-mail was sent in HTML format. |
| INT | NULL | Determines whether or not the e-mail was sent in text format. |
| LONG VARBINARY | NULL | Serialized map of template parameters used when rendering the e-mail template for a specific campaign. This is the value of the |
| TIMESTAMP | NULL | The time at which the SMTP server started sending e-mails. |
| TIMESTAMP | NULL | The time at which the SMTP server stopped sending e-mails. |
| INT | NULL | The status of the e-mail campaign, whether PENDING, INPROGRESS, CANCELED, COMPLETE, or FAILED. |
| INT | NULL | The total number of profiles to which this e-mail was sent. |
| INT | NULL | The total number of e-mails sent. |
| INT | NULL | The total number of e-mails that bounced back to the server. |
| INT | NULL | The number of errors that occurred while sending the e-mails. |
| INT | NULL | The number of recipients to whom the mailing could not be sent (for example, because their |
| NUMERIC(1) | NULL | The value of the |
| TINYINT | NULL | Identifies this mailing as a distributed mailing. |
| INT | NULL | The number of messages in this batch. |
dps_mail_server
This table is used to identify the servers participating in a distributed mailing.
Column | Data Type | Constraint | Description |
---|---|---|---|
| VARCHAR(254) | NOT NULL | The unique identifier associated with each participating server. |
| TIMESTAMP | NULL | The timestamp set by this server’s |
dps_mail_batch
This table is used by the distributed mailing feature.
Column | Data Type | Constraint | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier associated with the batch. References |
| INT | NOT NULL | An index that identifies the first profile in this batch. |
| VARCHAR(254) | NULL | The unique ID of the server (IP address: DRP port) that claimed the batch. |
| TIMESTAMP | NULL | The time at which the server started sending the e-mails in this batch. |
| TIMESTAMP | NULL | The time at which the server stopped sending the e-mails in this batch. |
| INT | NULL | The status of the batch mailing, whether PENDING, INPROGRESS, CANCELED, COMPLETE, or FAILED. |
| INT | NULL | The total number of profiles to which this mailing was sent. |
| INT | NULL | The total number of e-mails sent. |
| INT | NULL | The total number of e-mails that bounced back to the server. |
| INT | NULL | The number of errors that occurred while sending the e-mails. |
| INT | NULL | The number of recipients to whom the mailing could not be sent (because, for example, their |
| TINYINT | NULL | Indicates whether the counts for this batch have been merged back into the parent mailing. |
dps_user_mailing
This table contains information about users who are receiving e-mail as part of an e-mail campaign.
Column | Data Type | Constraint | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier associated with the e-mail campaign. References |
| VARCHAR(40) | NOT NULL | The ID of a user who received an e-mail from the e-mail campaign. References |
| INT | NOT NULL | An index used to order the users in this campaign. |
dps_email_address
This table stores information that allows you to send e-mail to specific e-mail addresses. A profile is not required.
Column | Data Type | Constraint | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier associated with the e-mail campaign. References |
| VARCHAR(255) | NOT NULL | The user’s e-mail address. |
| INT | NOT NULL | An index used to order the users in this campaign. |