This is something that tends to come down to personal preference everytime and is different with dang near every developer.
What I like for DBs is the table name, events and then the column name and type them if possible for ease of use. So you could have Table name: Events Columns: events_ID, events_dtStart, events_dtEnd, events_info, event_bOutside Or Columns: eventsID, dtEventStart, dtEventsEnd, eventsInfo, bEventsOutside This can depend on if you want the underscores for readability or not. Without the underscores it tends to be easier to read with the type then in front of the whole field. Just my two cents, t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----Original Message----- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 10:53 AM To: CF-Talk Subject: general question about naming conventions So, a general question, When dealing with databases, how do you name your columns? Example: Table Name: Events Column(s): Start, End, Info Would you name it like this (a)Start, End, Info (b)eStart, eEnd, eInfo (c)cStart, cEnd, cInfo (d)or something completely different (the c stands for column) This doesn't have to be answered over the list, private email is good too. Just curious as to what others do. -------------------------------------- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Question: "What is the first thing you notice about a person?" "Whether or not they're on fire." - Weird Al Yankovic FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
