def METHOD_NAME():
    op.drop_constraint(
        "weather_sensor_type_display_name_key", "weather_sensor_type", type_="unique"
    )
    op.drop_constraint("asset_type_display_name_key", "asset_type", type_="unique")
    op.drop_constraint("market_type_display_name_key", "market_type", type_="unique")
    op.drop_column("weather_sensor", "display_name")
    op.drop_column("weather_sensor_type", "display_name")
    op.drop_column("asset_type", "display_name")
    op.drop_column("market_type", "display_name")
    op.drop_column("weather_sensor", "unit")
    op.drop_column("asset", "unit")
    op.alter_column("market", "unit", new_column_name="price_unit")