Footprints Data Model

Table
Name search_col
Comment The number and order of search result columns returned when the search is executed.

Column
Name Datatype Comment Is PK Is FK
search_col_id bigint The automatically generated primary key of the search_col table. Yes No
search_col_name varchar(255) The name of the Search Column. No No
is_ascending_order bit Indicates if Is Ascending Order. No No
search_view_id bigint A Foreign Key to the Search View table. No Yes
sequence bigint The value of a Search Column stored as Long. No No
is_automatic bit Indicates if Is Automatic. No No