NC57开发部署涉及到的表

--公共参数

select * from pub_sysinittemp where initcode in ('SO100');

select * from pub_sysinit where pub_sysinit.sysinit in (select pk_sysinittemp from pub_sysinittemp where initcode in ('SO100'));

--系统注册

select * from sm_funcregister where (fun_code like '2006030102%') ; select * from PUB_SYSTEMPLATE where (funnode like '2006030102%'); select * from sm_butnregister where (fun_code like '2006030102%'); --公司建账

select * from sm_codetocode where funccode = 'yhzhwh' order by ts desc; select * from sm_createcorp where funccode = 'yhzhwh' order by ts desc;

--公司建账模块

select * from sm_codetocode where funccode = '39' ; select * from sm_createcorp where funccode = '39' ;

--delete from sm_codetocode where funccode = '39' ; --delete from sm_createcorp where funccode = '39' ;

--单据脚本

select * from pub_billtemplet where (nodecode in( '2006030102')) ;

select * from pub_billtemplet_b where pk_billtemplet in(select pk_billtemplet from pub_billtemplet where (nodecode in ('2006030102'))) ;

select * from pub_billtemplet_t where pk_billtemplet in(select pk_billtemplet from pub_billtemplet where (nodecode in ('2006030124'))); --查询脚本

select * from pub_query_templet where node_code like 'H205%' ;

select * from pub_query_condition where pk_templet in(select id from pub_query_templet where node_code like 'H205%') ;

--业务单据脚本

select * from bd_billtype where pk_billtypecode in('SKDJ'); select * from PUB_BILLACTION where pk_billtype in('SKDJ' );

select * from PUB_BILLCODE_RULE where pk_billtypecode in('SKDJ'); select * from PUB_BUSICLASS where pk_billtype in('SKDJ');

select * from dap_defitem where pk_billtype in('SKDJ');

select * from PUB_VOTABLE where pk_billtype like ('SKDJ%');

select * from DEV_VOTABLE where vtablename in('scf_endowment_b','scf_endowment'); select * from sm_busiworkflow order by ts desc ;

--打印模板根据主键ctemplateid来关联其他字表

select * from pub_print_template where vtemplatename in ('供应商订单确认');

select * from pub_print_cell where ctemplateid in (select ctemplateid from pub_print_template

where vtemplatename like '供应商订单确认');

select * from pub_print_datasource where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '供应商订单确认');

select * from pub_print_variable where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '供应商订单确认'); select * from pub_print_dataitem where vnodecode like 'H703%';

--select * from pub_print_region where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '修订订单');

--select * from pub_print_line where ctemplateid in (select ctemplateid from pub_print_template where vtemplatename like '修订订单'); --业务流程

select * from bd_busitype where busicode like 'H2%';

select * from pub_billbusiness where pk_businesstype='0001AA1000000000LA7T';

select * from pub_billsource where billbusinessid='@@@@AA10000000001WO9' referbusinesstype='0001AA1000000001PLM6';

select * from pub_messagedrive where pk_businesstype='0001AA1000000000LA7T' ;

select * from pub_billtobillrefer; select * from pub_billactiongroup; select * from pub_billactionconfig; select * from pub_billaction; select * from pub_billcode_obj;

select * from bd_busitype order by ts desc select * from pub_busitrans

select * from sm_busiflow_nodes

select * from pub_wf_instance order by ts desc select * from pub_wf_def

select * from bd_billtype order by ts desc where nodecode like '4[A,B]%' select * from dap_dapsystem where funcode = 'H2'

select * from PUB_BILLACTION where pk_billtype like '4[A,B]%' order by ts desc

select * from PUB_BILLCODE_RULE where pk_billtypecode like '[H,T]9[H,Z][1,2,Q,S,]' order by ts desc

select * from PUB_BUSICLASS where pk_billtype like 'T9Z[1,2]' order by ts desc

select * from PUB_VOTABLE order by ts desc where pk_billtype like '[H,T]9[H,Z][1,2,Q,S,]' select * from DEV_VOTABLE where vtablename in('oa_mailinbox','oa_mailsent','oa_docpub_sub','oa_docpub','oa_bizhandle') order by ts desc

--预警平台 select * from PUB_ALERTTYPE where busi_plugin in('nc.bs.oa.sms.ReadMessage','nc.bs.oa.sms.SendMessagePlugin') order by ts desc

select * from PUB_ALERTTYPE_B where pk_alerttype in(select pk_alerttype from PUB_ALERTTYPE where busi_plugin in('nc.bs.oa.sms.ReadMessage','nc.bs.oa.sms.SendMessagePlugin')) order by ts desc

--自定义档案

select * from bd_defdoclist where doclistcode in('OA002') order by ts desc;

select * from bd_defdoc where pk_defdoclist in(select pk_defdoclist from bd_defdoclist where doclistcode in('OA002'));

select * from bd_refinfo where para1 in (select pk_defdoclist from bd_defdoclist where doclistcode = 'WLGS');

select * from bd_bdinfo where pk_defdef in (select pk_defdoclist from bd_defdoclist where doclistcode = 'WLGS');

--二次开发平台表

select * from dev_billinfo where vnodecode like 'H2%';

select * from dev_billbutton where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;

select * from dev_billdatainfo where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;

select * from dev_buttonreference where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;

select * from dev_projectinfo where root_nodecode='H2';

select * from dev_specialcheckrule where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;

select * from dev_uibutton order by ts desc;

select * from dev_uniquecheckrule where pk_billinfo in (select pk_billinfo from dev_billinfo where vnodecode like 'H2%') ;

select * from dev_votable where vtablename like 'scf_%';

--数据字典

select * from pub_datadict t where t.display like '%发票购入表%' or t.display like '%捐赠意向%' or t.display like '%募捐活动%'; select * from pub_datadictdetail t where t.reserved1 in ('scf_invoice','scf_disposition','scf_disposition_b','scf_endowment','scf_endowment_b');

--查询mde元数据

select * from mde_buttoninfo order by ts desc;

select * from mde_componentinfo order by ts desc;

select * from mde_funnodeuirelation order by ts desc;

select * from mde_privatebutton order by ts desc;

select * from mde_refinfo order by ts desc;

select * from mde_refinfo_cp order by ts desc;

select * from mde_refinfo_p order by ts desc;

select * from mde_specialcheckrule order by ts desc;

select * from mde_treeinfo order by ts desc;

select * from mde_resourceinfo order by ts desc;

select * from mde_uibaseinfo order by ts desc;

select * from mde_uifactoryinfo order by ts desc;

select * from mde_uiresource order by ts desc;

select * from mde_uniquecheckrule order by ts desc;

--查询md元数据

select * from md_accessorpara order by ts desc;

select * from md_association order by ts desc;

select * from md_bizitfmap order by ts desc;

select * from md_busioperation order by ts desc;

select * from md_class order by ts desc;

select * from md_column order by ts desc;

select * from md_component order by ts desc;

select * from md_db order by ts desc;

select * from md_db_relation order by ts desc;

select * from md_enumvalue order by ts desc;

select * from md_index order by ts desc;

select * from md_indexcolumn order by ts desc;

select * from md_lrs order by ts desc;

select * from md_module order by ts desc;

select * from md_operation order by ts desc;

select * from md_ormap order by ts desc;

select * from md_parameter order by ts desc;

select * from md_property order by ts desc;

select * from md_table order by ts desc;

select * from md_view order by ts desc;

select * from md_viewcolumn order by ts desc;

--查询外部系统信息设置

select * from xx_exsystem where exsystemcode='2022' and nvl(dr,0)=0; select * from xx_exsystem_b where pk_exsystem in（select pk_exsystem from xx_exsystem where exsystemcode='2022' and nvl(dr,0)=0）and nvl(dr,0)=0;

本文来源：https://www.bwwdw.com/article/ebrr.html