Footprints Data Model

Table
Name search_cond
Comment
The set of logical search conditions for the query.  This is rendered into the
actual SQL or filtering code.

Column
Name Datatype Comment Is PK Is FK
search_cond_id bigint The automatically generated primary key of the search_cond table. Yes No
search_item_query_id bigint A Foreign Key to the Search Item Query table. No Yes
parent bigint A Foreign Key to the Search Condition table. Parent search. No Yes
search_cond_cd varchar(255) A well-known string identifier used as a code to identify the Search Condition. No No
field_name varchar(255) Field name. No No
field_type int A Foreign Key to the Logical Data Type table. No Yes
is_journal bit Indicates if Is Journal. No No
search_cstr_type_id int A Foreign Key to the Search Constraint Type table. No Yes
search_cstr_type varchar(255) Constraint type No No
cstr_val varchar(255) Constraint value No No
sequence bigint sequence integer No No
depth bigint tree depth No No
defn_id bigint A Foreign Key to the Definition table. No Yes
search_query_id bigint A Foreign Key to the Search Query table. No Yes
predicate varchar(255) Search Predicate No No
cond_name varchar(255) Name of condition No No