Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can increase many to many cardinality? #113

Open
Jackxwb opened this issue May 16, 2024 · 1 comment
Open

Can increase many to many cardinality? #113

Jackxwb opened this issue May 16, 2024 · 1 comment

Comments

@Jackxwb
Copy link

Jackxwb commented May 16, 2024

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
Copy link
Member

1ilit commented May 19, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants