Usage
Database row search and navigation using primary and foreign key constaints.
Enter text to the search field and hit Enter:
4 rows was found. One row in DEPARTMENTS table, one in EMPLOYEES and two in JOB_HISTORY.
Expand EMPLOYEES node:
Column JOB_ID is a foreign key that refers to row in JOBS table.
Expanding JOB_ID node gives you access to referenced row in JOBS table:
Note that primary key value AD_ASST is not readable enough. Administration Assistant is more convenient.
There is ability to compose readable string from
other columns value. Double-click String cell and type JOB_TITLE:
Now you see Administration value in String column that is more convenient than primary key value.
You can select any text or number column for search. For example JOBS.JOB_TITLE.
