refactor: refactor through model name with hasMany relationships

[GuillaumeCisco]

Pull Request checklist:

• [x] Write an explicit title for the Pull Request, following Conventional Commits specification
• [x] Create automatic tests
• [x] No automatic tests failures
• [x] Test manually the implemented changes
• [x] Review my own code (indentation, syntax, style, simplicity, readability)
• [x] Wonder if you can improve the existing code

According to https://sequelize.org/master/manual/advanced-many-to-many.html

By passing a string to through above, we are asking Sequelize to automatically generate a model named User_Profiles as the through table (also known as junction table), with only two columns: userId and profileId. A composite unique key will be established on these two columns.

[arnaudbesnier]

Task linked: CU-52jbcp P3 - Mysql model definition - createdAt field present in schema when timestamp is defined as false

[closingin]

Duplicate of #445 😕

[GuillaumeCisco]

I've just reopened it for using the through key instead of modifying the junctionTable in the middle of a process. It allows to be less error prone as we are more declarative.

We could remove the junctionTable key from the reference object if it does not break compatibility.

[closingin]

@GuillaumeCisco Change your PR type to "refactor", this is not a fix anymore (also amend your commits if possible) 🙂

[GuillaumeCisco]

@GuillaumeCisco Change your PR type to "refactor", this is not a fix anymore (also amend your commits if possible) 🙂

Thank you! It is done 🚀

[forest-bot]

:tada: This PR is included in version 3.6.3 :tada:

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot :package::rocket: