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 |