Footprints Data Model

Table
Table Name Search Column
Table Definition The number and order of search result columns returned when the search is executed.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Search Column Id The automatically generated primary key of the search_col table. LONG Yes
Search Column Name The name of the Search Column. VARCHAR(255) Yes
Is Ascending Order Indicates if Is Ascending Order. BOOLEAN Yes
Search View Id A Foreign Key to the Search View table. LONG No
Sequence The value of a Search Column stored as Long. LONG No
Is Automatic Indicates if Is Automatic. BOOLEAN Yes