Avoiding Duplicate Data in DB (for use with Rails)
- by ants
I have five tables that I am trying to get to work nicely together but may need some help.
I have three main tables:
accounts
members
and roles.
With two join tables
account_members
and account_member_roles.
The accounts and members table are joined by account_members (fk account_id and member_id) table.
The other 2 tables are the…