- The user is uniqely identified by UUID or (username , domain)
- The user in a specific domain has some preferences formed in (attribute, value) pairs.
- Another user (different user or different domain) can have the same references (all or some pairs).
The question: is it right to make the "value" as index (value_idx) for "usr_preferences" table ???. If yes why?
usr_preferences table scheme