[Vtigercrm-developers] understanding vtiger_entity2org

[Jens Hamisch]

Hi,


it can be assigned to more than one organization.
There is a 'primary' column in the entity2org table which defines the
primary organization - the one that really 'owns' the entity.


Jens


On Wed, May 09, 2007 at 01:42:40PM +0200, Enrico Weigelt wrote:
> 
> Hi folks,
> 
> 
> could anyone please explain what the table vtiger_entity2org 
> actually is for ?
> 
> As far as I understood it, we map the entities (ie. users are
> entities ?) to the organisation. 
> 
> Now I wonder if an entity can be associated to more than one
> organisation. If not, it's trivial to move that information
> directly to the entity's record and skip (maybe drop) this table.
> 
> 
> BTW: AFAIK we use the org's *NAME* here, not the (numerical) 
> ID or some unique ident. That's a really bad idea, ie. makes 
> changing the org name very, very complicated.
> 
> 
> cu
> -- 
> ---------------------------------------------------------------------
>  Enrico Weigelt    ==   metux IT service
> 
>   phone:     +49 36207 519931         www:       http://www.metux.de/
>   fax:       +49 36207 519932         email:     contact at metux.de
>   cellphone: +49 174 7066481
> ---------------------------------------------------------------------
>  -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
> ---------------------------------------------------------------------
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com 

-- 

--------------------------------------------------------------------------------

         s t r a w b e r r y      e d v - s y s t e m e      g m b h

     SSSSSSSSS       Am Flosskanal 7            Jens Hamisch
   SSSSSSSSSSSSS     D-82515 Wolfratshausen     Geschaeftsfuehrer/CEO
  SSSSS-----SSSSS                               
 ---SSSSS---------   fon (+49 8171) 41805-0     
 -----SSSSSSS-----   fax (+49 8171) 41805-59    
 ---------SSSSS---   info at strawberry.com        jens.hamisch at strawberry.com
  SSSSS-----SSSSS                               mobil: (+49 172) 8104162
   SSSSSSSSSSSSS     Geschaeftsfuehrer/CEO      
     SSSSSSSSS       Jens Hamisch               
  
   a g   m u e n c h e n   H R B   9 3 2 8 7  -  D E   1 2 9  4 6 7  5 1 8