医院信息系统表结构VIP免费

医院his管理系统——数据结构手册Version.1.0.0编制审核2007-10-08数据结构手册(第二版)医院his管理系统目录一、住院业务用表..........................................................................................3表清单................................................................................................3表结构................................................................................................31.1结算表hosp_pay_history...........................................................................31.2结算三级费用表hosp_pay_fyhzb.....................................................................51.3住院表patinfo(patinfo_cy)........................................................................51.4住院押金表forepayinfo(forpayinfo_cy).............................................................71.5费用明细表hosp_detail_price(hosp_detail_price_cy)................................................81.6患者一天费用明细汇总清单表hosp_day_fymx.........................................................101.7患者一天费用明细汇总清单结转表hosp_day_fymx_jz..................................................101.8医嘱主表doctmark(doctmark_cy)...................................................................101.9医嘱明细表doctmark_charge(doctmark_charge_cy)...................................................111.10检治待执行表doctmark_exec_jzmx.................................................................121.11药品待执行表doctmark_exec_ypmx.................................................................131.12申请单据表doctmark_request.....................................................................141.13医嘱执行表doctmark_exec........................................................................141.14床位代码表hosp_cwdmb...........................................................................141.15打折表hosp_discount_price......................................................................151.16住院结帐记录表hosp_payhistory..................................................................15二、门诊业务表...........................................................................................15表清单...............................................................................................15表结构...............................................................................................162.1门诊主表mzsf_clininvoinfo.......................................................................162.2门诊费用明细表mzsf_clinreciinfo.................................................................172.3处方单据主表mzsf_clinreciinfo_cfdj..............................................................182.4处方明细表mzsf_clinreciinfo_cfmx................................................................192.5检治单据表mzsf_clinreciinfo_jzdj................................................................202.6检治明细表mzsf_clinreciinfo_jzmx................................................................202.7门诊发票表mzsf_involistnumb.....................................................................212.8门诊作废发票表mzsf_involistnumb_zfmx............................................................222.9表clin_payhistory...............................................................................22三、药房药库业务表...............................................................