title: Composite Unique Constraint SQL
body: <p>I have a table with parents and children, each record has a PRIMARY KEY id, a 'name', and a 'parent' that references another record's 'id'.</p>
  
  <p>Can I enforce UNIQUE constraint on the 'name' among records that share a 'parent'?</p>