Footprints Data Model

Table
Name search_view
Comment The UI details of the default view of the saved search.

Column
Name Datatype Comment Is PK Is FK
search_view_id bigint The automatically generated primary key of the search_view table. Yes No
search_view_name varchar(255) The name of the Search View. No No
create_date datetime Create Date No No
is_shared bit Indicates if Is Shared. No No
search_query_id bigint A Foreign Key to the Search Query table. No Yes
create_user bigint A Foreign Key to the Application User table. No Yes
is_dflt bit Indicates if Is Default. No No
show_in_menu bit Indicates if Show In Menu. No No
search_view_descr varchar(512)
A descriptive name of the Search View.  This descriptive name may be localized.
No No
cxt varchar(255) Search Context No No
update_user bigint A Foreign Key to the Application User table. No Yes
update_date datetime Update Date No No