NC5X-NC6X-NCC开发常用数据表

元数据相关表

select * from dap_dapsystem 模块信息
select * from md_module where id='83cf74c7-2fa4-4e5f-a171-7aa3f2a44f54';--元数据所属模块信息
select * from md_class;--元数据实体表
select * from md_property;--存放元数的主子表属性及长度信息
select * from md_table;--元数据创建表的信息
select * from md_column where tableid ='bd_rack';--元数据表的列信息
select * from md_component  where id='83cf74c7-2fa4-4e5f-a171-7aa3f2a44f54';--存放模块下的元数据信息
md_accessorpara
md_bizitfmap
md_association
md_attr_busilog
md_attr_power
md_attr_table
md_bean_power
md_busiactivity
md_busiop
md_comp_busimodule
md_db
md_db_relation

常用开发表

select * from sm_busicenter;--查询系统账套表
select * from bd_refinfo ;--参照注册表
select * from pub_importregister;--数据导入注册信息表
select * from bd_userdefrule;--用户定义属性组表
select * from bd_userdefitem;--用户定义属性报表
select * from sm_pub_filesystem;--附件上传文档节点表
select * from sm_funcregister –功能注册;
select * from sm_paramregister –功能注册表体
select * from sm_menuitemreg –菜单
select * from bd_billtype –单据类型
select * from pub_billaction –单据类型动作
select * from pub_busiclass –单据动作插件注册
–模版信息
select * from pub_billtemplet –单据模版
select * from pub_billtemplet_b –单据模版表体
select * from pub_billtemplet_t –单据模版页签表
select * from pub_query_templet –查询模版表头
select * from pub_query_condition –查询模版表体
select * from pub_print_template –打印模版
select * from pub_print_cell –打印模版表体
select * from aam_appasset where dataid in (select pk_billtemplet from pub_billtemplet where pk_billtypecode = ‘1234567890’);
select * from aam_appasset where dataid in (select id from pub_query_templet where model_code = ‘1234567890’);
select * from aam_appasset where dataid in (select ctemplateid from pub_print_template where vtemplatecode = ‘1234567890’);
–模板分配基准表
select * from pub_systemplate_base where templateid in (select pk_billtemplet from pub_billtemplet where pk_billtypecode = ‘1234567890’);
select * from pub_systemplate_base where templateid in (select id from pub_query_templet where model_code = ‘1234567890’);
select * from pub_systemplate_base where templateid in (select ctemplateid from pub_print_template where vtemplatecode = ‘1234567890’);
–单据动作插件注册
select * from pub_bcr_nbcr where code in (select pk_billtypecode from bd_billtype where nodecode = ‘1234567890’);
–编码对象
select * from pub_bcr_RuleBase where rulecode in (select pk_billtypecode from bd_billtype where nodecode = ‘1234567890’);
–编码规则元素
select * from pub_bcr_elem where pk_billcodebase in (select pk_billcodebase from pub_bcr_RuleBase where rulecode in (select pk_billtypecode from bd_billtype where nodecode = ‘1234567890’));

 

后台任务表

SELECT * FROM pub_alerttype;--后台任务类型注册主表(存储后台任务注册类信息)
SELECT * FROM pub_alerttype_b;--后台任务类型注册字表(存储参数配置信息)

接口常用表

select* from opm_thirdapp;--OpenAPI 第三方系统注册表
select * from opm_apimanager;--OpenAPI 接口注册表
select* from opm_relateapi;--接口关联系统关系表
select * from opm_logmanager;--接口调用日志表

原文链接：https://blog.csdn.net/qq_38888284/article/details/115719693