<body><iframe src="http://www.blogger.com/navbar.g?targetBlogID=8010254895780061626&amp;blogName=lifeofbrian.org&amp;publishMode=PUBLISH_MODE_FTP&amp;navbarType=BLUE&amp;layoutType=CLASSIC&amp;homepageUrl=http%3A%2F%2Fwww.lifeofbrian.org%2Fblog%2F&amp;searchRoot=http%3A%2F%2Fblogsearch.google.com%2F" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" height="30px" width="100%" id="navbar-iframe"></iframe> <div id="space-for-ie"></div>

lifeofbrian
.
org

It's all in the name
2007-10-05

When designing a schema for a database, always remember to be consistent with naming conventions, especially:Additionally, consider using join tables or enums rather than char fields if there are very few options which may pertain to a given column.

Lastly, keep your names case consistent. Databases you may be working with are most likely case sensitive to table names and or column names.

This all has recently come to light given some assignments that have graced my plate in recent weeks.

Labels: , ,

posted by Brian Mansell @ 3:29:00 PM,  




0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home