Footprints Data Model

Table
Name search_query
Comment 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.

Column
Name Datatype Comment Is PK Is FK
search_query_id bigint The automatically generated primary key of the search_query table. Yes No
search_query_name varchar(255) The name of the Search Query. No No
start_from_pos bigint Start From Position No No
limit_ct bigint query limit. No No
parent_name varchar(255) The name of the Search Query. No No
search_source int Source No No
notes varchar() User notes No No
search_query_descr varchar(1024) A descriptive name of the Search Query. This descriptive name may be localized. No No
tab varchar(255) Tab name in UI No No
query_type varchar(255) Advanced or Global or other type No No
in_quick_searches bit Indicates if In Quick Searches. No No
in_search_analytics bit Indicates if In Search Analytics. No No
in_mobile bit Indicates if In Mobile. No No
search_in_all bit Indicates if Search In All containers No No