/*公共部分
TRUNCATE TABLE COM_CLIENTERROR; /*客戶端錯(cuò)誤信息*/
TRUNCATE TABLE COM_COMPUTER; /*登錄信息表*/
TRUNCATE TABLE COM_DATABASEDEBUG; /*對(duì)數(shù)據(jù)庫(kù)訪問(wèn)的SQL記錄表*/
TRUNCATE TABLE COM_DATABASEERROR; /*數(shù)據(jù)庫(kù)錯(cuò)誤記錄表*/
TRUNCATE TABLE COM_DATASTAT; /*數(shù)據(jù)庫(kù)統(tǒng)計(jì)*/
TRUNCATE TABLE COM_FILEINFO; /*數(shù)據(jù)文件信息表*/
TRUNCATE TABLE COM_IPADDRESS; /*操作員登錄信息表*/
TRUNCATE TABLE COM_LOG; /*登錄信息*/
TRUNCATE TABLE COM_LOGINSTATUS; /*登錄狀態(tài)表*/
TRUNCATE TABLE COM_NOTICE; /*His提示信息表*/
TRUNCATE TABLE COM_PASSWORDRECORD; /*患者密碼訪問(wèn)記錄*/
TRUNCATE TABLE COM_ROLEUSERLOG; /*用戶登錄記錄表*/
TRUNCATE TABLE COM_SHIFT_RECORD; - /*項(xiàng)目信息變更記錄*/
/*電子病歷
TRUNCATE TABLE EMR_COM_LOCK; /*電子病歷并發(fā)控制表*/
TRUNCATE TABLE EMR_COM_LOGO; /*電子病歷日志表*/
TRUNCATE TABLE EMR_COM_NODELIST; /*電子病歷節(jié)點(diǎn)路徑*/
/*財(cái)務(wù)管理
TRUNCATE TABLE FIN_COM_ADJUSTUNDRUGPRICEDETAI; /*非藥品調(diào)價(jià)記錄表*/
TRUNCATE TABLE FIN_COM_ADJUSTUNDRUGPRICEHEAD; /*非藥品調(diào)價(jià)頭表*/
TRUNCATE TABLE FIN_COM_CLINICOLDFEE; /*門診產(chǎn)前檢查*/
TRUNCATE TABLE FIN_COM_DEPTSICOST; /*醫(yī)保定額設(shè)置表*/
TRUNCATE TABLE FIN_COM_DERATE; /*費(fèi)用減免表*/
TRUNCATE TABLE FIN_COM_INVOICECHANGE; /*發(fā)票調(diào)整記錄表*/
TRUNCATE TABLE FIN_COM_OLDFEE; /*補(bǔ)錄費(fèi)用表*/
TRUNCATE TABLE FIN_IPB_BALANCEHEAD; /*住院結(jié)算頭表*/
TRUNCATE TABLE FIN_IPB_BALANCELIST; /*住院結(jié)算明細(xì)表*/
TRUNCATE TABLE FIN_IPB_BALANCEPAY; /*住院收費(fèi)結(jié)算實(shí)付表*/
TRUNCATE TABLE FIN_IPB_DAYREPORT; /*結(jié)算員日結(jié)*/
TRUNCATE TABLE FIN_IPB_DAYREPORTDETAIL; /*結(jié)算員日結(jié)明細(xì)表*/
TRUNCATE TABLE FIN_IPR_BABYINFO; /*嬰兒住院主表*/
TRUNCATE TABLE FIN_IPR_HANGBEDINFO; /*掛床信息表*/
TRUNCATE TABLE FIN_IPR_PREPAYIN; /*住院預(yù)約表*/
TRUNCATE TABLE FIN_IPR_RECEIVEINFO; /*接診信息表*/
TRUNCATE TABLE FIN_IPR_SHIFTAPPLY; /*轉(zhuǎn)科申請(qǐng)表*/
TRUNCATE TABLE FIN_OPB_ACCOUNT; /*帳戶信息表*/
TRUNCATE TABLE FIN_OPB_ACCOUNTCARD; /*帳戶和卡對(duì)應(yīng)表*/
TRUNCATE TABLE FIN_OPB_ACCOUNTCARD_RECORD; /*卡使用、變動(dòng)記錄表*/
TRUNCATE TABLE FIN_OPB_ACCOUNTRECORD; /*帳戶記錄*/
TRUNCATE TABLE FIN_OPB_DAYBALANCE; /*門診收款日結(jié)*/
TRUNCATE TABLE FIN_OPB_FEEDETAIL; /*處方明細(xì)表*/
TRUNCATE TABLE FIN_OPB_INJECT; /*院注次數(shù)*/
TRUNCATE TABLE FIN_OPB_INVOICEDETAIL; /*發(fā)票明細(xì)表(費(fèi)用分類表)*/
TRUNCATE TABLE FIN_OPB_INVOICEDETAIL_EXTEND; /*發(fā)票對(duì)照CT*/
TRUNCATE TABLE FIN_OPB_INVOICEINFO; /*發(fā)票信息表(結(jié)算信息表)*/
TRUNCATE TABLE FIN_OPB_PAYMODE; /*結(jié)算支付情況表*/
TRUNCATE TABLE FIN_OPB_SPECIALLIMIT; /*保存公費(fèi)患者收費(fèi)時(shí)限額*/
TRUNCATE TABLE FIN_OPR_BOOKING; /*預(yù)約主表*/
TRUNCATE TABLE FIN_OPR_DAYBALANCE; /*掛號(hào)員日結(jié)檔*/
TRUNCATE TABLE FIN_OPR_DAYBALANCEDETAIL; /*掛號(hào)員日結(jié)明細(xì)*/
TRUNCATE TABLE FIN_OPR_DIAGNOSE; /*病種診斷登記表*/
TRUNCATE TABLE FIN_OPR_REGISTER; /*掛號(hào)主表*/
TRUNCATE TABLE MET_BLD_APPLY; /*血液申請(qǐng)表*/
TRUNCATE TABLE MET_BLD_INPUT; /*血液入庫(kù)表*/
TRUNCATE TABLE MET_BLD_MATCH; /*配血記錄表*/
TRUNCATE TABLE MET_BLD_MONTHSTORE; /*血液月結(jié)表*/
TRUNCATE TABLE MET_BLD_OUTPUT; /*血液出庫(kù)表*/
TRUNCATE TABLE MET_BLD_REACTION; /*輸血不良反應(yīng)*/
TRUNCATE TABLE MET_BLD_STORE; /*血液庫(kù)存表*/
TRUNCATE TABLE MET_IPM_CONSULTATION; /*會(huì)診資料檔-院內(nèi)會(huì)診*/
TRUNCATE TABLE MET_IPM_CURE; /*治療單主表*/
TRUNCATE TABLE MET_IPM_CURELIST; /*治療單明細(xì)表*/
TRUNCATE TABLE MET_IPM_DEPTUSAGE; /*醫(yī)囑科常用用法表*/
TRUNCATE TABLE MET_IPM_DFQSPECIAL; /*醫(yī)囑特殊頻次表*/
TRUNCATE TABLE MET_IPM_DOSAGE; /*藥品配藥屬性資料檔*/
TRUNCATE TABLE MET_IPM_DRUGBILLDETAIL; /*藥品執(zhí)行單明細(xì)表*/
TRUNCATE TABLE MET_IPM_EXECBILL; /*醫(yī)囑執(zhí)行單信息表*/
TRUNCATE TABLE MET_IPM_EXECDRUG; /*藥囑執(zhí)行檔*/
TRUNCATE TABLE MET_IPM_EXECUNDRUG; /*非藥囑執(zhí)行檔*/
TRUNCATE TABLE MET_IPM_ORDER; /*醫(yī)囑資料檔*/
TRUNCATE TABLE MET_IPM_ORDERBILL; /*醫(yī)囑單打印資料檔*/
TRUNCATE TABLE MET_IPM_PACSBILL; /*檢查申請(qǐng)單表*/
TRUNCATE TABLE MET_IPM_PERMISSION; /*授權(quán)資料檔*/
TRUNCATE TABLE MET_IPM_SENDINFORMATION; /*醫(yī)囑擺藥通知檔*/
TRUNCATE TABLE MET_IPM_SETPHARMACY; /*科室領(lǐng)藥藥房設(shè)置*/
TRUNCATE TABLE MET_IPM_SPECIALFREQ; /*藥囑特殊頻次檔*/
TRUNCATE TABLE MET_IPM_UNDRUGBILLDETAIL; /*非藥品執(zhí)行單明細(xì)*/
TRUNCATE TABLE MET_LIS_SAMPLERECORD; /*檢驗(yàn)樣本周轉(zhuǎn)記錄表*/
TRUNCATE TABLE MET_NUI_ALLERGEN; /*患者過(guò)敏紀(jì)錄*/
TRUNCATE TABLE MET_NUI_CANCELITEM; /*病區(qū)退費(fèi)申請(qǐng)表*/
TRUNCATE TABLE MET_NUI_CHARGEBILL; /*病區(qū)收費(fèi)單*/
TRUNCATE TABLE MET_NUI_CONFIRM; /*護(hù)士確認(rèn)執(zhí)行醫(yī)囑表(目前不用)*/
TRUNCATE TABLE MET_NUI_INFECTION; /*感染記錄表*/
TRUNCATE TABLE MET_NUI_LEAVE; /*請(qǐng)假信息表*/
TRUNCATE TABLE MET_NUI_LFCH; /*患者生命體征記錄檔*/
TRUNCATE TABLE MET_NUI_SPECIALEND; /*特別護(hù)理記錄單*/
TRUNCATE TABLE MET_NUI_TEND; /*護(hù)理評(píng)估表*/
TRUNCATE TABLE MET_NUI_TENDACTION; /*護(hù)理計(jì)劃實(shí)施單*/
TRUNCATE TABLE MET_NUI_TENDACTIONTYPE; /*護(hù)理計(jì)劃實(shí)施單項(xiàng)目分類*/
TRUNCATE TABLE MET_NUI_TENDIMPORTANT; /*重病護(hù)理記錄*/
TRUNCATE TABLE MET_NUI_TENDPLAN; /*護(hù)理計(jì)劃記錄單*/
TRUNCATE TABLE MET_NUI_TYPE; /*護(hù)理類別檔*/
TRUNCATE TABLE MET_NUO_ASSIGNRECORD; /*護(hù)士分診記錄表*/
TRUNCATE TABLE MET_NUO_QUEUE; /*門診護(hù)士站分診隊(duì)列表*/
TRUNCATE TABLE MET_OPS_ANAEDRUG; /*麻醉用藥表*/
TRUNCATE TABLE MET_OPS_ANAERECORD; /*麻醉記錄表*/
TRUNCATE TABLE MET_OPS_APPARATUS; /*手術(shù)儀器設(shè)備維護(hù)表*/
TRUNCATE TABLE MET_OPS_APPARECORD; /*手術(shù)資料安排*/
TRUNCATE TABLE MET_OPS_APPLY; /*手術(shù)申請(qǐng)表*/
TRUNCATE TABLE MET_OPS_ARRANGE; /*手術(shù)人員安排*/
TRUNCATE TABLE MET_OPS_ARRANGECONSOLE; /*臨床科室正臺(tái)安排信息表*/
TRUNCATE TABLE MET_OPS_CONSOLE; /*手術(shù)臺(tái)維護(hù)表*/
TRUNCATE TABLE MET_OPS_DOCTINFO; /*手術(shù)醫(yī)生信息表*/
TRUNCATE TABLE MET_OPS_EVALUATION; /*手術(shù)效果評(píng)定表*/
TRUNCATE TABLE MET_OPS_GERMRECORD; /*無(wú)菌檢查記錄*/
TRUNCATE TABLE MET_OPS_OPERATIONITEM; /*手術(shù)記錄表*/
TRUNCATE TABLE MET_OPS_RECORD; /*手術(shù)登記表*/
TRUNCATE TABLE MET_ORD_RECIPECHANGEINFO; /*處方變化記錄表*/
TRUNCATE TABLE MET_ORD_RECIPEDETAIL; /*診間處方明細(xì)表*/
TRUNCATE TABLE MET_ORD_SEEDOCTRECORD; /*問(wèn)診記錄表,對(duì)于分診護(hù)士補(bǔ)充的信息，*/
/*醫(yī)技終端
TRUNCATE TABLE MET_TEC_APPLY; /*醫(yī)技申請(qǐng)表*/
TRUNCATE TABLE MET_TEC_APPLYARRANGE; /*項(xiàng)目預(yù)安排明細(xì)*/
TRUNCATE TABLE MET_TEC_ERROR; /*醫(yī)技錯(cuò)誤信息*/
TRUNCATE TABLE MET_TEC_EXECUTE; /*終端執(zhí)行*/
TRUNCATE TABLE MET_TEC_GROUP; /*醫(yī)技組*/
TRUNCATE TABLE MET_TEC_ITEM; /*醫(yī)技項(xiàng)目*/
TRUNCATE TABLE MET_TEC_ITEMBOOKINGINFO; /*
TRUNCATE TABLE MET_TEC_ITEMBOOKINGTEMPLATE; /*項(xiàng)目預(yù)約模板表*/
TRUNCATE TABLE MET_TEC_ITEM_NOTICE; /*醫(yī)技項(xiàng)目注意事項(xiàng)*/
TRUNCATE TABLE MET_TEC_LOCATION; /*醫(yī)技項(xiàng)目執(zhí)行地點(diǎn)*/
TRUNCATE TABLE MET_TEC_MACHINE; /*醫(yī)技設(shè)備*/
TRUNCATE TABLE MET_TEC_MACHINE_ITEM; /*醫(yī)技設(shè)備與收費(fèi)項(xiàng)目的對(duì)應(yīng)關(guān)系*/
TRUNCATE TABLE MET_TEC_MACHINE_OPER; /*醫(yī)技設(shè)備與操作員的對(duì)應(yīng)關(guān)系*/
TRUNCATE TABLE MET_TEC_MACHINE_RECORD; /*醫(yī)技設(shè)備使用記錄*/
TRUNCATE TABLE MET_TEC_MEMBER; /*醫(yī)技組成員*/
TRUNCATE TABLE MET_TEC_OPER; /*醫(yī)技操作員*/
TRUNCATE TABLE MET_TEC_OPER_ITEM; /*收費(fèi)項(xiàng)目與操作員的對(duì)應(yīng)關(guān)系*/
TRUNCATE TABLE MET_TEC_ROLE; /*醫(yī)技權(quán)限*/
TRUNCATE TABLE MET_TEC_ROOM; /*房間*/
TRUNCATE TABLE MET_TEC_SCHEMA; /*項(xiàng)目排班表*/
TRUNCATE TABLE MET_TEC_SCHEMATEMPLATE; /*項(xiàng)目預(yù)約模板表*/
TRUNCATE TABLE MET_TEC_TA_DETAIL; /*終端確認(rèn)業(yè)務(wù)子表*/
TRUNCATE TABLE MET_TEC_TEMPLATE; /*預(yù)約模板*/
TRUNCATE TABLE MET_TEC_TERMINALAPPLY; /*終端確認(rèn)申請(qǐng)檔*/
TRUNCATE TABLE MET_TEC_WINDOW; /*醫(yī)技窗口*/
/*藥品管理
TRUNCATE TABLE PHA_COM_ADJUSTPRICEBATCH; /*藥品調(diào)價(jià)批次表*/
TRUNCATE TABLE PHA_COM_ADJUSTPRICEDETAIL; /*藥品調(diào)價(jià)明細(xì)表*/
TRUNCATE TABLE PHA_COM_ADJUSTPRICEINFO; /*調(diào)價(jià)主表*/
TRUNCATE TABLE PHA_COM_APPLYIN; /*藥品入庫(kù)申請(qǐng)表*/
TRUNCATE TABLE PHA_COM_APPLYOUT; /*出庫(kù)申請(qǐng)表*/
TRUNCATE TABLE PHA_COM_CHECK; /*藥品盤點(diǎn)表(不用)*/
TRUNCATE TABLE PHA_COM_CHECKSTATIC; /*藥品盤點(diǎn)統(tǒng)計(jì)表*/
TRUNCATE TABLE PHA_COM_DAILYSTAT; /*藥品日結(jié)表*/
TRUNCATE TABLE PHA_COM_DEPTRADIX; /*病區(qū)藥品基數(shù)表*/
TRUNCATE TABLE PHA_COM_EXTENDCLASS; /*藥品擴(kuò)展信息分類表(不用)*/
TRUNCATE TABLE PHA_COM_EXTENDINFO; /*藥品擴(kuò)展信息(不用)*/
TRUNCATE TABLE PHA_COM_INPLAN; /*入庫(kù)計(jì)劃表*/
TRUNCATE TABLE PHA_COM_INPUT; /*藥品入庫(kù)記錄表*/
TRUNCATE TABLE PHA_COM_MS_CUSTOM; /*藥品自定義月結(jié)表*/
TRUNCATE TABLE PHA_COM_MS_DEPT; /*藥品科室月結(jié)表_科室*/
TRUNCATE TABLE PHA_COM_MS_DRUG; /*藥品月結(jié)表_藥品明細(xì)*/
TRUNCATE TABLE PHA_COM_OUTPUT; /*藥品出庫(kù)記錄表*/
TRUNCATE TABLE PHA_COM_RECORD; /*藥品臺(tái)帳表(流水帳)*/
TRUNCATE TABLE PHA_COM_SHIFTDATA; /*藥品資料變更(基本信息變更)*/
TRUNCATE TABLE PHA_MED_PAYDETAIL; /*藥庫(kù)供應(yīng)商往來(lái)明細(xì)表*/
TRUNCATE TABLE PHA_MED_PAYHEAD; /*藥庫(kù)供應(yīng)商往來(lái)帳目頭表*/
TRUNCATE TABLE PHA_MED_STOCKPLAN; /*藥庫(kù)采購(gòu)計(jì)劃表*/
/*制劑管理
TRUNCATE TABLE PHA_PPR_ASSAY; /*制劑檢驗(yàn)記錄*/
TRUNCATE TABLE PHA_PPR_CLEAR; /*制劑情場(chǎng)記錄*/
TRUNCATE TABLE PHA_PPR_CONFECT; /*制劑配制報(bào)告記錄*/
TRUNCATE TABLE PHA_PPR_DIVISION; /*制劑分裝報(bào)告記錄*/
TRUNCATE TABLE PHA_PPR_INPUT; /*制劑產(chǎn)品入庫(kù)報(bào)告記錄*/
TRUNCATE TABLE PHA_PPR_PACKAGE; /*制劑外包裝報(bào)告記錄*/
TRUNCATE TABLE PHA_PPR_PREPARATION; /*制劑調(diào)配主表*/
/*藥房管理
TRUNCATE TABLE PHA_STO_CANCEL; /*門診藥品核銷記錄表*/
TRUNCATE TABLE PHA_STO_MSG; /*擺藥通知檔*/
TRUNCATE TABLE PHA_STO_OPBSEND; /*門診發(fā)藥記錄表*/
TRUNCATE TABLE PHA_STO_RECIPE; /*處方調(diào)劑頭表*/
TRUNCATE TABLE PHA_STO_RELIEVE; /*門診調(diào)劑表*/
TRUNCATE TABLE PHA_STO_SETDOSAGE; /*門診配藥臺(tái)(目前不用)*/
TRUNCATE TABLE PHA_STO_SETDOSAGE_SPE; /*特殊配藥臺(tái)設(shè)置(目前不用)*/
/*科教
TRUNCATE TABLE SEM_SCI_BOOKMAKING; /*著作信息/*
TRUNCATE TABLE SEM_SCI_BOOKMAKINGEXT; /*著作擴(kuò)展信息/*
TRUNCATE TABLE SEM_SCI_COMEXTEND; /*課題登記表擴(kuò)展信息/*
TRUNCATE TABLE SEM_SCI_CONFERENCEINFO; /*學(xué)術(shù)會(huì)議信息/*
TRUNCATE TABLE SEM_SCI_EMPLOYEEPOST; /*學(xué)術(shù)任職登記信息*/
|
|
資源大�。�2.86 KB 
