adds percentage by category, adds pairings table and remodels associations.