Defining arrival-departure

In relational databases, sometimes search criteria field may be in different table, the field we want to see in search results may be in another table. In this stiuation we use arrival-departure er fields. Departure Er entities must be the same of SRC Er entites but Arrival Er entities must be different from departure er entities. Arrival ER field is the field we want to see in search results. Departure Er field is the start point of the search.

Sample ER Design

In figure above, you see a sample er design of a relational database. table1 is related to table2, table2 is related to table3 and table3 is related to table4. If we want find t4_field2 field and Our SRC main table is table1, we should to use arrival-depatrure er fields. In this example, our departure field is table1.id, and our arrival field is table4.t4_field2. Thats all. You don't have to do anything else. DynamicSearch does everything for you.

Defining Arrival-Departure ER Fields

Arrival-departure fields are defined at the bottom of the node attribute form. Arrival field is required but departure field not.