Database Design - Saving the order of something.
Hey there,
the user chooses 0 to n entries in a specified order and i've to save said order of the entries in the user table. My approach of saving the order in a single string (1,5,3,2) worked but I think that's not exactly considered best practice.
Table User: (int ID; string username; string order) e.g: 1;Hans;1,2,3,4
Table Entries: (int ID; string content) e.g. 1;Fruityloops
Any ideas how to improve this?
Subject
Written By
Posted
Database Design - Saving the order of something.
January 27, 2012 08:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.