implemented new database schema and single table inheritance. fully functional, however there are still a number of issues resulting from the changes in schema and expansion in functionalities.