醫(yī)院信息系統(tǒng)表結(jié)構(gòu)

醫(yī)院his管理系統(tǒng)

一數(shù)據(jù)結(jié)構(gòu)手冊(cè)Version.1.0.0編制

審核2007-10-08醫(yī)院心5醫(yī)院心5管理系統(tǒng)TOC\o"1-5"\h\z\o"CurrentDocument"一、住院業(yè)務(wù)用表 3表清單 3表結(jié)構(gòu) 3結(jié)算表hosp_pay_history 3\o"CurrentDocument"結(jié)算三級(jí)費(fèi)用表hosp_pay_fyhzb 5住院表patinfo(patinfo_cy) 5\o"CurrentDocument"住院押金表forepayinfo(forpayinfo_cy) 7\o"CurrentDocument"費(fèi)用明細(xì)表hosp_detail_price(hosp_detail_price_cy) 8患者一天費(fèi)用明細(xì)匯總清單表hosp_day_fymx 錯(cuò)誤!未定義書(shū)簽?；颊咭惶熨M(fèi)用明細(xì)匯總清單結(jié)轉(zhuǎn)表hosp_day_fymx_jz 錯(cuò)誤!未定義書(shū)簽。\o"CurrentDocument"醫(yī)囑主表doctmark(doctmark_cy) 9\o"CurrentDocument"醫(yī)囑明細(xì)表doctmark_charge(doctmark_charge_cy) 10\o"CurrentDocument"檢治待執(zhí)行表doctmark_exec_jzmx 11\o"CurrentDocument"藥品待執(zhí)行表doctmark_exec_ypmx 12\o"CurrentDocument"申請(qǐng)單據(jù)表doctmark_request 13\o"CurrentDocument"醫(yī)囑執(zhí)行表doctmark_exec 13\o"CurrentDocument"床位代碼表hosp_cwdmb 13\o"CurrentDocument"打折表hosp_discount_price 14\o"CurrentDocument"住院結(jié)帳記錄表hosp_payhistory 14\o"CurrentDocument"業(yè)務(wù)表 15\o"CurrentDocument"表清單 15表結(jié)構(gòu) 15門(mén)診主表mzsf_clininvoinfo 15\o"CurrentDocument"門(mén)診費(fèi)用明細(xì)表mzsf_clinreciinfo 17\o"CurrentDocument"處方單據(jù)主表mzsf_clinreciinfo_cfdj 18\o"CurrentDocument"處方明細(xì)表mzsf_clinreciinfo_cfmx 18檢治單據(jù)表mzsf_clinreciinfo_jzdj 19\o"CurrentDocument"檢治明細(xì)表mzsf_clinreciinfo_jzmx 20\o"CurrentDocument"門(mén)診發(fā)票表mzsf_involistnumb 21\o"CurrentDocument"門(mén)診作廢發(fā)票表mzsf_involistnumb_zfmx 21\o"CurrentDocument"表clin_payhistory 22\o"CurrentDocument"三、藥房藥庫(kù)業(yè)務(wù)表 252525\o"CurrentDocument"出入庫(kù)單據(jù)總表glidetotal 25\o"CurrentDocument"出入庫(kù)單據(jù)明細(xì)表glide 26\o"CurrentDocument"選入藥品表store_infostru 27\o"CurrentDocument"藥房庫(kù)存表store_infostru_detail 27\o"CurrentDocument"盤(pán)點(diǎn)表store_check 27\o"CurrentDocument"盤(pán)點(diǎn)明細(xì)表store_check_detail 28\o"CurrentDocument"藥房庫(kù)存明細(xì)表yf_kcmx 29\o"CurrentDocument"藥房庫(kù)存明細(xì)表歷史yf_kcmxls 29\o"CurrentDocument"用字典表 30表清單 30表結(jié)構(gòu) 30操作員表dictoper 30\o"CurrentDocument"科室代碼表dictoffice 31\o"CurrentDocument"職稱(chēng)表dicttitle 32醫(yī)院心5醫(yī)院心5管理系統(tǒng)TOC\o"1-5"\h\z\o"CurrentDocument"項(xiàng)目表dictmedi 32\o"CurrentDocument"三級(jí)項(xiàng)目表dictcharge 34\o"CurrentDocument"二級(jí)項(xiàng)目dictcalc 36\o"CurrentDocument"病人類(lèi)型表dictpatitype 36\o"CurrentDocument"藥品單價(jià)表dictmedi_ypdj 37\o"CurrentDocument"協(xié)定處方表dictmedi_rela 37\o"CurrentDocument"系統(tǒng)設(shè)置表clin_sysset 38\o"CurrentDocument"程序版本模塊信息表hosp_ver 39醫(yī)院信息表infohosp 40\o"CurrentDocument"權(quán)限用戶(hù)表sys_authority_user 40權(quán)限表sys_authority 41\o"CurrentDocument"藥品用法表1dicttimes 41\o"CurrentDocument"藥品用法表2nclinspecuser 42\o"CurrentDocument"藥品用法表3nclinspecuser2 42醫(yī)院心5醫(yī)院心5管理系統(tǒng)一、住院業(yè)務(wù)用表表清單名稱(chēng)代碼出院（中途）結(jié)算表hosp_pay_history結(jié)算三級(jí)費(fèi)用表Hosp_pay_fyhzb在院（出院）病人信息表Patinfo(patinfo_cy)在院（出院）押金表Forpayinfo(Forpayinfo_cy)在院（出院）費(fèi)用明細(xì)表Hosp_detail_price(Hosp_detail_price_cy)患者一天費(fèi)用明細(xì)匯總清單表Hosp_day_fymx患者一天費(fèi)用明細(xì)匯總清單結(jié)轉(zhuǎn)表Hosp_day_fymx_jz醫(yī)囑主表Doctmark(Doctmark_cy)醫(yī)囑明細(xì)表Doctmark_charge(Doctmark_charge_cy)檢治待執(zhí)行表Doctmark_exec_jzmx藥品待執(zhí)行表Doctmark_exec_ypmx藥品領(lǐng)藥申請(qǐng)表Doctmark_request醫(yī)囑執(zhí)行表Doctmark_exec床位代碼表Hosp_cwdmb出院打折表Hosp_discount_price(Hosp_discount_price_cy)住院日結(jié)記錄表Hosp_payhistory住院病人轉(zhuǎn)科表hosp_change_office表結(jié)構(gòu)出院（中途）結(jié)算表hosp_pay_history中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明結(jié)算IDVpriceidnumeric9V住院IDhospidnumeric9日期ddatechar8結(jié)算金額bepricenumeric9總押金depositnumeric9-3-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)打折discountnumeric9單據(jù)號(hào)（結(jié)算單號(hào)）codevarchar20操作員operidnumeric9收款員operid_sknumeric9作廢人員operid_zfnumeric9V備注remarkvarchar30標(biāo)記invalidint40結(jié)算類(lèi)型payTypeint40補(bǔ)交款recoupnumeric9V找款refundnumeric9V總押金advancenumeric9V押金號(hào)depositnovarchar255V結(jié)帳類(lèi)別jelbint40留款金額cylknumeric9V結(jié)算時(shí)間sjdatetime8(getdate())退帳標(biāo)記tzbjnumeric90退帳退款tztknumeric90出院欠款cyqknumeric90押金—現(xiàn)金deposit_xjnumeric90押金一支票deposit_zpnumeric90醫(yī)保支付sbzfjenumeric90個(gè)人支付grzfjenumeric90操作員operid1numeric9V結(jié)算流水號(hào)jslshchar8V自付費(fèi)用zffypricenumeric90個(gè)會(huì)自付grzfpricenumeric90起伏標(biāo)準(zhǔn)qfbzpricenumeric90按比例自付ablzfpricenumeric90統(tǒng)籌記帳tcjzpricenumeric90大額記帳dejzpricenumeric90超大額記帳cdejzpricenumeric90公務(wù)員記帳gwyjzpricenumeric90個(gè)人帳戶(hù)grzhpricenumeric90現(xiàn)金支付xjzfpricenumeric90帳戶(hù)余額zhyenumeric90出院類(lèi)型outtypenumeric90V門(mén)診票據(jù)mzpjdecimal9V貨幣誤差zenumeric90原結(jié)算IDypriceidnumeric9新加列作廢時(shí)該列記錄原記錄結(jié)算id標(biāo)記bjnumeric91正常2作廢記錄3被作廢結(jié)算表該造說(shuō)明：增加一個(gè)字段名稱(chēng)為原結(jié)ID新加表：結(jié)算三級(jí)費(fèi)用表

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)結(jié)算三級(jí)費(fèi)用表hosp_pay_fyhzb（暫無(wú)）醫(yī)院心5管理系統(tǒng)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明結(jié)算IDVpriceidnumeric9V序號(hào)Vserialnumeric9病人類(lèi)型patitypenumeric9三級(jí)項(xiàng)目IDchargeidnumeric9三級(jí)項(xiàng)目名稱(chēng)Chargenamevarchar20金額PriceNumeric9,2醫(yī)生DoctidNumeric9病人科室Requoffiidnumeric9執(zhí)行科室Execofficenumeric9核算科室Intoofficenumeric9結(jié)算日期pricedatedatetime打折金額discountpricenumeric9,2打折的金額數(shù)備注remarkvarchar20在院（出院）病人信息表patinfo（Patinfo_cy）中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明住院IDVHospIDnumeric9住院號(hào)HospCodevarchar20病案號(hào)bahvarchar20V來(lái)源AutoNumbnumeric9V姓名NAMEvarchar10性別SEXint41-男2-女出生日期BIRTHdatetime8V血型xxvarchar10V年齡AGEint4V年齡單位Ageunitvarchar4V醫(yī)保號(hào)MEDINUMBvarchar20V身份證號(hào)IDvarchar20V職業(yè)porfnumeric9V國(guó)家COUNTRYnumeric9V籍貫NATIONALITYnumeric9V民族NATIPLACvarchar20V婚姻MARRIAGEnumeric9V1-未婚2-已婚工作DUTYvarchar14V單位COMPANYvarchar40V單位電話(huà)COMPPHONvarchar20V-5-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)單位郵編COMPZIPvarchar10V家庭地址HOMEADDRvarchar40V家庭電話(huà)HOMEPHONvarchar20V家庭郵編HOMEZIPvarchar10V聯(lián)系人RefeManvarchar50V關(guān)系gxvarchar50V聯(lián)系人地址REFEADDRvarchar50V電加工能力REFEPHONvarchar50VCHALKNUMBvarchar40V次數(shù)Serialint4入院科室OffiIDnumeric9當(dāng)前科室currOffiIdnumeric9入科日期indatedatetime8V床位收費(fèi)IDmediidnumeric9V住院類(lèi)型hosptpyenumeric9V入院日期HospDatedatetime8費(fèi)用retr_pricedecimal90總費(fèi)用total_pricedecimal90收治醫(yī)生ReciDoctnumeric9收治科室ReciOfficenumeric90門(mén)診診斷ClinResuint40住院診斷HospResuint40病人類(lèi)型PatiTypeint403-省醫(yī)保4-自費(fèi)7-鄭煤8-鄭煤離休入院操作員InOperIdint4出院操作員OutOperIdint40出院日期OutDatedatetime8V出科日期outdate2datetime8V出院情況outtypenumeric9V在院出院標(biāo)志HospPerfint40PriceTypeint40date3datetime8V未結(jié)算費(fèi)用nopaymentnumeric90未結(jié)算時(shí)間nopaydatevarchar8V診斷醫(yī)生Maindoctidnumeric90組號(hào)GroupIdnumeric90MHospIdnumeric90orderidint40護(hù)理級(jí)別nurselevelint40isPauseint40狀態(tài)curstateint4-11-在院2-確認(rèn)出院來(lái)源科室comeoffiidnumeric9擔(dān)保isAssureint40-沒(méi)擔(dān)保1-有擔(dān)保擔(dān)保人Assurevarchar8V擔(dān)保金額AssurePricenumeric5最大組號(hào)maxNumint40-6-

iscountint4-1maxNum2int40總費(fèi)用grandPricenumeric90V總押金grandDepositnumeric90Vyjdhchar8Vyjlbint40isprintint4Visftint40Vfcpricedecimal90V入院情況ryqknumeric9Vstageint40V業(yè)務(wù)登記號(hào)ywdjcodevarchar12V治療結(jié)果zljgint4V出院診斷outresunumeric9Vhz_stageint40是否IC卡isickint40個(gè)人自付grzfjedecimal9V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)住院(出院)押金表forepayinfo(forpayinfo_cy)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明押金IDVForeNumbnumeric9住院IDHospIDnumeric9金額Amountnumeric9結(jié)算日期PayDatedatetime8操作員OperIdnumeric9收款員operid_sknumeric9狀態(tài)Statusint40-未結(jié)算1-結(jié)算作廢日期DelDatedatetime8V備注remarkvarchar20V第一筆isFirstint40是否結(jié)算isPayint4-10-結(jié)算過(guò)1-未結(jié)算押金類(lèi)別yjlbint400-現(xiàn)金4-票據(jù)5-支票8-pos卡9-批條操作員operidlnumeric9V作廢操作員operid1_zfnumeric9V是否打印isprinint400-未打印1-打印過(guò)結(jié)算單號(hào)jsdhchar12V結(jié)算IDpriceidint4V開(kāi)戶(hù)銀行bankchar50V帳號(hào)zhchar20V支票號(hào)zphchar20V支票是否到帳isdzint40V0-未到帳1-到帳-7-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)支票到帳日期dz_datedatetime8V到帳操作員operid_dznumeric9V流水號(hào)yjjlshchar8V中結(jié)IDpriceid_jznumeric9V票據(jù)狀態(tài)pj_statusint40是否現(xiàn)金結(jié)算isxjjsint40在院(出院)費(fèi)用明細(xì)表hosp_detail_price(hosp_detail_price_cy)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明費(fèi)用明細(xì)idVdetailidnumeric9V住院IDhospidnumeric9醫(yī)囑IDAutoNumbnumeric9醫(yī)囑明細(xì)IDpriceidnumeric90申請(qǐng)IDrequestidnumeric90checkidnumeric90V醫(yī)囑申請(qǐng)?doc_requestidnumeric9V病人科室RequOffilDnumeric9執(zhí)行科室Execofficenumeric9核算科室intoofficenumeric9V醫(yī)生doctidnumeric9V操作員operidnumeric9V醫(yī)囑類(lèi)型MarkTypeint4項(xiàng)目IDmediidnumeric9記帳日期ddatedatetime8記帳日期date2varchar8上帳日期date3datetime8Vnumlnumeric50num2numeric50數(shù)量user_numdecimal5單價(jià)unitpricenumeric9打折discountdecimal5-1V合計(jì)pricenumeric9自付比例paypercnumeric5-1作廢合計(jì)price_zfnumeric90V備注remarkvarchar255V是否收費(fèi)isPriceint4-1是否核對(duì)ischeckint40操作員operidlnumeric90是否申請(qǐng)isRequestint40操作員operid2numeric90上帳標(biāo)記isconfirmint40

操作員operid3numeric90是否發(fā)藥isReceiveint40是否打印isPrintint40isLackint40打印isPrint2int40打印isPrint3int40用量theoQuanvarchar10V單位unitvarchar8V頻率timeidnumeric9V打印isPrint4int40V操作員operid4numeric9V藥品單位AmbUnitchar10V發(fā)藥類(lèi)型worktypeint40發(fā)藥單據(jù)號(hào)djh_fynumeric9V退藥單據(jù)號(hào)djh_tynumeric9V產(chǎn)地carryidnumeric9V發(fā)藥方式fyfsnumeric9V醫(yī)保傳送標(biāo)記dr_stageint40isperfint40V是否日結(jié)isrjint40V退藥日期date4datetime8V最小數(shù)理min_numnumeric9V批號(hào)phvarchar20V效期yxqdatetime8V結(jié)算IDjsidnumeric9V原費(fèi)用明細(xì)IDy_detailidnumeric9V是否現(xiàn)金結(jié)算isxjjsint40現(xiàn)金結(jié)算申請(qǐng)?zhí)杍f_requestidvarchar20V單號(hào)jf_codevarchar10V門(mén)診號(hào)mz_autonumbvarchar20V藥品定價(jià)IDypdjidnumeric9V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)醫(yī)囑主表doctmark(doctmark_cy)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度麗卜1r默認(rèn)值標(biāo)識(shí)允許空說(shuō)明醫(yī)囑IDVAutoNumbnumeric9用法IDusageidnumeric9V病人科室RequOffiIDnumeric9住院IDHospIDnumeric9當(dāng)前數(shù)量curnumint4組號(hào)TheGroupint4序Serialint4項(xiàng)目IDMediIDnumeric9

產(chǎn)地carryidnumeric9V周期TimeIDnumeric9首次數(shù)量firstnumint40末次數(shù)量lastnumint40本次用量TheoQuannumeric9本次數(shù)量TheNumnumeric90單位unitvarchar8開(kāi)始時(shí)間BegiDatedatetime8結(jié)束時(shí)間EndDatedatetime8V執(zhí)行科室ExecOfficenumeric9開(kāi)醫(yī)囑人BegiOperIDnumeric9停醫(yī)囑人EndOperIDnumeric9醫(yī)生DoctIDnumeric9操作員operidnumeric9停醫(yī)生Doctid2numeric9停人員operid2numeric9備注Remarkvarchar50V醫(yī)囑類(lèi)型MarkTypeint41-長(zhǎng)囑2-臨囑4-床位費(fèi)金額pricenumeric90是否主醫(yī)囑isMainint4是否收費(fèi)isPriceint4-1是否取消isCancelint4臨囑天數(shù)lztsnumeric9-1發(fā)藥方式fyfsnumeric9V是否新醫(yī)囑isnewint40核對(duì)時(shí)間hd_datedatetime8V核對(duì)人員hd_operidnumeric9V執(zhí)行時(shí)間zx_datedatetime8V核對(duì)次次hd_serialint40數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)醫(yī)囑明細(xì)表doctmark_charge(doctmark_charge_cy)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明醫(yī)囑明細(xì)IDVpriceidnumeric9V醫(yī)囑IDAutoNumbnumeric9住院IDhospidnumeric9數(shù)量curnumint4組號(hào)theGroupint4項(xiàng)目IDmediidnumeric9產(chǎn)地carryidnumeric9V是否收費(fèi)isPriceint4當(dāng)天數(shù)量day_numnumeric5首次數(shù)量first_numnumeric510-

末次數(shù)量last_numnumeric5開(kāi)始時(shí)間begin_datedatetime8結(jié)束時(shí)間end_datedatetime8V備注remarkvarchar20VisAttachnumeric90臨囑天數(shù)lztsnumeric9-1是否打印isprintnumeric50打折discountnumeric5-1單價(jià)ambpricenumeric9V單位ambunitvarchar8V執(zhí)行科室execofficenumeric9V藥品定價(jià)IDypdjidnumeric9V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)醫(yī)囑修改方案：新建一個(gè)檢治待執(zhí)行表和藥品待發(fā)藥表,當(dāng)醫(yī)囑執(zhí)行時(shí)，檢治的寫(xiě)入檢治執(zhí)行表，藥品寫(xiě)入藥品申請(qǐng)表檢治待執(zhí)行表doctmark_exec_jzmx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明明細(xì)idVMXIDNumeric9V醫(yī)囑IDAutonumbNumeric9醫(yī)囑明細(xì)IDPriceidNumeric9患者IDHospidNumeric9項(xiàng)目IDMediidNumeric9數(shù)量User_numNumeric9,2單價(jià)UnitpriceNumeric9,4合計(jì)PriceNumeric9,4打折DiscountNumeric9,2病人科室RequoffiidNumeric9執(zhí)行科室ExecofficeNumeric9核算科室IntoofficeNumeric9醫(yī)囑類(lèi)型MarktypeVarchar50費(fèi)用日期ddateDatetime8記帳日期Date2Varchar8執(zhí)行時(shí)間Date3Datetime8是否收費(fèi)IspriceInt4申請(qǐng)IDRequestidNumeric9是否申請(qǐng)IsrequestInt4是否執(zhí)行IsconfirmInt4醫(yī)生DoctidNumeric9操作員OperidNumeric9操作員OperidlNumeric9停醫(yī)囑操作員Operid2Numeric9-11-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)執(zhí)行人Operid3Numeric9原費(fèi)用明細(xì)IDY_detailidNumeric9備注RemarkVarchar50是否打印IsprintInt4是否現(xiàn)金結(jié)算方式IsxjjsNumeric9藥品待執(zhí)行表doctmark_exec_ypmx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明明細(xì)IDVMXIDNumeric9V醫(yī)囑IDAutonumbNumeric9醫(yī)囑明細(xì)IDPriceidNumeric9患者IDHospidNumeric9項(xiàng)目IDMediidNumeric9數(shù)量User_numNumeric9,2單位ambUnitvarchar10單價(jià)unitPriceNumeric9,4合計(jì)PriceNumeric9,4打折DiscountNumeric9,2定價(jià)IDypdjidNumeric9是否申請(qǐng)Isrequestint4申請(qǐng)IDRequestidNumeric9病人科室RequoffiidNumeric9執(zhí)行科室ExecofficeNumeric9核算科室IntoofficeNumeric9費(fèi)用日期DdateDatetime8記帳日期Date2Varchar8發(fā)藥日期Date3Datetime8是否收費(fèi)IspriceInt40是否執(zhí)行IsconfirmInt40發(fā)藥時(shí)間Date4Datetime8是否發(fā)藥IsreceiveInt4醫(yī)囑類(lèi)型MarktypeNumeric9發(fā)藥類(lèi)型worktypeNumeric9發(fā)藥方式fyfsNumeric9醫(yī)生IDDoctidNumeric9操作員IDoperidNumeric9操作員IDOperidl停醫(yī)囑操作員Operid2Numeric9發(fā)藥人Operid3Numeric9發(fā)藥單據(jù)號(hào)Djh_fyNumeric9退藥單據(jù)號(hào)Djh_tyNumeric912-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)藥品最小拆分?jǐn)?shù)量Min_numNumeric9是否打印IsprintInt4原費(fèi)用明細(xì)IDY_detailidNumeric9備注RemarkVarchar255是否現(xiàn)金結(jié)算IsxjjsInt4Z_requestedVarchar50一次發(fā)多個(gè)申請(qǐng)時(shí)總的申請(qǐng)單號(hào)1.12藥品領(lǐng)藥申請(qǐng)表doctmark_request中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明申請(qǐng)IDVrequestidnumeric9V科室officeidnumeric9日期ddatedatetime8(getdate())標(biāo)志isRequestint400退回申請(qǐng)1已申請(qǐng)2申請(qǐng)結(jié)■束確認(rèn)isConfirmint400未發(fā)藥1已發(fā)藥執(zhí)行科室execOfficenumeric9發(fā)藥方式FyfsInt4Y領(lǐng)藥退藥WorktypeInt40領(lǐng)藥6退藥發(fā)藥時(shí)間FydateDatetime8如果IsRequest=0為退回申請(qǐng)時(shí)間患者IDHospidNumeric9有值為出院帶藥空為醫(yī)囑領(lǐng)藥1.13醫(yī)囑執(zhí)行表doctmark_exec中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明醫(yī)囑IDVAutoNumbnumeric9執(zhí)行時(shí)間zx_datedatetime8執(zhí)行人zx_operidnumeric9V1.14床位代碼表hosp_cwdmb中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型I長(zhǎng)度［默認(rèn)值［標(biāo)識(shí)|允許空［說(shuō)明科室IDVofficeidnumeric9床號(hào)cwhvarchar20房間號(hào)fjhvarchar20V病區(qū)bq_officeidnumeric9醫(yī)生IDdoctidnumeric9V性別限制xbxzint4V住院IDhospidnumeric9V13-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)類(lèi)別cwlbint40V項(xiàng)目IDmediidnumeric9主床標(biāo)志iszcint401.15出院打折表hosp_discount_price中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明打折IDVdiscountidnumeric9V結(jié)算IDpriceidnumeric9住院號(hào)hospcodechar10次數(shù)serialnumeric9發(fā)票項(xiàng)目no3numeric9項(xiàng)目名稱(chēng)name3char10二級(jí)IDcalcidnumeric9科室requoffidnumeric9執(zhí)行科室execofficenumeric9打折discountdecimal9日期ddatechar8日期datetimedatetime8操作員operidnumeric9狀態(tài)stageint401.16住院日結(jié)記錄表hosp_payhistory中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明操作員Voperidnumeric9結(jié)算組paygroupnumeric9開(kāi)始時(shí)間date_bdatetime8結(jié)束時(shí)間date_edatetime8班組號(hào)group_paynumeric901.17住院病人轉(zhuǎn)科表hosp_change_office中文名稱(chēng)主鍵英文名稱(chēng)0Jg數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VIdnumeric9患者IDHospidnumeric9-14-

轉(zhuǎn)科時(shí)間Ddatedatetime8轉(zhuǎn)科時(shí)間Ddate2Varchar8原科室IDOld_officenumeric90新科室IDNew_officenumeric數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)二、門(mén)診業(yè)務(wù)表表清單名稱(chēng)代碼門(mén)診主表Mzsf_clininvoinfo門(mén)診費(fèi)用明細(xì)表Mzsf_clinreciinfo門(mén)診收款表Mzsf_sfmx處方單據(jù)主表Mzsf_clinreciinfo_cfdj處方明細(xì)表Mzsf_clinreciinfo_cfmx檢治單據(jù)表Mzsf_clinreciinfo_jzdj檢治明細(xì)表Mzsf_clinreciinfo_jzmx門(mén)診發(fā)票表Mzsf_involistnumb門(mén)診作廢發(fā)票表Mzsf_involistnumb_zfmx門(mén)診日結(jié)表Clin_payhistory門(mén)診MZSF_ClinWind患者登記表Gh_hzxx登記患者沖值表GH_ForePayInfo登記患者消費(fèi)明細(xì)GH_HZXX_XFMX掛號(hào)表Nregipati掛號(hào)收費(fèi)明細(xì)表nRegiPatiCharge表結(jié)構(gòu)2.1門(mén)診主表mzsf_clininvoinfo中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明就診號(hào)VAUTONUMBvarchar20ClinNumbnumeric9VCaseldvarchar15V15-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)患者姓名Patinamevarchar10V性別Sexint4V年齡Ageint4VPayWayIDnumeric9V金額ORIGAMOUnumeric9金額DISCAMOUnumeric9金額ownpricenumeric9paymentamoutnumeric90收費(fèi)時(shí)間CREADATEdatetime8(getdate())收費(fèi)員IDCreaOperIDvarchar8日結(jié)組號(hào)PAYGROUnumeric9V日結(jié)人IDPayOperIDvarchar8V日結(jié)時(shí)間PAYDATEdatetime8V病人類(lèi)型PatiTypeIdnumeric9VstrCreaDatechar8V醫(yī)保支付金額sbzfjenumeric90醫(yī)保支付現(xiàn)金金額sbzfxjjenumeric90V收費(fèi)狀態(tài)statusint411正常2作廢3退費(fèi)4無(wú)效自費(fèi)費(fèi)用zffypricedecimal90V個(gè)人支付grzfpricedecimal90V按比例支付ablzfpricedecimal90V統(tǒng)籌記帳tcjzpricedecimal90V大額記帳dejzpricedecimal90V公務(wù)員記帳gwyjzpricedecimal90V個(gè)人帳戶(hù)grzhpricedecimal90Vsbzfpricedecimal90V醫(yī)保證號(hào)ybzhcodedecimal90Vhospcodevarchar9V醫(yī)保狀態(tài)status_ybint40登記表患者IDhzidnumeric9Vmzzyint40醫(yī)療類(lèi)別YLLBint4V是否急診病號(hào)isjzint400門(mén)診1急診isickint40CardcodeVarchar1816-

醫(yī)院心5醫(yī)院心5管理系統(tǒng)門(mén)診費(fèi)用明細(xì)表mzsf_clinreciinfo（廢除）中文名稱(chēng)主鍵英文名稱(chēng)gr數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VAutoNumbvarchar20Serialint4MedilDdecimal9mediid_alldecimal9MediNamevarchar70UnitPricdecimal9Specvarchar30UNITvarchar10CharlDdecimal9CHARNAMEvarchar20ITEMint4DOSEint4QUANTITYint4ITEMAMOUdecimal9wipepercdecimal50VDISCOUNTdecimal5-1STATUSint4-4DELIOPERCODEvarchar8Vdelidatedatetime8VUsageIDdecimal9VUsageNamevarchar20VTimeIDdecimal5VPeriodint4VTimesint4VHzvarchar20VDaysint4VDosagenumeric9VIntoOfficedecimal9Vyldwchar10Vzbint4Vtybzint40lbbzint4Vdoctidnumeric9Voffiidnumeric9Vjjhchar12Visfyint40rshtnonumeric90Vbacknumdecimal90carryidnumeric9V17-

醫(yī)院心5醫(yī)院心5管理系統(tǒng)處方單據(jù)主表mzsf_clinreciinfo_cfdj中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VAUTONUMBvarchar20就診號(hào)SFIDvarchar20VBLHvarchar20V處方號(hào)CF_CODEvarchar12單據(jù)類(lèi)型DJ_TYPEnumeric9處方類(lèi)型CF_TYPEnumeric9V核算IDCHARGEIDnumeric9核算項(xiàng)目CHARGENAMEvarchar10時(shí)間DDATEdatetime8開(kāi)單科室OFFIIDnumeric9開(kāi)單醫(yī)師DOCTIDnumeric9DOSEint4金額PRICEnumeric9V誤差ZEnumeric5V發(fā)藥藥房FY_OFFIIDnumeric9V發(fā)藥窗口FY_CKnumeric9V發(fā)藥人IDFY_OPERIDnumeric9V是否發(fā)藥ISFYsmallint20V發(fā)藥時(shí)間ZX_DATEdatetime8V戈必介人OPERIDnumeric9VKF_DATEdatetime8V是否擺藥ISPYsmallint20V擺藥人IDPY_OPERIDnumeric9V擺藥時(shí)間PY_DATEdatetime8VSTOCK_CHECK_IDvarchar20V狀態(tài)STATUSint4是否使用ISSYint40NOTEvarchar255V患者病例號(hào)HzblhVarchar18V患者卡號(hào)HzkhVarchar18患者條碼號(hào)HztmhVarchar18掛號(hào)流水號(hào)RegiidVarchar18處方明細(xì)表mzsf_clinreciinfo_cfmx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VAUTONUMBvarchar20('0')18-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)序號(hào)SERIALint4項(xiàng)目IDMEDIIDdecimal9組號(hào)ZHint4V項(xiàng)目名稱(chēng)MEDINAMEvarchar70規(guī)格SPECvarchar30V單價(jià)UNITPRICEdecimal9單位UNITvarchar10核算IDCHARIDdecimal9核算名稱(chēng)CHARNAMEvarchar20類(lèi)別ITEMint4V數(shù)量QUANTITYdecimal9最小數(shù)量QUANTITY_MINnumeric9單位UNIT_MINvarchar10金額ITEMAMOUdecimal9自付比例ZFBLdecimal5V打折比例DZBLdecimal5-1VUSAGEIDdecimal9VUSAGENAMEvarchar20VPLIDdecimal5V周期ZQint4V次數(shù)CSint4V頻率PLNAMEvarchar20VDAYSint4V一次用量DOSAGEdecimal9V用量單位YLDWchar10V產(chǎn)地CARRYIDnumeric9V批號(hào)PHvarchar20V有效日期YXQdatetime8V是否收費(fèi)ISPRICEint41VMZZYint40VC_SERIALnumeric90V檢治單據(jù)表mzsf_clinreciinfo_jzdj中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VAUTONUMBvarchar20就診號(hào)SFIDvarchar20VBLHvarchar20V檢治號(hào)JZ_CODEvarchar20單據(jù)類(lèi)型DJ_TYPEnumeric9VCF_TYPEnumeric9VMEDIIDnumeric919-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)核算IDCHARIDnumeric9核算名稱(chēng)CHARGENAMEvarchar20時(shí)間DDATEdatetime8開(kāi)單科室OFFIIDnumeric9開(kāi)單醫(yī)師DOCTIDnumeric9金額PRICEnumeric9V誤差ZEnumeric5V執(zhí)行科室ZX_OFFIIDnumeric9V執(zhí)行人IDZX_OPERIDnumeric9V是否執(zhí)行ISZXsmallint20V執(zhí)行時(shí)間ZX_DATEdatetime8V劃價(jià)人員OPERIDnumeric9V狀態(tài)STATUSint4是否使用ISSYint40NOTEvarchar255V設(shè)備IDsbidnumeric9V患者病例號(hào)HzblhVarchar18V患者卡號(hào)HzkhVarchar18患者條碼號(hào)HztmhVarchar18掛號(hào)流水號(hào)RegiidVarchar18檢治明細(xì)表mzsf_clinreciinfo_jzmx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VAUTONUMBvarchar20('0')序號(hào)SERIALint4項(xiàng)目IDMediIDdecimal9項(xiàng)目名稱(chēng)MEDINAMEvarchar70規(guī)格SPECvarchar30V單價(jià)UNITPRICEdecimal9單位UNITvarchar10核算IDCHARIDdecimal9核算名稱(chēng)CHARNAMEvarchar20類(lèi)別ITEMint4V數(shù)量QUANTITYint4金額ITEMAMOUdecimal9自付比例ZFBLdecimal5V打折比例DZBLdecimal5-1V是否收費(fèi)ISPRICEint4-1VMZZYint40VC_SERIALnumeric9V-20-

醫(yī)院心5醫(yī)院心5管理系統(tǒng)門(mén)診發(fā)票表mzsf_involistnumb中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明 ■發(fā)票號(hào)VINVOCODEvarchar10序號(hào)SERIALint4就診號(hào)SFIDvarchar20發(fā)票號(hào)INVOLISTvarchar20單據(jù)IDDJ_IDvarchar20核算IDCHARIDnumeric9核算名稱(chēng)CHARNAMEvarchar10金額CHARAMOUdecimal9開(kāi)單醫(yī)師DOCTIDnumeric9開(kāi)單科室OFFIIDnumeric9執(zhí)行科室INTOOFFICEnumeric9V收款員SK_OPERIDnumeric9收款時(shí)間SK_DATEdatetime8交款員JK_OPERIDnumeric9V交款組號(hào)JK_SERIALnumeric9V交款時(shí)間JK_DATEdatetime8V是否打印ISPINTint4狀態(tài)STATUSint4是否使用ISSYint40單據(jù)類(lèi)型DJLXint40BXAMOUdecimal90ZFAMOUdecimal90作廢發(fā)票號(hào)INVOCODE_oldvarchar10VY_CHARAMOUdecimal90V醫(yī)師沖卡發(fā)票號(hào)Ys_invocode打印發(fā)票人IDDy_operid門(mén)診作廢發(fā)票表mzsf_involistnumb_zfmx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明原發(fā)票號(hào)VINVOCODEvarchar10序號(hào)SERIALint4就診號(hào)SFIDvarchar20原發(fā)票號(hào)INVOLISTvarchar20-21

作廢人IDSK_OPERIDnumeric9作廢時(shí)間SK_DATEdatetime8交款人IDJK_OPERIDnumeric9V交款組號(hào)JK_SERIALnumeric9V交款時(shí)間JK_DATEdatetime8V是否打印ISPINTint4狀態(tài)STATUSint4數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)門(mén)診日結(jié)表clin_payhistory醫(yī)院心5管理系統(tǒng)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明日結(jié)人IDVoperidvarchar10日結(jié)組號(hào)paygroupnumeric9開(kāi)始時(shí)間date_bdatetime8結(jié)束時(shí)間date_edatetime8group_paynumeric9Vgroup_operidvarchar10V是否打印isprintint40患者登記表Gh_hzxx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明患者IDVHZIDvarchar10患者編號(hào)HZCODEnumeric9姓名NAMEdatetime8拼音碼PYMdatetime8性別SEXnumeric9V醫(yī)療類(lèi)別YLLXvarchar10V病例號(hào)Hzblhvarchar18卡號(hào)hzkhvarchar18條碼號(hào)hztmhvarchar18沖值總額CZZJEnumeric9消費(fèi)總額XFZJEnumeric9銷(xiāo)戶(hù)原因JYYYvarchar50登記患者沖值表GH_ForePayInfo中文名稱(chēng)主鍵英文名稱(chēng)皿.1= El數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明-22-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)序號(hào)*BhNumeric9患者IDHzidNumeric9患者姓名HzxmVarchar20。。類(lèi)別YjlbInt4金額JeDecimal9操作員IDCzyNumeric9操作員姓名CzyxmVarchar20時(shí)間FssjDatetime8沖退編號(hào)CtbhNumeric9RemarkVarchar50收費(fèi)打印SfdyInt4登記患者消費(fèi)明細(xì)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明序號(hào)*IdNumeric9門(mén)診就診號(hào)AutonumbNumeric9掛號(hào)流水號(hào)RegiidVarchar20患者IDHzidInt4金額PriceDecimal9沖卡金額CkpriceNumeric9消費(fèi)時(shí)間DdateVarchar20病例號(hào)HzblhDatetime8條碼號(hào)HztmhNumeric9帳戶(hù)余額ZhyeVarchar50退費(fèi)所對(duì)應(yīng)的正記錄的門(mén)診就診號(hào)或掛號(hào)流水號(hào)Y_autonumbInt4掛號(hào)表Nregipati中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明流水號(hào)*RegiIDVarchar20RegiTrackInt4autonumbNumeric9患者IDPatiIDNumeric9CaseIDVarchar12-23-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)姓名nameVarchar10性別sexInt4病人類(lèi)型patitypeidNumeric9掛號(hào)時(shí)間RegiDateDatetime8RegiStrDateVarchar8掛號(hào)科室OfficeIDNumeric9offiid_orderNumeric9掛號(hào)醫(yī)師DoctorIdNumeric9doct_orderNumeric9操作員operidNumeric9金額priceNumeric9狀態(tài)statusInt4日結(jié)組號(hào)PaygroupNumeric9日結(jié)時(shí)間paydateNumeric9日結(jié)人IDpayoperidNumeric9zdstatusInt4病例號(hào)blcodeVarchar18沖卡金額CkpriceNumeric9病例號(hào)hzblhVarchar18卡號(hào)hzkhVarchar18條碼號(hào)hztmhVarchar182.143掛號(hào)收費(fèi)明細(xì)表nRegiPatiCharge中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明流水號(hào)*RegiIDVarchar20項(xiàng)目IDMediidNumeric9單價(jià)UnitpriceNumeric5CountnumNumeric5ItemsumNumeric5狀態(tài)StatusInt4發(fā)票號(hào)InvocodeVarchar10Invocode_oldVarchar10*-24-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）三、藥房藥庫(kù)業(yè)務(wù)表醫(yī)院心5管理系統(tǒng)表清單醫(yī)院心5管理系統(tǒng)名稱(chēng)代碼出入庫(kù)單據(jù)總表Gledi_total出入庫(kù)單據(jù)明細(xì)表Glide選入藥品表Store_infostru藥房庫(kù)存表Store_InfoStru_detail盤(pán)點(diǎn)表Store_check盤(pán)點(diǎn)明名細(xì)表Store_check_detail藥房庫(kù)存明細(xì)表YF_kcmx藥房庫(kù)存明細(xì)表歷史YF_kcmxls表結(jié)構(gòu)出入庫(kù)單據(jù)總表glide_total中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明出入庫(kù)標(biāo)記VGlideldnumeric9VBaseCodenumeric5FellowIdnumeric5出/入庫(kù)區(qū)別InOutint4Tranldint4V單據(jù)號(hào)InOutOddvarchar16fdjzsnumeric50操作員Inputornumeric9HappenDatedatetime8是否審核Stageint40審核人員Auditornumeric9V審核日期A(yíng)uditDatedatetime8Vhandervarchar16VConfSignint40Confdatedatetime8Vconfopernumeric9Vcheckidnumeric9Vpostidnumeric9Vpostdatedatetime8Vremarkchar50V-25-

yk_storeidnumeric9Vyk_jzidnumeric9Visprintint40數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)出入庫(kù)單據(jù)明細(xì)表glide中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VGlideldnumeric9序號(hào)Orderldint4項(xiàng)目IDmediidnumeric9idnumeric9VRShtNonumeric9VInvoiceldvarchar12V數(shù)量InOutNumdecimal90單位unitvarchar8hgsldecimal90進(jìn)價(jià)ActPridecimal90Discountdecimal5VJobPridecimal90售價(jià)RetailPridecimal90進(jìn)價(jià)金額ActMondecimal90JobMondecimal90售價(jià)金額RetailMondecimal90TurnDatedatetime8VProductNovarchar16V已出庫(kù)數(shù)量Outnumnumeric50出庫(kù)金額outamountnumeric90產(chǎn)地carridnumeric9VoutRetailPrinumeric9V扣率ypklnumeric9-1bafkdecimal90Vfkdatetimedatetime8Vremarkvarchar50Vzbidnumeric9Vzbpricedecimal90VConfSignint40最小數(shù)量min_numdecimal9藥品單價(jià)IDypdjidnumeric9V-26-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)選入藥品表store_infostru醫(yī)院心5管理系統(tǒng)中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明科室IDVOfficeldnumeric9項(xiàng)目IDMedildnumeric9助記碼memocodevarchar10V最小庫(kù)存MinStoredecimal50最佳庫(kù)存BestStoredecimal50MinBuydecimal50remaindecimal5Vretaildecimal9V是否禁用islackint4Vpfwznumeric9Vischeckint4是否管理isglint40操作員Inputornumeric9V日期Inputdatedatetime8V藥房庫(kù)存表store_infostru_detail中文名稱(chēng)主鍵英文名稱(chēng)皿，10 gr數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明序號(hào)Vidnumeric9V藥房idofficeidnumeric9項(xiàng)目IDmediidnumeric9批號(hào)phvarchar20V有效日期yxqdatetime8V產(chǎn)地carryidnumeric9V售價(jià)retaildecimal90數(shù)量remaindecimal50最小數(shù)量minnumnumeric90是否禁用islackint40藥品單價(jià)IDypdjidnumeric90盤(pán)點(diǎn)表store_check中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明Vidnumeric9V庫(kù)房IDofficeidnumeric9remarkvarchar30V-27-

醫(yī)院心5管理系統(tǒng)會(huì)計(jì)期間醫(yī)院心5管理系統(tǒng)會(huì)計(jì)期間kjqjchar6日期ddate1datetime8審核日期ddatedatetime8操作員opernamevarchar10是否審核isconfirmint40操作員opername2varchar10V標(biāo)志bzint401盤(pán)點(diǎn)0結(jié)轉(zhuǎn)數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）盤(pán)點(diǎn)明細(xì)表store_check_detail中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VIDnumeric9序號(hào)SERIALnumeric9V項(xiàng)目IDMEDIIDnumeric9產(chǎn)地CARRYIDnumeric90V批號(hào)PHvarchar20V有效日期YXQdatetime8V單價(jià)UNITPRICEdecimal90上期結(jié)余數(shù)量PRENUMdecimal90售價(jià)PREACTMONdecimal90金額PRERETAILMONdecimal90入庫(kù)數(shù)量INNUMdecimal90售價(jià)INACTMONdecimal90金額INRETAILMONdecimal90出庫(kù)數(shù)量OUTNUMdecimal90售價(jià)OUTACTMONdecimal90金額OUTRETAILMONdecimal90TJSYdecimal90ZMSZdecimal90MIN_SLnumeric9ZMSZSLdecimal90QRNUMdecimal90QRACTMONdecimal90QRRETAILMONdecimal90PYNUMdecimal90PYRETAILMONdecimal90PKNUMdecimal90PKRETAILMONdecimal90XSNUMdecimal90XSRETAILMONdecimal90-28-

醫(yī)院心5醫(yī)院心5管理系統(tǒng)藥房庫(kù)存明細(xì)表yf_kcmx中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VIDnumeric9VYFIDnumeric9CRBSint4LXsmallint2DJHvarchar20XHsmallint2RQdatetime8MEDIIDnumeric9SLnumeric9ZXDWSLnumeric9DJdecimal9PHvarchar20VYXQdatetime8VCDIDnumeric9VPDIDnumeric9VJZBSint40SYBSint40OFFICEIDnumeric9Kcidnumeric90ypdjidnumeric90藥房庫(kù)存明細(xì)表歷史yf_kcmxls中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VIDnumeric9YFIDnumeric9CRBSint4LXsmallint2DJHvarchar20XHsmallint2RQdatetime8MEDIIDnumeric9SLnumeric9ZXDWSLnumeric9DJdecimal9PHvarchar20VYXQdatetime8VCDIDnumeric9VPDIDnumeric9V-29-

JZBSint40SYBSint40OFFICEIDnumeric9kcidnumeric90ypdjidnumeric90數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)四、通用字典表醫(yī)院心5管理系統(tǒng)表清單名稱(chēng)代碼操作員表Dictoper科室代碼表Dictoffice職稱(chēng)表Dicttitle項(xiàng)目表Dictmedi三級(jí)項(xiàng)目表Dictcharge二級(jí)項(xiàng)目Dictcalc病人類(lèi)型表Dictpatitype藥品單價(jià)表Dictmedi_ypdj協(xié)定處方表Dictmedi_rela系統(tǒng)設(shè)置表Clin_SysSet程序版本模塊信息表Hosp_ver程序模塊菜單表hosp_ver_model醫(yī)院信息表InfoHosp權(quán)限用戶(hù)表Sys_authority_user權(quán)限表Sys_authority藥品用法表1DictTimes藥品用法表2NClinSpecUser藥品用法表3NClinSpecUser2表結(jié)構(gòu)4.1操作員表dictoper中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明-30-

操作員IDVOperldnumeric9V代碼OperCodevarchar6密碼OperPswdvarchar255V名稱(chēng)OperNamevarchar10V服務(wù)名SrvNamevarchar6V職稱(chēng)Titleldnumeric5V門(mén)診科室Officeldnumeric5V住院科室officeid2numeric5V工作類(lèi)別TitleId2numeric9V頭銜TitleId3numeric9VAdviMarkint4VChgPswdint4VReceSuredatetime8VAlwayValidint4VPerioddatetime8V組號(hào)paygroupint4VAccFlagint4V操作員Inputorvarchar6V日期InputDatedatetime8V狀態(tài)Stageint4V審核人Auditorvarchar6V審核日期A(yíng)uditDatedatetime8V助記碼zjmvarchar10Vsend_paygroupdecimal90memocodevarchar10Vyybhvarchar4V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)科室代碼表dictoffice中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型 長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明科室IDVOfficeIdnumeric5V代碼OfficeCodevarchar4V名稱(chēng)OfficeNamevarchar60類(lèi)型OfficeKindint4上級(jí)HighOfficenumeric5類(lèi)別OfficeTypeint4電話(huà)OfficePhonevarchar30V地址OfficeAddrvarchar30V操作員Inputorvarchar6V日期InputDatedatetime8V狀態(tài)Stageint4審核人Auditorvarchar6V審核日期A(yíng)uditDatedatetime8V-31

isBeginint4V助記碼zjmchar12V押金限額yjjxenumeric90發(fā)藥限額fyxenumeric90V記帳限額jzxenumeric90V固定床位gdcwnumeric90Vksbsint40Visykint40Vbasecodenumeric90num_sxint4Vbadnumbnumeric9Visqrfyint40ordercodevarchar8Vordernamevarchar50（'未分科室'）no_flnamevarchar20Visprintint4-1isstatchar100Vno_flnumbvarchar10ybofficecodevarchar10Vmemocodevarchar20V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)職稱(chēng)表dicttitle中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明職稱(chēng)IDVTitlelddecimal9V代碼TitleCodevarchar4V名稱(chēng)TitleNamevarchar20描述TitleDescvarchar40V操作員Inputorvarchar6(user_name())V操作日期InputDatedatetime8(getdate())V狀態(tài)Stageint4V審核人Auditorvarchar6V審核日期A(yíng)uditDatedatetime8V項(xiàng)目表dictmedi中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明項(xiàng)目IDMediIddecimal9V項(xiàng)目名稱(chēng)MediNamevarchar20V項(xiàng)目代碼MediCodevarchar10VAddicodevarchar10V-32-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)ScieNamevarchar30VMediAliasvarchar30V拼音碼MemoCodevarchar10V五筆碼WbCodevarchar4V拉丁碼LatnCodevarchar20Vybcode_drvarchar20V規(guī)格Specvarchar20V最新進(jìn)價(jià)NewActPridecimal90藥品來(lái)源MediSourceint4-1ProManuvarchar30VPiosidint4Vstuffidint4V產(chǎn)地IDcarryidint4VProFellowIDint4V貴重性IDPrecidint4V分類(lèi)IDKindIddecimal5V項(xiàng)目類(lèi)別Itemint40藥品1檢治2床位3協(xié)定處方Shapeint40V劑型NeedleIddecimal5V藥品類(lèi)型TypeIddecimal5V核算IDChargeIddecimal5BCalcIddecimal5V歸入科室IntoOfficenumeric9V執(zhí)行科室execofficenumeric9VBanStatint4-1VMediCareint4VMediCare_drint4VWipePercdecimal50VPayPercdecimal5-1VCombFactorint4VCombFactor1int4VAmbUnitvarchar10VAmbUnit1varchar10VSFixGPricedecimal9Vambpricedecimal9VAmbPrice1decimal9VFixPricedecimal90VYKPricedecimal9VHspUnitvarchar10VRemaindecimal50VAmountdecimal9V定價(jià)分類(lèi)Mptypeint4VInputorvarchar6(user_name())VInputDatedatetime8(getdate())VisNewint4V-33-

validDateint4VStageint40Auditorvarchar6VAuditDatedatetime8Vhosptypenumeric9isPriceint4detailidnumeric9isUsernumeric90operid1numeric9Voperid2numeric9Vislackint4VisManualint4VminUsagenumeric5VambUnit2varchar10Vofficeidnumeric9Vambunit3varchar10Vsccjvarchar30Vgmpchar2Vjbylnumeric9Vyldwchar8Vybcodechar15Vfyfsint4-1Vispsint40Viscfyint40Vpayperc_drdecimal5-1Viszbpzint40Vminunitchar10-1min_splitnumeric9-1store_splitnumeric9-1clinic_splitnumeric9-1hosp_splitnumeric9-1xmnhnvarchar255Vcwnrnvarchar255Vjjdwvarchar50Vsmvarchar255V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）醫(yī)院心5管理系統(tǒng)三級(jí)項(xiàng)目表dictcharge中文名稱(chēng)主鍵英文名稱(chēng)數(shù)據(jù)類(lèi)型長(zhǎng)度默認(rèn)值標(biāo)識(shí)允許空說(shuō)明VChargelddecimal9VChargeCodevarchar4VChargeNamevarchar20CalcIddecimal5-34-

數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版） 醫(yī)院心5管理系統(tǒng)Inputorvarchar6VInputDatedatetime8VStageint4VAuditorvarchar6VAuditDatedatetime8Vno1int4Vname1varchar20Vno2int4Vname2varchar20Vno3int4Vname3varchar20Vno4int4Vname4varchar20Vno5int4Vname5varchar20Vno6int4Vname6varchar20Vno7int4Vname7varchar20Vno8int4Vname8varchar20Vno9int4Vname9varchar20Vno10int4Vname10varchar20Vno11int4Vname11varchar20Vno12int4Vname12varchar20Vno13int4Vname13varchar20Vno14int4Vname14varchar20Vno15int4Vname15varchar20Vno16int4Vname16varchar20Vno17int4Vname17varchar20Vno18int4Vname18varchar20Vno_jjbint4Vno_namevarchar20Vno_namemarkvarchar20Vno_yjksint4V-35-

no_yjksnamevarchar20Vno_kscodeint4Vno_ksnamevarchar20Vno_sybnumeric5Vno_sybnamevarchar20Vno_proportingdecimal9Vno_whetherint4Vno_jjhsvarchar20Vno_jjhsnamevarchar20Vno_jshmarkvarchar50Vfylxint40Vno_hnjbvarchar2Vno_hnjb_namevarchar20V數(shù)據(jù)結(jié)構(gòu)手冊(cè)（第二版）