[r][0][2][q]| Wanted table | It is possible to view parts of the schema by marking tables as wanted. This can make it easier
to view larger schemas. See more under [r] below.
|
|---|---|
| Skipped table | In addition to wanted, tables can also be skipped. These tables will excluded. See more under [r] below. |
| Degrees of separation | When any table is wanted this determines how many relations will be traversed to find additional tables to show. See more under [num] below. |
| Action | Result |
|---|---|
| Hover | The relation will be highlighted. The columns and their relation types are shown. |
| Click | The relation will remain highlighted until clicked again, or the [escape] key is pressed. |
| Action | Result |
|---|---|
| Hover column name | The column name and all relations from the column will be highlighted |
| Click column name | The column name and its relations will remain highlighted until clicked again, or the [escape] key is pressed. |
| Hover table name | The table and all relations from the table will be highlighted. |
| Click table name |
The table and all relations from the table will remain highlighted until clicked again, or the Additionally, the table will be marked as wanted. |
| [shift] + click table name | This is exactly the same as doing click table name followed by [r]. |
| [ctrl] + click table name | The table is marked as skipped. |
| [shift] + [ctrl] + click table name | This is exactly the same as doing [ctrl] + click table name followed by [r]. |
| Action | Result |
|---|---|
| [escape] | Remove all highlights, but don't reload. The tables that was marked wanted or skipped at the last reload will remain so. |
| [k] | Toggles between showing only primary and foreign keys, and showing all columns. |
| [q] | Show the whole schema and remove all highlights and the wanted, skipped and degrees of separation settings. |
| [r] | Reload the schema using the current wanted, skipped and degrees of separation settings. |
| [num] | Sets the degrees of separation setting to between 0 and 9. The numpad don't work. It is often better to mark tables as skipped rather than using a high degrees of separation. |
| [shift] + [num] | Sets the degrees of separation setting to between 10 and 19. |
| [ctrl] + [num] | Sets the degrees of separation setting to between 20 and 29. |
| [ctrl] + [shift] + [num] | Sets the degrees of separation setting to between 30 and 39. |