Many to Many relationships

DBML Syntax
1

I would like to add a many to many relation ship between tables.

2

Hey Lotte, thanks for using dbdiagram! A many-to-many relationship usually requires a table in the middle. E.g:

  • A Book has multiple Authors
  • An Author can write multiple Books
  • That means there should be an Authorship table with (BookID, AuthorID) that indicates these links.

image

Do you mean to write the diagram without mentioning the Authorship table at all?

3

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/