- Strapi Version: 4.2.3
- Operating System: Windows
- Database: Mysql
- Node Version: 16.14.2
I have been using V3 and I’m quite happy with it, however, since it will probably lose support I’m trying to learn V4.
This question is associated with Mysql Relations. In v3, when I create a one-to-many relation, it would create a foreign key in one of the tables to represent that relation (expected behaviour). That allowd us to manage the complexity of our database fairly well.
In V4, when I create a one-to-many relation it creates a new table table1_table2_links. A junction table is not really needed to represent this realtion and increases the database complexity. This can be troublesome especially when one has to write raw SQL queries…
Is it possible to avoid the creation of a table table1_table2_links and generate the foreign key directly on the respective table in a V3 fashion?
Thank you in advance