Foreign Key doesn't created

System Information
  • Strapi Version: 3.4.6
  • Operating System: Windows 10
  • Database: Postgree
  • Node Version: 12.20
  • NPM Version: 6.14.8
  • Yarn Version:

We have an issue related to foreign keys in Strapi. When we create entity collections and add fields related to another entity, we have not been able to find the foreign keys. Is it an expected behavior or do we have to perform any configuration in the environment?

Thats an expected behavior. It creates foreign keys only for Components.

We are looking into automatically creating them in the v4, once we have a public RFC I’ll link it.

is it possible to have the relationships between tables? to maintain integrity constraints especially FOREIGN KEYS.

Thank you

Foreign Keys are added by default in the v4