NC65 自定义档案所涉及的表

最新推荐文章于 2023-02-07 18:24:51 发布

我是个假程序员

最新推荐文章于 2023-02-07 18:24:51 发布

阅读量479

点赞数

分类专栏： NC 文章标签： sql NC

本文链接：https://blog.csdn.net/u010741112/article/details/127638010

版权

NC 专栏收录该内容

354 篇文章 100 订阅

订阅专栏

NC65 自定义档案所涉及的表

--CJH=NC自定义档案定义code
--元数据_实体属性--
select * from md_property where md_property.classid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--元数据_字段映射表--
select * from md_ormap where classid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--元数据_组件--
select * from md_component where id in(select bpfcomponentid as id from bd_defdoclist where code in('CJH') union all select componentid as id from bd_defdoclist where code in('CJH'));
--元数据_实体类--
select * from md_class where id in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--元数据_业务接口映射--
select * from md_bizitfmap where classid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--元数据_实体关系--
select * from md_db_relation where md_db_relation.startattrid in(select STARTELEMENTID from md_association where md_association.startbeanid in(select pk_defdoclist from bd_defdoclist where code in('CJH')));
--元数据_业务接口属性映射--
select * from md_association where md_association.startbeanid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--自定义档案参照注册--
select * from bd_refinfo where para1 in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--自定义档案
select * from bd_defdoc;
--自定义档案列表--
select * from bd_defdoclist where code in('CJH');
--自定义档_业务插件注册_事件类型--
select * from pub_eventtype where sourceid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--自定义档_权限资源--
select * from sm_permission_res where mdid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));
--自定义档_管控模式--
select * from bd_mode_selected where mdclassid in(select pk_defdoclist from bd_defdoclist where code in('CJH'));