title: Data model: Having separate table for a field vs having it as a column in the main table
body: <p>We have a scenario where we want to store the 'status'(say of a 'user')</p>
  
  <p>We want to impose restriction for the allowed values of 'user' status.</p>
  
  <p>So we considered two alternatives:</p>
  
  <ol>
  <li>Have 'status' as a column of enumeration type in the 'user' table</li>
  <li>Have a separate table for 'status' and populate with the allowed values during DB initialisation and have it as foreign key in the 'user' table.</li>
  </ol>
  
  <p>Can you suggest which is a better approach and why
  Appreciate if references are shared on what is the best practice </p>