changed provider/client type column to be rails friendly