mktg_creative_property Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_creative_property table in the marketing database contains information about creative properties.
The following table describes the columns in the mktg_creative_property table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_cp_id |
int |
no |
The ID of this creative property. This is the primary key. |
i_creative_type_id |
int |
no |
The type of this creative property. This is a foreign key into the mktg_creative_type table. |
u_cp_name |
nvarchar(50) |
no |
The name of this creative property. |
i_cp_type |
smallint |
yes |
The type of input field and validation to use for this creative property in the user interface. |
u_cp_label |
nvarchar(255) |
yes |
The label to use for this creative property in the user interface. |
i_cp_order |
smallint |
yes |
The relative order of this creative property in the user interface. |
b_cp_required |
bit |
yes |
A Boolean value that indicates whether this creative property is required or optional. |
u_cp_default |
nvarchar(255) |
yes |
The default value for this creative property. |
i_cp_source |
smallint |
yes |
The run-time source of this creative property. |
i_cp_encoding |
smallint |
yes |
The type of URL encoding associated with this creative property. |