sqlite - Android - Best practice for showing join select in ListActivity -

i'm working on listactivity app 1 table:

- commands   - _id   - name   - url   - ... 

so far success/failure flag added "on fly" , responses not stored. if restart app or change orientation, responses cleared. i'd able retrieve past responses specific command new activity.

i'm thinking of adding second table storing responses:

- responses   - _id   - command_id (foreign key)   - success (true/false)   - ... 

at moment use simple pojo (i'll add setters , getters asap):

public class command {    public long id;   public string name;   public string server;   public string url;  } 

my customadapter working arraylist<command>. i'm thinking of subclassing command adding fields show on listview (success/failure flag, date when command sent) retrieved join select between commands , responses tables.

commands , responses have separate datasources classes opening/closing db, inserting, editing, removing , selecting. customadapter work on new subclass of command.

what think?