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 |