Reputation: 51
I have 3 tables organization(id, name, and etc) organizationContact(organizationId, contactId, status) contact(id, name, email) How can I make a many to many mapping and use status column from organizationContact?
Upvotes: 1
Views: 103
Reputation: 8270
For a strict many-to-many mapping, you would just have the organizationId and contactId in the mapping table. Adding the status column would require making a proper entity out of the organizationContact.
Upvotes: 1