Footprints Data Model

Table
Table Name Template Definition
Table Definition A template used for notifications or description content with substitution attributes.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Template Definition Id The automatically generated primary key of the tmpl_defn table. LONG Yes
Template Definition Type The Type of template. VARCHAR(255) Yes
Template Content The value of a Template Definition, stored as a long text object. TEXT Yes
Is_Imported Indicates if Is_Imported. BOOLEAN No
Is Editable Indicates if Is Editable. BOOLEAN No
Template Group Id A Foreign Key to the Template Group table. LONG Yes
Template Category Id A Foreign Key to the Template Category table. LONG Yes
Template Content Type Id A Foreign Key to the Template Content Type table. INTEGER No
Is System Template Indicates if Is System Template. BOOLEAN No