RE: [Fwd: Re: PIM Schema ideas]

From: Philip Blundell <pb_at_nexus.co.uk>
Date: 06 Jun 2002 16:02:25 +0100

On Thu, 2002-06-06 at 15:54, Noel J. Bergman wrote:
> 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.

I actually had in mind that the "name" field would be encoded using some
kind of mangling scheme like the vCard one. Splitting it up into
separate SQL fields would be an equally reasonable thing to do, though.

> 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.

Yeah, that might be a good idea.

p.
Received on Thu Jun 06 2002 - 15:02:40 EDT

This archive was generated by hypermail 2.2.0 : Mon Jul 25 2005 - 17:19:00 EDT