[Vtigercrm-developers] organization ident

[Enrico Weigelt]

Hi folks,


I've found an big-fat problem with the organization modeling in 
the DB:

The org is always referenced by its name !
To be clear: its the *printable* name, which appears for example
on the bill.

So now it's clear, why it cannot be changed in the settings ;-O

It appears the name is also abused as ident, which is the key
problem. There's no additional ID here.

To fix this, we have two options: 

a) Add an numerical ID to the organization table and fix all the
   schema to reference on that. This would probably be the most
   clean model, but requires much care on schema updates.
   
b) Add an new text field (ie. "official_name") which now carries
   the actual *name* (ie. for printing on the invoice) and leave
   evrything else untouched. Nearly trivial to implement, but maybe
   not very clean design.



Comments ?

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 --
---------------------------------------------------------------------