Alright, addToLocalTableWithData method renamed to setSQLiteTableWithData per Willie's request. It can insert/update any combo of columns/fields/values into any table. Also added a unit test that inserts and updates patients and patient records.
SQLite: Fixed foreign keys

Something happened between today and Sunday…lost several foreign key
constraints, added them back