Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Keys: surrogate or composite??
Message
From
27/03/2000 21:10:08
 
 
To
27/03/2000 21:01:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00348623
Message ID:
00351182
Views:
27
Mike,

>>Why? If "pk" is an attribute of Entity, isn't it redundant to name it pkEntity?
>
>Maybe, but what happens if you've got a list of field names with no Alias? You'l;l be able to see the relationship in pktable and fktable faster than pk and fktable. Its more "self documenting", in some situations, and easier to say verbally if it applies. IMO

But your approach also means a bit more complexity in your framework code for assigning pk's generically.

Welcome back, BTW.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform