title: Schema for a table in informix
body: <p>I have to design schema for a database table.</p>
  
  <p>It goes like :</p>
  
  <pre><code>     field1 is TRUE/FALSE
       field2 is TRUE/FALSE
       field3 is TRUE/FALSE
       field4 is TRUE/FALSE
       field5 is char(50)  if field4 is TRUE
  </code></pre>
  
  <p>Can someone suggest an optimal schema for this kind of table.</p>
  
  <p>I am using Informix database.</p>