Subject Area : 160 - Templating
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 160 - Templating Tables for notification template messaging and substitution of item field values inside messages. Details.. Details..
ER Diagram(s) of Subject Area "160 - Templating"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "160 - Templating"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 9
. app_ele Application Element false The identity and name of an element in the application implementation. An element can be one of many types, and can contain other elements. Example Application Elements include: a screen, a form, a dialog box, a text box, the Home Page, an Architecture Component, the Item Status field, the system values of the Item Status field. The Application Element is not the full implementation of the element, but is a key and nametag for the element. In many cases, a well-known algorithm can be used to locate the correct Application Element from the Application Element implementation. In other cases, an association to the Application Element Id must be recorded as part of the implementation. Details..
. defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. item_field_defn Item Field Definition true true Item Field Definition is an association between the Item Definition entity and the Field Definition entity. This association contains a distinct value for each of the intersection points between the two entities. Details..
. tmpl_attr_defn Template Attribute Definition false A list of substitution attributes that can be used in an email template. Details..
. tmpl_ctgy Template Category false A category of template, for example Email Template Definition. Details..
. tmpl_content_type Template Content Type false A lookup table for the type of template content. Values include: PLAINTEXT, HTML. Details..
. tmpl_defn Template Definition false A template used for notifications or description content with substitution attributes. Details..
. tmpl_defn_attr Template Definition Attribute false The collection of template attributes associated with an instance of template definition. Details..
. tmpl_grp Template Group false A group of templates. Details..
Attribute/Column(s) of Entity/Table "Application Element"
# Physical Name Name Definition Physical Data Type
Total 7
. app_ele_id Application Element Id The automatically generated primary key of the app_ele table. bigint
. app_ele_name Application Element Name The name of the Application Element. VARCHAR(2000)
. intrnl_id Internal Id An alternate automatically generated key of the app_ele table. int
. is_intrnl_flag Is Internal Flag A boolean flag for indicating if the Application Element is defined internally by Engineering or by Partners or is defined by the customer. bit
. app_ele_type_id Application Element Type Id A Foreign Key to the Application Element Type table. int
. intrnl_id_type_id Internal Identifier Type Id A Foreign Key to the Internal Identifier Type table. int
. app_ele_nmsp_id Application Element Namespace Id A Foreign Key to the Application Element Namespace table. bigint
Attribute/Column(s) of Entity/Table "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. defn_id Definition Id The automatically generated primary key of the defn table. bigint
. defn_name Definition Name The name of the Definition. nvarchar(4000)
. dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
. defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
. defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
Attribute/Column(s) of Entity/Table "Item Field Definition"
# Physical Name Name Definition Physical Data Type
Total 3
. item_field_defn_id Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. field_defn_id Field Definition Id A Foreign Key to the Definition table. bigint
Attribute/Column(s) of Entity/Table "Template Attribute Definition"
# Physical Name Name Definition Physical Data Type
Total 5
. tmpl_attr_defn_name Template Attribute Definition Name The value of a Template Attribute Definition, stored as a string. varchar(255)
. is_intrnl Is Internal Indicates if Is Internal. bit
. tmpl_ctgy_id Template Category Id A Foreign Key to the Template Category table. bigint
. tmpl_attr_defn_id Template Attribute Definition Id The automatically generated primary key of the tmpl_attr_defn table. bigint
. tmpl_attr_defn_keyword Template Attribute Definition Keyword The value of a Template Attribute Definition, stored as a string. varchar(255)
Attribute/Column(s) of Entity/Table "Template Category"
# Physical Name Name Definition Physical Data Type
Total 3
. tmpl_ctgy_id Template Category Id The automatically generated primary key of the tmpl_ctgy table. bigint
. tmpl_ctgy_name Template Category Name The name of the Template Category. varchar(255)
. tmpl_ctgy_descr Template Category Description A descriptive name of the Template Category. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Template Content Type"
# Physical Name Name Definition Physical Data Type
Total 3
. tmpl_content_type_name Template Content Type Name The name of the Template Content Type. varchar(255)
. tmpl_content_type_id Template Content Type Id The automatically generated primary key of the tmpl_content_type table. int
. tmpl_content_type_descr Template Content Type Description A descriptive name of the Template Content Type. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Template Definition"
# Physical Name Name Definition Physical Data Type
Total 9
. tmpl_defn_id Template Definition Id The automatically generated primary key of the tmpl_defn table. bigint
. tmpl_defn_type Template Definition Type The Type of template. varchar(255)
. tmpl_content Template Content The value of a Template Definition, stored as a long text object. varchar(max)
. is_imported Is_Imported Indicates if Is_Imported. bit
. is_editable Is Editable Indicates if Is Editable. bit
. tmpl_grp_id Template Group Id A Foreign Key to the Template Group table. bigint
. tmpl_ctgy_id Template Category Id A Foreign Key to the Template Category table. bigint
. tmpl_content_type_id Template Content Type Id A Foreign Key to the Template Content Type table. int
. is_sys_tmpl Is System Template Indicates if Is System Template. bit
Attribute/Column(s) of Entity/Table "Template Definition Attribute"
# Physical Name Name Definition Physical Data Type
Total 2
. tmpl_defn_id Template Definition Id A Foreign Key to the Template Definition table. bigint
. tmpl_attr_defn_id Template Attribute Definition Id The automatically generated primary key of the tmpl_attr_defn table. bigint
Attribute/Column(s) of Entity/Table "Template Group"
# Physical Name Name Definition Physical Data Type
Total 3
. tmpl_grp_id Template Group Id The automatically generated primary key of the tmpl_grp table. bigint
. tmpl_grp_name Template Group Name The name of the Template Group. varchar(255)
. tmpl_grp_descr Template Group Description A descriptive name of the Template Group. This descriptive name may be localized. varchar(512)