title: A Proper One-to-One Mapping Table
body: <p>I want to make a table that simply has two integer columns to serve as a mapping table between two different data sets and I wish to put the correct constraints on it.</p>
  
  <p>I initially set the two columns as a compound primary key, but then realized that represents a many to many, only keeping duplicate many to many mappings from occurring.</p>
  
  <p>How do I specify I want both columns to be unique integers in all rows?  I'm using MS SQL, but I suppose this is a general database design question.</p>