UPDATE Unit INNER JOIN UnitType
    ON Unit.`UnitType_unit_type_id` = UnitType.`unit_type_id`
SET Unit.notes = UnitType.unit_type;

UPDATE Space INNER JOIN SpaceType
    ON Space.`SpaceType_space_type_id` = SpaceType.`space_type_id`
SET Space.notes = SpaceType.`space_type`

UPDATE Appliance INNER JOIN AppType
    ON Appliance.`AppType_app_type_id` = AppType.`app_type_id`
SET Appliance.notes = AppType.`app_type`