I have various tables in which each record has an associate rank. The rank given is not an automatic, calculated rank but a manual rank decided by me.
I want the rank to be dynamic so that if I add a new row which should be ranked somewhere in the middle of the total order then all other entries in the same table have their rank change accordingly.
I do not need the rank to taken into account any other tables, the rank is specific to each table individually.
Is this possible?