NCCloud开发-开发内容导出部署相关

导出涉及的常用表

----------------------------元数据--------------------------
--名称空间 
select * from md_module where  id='dqy'; 
select * from md_component where namespace = 'dqy'; --组件
select * from md_table where  resmodule in( select name from md_component where namespace = 'dqy');--表
select * from md_class where componentid in ( select id from  md_component where namespace = 'dqy' ); --表、类
select * from md_accessorpara where ( paravalue  like 'nc.vo.dqyyx_%'); --聚合vo
select * from md_property where ( classid in ( select id from md_class where componentid in ( select id from  md_component where name like 'dqyyx_%' )));--字段
select * from md_column where tableid in ( select defaulttablename from md_class where componentid in ( select id from  md_component where name like 'dqyyx_%' ) ); --字段
select * from md_ormap where  tableid in (select id from  md_table where  resmodule like 'dqyyx_%');--字段
select * from md_db_relation  where endtableid in ( select defaulttablename from md_class where componentid in ( select id from  md_component where name like 'dqyyx_%' ) );  --关联
select * from md_association where componentid in ( select id from  md_component where name like 'dqyyx_%' );--关系（参照字段？）
select * from md_bizitfmap where ( classid in ( select id from md_class where componentid in ( select id from  md_component where name like 'dqyyx_%' )));--业务接口
select * from md_enumvalue

----------------------------------注册脚本--------------------------
-- 模块
select * from dap_dapsystem where moduleid like 'DQ%';
select * FROM sm_funcregister WHERE funcode like ('DQ%'); --功能注册
select * FROM sm_paramregister p WHERE p.parentid in (select f.cfunid  FROM sm_funcregister f WHERE f.funcode like 'DQ%' ); --功能注册-参数
--select * from SM_BUTNREGISTER b WHERE b.parent_id in (select f.cfunid  FROM sm_funcregister f WHERE f.funcode like 'DQ%'); --功能注册-按钮注册
select * FROM sm_menuitemreg WHERE funcode like 'DQ%'; --菜单
select * FROM bd_billtype WHERE pk_billtypecode like 'DQ%'; --单据类型
select * from bd_fwdbilltype where pk_billtype='20' ;--单据类型_下游单据类型 例如查询请购单20的下游单据类型
select * from pub_billaction where pk_billtype like 'DQ%'; --单据动作注册
select * from pub_busiclass where pk_billtype like 'DQ%'; --单据动作注册
select * from pub_bcr_nbcr where code like 'DQ%'; --单据号
select * from pub_bcr_RuleBase where nbcrcode like 'DQ%'; --单据号
select * from pub_bcr_elem where pk_billcodebase in (select pk_billcodebase from pub_bcr_RuleBase where nbcrcode like 'DQ%'); --单据号
select * from pub_billtemplet where nodecode like 'DQ%'; --单据模板
select * from pub_billtemplet_b where pk_billtemplet in (select pk_billtemplet from pub_billtemplet where nodecode like 'DQ%');
select * from pub_billtemplet_t where pk_billtemplet in (select pk_billtemplet from pub_billtemplet where nodecode like 'DQ%');
select * from pub_query_templet where node_code like 'DQ%'; --查询模板
select * from pub_query_condition where pk_templet in ( select id from pub_query_templet where node_code like 'DQ%' );
select * from pub_print_template where vnodecode like 'DQ%'; --打印模板
select * from pub_print_cell where ctemplateid in (select ctemplateid from pub_print_template where vnodecode like 'DQ%');
--select * from aam_appasset where pk_module like 'DQ%';

select * from pub_systemplate where funnode like 'DQ%'; --默认模板
select * from pub_systemplate_base where funnode like 'DQ%'; --默认模板