title: Python sqlite3 generate unique identifier
body: <p>I am trying to add values to a 'pending application table'. This is what I have so far:</p>
  
  <pre><code>    appdata = [(ID,UNIQUE_IDENTIFIER,(time.strftime("%d/%m/%Y"),self.amount_input.get(),self.why_input.get())]
  
      self.c.execute('INSERT into Pending VALUES (?,?,?,?,?)', appdata)
      self.conn.commit()
  </code></pre>
  
  <p>I need to set a value for 'UNIQUE_IDENTIFIER', which is a primary key in a sqlite database.</p>
  
  <p>How can I generate a unquie number for this value?</p>
  
  <pre><code>CREATE TABLE Pending (
      ID          STRING REFERENCES StaffTable (ID),
      PendindID   STRING PRIMARY KEY,
      RequestDate STRING,
      Amount      TEXT,
      Reason      TEXT
  );
  </code></pre>