sharp
sharp
PostsComments
CC#
Created by sharp on 6/6/2023 in #help
❔ Storing data which is different per user type
Great, thanks for the input
22 replies
CC#
Created by sharp on 6/6/2023 in #help
❔ Storing data which is different per user type
Something like this 
+---+-----------------------+----------+----------+
| # |         Name          | Language |  Value   |
+---+-----------------------+----------+----------+
| 1 | user.supplier.statusx | en-GB    | Status A |
| 2 | user.buyer.statusx    | en-GB    | Status X |
| 3 |                       |          |          |
+---+-----------------------+----------+----------+
+---+-----------------------+----------+----------+
| # |         Name          | Language |  Value   |
+---+-----------------------+----------+----------+
| 1 | user.supplier.statusx | en-GB    | Status A |
| 2 | user.buyer.statusx    | en-GB    | Status X |
| 3 |                       |          |          |
+---+-----------------------+----------+----------+
Where the name would follow some sort table-related naming pattern
22 replies
CC#
Created by sharp on 6/6/2023 in #help
❔ Storing data which is different per user type
What do you think about storing it in "Resources" table, where all the other resources could live in? Yes the downfall is querying it by resource name...
22 replies
CC#
Created by sharp on 6/6/2023 in #help
❔ Storing data which is different per user type
What is this approach named, do you know any articles/blogs that I could check out? Or any github repo which implements it in similar matter?
22 replies
CC#
Created by sharp on 6/6/2023 in #help
❔ Storing data which is different per user type
I usually distinguish them by UserType, 1 = Buyer, 2 = Supplier
22 replies