I would like to add a many to many relation ship between tables.
Hey Lotte, thanks for using dbdiagram! A many-to-many relationship usually requires a table in the middle. E.g:
Authorcan write multiple
- That means there should be an
(BookID, AuthorID)that indicates these links.
Do you mean to write the diagram without mentioning the Authorship table at all?
Hi Lotte, we recently wrote a blog post on building manny-many relationships in DBDiagram, one of our users Matt even shared his code on Github for automatically generating such a script https://www.holistics.io/blog/dbdiagram-io-many-to-many-relationship-diagram-generator-script/