Footprints Data Model

Table
Name tmpl_defn
Comment A template used for notifications or description content with substitution attributes.

Column
Name Datatype Comment Is PK Is FK
tmpl_defn_id bigint The automatically generated primary key of the tmpl_defn table. Yes No
tmpl_defn_type varchar(255) The Type of template. No No
tmpl_content varchar(max) The value of a Template Definition, stored as a long text object. No No
is_imported bit Indicates if Is_Imported. No No
is_editable bit Indicates if Is Editable. No No
tmpl_grp_id bigint A Foreign Key to the Template Group table. No Yes
tmpl_ctgy_id bigint A Foreign Key to the Template Category table. No Yes
tmpl_content_type_id int A Foreign Key to the Template Content Type table. No Yes
is_sys_tmpl bit Indicates if Is System Template. No No