Re: pim schema

Originally somebody proposed both adressbook and calendar
categories/groups and i didn't see whey they shouldn't be merged into a
single scheme.

you are right categories might be a more accurate (although
unfortunately longer... name)

the relational model gpe_person_groups does imply that one person can
belong to more than one group.

owen

On Fri, 2002-04-19 at 22:44, digger vermont wrote:
> Hello All,
> I have some questions about the schmema. It could be that I just don't
> understand how it works..
>
> In general are groups what I might call a category?
>
>
> And then, there is:
>
> create table gpe_groups(
> id int NOT NULL,
> name text UNIQUE,
>
> Is gpe_groups what I had called a Profile (Nils called a
> global_category)?
>
>
> And further down:
>
> create table gpe_person_groups(
> person_id int NOT NULL,
> group_id int NOT NULL,
> PRIMARY KEY(person_id,group_id)
>
> Is this where a person is put into a global_category/profile?
>
> If so can a person belong to more than one profile if group_id is an
> integer?
>
> digger
>
> _______________________________________________
> GPE mailing list
> GPE_at_handhelds.org
> http://handhelds.org/mailman/listinfo/gpe
>
>
Received on Fri Apr 19 2002 - 22:43:26 EDT