I have a table of real estate objects. The objects are shown in three lists (sell, rent long, rent short), each object in exactly one list (defined by an ENUM field).
I want to add field
seq INT to the table to be able to reorder objects in every of the three lists (
ORDER BY seq). Should I permit objects of different lists have the same seq?