[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: For those interested in the CRM/Entity management



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/