I have a table to an application. The application can add a few objects such as blue, red and yellow. Since the items can be added more than once, I wan the items to be added as blue1 for the first time and blue2, blue3 if user keeps on adding blue to identify each blue item.
I thought of giving them an increment id, but then there are red and yellow too.
How to do this?