Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Design and iid Primary Key Naming Convention Options
Message
De
18/02/2000 12:04:21
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Titre:
Table Design and iid Primary Key Naming Convention Options
Divers
Thread ID:
00334139
Message ID:
00334139
Vues:
69
In the new application MMs Quick Start produces, it appears that Oakleaf recommends using iid as the field name for the primary keys in tables. There are however, at least three options I know of;

1. Use iid, as is the case in many of the MM's new application tables.
2. Use i[table abbreviation]id.
3. Use iid[table abbreviation].

There are advantages and disadvantages to each option.

Options two and three have the advantage that a developer can look at the table will see a 'standard' id field name to use in tables that relate to it.
Example: Company.DBF would have iidCo field, so when looking for a field to use to relate to this table, one looks at the Company.DBF and instantly sees that the iidCo 'standard' field name is the one to use.

What are the advantages to using 1. iid as the naming convention option?

Which option would you recommend using?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform