NCC重要数据表

抽脚本重要的数据表，欢迎补充@晓明童鞋

SM_APPREGISTER where CODE in (‘50030006’,’50020002’,’50030102’) | | | 参数注册 （应用注册表体） | SM_APPPARAM | select from SM_APPPARAM where PARENTID in (select PK_APPREGISTER from SM_APPREGISTER where CODE in (‘50030006’,’50020002’,’50030102’)) | | | 页面注册 | SM_APPPAGE | select from SM_APPPAGE where PARENTCODE in (‘50030006’,’50020002’,’50030102’) | | | 按钮注册 | SM_APPBUTNREGISTER | select from SM_APPBUTNREGISTER where appid in (select PK_APPREGISTER from SM_APPREGISTER where CODE in (‘50030006’,’50020002’,’50030102’) ) | | | 页面模板 | pub_page_templet | select from PUB_PAGE_TEMPLET where appcode in (‘50030006’,’50020002’,’50030102’) | | | 页面区域 | pub_area | select from pub_area where templetid in (select PK_PAGE_TEMPLET from PUB_PAGE_TEMPLET where appcode in (‘50030006’,’50020002’,’50030102’)) | | | 页面Form\Grid区域属性 | pub_form_property | select from pub_form_property where areaid in (select PK_AREA from pub_area where templetid in (select PK_PAGE_TEMPLET from PUB_PAGE_TEMPLET where appcode in (‘50030006’,’50020002’,’50030102’))) | | | 页面Query区域属性 | pub_query_property | select from pub_query_property where areaid in (select PK_AREA from pub_area where templetid in (select PK_PAGE_TEMPLET from PUB_PAGE_TEMPLET where appcode in (‘50040022’))) | | | 菜单注册 | SM_APPMENUITEM | select from SM_APPMENUITEM where menuitemcode = ‘50’ or menuitemcode like ‘5003%’ or menuitemcode like ‘5002%’ | | | 导出数据加工处理 | EXCEL_OUTPUTPROCESS | SELECT * FROM EXCEL_OUTPUTPROCESS WHERE MODULE = ‘MMMPS’ AND BILLTYPE = ‘MPS’ | |

| 轻量端输出模板初始化 | pub_print_template | select from pub_print_template where appcode = ‘50030006’ | | —- | —- | —- | | | pub_print_cell | select from pub_print_cell where ctemplateid in ( select ctemplateid from pub_print_template where appcode = ‘50030006’) | | | pub_print_datasource | select from pub_print_datasource where ctemplateid in ( select ctemplateid from pub_print_template where appcode = ‘50030006’) | | | pub_print_variable | select from pub_print_variable where ctemplateid in ( select ctemplateid from pub_print_template where appcode = ‘50030006’) | | 轻量端应用默认输出模板设置 | pub_systemplate_base | select from pub_systemplate_base where templateid in (select ctemplateid from pub_print_template where appcode = ‘50030006’) | | | pub_systemplate | select from pub_systemplate where templateid in (select ctemplateid from pub_print_template where appcode = ‘50030006’) |