RE: pim schema

In point of fact, it appears to be a general grouping facility. If one were
so inclined, one could put Calendar items, Contact items, and other PIM
items into a group. Not with the current schema, but in concept. We'd have
to extend the schema to implement this in actuality.

This could be quite useful. I could search for all PIM items associated
with a group, which might be (for example) a particular event.

        --- Noel

-----Original Message-----
From: Owen Cliffe

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.

On Fri, 2002-04-19 at 22:44, digger vermont wrote:
> 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,
>
> And further down:
>
> create table gpe_person_groups(
> person_id int NOT NULL,
> group_id int NOT NULL,
> PRIMARY KEY(person_id,group_id)
>
> If so can a person belong to more than one [group]?
Received on Fri Apr 19 2002 - 23:40:25 EDT