Naming columns ID is evil

When naming database columns my two pet peeves are fields called ID and field called date.

Renaming ID to [tablename]ID makes it clear when using it in code and SQL. It become obvious what it is the ID of.

Date. What date, yes it may be obvious now but naming it SavedDate or InvoicePostedDate is much more helpful.

This entry was posted in Uncategorized. Bookmark the permalink.