Footprints Data Model

Table
Table Name Template Attribute Definition
Table Definition A list of substitution attributes that can be used in an email template.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Template Attribute Definition Id The automatically generated primary key of the tmpl_attr_defn table. LONG Yes
Template Attribute Definition Keyword The value of a Template Attribute Definition, stored as a string. VARCHAR(255) Yes
Template Attribute Definition Name The value of a Template Attribute Definition, stored as a string. VARCHAR(255) No
Is Internal Indicates if Is Internal. BOOLEAN No
Template Category Id A Foreign Key to the Template Category table. LONG Yes