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

NameTypeDescription
TEMPLATE_IDBIGINT NOT NULLThe primary key of the template.
EVENTTYPE_IDINTEGER NOT NULLThe event type for which this template was created.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TEMPLATE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
GRA_CONSTRAINT2EVENTTYPE_IDGREVNTTYPEEVENTTYPE_IDNo Action