Level 2: Naming Conventions and Data Types

Name tables and fields using Hungarian notation, camel case, no spaces, no symbols. Use the smallest possible data type.

  • tbl for Table
  • dtm for Date Time
  • bln for Boolean
  • txt for Text (fixed length)
  • mem for Memo/Varchar (any length)
  • int for Integer (0-255)
  • lng for Long (0-255+)
  • sng for Single (floating point)
  • dbl for Double (big floating point)
  • books table 
    book title 
    word count 
    release date 
    authors table 
    author website 
    series table 
    series name 
    events table 
    event name 
    event start date