Isn't a set singular? So a set refers to one set such as a table containing People, but more than one set (sets - plural) would be like People and Organization (two sets).
So a table name should be singular using the set reference :P -----Original Message----- From: [EMAIL PROTECTED] Date: 10/19/04 9:28 am To: CF-Talk Subj: RE: Field Naming As said there is no definitive but here's my two pennies worth. >> After all, we are talking about sets here, and it's natural to pluralise them. My old database teacher would have a fit with that... but each to their own :) We use two words to describe (and name) each table An example here would be TABLE: PROJECT_DETAIL COLUMN: PD_ID, PD_NAME... etc The column name is collapsed two a two letter prefix, not actually came across a time when their was a duplicate prefix within a schema but I'm sure if it happened you could use a different Anyways... -- dc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181860 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
