Re: [Phpgroupware-developers] integration of admin-addressbook-calendar-HR

[Michael Dean]

On Mon, 2003-06-16 at 23:56, Brian Johnson wrote:
> I took a look at: http://www.gnue.org/~dneighbo/fsf/datadictionary.html
> and couldn't understand how a company gets referenced to a person

dcl_account_contact - many-to-many relationship

> 
> Also, although I like the fact that you allow muliple emails, phones, etc per
> person, wouldn't it be cleaner to combine those tables and have only one 
> "type"
> table and one table for those values?

Again - larger installations over time will benefit from not throwing
everything into one table.

> Lastly, is it necessary to have creation & modification time stamps for every 
> bit of
> data?

Yup - it acts as an extra piece of audit information and can be used for
distributing the data (for example, to handhelds via sync).

Mike