Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Barbara,
Controversial or not, it sounds very useful and straightforward.
Thank you for your clear answer (as allways).
>Koos,
>You may find this starts a long and controversial thread. A couple of years ago Jim Nelson and someone else (can't remember who) had 'competing' articles in FPA on this subjec.
>
>We use a 2-letter prefix unique to each table in our apps and have found it extremely useful. One advantage is not having to repeat the table name in SQL-Select commands, and never running into fields with the same name. Another is that it helps us figure out code when we're updating or debugging apps we haven't worked on for a while.
>
>We use a 4-character code for all PKs - xxID (xx is the table prefix) and a 7-character code for all FKs, xx_ptID (xx is the present table prefix and pt is the parent table prefix). We also try to use the same field name (except for prefix) when we have 'matching' fields. For example a present app has 10 fields that are identical in Quote, OrderDetail and Estimate tables, and we use the same names in all 3 tables.
>
>Again, this is controversial and you'll have to figure out if it will work throughout your framework and team.
>JMHO
>Barbara
>
>
>>Hello,
>>
>>We are thinking in our shop to introduce a field naming convention that gives every table in each application a 2 letter code and that is the suffix for each fieldname, making all fieldnames unique.
>>
>>Anybody with ideas about (other) field naming conventions ?
>>
>>Thanks,
>>
>>Koos Veel.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement