changed DB to reflect appropriate aspects of pivot