How to find relationship between tables/models?

Question

PostgreSQL

The project has two models (tables), I want to filter the records of one model, according to the values ​​of the other. The models are not directly related, there are a total of a thousand models in the project. How to find a connection between them?

Answer 1

We select the necessary tables in pycharm and build a diagram - only related models will fall into it and nothing more.

Answer 2

total in the project for a thousand models

this is hell. Stupidly sit down and make out connections. Perhaps visualization through https://django-extensions.readthedocs.io/en/latest... or other software that builds on the database will help, but there are doubts because of such a bunch of models.
PS In the python's console, you can still see a specific object, through tab completion, and probably in smart IDEs too. Sit down and spin.