Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GRANNTMPLT
This table stores announcement e-mail template information. The registrant can select a template when sending an announcement for a gift registry or wish list.
Column Name Column Type Description TEMPLATE_ID BIGINT NOT NULL The primary key of the template. EVENTTYPE_ID INTEGER NOT NULL The event type for which this this template was created. OPTCOUNTER SMALLINT Reserved for IBM internal use. DEFAULTTEMPLATE SMALLINT NOT NULL Whether this template is the default for a given event type:
- 1: Default
- 0: Not default
TEMPLATENAME VARCHAR(254) NOT NULL The name of a template that can be used to uniquely identify a template. DESCRIPTION VARCHAR(254) The description of the template. THUMBNAILPATH VARCHAR(254) The path of the template's thumbnail, if any. PATH VARCHAR(254) NOT NULL The path of the template. FIELD1 VARCHAR(64) Customizable. FIELD2 VARCHAR(64) Customizable. FIELD3 VARCHAR(64) Customizable.
Indexes Index Name Indexed Column Names Index Type SQL100520030338880 TEMPLATE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type GRA_CONSTRAINT2 EVENTTYPE_ID GREVNTTYPE EVENTTYPE_ID No Action _vcc_freeselect_bottom_