search

drawdb-io / drawdb

Free, simple, and intuitive online database design tool and SQL generator.
https://drawdb.vercel.app
MIT License
12.08k stars 851 forks source link

Can increase many to many cardinality? #113

Open Jackxwb opened 1 month ago

Jackxwb commented 1 month ago

Referring to the many to many relationship in Java JPA, it is used to express the following diagrams image

Its actual working mechanism involves automatically creating an intermediate table, resulting in a structure akin to the one below image

The current cardinality numbers may convey incorrect meanings in the illustration (as shown in Figure 1)

1ilit commented 1 month ago

This is intentional. To have a many to many relationship in sql you need to have a join table