RE: [Fwd: Re: PIM Schema ideas]

Philip,

The problem I have with the scheme is the presence of the name string in the
person table. I might want a more sophisticated name scheme (e.g., title,
first, middle, last, suffix). The "name" might the "display name", I
suppose.

What we're saying, essentially, is that the person table's role is to
provide a unique id to key into the person_attr table.

I'm wondering if there should be an attributes table that provides the
attribute ID (local to this database), attribute identify code (global!),
attribute display name, and attribute properties. That eliminates the
hardcoded attribute values, and allows new programs to register new
attributes.

        --- Noel
Received on Thu Jun 06 2002 - 14:55:02 EDT