Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opinions on a table name please...
Message
De
13/05/2010 23:36:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
13/05/2010 23:04:36
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
Database:
Visual FoxPro
Divers
Thread ID:
01464518
Message ID:
01464520
Vues:
64
>I have a table of child items (raw steel, bolts, tubing, paint, structural steel pieces, misc hardware, etc.) that we order from vendors through Purchase Orders and charge each item to a particular Job.
>
>Therefore, each record in this table is linked to both the Jobs table and the PurchaseOrders table by a separate foreign key for each. It’s link to each of these parent tables is equally important, and I cannot see how it is more related to one than the other.
>
>What should be the NAME of this child table?
>
>.

I would also call it JobsOrders, unless you come up with a better, succinct, description of the purpose of the table. For example, perhaps the description of the table is "This table stores information about how purchase orders are assigned or charged to different jobs" (you decide whether this accurately describes the purpose of the table or not!), you can use some of the words which I put in bold for the table name, which gives you one of the following alternatives: OrderAsignment, OrderCharge, OrderJobs.

In the above general description of the table I may have missed the point completely, but the point is to get some description of what the table does, and then either use some key words from that descrition (not words like "information" or "store" that apply to any table!), or alternately, if the table joins two other tables, use parts of the two table names for the join 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