Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Design and iid Primary Key Naming Convention Options
Message
From
18/02/2000 12:04:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Table Design and iid Primary Key Naming Convention Options
Miscellaneous
Thread ID:
00334139
Message ID:
00334139
Views:
67
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?
Next
Reply
Map
View

Click here to load this message in the networking platform