title: Database/SQL: Is attribute/key name for table unique?
body: <p>In database, can I use the same attribute name for multiple tables, but the description of the attribute name are not necessary the same?  For example, i have the following tables for a furniture store:</p>
  
  <pre><code>Table1(itemID, type)
  
   - type = car, tv, furniture
  
  Table2(custID, type)
  
   - type = new member, vip    
   - I know I could re-name "type" to something like membership_type, but for this example, let's assume the above is the attribute name that I'm using.
  </code></pre>
  
  <p>Can I use type as an attribute name in both table?</p>
  
  <p>Just like the above, in SQL, are key names unique?  Can I use the same key name for multiple tables, but have different use for that key name?   </p>