added DB views for compatibility with existing API code