Re: [Phpgroupware-developers] Account/Address DB proposal

[Brian Johnson]

I hope we can move towards a shared schema in the future (I think I've 
made my wishes to work with dcl clear)

In the meantime, there are a couple of shortfalls with the both the 
phpgw and dcl schema that review of the probiz one has brought to light

The major issue is that for a multilocation company, there is currently no 
way to track which location an employee works at (the employee just links 
to the company, not a specific office of that company)

Also, for a multi-location company, some information will be shared among 
all the locations (ie phone, toll-free, main fax line, etc) and some will 
be location specific (ie each branch location has a local phone number)

I'm really wondering if we should dump the multi-location addresses 
concept for companies only (since people could still have multiple 
residences without getting into this issue) and have the user create a new 
company record for each location.  It is somewhat un-normallized but it 
greatly simplified

Their schema included relationships to track spoken languages of the 
people that I don't know how useful it is (it is of no use to me) but 
could be considered as a future added feature

They also create a n:n relationship between companies and company 
departments and departments and employees that might be worth considering 
for future inclusion (again I don't need this but other might .. I would 
prefer just a string field .. one per person, if they are linked to a 
company)



On 7 Jul 2003, Michael Dean wrote:

> I've followed the thread, but dropped out of discussion because the
> schema was completely tanked.  It was not a concept schema - it already
> has code behind it and is in use AFAIK.  I made my points, it wasn't
> accepted, so I have nothing else to add.
> 
> The DCL/GNUe definition of the contact schema will not change from the
> original, with the exception of renaming the accounts to orgs (since it
> confuses everyone) and adding a configurable contact method schema
> (Jabber, ICQ, etc).
> 
> On Mon, 2003-07-07 at 14:31, Alex Borges wrote:
> > El lun, 07-07-2003 a las 09:15, Brian Johnson escribió:
> > > Some is good, some can be handled by current proposal (if provided for in 
> > > ui), and
> > > some I don't understand it's purpose/need
> > > 
> > > IMO, we should work in conjunction with mdean of dcl to develop a new db 
> > > model for
> > > both projects since dcl is part of gnu enterprise
> > > http://www.gnu.org/software/gnue/project/what.html
> > 
> > I thought we did that. Mike is shure reading all of this.
> > 
> 
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>