How to get table relationships for all tables in a database ?

[shrutikaponde]

I want to extract relationships between tables ( one to many / many to many / etc ).
Currently using tap-mysql with --discover option I am able to get list of all tables. It contains information about schema name, table name, table schema ( columns and column types) and metadata.
Metadata only contains table-key-properties :
"metadata": { "selected-by-default": false, "database-name": "employee", "row-count": 0, "is-view": false, "table-key-properties": [ "id" ] }
Is there a way extract foreign and primary key information ?