title: Getting the type of a column in SQLite
body: <p>My mate made the database for my Android app. For example, one of the tables is created like this:</p>
  
  <pre><code>CREATE TABLE table1(
      id_fields_starring INTEGER PRIMARY KEY AUTOINCREMENT
      , fields_descriptor_id INTEGER NOT NULL
      , starring_id INTEGER NOT NULL
      , form_mandatory INTEGER NOT NULL DEFAULT 1
      , form_visible INTEGER NOT NULL DEFAULT 1
      , FOREIGN KEY(fields_descriptor_id) REFERENCES pr_fields_descriptor(id_fields_descriptor) ON DELETE CASCADE ON UPDATE CASCADE
      , FOREIGN KEY(starring_id) REFERENCES starring(id_starring) ON DELETE CASCADE ON UPDATE CASCADE
  )
  </code></pre>
  
  <p>From the fields of a table I need to know which of them is <code>INTEGER NOT NULL</code> and which is <code>INTEGER NOT NULL DEFAULT 1</code>, because for the first case I must create dinamically an <code>EditText</code> and for the second case I must create a <code>CheckBox</code>. Any idea?</p>