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'. Thanks in advanced. Best Regards Andrew. ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181817 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
Re: OT: Field Naming
Andrew Dixon wrote: 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'. None that I know of, but what I do is use plural in general for the table names, e.g. categories, posts. After all, we are talking about sets here, and it's natural to pluralise them. Fields I give the singular form to, so the projects would have a field called project_id. The reasoning being that whereas the set contains many projects, hence the pluralisation, each tuple refers to just one, so it's singular. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://www.digital-crew.com/ ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181824 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
Re: OT: Field Naming
After a quick search on Google I found this: http://www.ss64.com/orasyntax/naming.html Which seems like a good little guide. It mentions an ISO standard (ISO11157) but I had a quick look at this and this appears to be a more general standard for data type naming. Andrew. On Tue, 19 Oct 2004 14:11:15 +0100, Keith Gaughan [EMAIL PROTECTED] wrote: Andrew Dixon wrote: 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'. None that I know of, but what I do is use plural in general for the table names, e.g. categories, posts. After all, we are talking about sets here, and it's natural to pluralise them. Fields I give the singular form to, so the projects would have a field called project_id. The reasoning being that whereas the set contains many projects, hence the pluralisation, each tuple refers to just one, so it's singular. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://www.digital-crew.com/ ~| 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:181825 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
Re: OT: Field Naming
Andrew Dixon wrote: 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. Does the client have other databases? Which convention do they use? Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181833 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
Re: OT: Field Naming
Hi Jochem. No. They have no other database at the the moment. At the moment all the data is keep in a strange series of Excel sheets which has become unmanageable (I'm attempting to decipher at the moment). The reason I asked the question was because in a recent meeting with them one of them asked if there was a standard naming convention we could use, you know what government people are like, love their standards and conventions!!! Andrew. On Tue, 19 Oct 2004 16:08:54 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Andrew Dixon wrote: 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. Does the client have other databases? Which convention do they use? Jochem ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181836 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
Re: OT: Field Naming
Andrew Dixon wrote: No. They have no other database at the the moment. At the moment all the data is keep in a strange series of Excel sheets which has become unmanageable (I'm attempting to decipher at the moment). The reason I asked the question was because in a recent meeting with them one of them asked if there was a standard naming convention we could use, you know what government people are like, love their standards and conventions!!! What is supposed to be stored in the database? There might be some standard that deals specifically with the type of information you have to work with. For instance, OASIS has compiled a nice list of different address information standards: http://www.oasis-open.org/committees/download.php/176/na_initiatives.pdf There are other lists for other types of information. Jochem ~| 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:181840 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