Re: [Phpgroupware-developers] addbook module suggestions

[Ralf Becker]

Brian Johnson schrieb:
> I said I would offer some suggestions to simplify the database layout for
> the addbook module and here it is - aren't we all excited?
>
> I won't attach what I think is the relationship diagram again, just refer to
> my post from yesterday for that jpg
>
> Basically what I'm going to suggest is to get rid of the multiple tables
> with one to one relationships
>
> Here are the specifics:
> 1. add the fields from phpgw_addbook_pcontacts and phpgw_addbook_relation to
> phpgw_addbook_person_main
> 2. add the fileds from phpgw_addbook_ocontacts to phpgw_addbook_org_main
> 3. add a notes field for both people and orgs to catch any data that doesn't
> fit elsewhere
>
> This is an old thought that still applies:
>
> I think there is a need/use for an additional category system to allow
> multiple categories to be assigned to each person or organization and this
> would require an additional table.  

Why not using the system of addressbook, which alows multiple cat's per 
entry based on a comma-separated text-field of the cat-id's. This is 
easy to implement and does not need an other table (just changing the 
fieldtype to text).

> I could add my own, but it would be nice
> and convenient for data entry/editing if it were part of a module.  For
> sharing of data, it provides another way for other modules/progs to use
> queries to filter out what data they are looking for (eg in my engineering
> field, I could flag a building contractor as an industrial contractor, an
> institutional contractor, a commercial contractor, and a residential
> contractor if they do all of those types of projects - some do and some
> don't - and then I can create a query for commercial contractors when I want
> to do a mailout to invite them to tender a commercial building project for
> instance)
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers



--
----------------------------------------------------------------------
Ralf Becker
OUTDOOR UNLIMITED Training GmbH                Telefon 0631 / 31657-0
Leibnizstraße 17                               Telefax 0631 / 31657-26
D-67663 Kaiserslautern            EMail address@hidden