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 |