title: How to build a category table
body: <p>Sorry for the not so great title, but I'm curious how people build a category table in SQL given the following example</p>
  
  <p>Two columns: 
  ID,
  CATEGORY</p>
  
  <p>Which of these ways would you name the columns?</p>
  
  <p>ID,
  CATEGORY</p>
  
  <p>ID,
  DESCRIPTION</p>
  
  <p>CAT_ID,
  CAT_DESC</p>
  
  <p>Or something else?  Just wondering what other people do.  Sorry if this is less than clear.  I hope it's worth answering because feedback would be great.</p>