title: Can primary key in one table appear in another table as primary key as well?
body: <p>I'm sorry for the rather stupid question. 
  For example, can one table have composite primary key consisting of <strong>'user_id'</strong> and 'employee_id'</p>
  
  <p>and another table containing <strong>'user_id'</strong> as primary key?</p>