many changes made as I am learning how to work with the databases. need to start using branches in git. for now, this is a bit messy. correct in the future.