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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | 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 |
---|---|---|
| VARCHAR(254) | NOT NULL |
(primary key) | 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 |
---|---|---|
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | 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 |
(primary key) | 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the e-mail campaign. References | |
| VARCHAR(255) | NOT NULL |
The user’s e-mail address. | ||
| INT | NOT NULL |
(primary key) | An index used to order the users in this campaign. |