❔ Storing data which is different per user type
Hi there!
I'm working on a project where I have two types of users. Buyer and Suppler.
When the buyer is making a purchase of some items, I'm having some statuses of the purchase which he can track.
Since the status is and integer in the database, both of those users should see different value on UI based on that integer
My current table has only ID and Name, but should I add type and maybe a separate
The main reason I'm asking is because I need to be able to show the statuses on the list and order by them (Alphabetically). Currently they are being ordered by ID, which is not the correct way.
I'm working on a project where I have two types of users. Buyer and Suppler.
When the buyer is making a purchase of some items, I'm having some statuses of the purchase which he can track.
Since the status is and integer in the database, both of those users should see different value on UI based on that integer
My current table has only ID and Name, but should I add type and maybe a separate
ResourcesThe main reason I'm asking is because I need to be able to show the statuses on the list and order by them (Alphabetically). Currently they are being ordered by ID, which is not the correct way.
