I suppose this may be more of a database question, but what is the best way to handle this scenario.
I have the following tables: articles, collections, articles_collections
a collection contains many articles but I want to be able to order them. Would I simply add a "stacking_order" column to the articles table?
Although, an article can belong to many collections and each would have different stacking orders.
Any suggestions?