Little help with a Db design quesiton
Little help with a Db design quesiton
- Subject: Little help with a Db design quesiton
- From: Gustavo Pizano <email@hidden>
- Date: Mon, 16 Nov 2009 12:22:52 +0100
Hello all.
I know this is off topic, but you guys have helped me in the past with such a questions, so I hope Im not bothering anybody.
Im building a Invoicing app, so I have my EOModel and this is what I have.
Person:
Client: Parent is Person
User: Parent is Person.
Person < >> Address (toAddress)
Invoice << > User (toUser)
Invoice<< > Client (toClient)
InvoiceItem<< >> Invoice
InvoiceStatus< >> Invoice
now... what happens if the Person changes address?, it will change the address of all already created invoices, which for record purposes its not allowed, it think. (I mean my already created invoices should stay as they where created)
So is it correct to add a relation from Invoice << > Address ?, so when I add a new address to Person the invoice will kept the old address. right?
how can I avoid when modifying the address, if I do this, then the invoice toAddress will change also.
Thanks
G. _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden