Reference > Database > WebSphere Commerce database tables > D


WebSphere Commerce database table: DMTEMPLATETYPE

Types of marketing activity templates.

Column Name Column Type Description
DMTEMPLATETYPE_ID SMALLINT NOT NULL The unique identifier of the template for a marketing activity.
TYPE VARCHAR(64) NOT NULL The type of the marketing activity template.
DESCRIPTION VARCHAR(254) The description of the marketing activity template.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030328820 DMTEMPLATETYPE_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_3525 DMTEMPLATETYPE_ID DMACTIVITY DMTEMPLATETYPE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search