finished creating models for database and created views to use them