织信自带的模型字典弹框,没有显示原始的字段名,不方便查询数据库,如下图所示:
其实,织信表字段的定义,都保存在表 t_application_define_object 中,我们可以通过一下SQL查出表字典信息:
SELECT A."scope" AS "表名", A."name" AS "中文名", A.ID AS "字段名", A.CONTENT ->> 'key' AS "标识符" FROM "public"."t_application_define_object" A WHERE A."scope" = 'ip7wplzmnbk57'
效果截图: