Footprints Data Model

Table
Table Name Search Query
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Search Query Id The automatically generated primary key of the search_query table. LONG Yes
Search Query Name The name of the Search Query. VARCHAR(255) Yes
Start From Position Start From Position LONG No
Limit Count query limit. LONG No
Parent Name Parent Name VARCHAR(255) No
Search Source Source INTEGER No
Notes User notes VARCHAR(MAX) No
Search Query Description A descriptive name of the Search Query. This descriptive name may be localized. VARCHAR(1024) No
Tab Tab name in UI VARCHAR(255) No
Query Type Advanced or Global or other type VARCHAR(255) No
In Quick Searches Indicates if In Quick Searches. BOOLEAN Yes
In Search Analytics Indicates if In Search Analytics. BOOLEAN Yes
In Mobile Indicates if In Mobile. BOOLEAN Yes
Search In All Indicates if Search In All containers BOOLEAN Yes