[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: Latest DB schema
Alexey Parshin wrote:
> IMO, any preferences that are not one-to-many (ie not a list), like
> preferred_language, may go into person_list.
I tend to agree with that.
> As for the others - we would need to discuss it separately, since it
> probably requires support on the database level.
> The notifications, for instance, belong to an object.
Hmm... At first I wanted to say "to object relationship", but then
realized that relationships themselves
are versioned. At the same time each object-object relationship may have
its own notification preference.
I guess this either means separate object<->object table for
notification statuses, or copying that
preference when creating new object version, and using last version when
sending out actual
notifications.
>
> 2006/10/31, sergey@total-knowledge.com
> <mailto:sergey@total-knowledge.com> < sergey@total-knowledge.com
> <mailto:sergey@total-knowledge.com>>:
>
> > sergey@total-knowledge.com <mailto:sergey@total-knowledge.com>
> wrote:
> >> I think we may need something like person_preferences table to
> handle
> >> user
> >> preferences for
> >>
> >> 1. Prefered UI language.
> >>
> > Good point. Although this might be just a field in person_list
>
> IMO a new table may be better, since user may have many additional
> preferncies(email notifications for ordering, currency, the way UI
> displays certain UMOs/features, any kind of
> restrictions/limitations/preferencies for UMO he is an author of,
> etc).
>
>
> >> 2. Object change notifications/preferencies.
> >>
> > No, these are per-object-relation. Although you are right in that
> > the info is missing.
> >> Also we need to handle user types somehow, probably using
> user_types
> >> table.
> >>
> > There are no user-types as such. There are access kinds users
> > have to different objects. ACL tables handle that.
> >
> > --
> > Ilya A. Volynets-Evenbakh
> > Total Knowledge. CTO
> > http://www.total-knowledge.com
> >
> >
>
>
>
>
>
> --
> Alexey Parshin,
> http://www.sptk.net <http://www.sptk.net>
--
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com