Subject Area : 170 - Knowledge Base
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 170 - Knowledge Base Tables to add on to knowledge base items regarding user comments on usefulness. Details.. Details..
ER Diagram(s) of Subject Area "170 - Knowledge Base"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "170 - Knowledge Base"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 8
. app_user Application User false A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions. 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 Item true true The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance. Details..
. item_defn Item Definition true true The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names. Details..
. item_useful_dtl Item Useful Detail false An entry from an agent or customer classifying the quality and usefulness of an knowledgebase item or other item. Details..
. item_useful_sumry Item Useful Summary false A standalone table holding a summary count of the usefulness of an Item, computed by summing the detail. Details..
. soln_item Solution Item true true An item that stores the solution information for a particular issue. Details..
. useful_cd Useful Code false A lookup table for the useful code used in grading solutions. Examples include: I - Yes, but inaccurate, N - No, Y - Yes Details..
Attribute/Column(s) of Entity/Table "Application User"
# Physical Name Name Definition Physical Data Type
Total 8
. pwd Password This space intentionally left blank. varchar(255)
. user_name User Name The name of the Application User. nvarchar(4000)
. cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
. app_user_id Application User Id The automatically generated primary key of the app_user table. bigint
. lic_type_id License Type Id A Foreign Key to the License Type table. bigint
. user_login User Login The login name used to access the Application. This may not be filled in if external application security is used. nvarchar(4000)
. email_addr Email Address An email address for the Application User. nvarchar(4000)
. delete_date Delete Date The value of a Application User, stored as a date. datetime
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"
# Physical Name Name Definition Physical Data Type
Total 4
. item_key Item Key A search key for the Item, composed of letters and numbers. varchar(255)
. item_id Item Id The automatically generated primary key of the item table. bigint
. cntnr_id Container Id A Foreign Key to the Container table. bigint
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "Item Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. item_table_name Item Table Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "Item Useful Detail"
# Physical Name Name Definition Physical Data Type
Total 7
. item_useful_dtl_id Item Useful Detail Id The automatically generated primary key of the item_useful_dtl table. bigint
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
. user_comment User Comment A free-form text comment describing the Item Useful Detail entry made by the application user. nvarchar(4000)
. create_date Create Date The date that the Item Useful Detail was created. datetime
. item_defn_id Item Definition Id A Foreign Key to the Definition table. Identifies the Container and Item Type. bigint
. item_id Item Id A Foreign Key to the generated Dyamic Item table key. Not database enforced. bigint
. useful_cd Useful Code Indicates the level of usefulness recorded by the user. A Foreign Key to the lookup table. varchar(2)
Attribute/Column(s) of Entity/Table "Item Useful Summary"
# Physical Name Name Definition Physical Data Type
Total 6
. item_useful_sumry_id Item Useful Summary Id The automatically generated primary key of the item_useful_sumry table. bigint
. yes_ct Yes Count The summarized count of Yes responses, calculated from the detail table as stored here for convenience. int
. item_defn_id Item Definition Id A Foreign Key to the Definition table. Identifies the Container and Item Type. bigint
. inaccr_ct Inaccurate Count The summarized count of Inaccurate responses, calculated from the detail table as stored here for convenience. Perl FP does not show this column, it could be used to search for inaccurate items. int
. no_ct No Count The summarized count of No responses, calculated from the detail table as stored here for convenience. Perl FP does not show this column, it could be used to calculate a usefullness percentage. int
. item_id Item Id A Foreign Key to the generated Dyamic Item table key. Not database enforced. bigint
Attribute/Column(s) of Entity/Table "Solution Item"
# Physical Name Name Definition Physical Data Type
Total 1
. item_id Item Id A Foreign Key to the Item table. bigint
Attribute/Column(s) of Entity/Table "Useful Code"
# Physical Name Name Definition Physical Data Type
Total 2
. useful_cd_descr Useful Code Description A descriptive name of the Useful Code. This descriptive name may be localized. varchar(512)
. useful_cd Useful Code The name of the Useful Code. varchar(2)