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'));