Suggestion on FOREIGN KEYs

[John Crowley]

Trying to understand a MySQL database in order to incorporate into some application code.

It would be extremely helpful if MySQLWorkbench provided a single screen (or at worst 2 screens) which:

1) showed all tables which included FOREIGN KEY definitions,
2) for each FK show the source column(s), and the target table and columns,
3) and the reverse - all tables which are the TARGET of a FOREIGN KEY, the columns involved and the source table and columns

Would give any user of a MySQL database a much more complete understanding (in detail) of the structure of the schema.

(Also, fix the issue to allow the FK to be within the CREATE TABLE instead of having to be in a separate ALTER TABLE statement!).

These screens could easily be derived by parsing the DDL of each existing table. To save startup time, would not populate these screens until first requested by the user.
Thanks