Re: For those interested in the CRM/Entity management

["Joshua D. Drake" <..hidden..>]

Ed W wrote:
> Hi
>
> > Ok, I look at normalization as a mathematical method of ensuring that
> > the data can represent anything it needs to.

> Address should probably be nomalised out of the entity in order to allow 
> having multiple addresses per entity (eg two delivery addresses)

Addresses (locations in the model) are completely separated from 
everything already :)

Joshua D. Drake

> How does this sound?  We probably don't want this to get 
> overcomplicated, hence the suggestion just to duplicate records when 
> they are changed and hide the old records so that they don't normally 
> show up (but are available to be referenced by old invoices)
>
> Sound sensible?
>
> Ed W
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/