Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opinion On Surrogated Key Requested
Message
From
04/09/1997 12:51:32
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapore
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Opinion On Surrogated Key Requested
Miscellaneous
Thread ID:
00048536
Message ID:
00048536
Views:
66
I am using surrogated keys for some of the transaction tables but couldn't decide whether to use surrogated keys for all the tables with persistent relationship or not. I couldn't see the advantages in some cases. I need some advice.

For example, in invoice table, I can choose to relate to the currency table via a currency code or the surrogated currency key. The currency table has currency description and a recommended exchange rate. Using a currency code, I don't need to refer to the currency table during invoice search because the code itself is meaningful enough. Why would I use surrogated key? One advantage I can think of is to allow my user to ammend the currency code, maybe from 'US$' to 'USD'. Other than that, I can't think of any. Another example is if I want to group the journal transaction. I keep a journal type table for that. It consists of journal type and journal type description. Is it recommended to keep surrogated key for this kind of table?

Can I have some opinions on this? What is the usual practice?
Reply
Map
View

Click here to load this message in the networking platform