mktg_lm_{listid}_list Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_lm_{listid}_list tables in the marketing lists database contain mailing lists. The names of these tables are of the form mktg_lm_{listid}_list, where "{listid}" is replaced by a GUID without any hyphens.
Note
One such list table is pre-defined and serves as the global opt-out mailing list. The "{listid}" section of the name of this table consists of a GUID using only the letter "F", creating the following table name: mktg_lm_FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF_list
The following table describes the columns in the mktg_lm_{listid}_list tables.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_rcp_email |
nvarchar(256) |
no |
The recipient e-mail address. This is the primary key. |
u_rcp_id |
nvarchar(64) |
yes |
An identifier for the recipient. |
i_rcp_fmt |
int |
yes |
The mail format for this recipient. |
u_rcp_language |
nvarchar(20) |
yes |
The language for direct mail sent to this recipient. |
u_rcp_charset |
nvarchar(20) |
yes |
The character set for direct mail sent to this recipient. |
u_rcp_url |
nvarchar(2048) |
yes |
The URL from which to load the page. |