Originally Posted by Old Pedant
Sure. I do this all the time.
That's good, because while I love my new Data Model, I found out pretty quickly last night that my "Natural Keys" in the junction tables were very short lived as far as simplifying my queries...
But take a hint from the olden days of when BASIC had line numbers and most people numbered their lines in increments of 10 ( 10, 20, 30, ... ).
Do that with your ordering column.
Now, if you change your mind about one number, you don't have to shuffle all the numbers around.
Say you had, indeed,
and you decided the 30 really should be before 20. So just change 30 to 15.
(Heck, I can remember numbering by 100 on occasion.)
Thanks for the tip!