The are so many options on which styles to follow, the approach I recommend is to pick a something, document it and follow your document.
For my clients that I do database design work for, as part of the deliverable, I give them a copy of the style guide we used to develop the database. If you want to see the style guide we use, it is included with the documentation for CFSQLTool. To get you started, you may wish to take it and modify to meet your needs. I make no claims as to if it best or better practice, just that it works good for us. There is no separate download for the style guide, but if you download the tool, ( http://www.switch-box.org/CFSQLTool/Download/ ) unzip the file and look in the docs folder you will find the file docs_Databases_Style_Practices.cfml Create Table Pajamas, Joseph ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181894 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
