Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field naming conventions
Message
De
18/02/2008 17:09:10
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01293572
Message ID:
01293619
Vues:
17
>As a preference... in your field names... do you include the type as part of the description...? even if you are using Hungarian notation...? such as...
>
>tstarttime vs tstart
>dduedate vs ddue

I have seen one system where a two-letter prefix was used, to indicate the table name.

I think I have also seen recommendations, to have the first letter indicate the type, like dBirthday, nAge, etc.

But personally, I don't use any of this; I just try to give the fields meaningful names.

The first field is always the same as the table, and is named the same as the table (or sometimes an abbreviated version).

If a field represents a foreign key, I usually try to give it the same name as the primary key field in the other table. Note that this is not always possible: sometimes a table may have two or more foreign keys to the same table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform