ummm, is there any thing wrong with using the Naming Convention devloped by Stan Leszynski and Greg Reddick, authors of Access 97 books?
Their conventions would creat this: tblNews intpkNewsID intfkUsersID datPosted varSubject txtContent blnBoolean tblUsers intpkUsersID intfkNewsID varName pk = primary key fk = foreign key The capitals are my preference. ----- Original Message ----- From: "Mike E" <[EMAIL PROTECTED]> To: "ryc" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, October 20, 2001 3:36 PM Subject: Re: Field Naming Standards > That seems to follow how I've been doing it as well. > > For example, consider this database set up: > > Table: news > Fields: > newsid int(10) > userid int(10) > dateposted datetime > subject varchar(255) > content text > > Table: users > Fields: > userid int(10) > name varchar(60) > > and on and on. I'd love to hear from some hard-core developers. Guys who > have been doing database development professionally for years. > > Mike > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php