added model definitions for the database.
renamed a column.
fleshed out more unit tests, including a base test class for the database.