Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |