Clearly combining multiple descriptions with type codes into a single table as your example evolved to would be a terrible practice unless it was a single step in a migration...