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

Re: For those interested in the CRM/Entity management

Ed W wrote:

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.
Ledger-smb-devel mailing list


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

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