Re: EOF and meaningful, modifiable PKs
Re: EOF and meaningful, modifiable PKs
- Subject: Re: EOF and meaningful, modifiable PKs
- From: Hugi Thordarson <email@hidden>
- Date: Thu, 29 Jul 2010 09:52:48 +0000
>>> User. Modifiable. PK. WTF?!!? Icelandic banking systems? :-P
>>>
>>
>> I wish - unfortunately it's the Icelandic Vehicle Registry, meaning *I* have to fix this :).
>
> You need to expand your definition of "fix"
> A re-architecting from the DB up is also a fix in my book.
That would indeed be my first choice, but unfortunately there are tons of legacy systems using the DB, and it will take 3-5 years to phase them all out. This means the WO system will have to coexist with them for a while.
One option I considered was to design an entirely new DB for the WO systems to talk to and keep it in sync with the old DB using triggers. But due to the size of the DB, this would be a huge undertaking.
> The good news is that you can use booleans for the PKs/FKs since that should cover both cars.
ROFL!
- hugi _______________________________________________
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