【泛微E9】修改表单字段类型，将[附件上传-上传文件]修改为[附件上传-上传图片]

根据字段名查到该字段所在的所有表

-- MYSQL
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME = 'bhgxtpsc';

对比可知，附件上传 type = 1，图片上传 type = 2

SELECT * FROM workflow_billfield WHERE ID = 12749UPDATE workflow_billfield SET TYPE = 2 where id = 12749

执行完 UPDATE 语句，清空缓存即可。