cleaned up customer and transaction relationships