I just finished adding Section, Dimension, and SubSection columns to my database.
When I start joining the tables in various ways, I am not getting things in the order I want.
Would it be okay to add a column called "sort" and manually assign a "Sort Order #" so I have something on which to run my ORDER BY against?
For example, I want things in this order...
Also, if it is okay to do this for one table, would it be a major deal to do it on several tables, e.g. my Section, Dimension, and SubSection tables?