User Requirements :-
A design to store Preference Settings in a database.
Let's assume 3 levels
1) a general (= default settings)
2) group level
3) user level - a user belongs to a group.
Group- and User- settings overwrite the general settings and are normally a
subset of all possible values.
----------------------------
this could be an example:
general:
- color = black
- lang = en
- size = 5
group1:
- lang = fr
user1:
- size = 6
(user1 belongs to group1)
----------------------------
the query to get all the settings for user1 should return the following
values:
- color = black
- lang = fr
- size = 6
----------------------------
I know, there are other solutions than using a database and it could be a
massive overkill, but I'm interested in possible designs.
Thank you for any comment!
Greetings from Switzerland to London
Philipp
A. The Area being Modelled is :-
A Hierarchy of Preferences
B. The Things of Interest, ('THINGS'), include :-
B.1 Hierarchies
B.2 Hierarchy Entries
B.3 Hierarchy Levels
B.3 Preferences
C. These THINGS are Related as follows :-
C.1 A HIERARCHY has one or many LEVELS.
C.2
D. Other Characteristics of these THINGS include :-
D.1
E. Sample Data includes :-
To be determined
F. Typical Enquiries include :-
F.1 To be determined