1)Columns, Indexes and Constraints – Keys end in ID (e.g UserID), use audit columns when appropriate, like – Created Date, Created By, Updated Date and Updated By. 2)Indexes are named to indicate the table they are attached to and the purpose
Read this post on makdns.blogspot.com