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 Descriptions:

TEMPLATE_IDBIGINT NOT NULLThe primary key of the template.
EVENTTYPE_IDINTEGER NOT NULLThe event type for which this this template was created.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
DEFAULTTEMPLATESMALLINT NOT NULLWhether this template is the default for a given event type:
  • 1: Default
  • 0: Not default
TEMPLATENAMEVARCHAR (254) NOT NULLThe name of a template that can be used to uniquely identify a template.
DESCRIPTIONVARCHAR (254)The description of the template.
THUMBNAILPATHVARCHAR (254)The path of the template's thumbnail, if any.
PATHVARCHAR (254) NOT NULLThe path of the template.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.
FIELD3VARCHAR (64)Customizable.


NameColumn NamesType

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType