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_