Naming columns ID is evil

6/12/2011

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.