mktg_dm_subject Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The mktg_dm_subject table in the marketing database contains information for a direct mail subject line in a particular language.

The following table describes the columns in the mktg_dm_subject table.

Column name	Type	Allow null	Description
i_dmitem_id	int	no	The ID of the direct mail item to which this subject line applies. This is a primary key, and a foreign key into the mktg_dm_item table.
u_subject_culture_code	nvarchar(20)	no	A string that indicates the culture code associated with this subject line. This is a primary key.
u_subject	nvarchar(1024)	no	A string that contains this subject line in the language that corresponds to the culture code for this direct mail.

i_dmitem_id

int

The ID of the direct mail item to which this subject line applies.

This is a primary key, and a foreign key into the mktg_dm_item table.

u_subject_culture_code

nvarchar(20)

A string that indicates the culture code associated with this subject line.

This is a primary key.

u_subject

nvarchar(1024)

A string that contains this subject line in the language that corresponds to the culture code for this direct mail.

See Also