Re: [Phpgroupware-developers] integration addbook-accounts

[Michael Dean]

On Mon, 2003-06-23 at 18:25, Dave Hall wrote:
> Calendar uses them.  I think in the case of the proposed contacts schema
> auto increment keys are generally best.

Not for the cross reference tables.  You'd essentially be generating an
ID for the sake of generating an ID.  It serves no purpose in this case.

> > follow the phpgw style of category linking.  Each record gets a 
> > string field that
> > contains a cat_id number or a comma delimited list of cat_id 
> > numbers if multiple
> > categories are assigned (addressbook currently does this)
> 
> That is bad db design ... if there is a n:n relationship it should be in
> a seperate table.

Yup.

> This should be possible either through infolog or some other data
> linking mechanism.  Notes really don't belong in contacts ... imho

I think they do.  Contact management should be more than just a list of
contacts and their methods of communication.  Some go as far as tracking
spouses, family members, birthdays, etc for each contact.

This schema is meant to provide the foundation to build on for more
complex applications.

> I personally think this should be a 1:1 relationship with the id in the
> accounts table.  There should also be a flag in the contacts table to
> indicate the contact is a system user.  There is currently a
> contact_tpye (or something) field - this should be set to "u" for user
> or something.

Type should be an integer, so that makes this a little tricky to
implement.  What value do you see in marking a record as a user if you
already have that info on the account record?

Mike