How should I manage my many-to-many relationships?
- by wes
Hello all,
I have a database containing a couple tables: files and users. This relationship is many-to-many, so I also have a table called users_files_ref which holds foreign keys to both of the above tables.
Here's the schema of each table:
files - file_id, file_name
users - user_id, user_name
users_files_ref -…