Hi Andrew Based purely on ituition / gut feel / experience, I never name a table as its plural, always singular form, so Project table, not Projects table.
Sorry I know of no published field naming standard, but do something similar to what you have suggested. Aaron ----- Original Message ----- From: "Andrew Dixon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 19, 2004 9:30 PM Subject: OT: Field Naming > Hi Everyone. > > I'm just starting a major project for a government client and the > first job is to design the database. Is there any recongnised > convention on the naming of database fields. In the past I have always > named them [table_name_field_name] for example: projects_id where the > table is called 'projects' and the field is called 'id'. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181820 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
