Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Keys: surrogate or composite??
Message
De
27/03/2000 21:10:08
 
 
À
27/03/2000 21:01:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00348623
Message ID:
00351182
Vues:
28
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform