rough plan of schema, have started building the tables, see ipython notebook