[OGo-Developer] Database layout?

[Helge Hess]

On Nov 13, 2006, at 12:45, Jan Kesten wrote:
> But therefore I need to understand how OGOs database is organized
> (especially for contacts). Is there any documentation about this?

There is this auto generated thing:
   http://www.opengroupware.org/en/devs/resources/db/

otherwise the structure should be mostly self explanatory?


Basically there is a table 'company' which has three relevant views:
   'team'
   'enterprise'
   'person'
(views implemented using derived tables in PostgreSQL ...)

Further the company has associated tables:
   'address'
   'telephone'
   'company_value'
The latter stores the extra attributes (which includes email1 for  
company records).


Thats about it. Of course you might consider using XML-RPC or  
GroupDAV for synchronization though hacking at the low level also has  
its advantages.

Feel free to ask more specific questions.

Greets,
   Helge
-- 
Helge Hess
http://docs.opengroupware.org/Members/helge/