Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Search Condition Id The automatically generated primary key of the search_cond table. LONG Yes
Search Item Query Id A Foreign Key to the Search Item Query table. LONG No
Parent A Foreign Key to the Search Condition table. Parent search. LONG No
Search Condition Code A well-known string identifier used as a code to identify the Search Condition. VARCHAR(255) Yes
Field Name Field name. VARCHAR(255) No
Field Type A Foreign Key to the Logical Data Type table. INTEGER No
Is Journal Indicates if Is Journal. BOOLEAN No
Search Constraint Type Id A Foreign Key to the Search Constraint Type table. INTEGER No
Search Constraint Type Constraint type VARCHAR(255) No
Constraint Value Constraint value VARCHAR(255) No
Sequence sequence integer LONG No
Depth tree depth LONG No
Definition Id A Foreign Key to the Definition table. LONG No
Search Query Id A Foreign Key to the Search Query table. LONG No
Predicate Search Predicate VARCHAR(255) No
Condition Name Name of condition VARCHAR(255) No