title: Relational table naming convention
body: <p>I'm starting a new project and would like to get my table- and column names right from the start. For example I've always used plural in table names but recently learned singular is correct.</p>
  
  <p>So, if I got a table "user" and then I got products that only the user will have,
  should the table be named "user_product" or just "product" ? This is a one to many relationship.</p>
  
  <p>And further on, if i would have (for some reason) several product descriptions for each product, would it be "user_product_description" or "product_description" or just "description"? Of course with the right foreign keys set.. Naming it only description would be problematic since i could also have user description or account description or whatever..</p>
  
  <p>What about if i want a pure relational table (many to many) with only two columns, what would this look like? "user_stuff" or maybe something like "rel_user_stuff" ? And if the first one, what would distinguish this from, for example "user_product"?</p>
  
  <p>Any help is highly appreciated and if there is some sort of naming convention standard out there that you guys recommend, feel free to link.</p>
  
  <p>Thanks</p>