Subject Area : 340 - Search
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 340 - Search Tables that defined saved searches and help with query generation and results presentation. Details.. Details..
ER Diagram(s) of Subject Area "340 - Search"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "340 - Search"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 10
. 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..
. defn_ver Definition Version false A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. logical_data_type Logical Data Type false A reference table for logical data type. The logical type maps to the database type in DDL generation. Details..
. search_col Search Column false The number and order of search result columns returned when the search is executed. Details..
. search_cond Search Condition false The set of logical search conditions for the query. This is rendered into the actual SQL or filtering code. Details..
. search_cstr_type Search Constraint Type false A lookup table for the various operators that can be used in a search condition. These are logical operators. Details..
. search_item_query Search Item Query false Identifies the specific item definitions associated with the search query to aid in visibility and permissions. Details..
. search_query Search Query false The root table for saved searches. It names the search, and indicates the visibility in various parts of the application. The search is saved in an implementation neutral format so that it can be used in many different layers. Details..
. search_view Search View false The UI details of the default view of the saved search. 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 "Definition Version"
# Physical Name Name Definition Physical Data Type
Total 5
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. defn_ver_id Definition Version Id The automatically generated primary key of the defn_ver table. bigint
. defn_ver_name Definition Version Name The name of the Definition Version. nvarchar(4000)
. defn_ver_status_id Definition Version Status Id A Foreign Key to the Definition Version Status table. int
. defn_ver_guid Definition Version GUID A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
Attribute/Column(s) of Entity/Table "Logical Data Type"
# Physical Name Name Definition Physical Data Type
Total 2
. logical_data_type_name Logical Data Type Name The name of the Logical Data Type. varchar(255)
. logical_data_type_id Logical Data Type Id The automatically generated primary key of the logical_data_type table. int
Attribute/Column(s) of Entity/Table "Search Column"
# Physical Name Name Definition Physical Data Type
Total 6
. search_col_id Search Column Id The automatically generated primary key of the search_col table. bigint
. search_col_name Search Column Name The name of the Search Column. varchar(255)
. is_ascending_order Is Ascending Order Indicates if Is Ascending Order. bit
. search_view_id Search View Id A Foreign Key to the Search View table. bigint
. sequence Sequence The value of a Search Column stored as Long. bigint
. is_automatic Is Automatic Indicates if Is Automatic. bit
Attribute/Column(s) of Entity/Table "Search Condition"
# Physical Name Name Definition Physical Data Type
Total 16
. search_cond_id Search Condition Id The automatically generated primary key of the search_cond table. bigint
. parent Parent A Foreign Key to the Search Condition table. Parent search. bigint
. search_cond_cd Search Condition Code A well-known string identifier used as a code to identify the Search Condition. varchar(255)
. field_name Field Name Field name. varchar(255)
. cstr_val Constraint Value Constraint value nvarchar(4000)
. search_item_query_id Search Item Query Id A Foreign Key to the Search Item Query table. bigint
. search_cstr_type_id Search Constraint Type Id A Foreign Key to the Search Constraint Type table. int
. sequence Sequence sequence integer bigint
. search_cstr_type Search Constraint Type Constraint type varchar(255)
. depth Depth tree depth bigint
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. field_type Field Type A Foreign Key to the Logical Data Type table. int
. is_journal Is Journal Indicates if Is Journal. bit
. search_query_id Search Query Id A Foreign Key to the Search Query table. bigint
. predicate Predicate Search Predicate varchar(255)
. cond_name Condition Name Name of condition varchar(255)
Attribute/Column(s) of Entity/Table "Search Constraint Type"
# Physical Name Name Definition Physical Data Type
Total 3
. search_cstr_type_id Search Constraint Type Id The automatically generated primary key of the search_cstr_type table. int
. search_cstr_type_name Search Constraint Type Name The name of the Search Constraint Type. varchar(255)
. search_cstr_type_descr Search Constraint Type Description A descriptive name of the Search Constraint Type. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Search Item Query"
# Physical Name Name Definition Physical Data Type
Total 7
. search_item_query_id Search Item Query Id The automatically generated primary key of the search_item_query table. bigint
. search_item_query_name Search Item Query Name The name of the Search Item Query. varchar(255)
. search_query_id Search Query Id A Foreign Key to the Search Query table. bigint
. extl_mapping_defn_id External Mapping Definition Id A Foreign Key to the Definition table. External data source. bigint
. meta_id Meta Id A Foreign Key to the Definition Version table. bigint
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. schema_name Schema Name Database schema name varchar(255)
Attribute/Column(s) of Entity/Table "Search Query"
# Physical Name Name Definition Physical Data Type
Total 14
. search_query_id Search Query Id The automatically generated primary key of the search_query table. bigint
. search_query_name Search Query Name The name of the Search Query. varchar(255)
. start_from_pos Start From Position Start From Position bigint
. limit_ct Limit Count query limit. bigint
. parent_name Parent Name Parent Name varchar(255)
. search_source Search Source Source int
. notes Notes User notes varchar()
. search_query_descr Search Query Description A descriptive name of the Search Query. This descriptive name may be localized. varchar(1024)
. tab Tab Tab name in UI varchar(255)
. query_type Query Type Advanced or Global or other type varchar(255)
. in_quick_searches In Quick Searches Indicates if In Quick Searches. bit
. in_search_analytics In Search Analytics Indicates if In Search Analytics. bit
. search_in_all Search In All Indicates if Search In All containers bit
. in_mobile In Mobile Indicates if In Mobile. bit
Attribute/Column(s) of Entity/Table "Search View"
# Physical Name Name Definition Physical Data Type
Total 12
. search_view_id Search View Id The automatically generated primary key of the search_view table. bigint
. search_view_name Search View Name The name of the Search View. varchar(255)
. create_date Create Date Create Date datetime
. is_shared Is Shared Indicates if Is Shared. bit
. search_query_id Search Query Id A Foreign Key to the Search Query table. bigint
. create_user Create User A Foreign Key to the Application User table. bigint
. is_dflt Is Default Indicates if Is Default. bit
. show_in_menu Show In Menu Indicates if Show In Menu. bit
. search_view_descr Search View Description A descriptive name of the Search View. This descriptive name may be localized. varchar(512)
. cxt Context Search Context varchar(255)
. update_user Update User A Foreign Key to the Application User table. bigint
. update_date Update Date Update Date datetime