Subject Area : 160 - Templating |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 160 - Templating | Tables for notification template messaging and substitution of item field values inside messages. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | 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.. |
# | 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 |
# | 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) |
# | 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 |
# | 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) |
# | 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) |
# | 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) |
# | 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 |
# | 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 |
# | 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) |