數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書.docx

1、數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書創(chuàng)業(yè)項(xiàng)目經(jīng)理：日期：修改歷史日期版本作者修改內(nèi)容評(píng)審號(hào)更改請(qǐng)求號(hào)00002中心庫(kù)表單描述ttWUi標(biāo)識(shí)表中文名表名父農(nóng)名父農(nóng)關(guān)聯(lián)外擺數(shù)據(jù)分粗名l-KSYSDATA1.2圖00系統(tǒng)表VARaiAR2(l0)VARaiAR2(100)VARCHAR2(30)NUMBERVARaiAR2(30)YARaiAR2(3O)VARaiAR2(IO)00.004批次更新記錄批次號(hào)散帔代研果后史斷時(shí)間批次開(kāi)始時(shí)間批次垢束時(shí)閭VARCHAR2(16)V.M?CHAR2(40)DATEDA1EDA1E00_005附登債規(guī)則敬地IDVARCHAR2(10)數(shù)據(jù)集代碼VARCHAR2(40)附件類型編

2、碼(文檔格式)VARCHAR2(2)存fi#方式VARCIIAR2(1)存儲(chǔ)參數(shù)VARCIIAR2(500)1.3圖99接口表單1.4圖OO-EMPI個(gè)人基本信息*irAurxHvtei、；，c*91H，q，.mVi2：*44;*turrl!KH*4“g*&，、EOl5im人Y4l3*443加Al.MAARCWA礦偵EFtwwujomni，業(yè)的g”riUtkLtpHC1IUIWwtnunuitKt?漩iitnqmhauni*ntXHrAMMK2IX&mbimtf.HTrivrnomuiin人，E0；aL5圖01-emrview數(shù)據(jù)盒收藏夾鍵戶容建工主用內(nèi)創(chuàng)員INTEGERVARCHAR2(30

3、)VARCHAR2(2000)DATEVARCHAR2(30)用戶idVARCHAR2(50)姓名VARCHAR2(50)文件夾VARCHAR2(30)備注VARCHAR2(500)創(chuàng)建時(shí)間DATE主索引IDchar(32)就診標(biāo)識(shí)VARCHAR2(30)1.6圖Accountid栗呼弓U*鋼】8么易流水弓v.viauRz(zo)(MTB也村：族引num)M由機(jī)構(gòu)V.WHKK2(MI傳出成幻業(yè)并俗統(tǒng)）V.WVHUC2(2(1)的入財(cái)V.WHUC2I50)H入底今W芥雍統(tǒng)）V.WaiU2l20)2)V(WUR?(50)meVARnUR?(200)耕示玄GUR(2VAKnURZ(HKI)2獨(dú)操作入

4、VAftlHKk2(50)父岫WV.WLHUC2(20)V.Vn：HU2ltOOO)人工奶螭MARQIAR蚪昧H掬IXXTE*人姓名VARUURZdOO)fldrtutlKV.UXHAR2(20lpk/ZU足性偵VARCHAR2(6O)機(jī)枸代列機(jī)杓侖松啟用賬戶共享贓戶芯務(wù)地址賬戶眼務(wù)域名VABCHAR2(5O)VABCIUK2(20)OURVAOAR2C50)VARCHAR2CSO)甘豚H期捻偉入交易Jf飴日M交映Al止H期姑暇沈故DATEVMiaiUfc250)MTEDATENVWfRG)FKACSETRBECTRESVLTSETTIDM眥血18H政凱構(gòu)VAIKHKR2I5O)CIMR話吐f

5、海MV1RUO.27易Hl構(gòu)VAHQilR2(50)M.WRI.I8)NltBER(18)YAW：UR2(20)NLMBERC10.2)ClURY.U3CiWR2(5OO)L7圖dataset標(biāo)準(zhǔn)-數(shù)據(jù)標(biāo)準(zhǔn)版本標(biāo)日者者據(jù)稱本布布理態(tài)明數(shù)名版發(fā)發(fā)管狀說(shuō)VARCHAR206)VARCHAR2(50)VARCIiAR2(16)DATEVARCIIAR2(32)VARCILR2(32)aiAR(l)YARCHAR2(200)標(biāo)準(zhǔn)-數(shù)據(jù)集目錄目錄ID數(shù)據(jù)標(biāo)準(zhǔn)ID目錄標(biāo)識(shí)自定義標(biāo)識(shí)日錄名稱泉廂目錄啟用NUMBERVARCIIAR2(16)VARCIIAR2(20)VARCHAR2(50)VAKCHAR2(

6、50)INTEGERIINTEGER標(biāo)準(zhǔn)-數(shù)據(jù)元數(shù)據(jù)元IDNUMBER(6)數(shù)據(jù)標(biāo)準(zhǔn)IDVARCIIAR2(16)衛(wèi)生部標(biāo)i只符VARC1LAR2(5O)自定義標(biāo)識(shí)符VARC1WR2(5O)名稱VARCHAR2(50)數(shù)據(jù)類型VARCHAR2(2)數(shù)據(jù)長(zhǎng)度VARCHAR2(15)字典VARCHAR2(50)最大值VARQWR2(16)最小值VARCHAR2(16)分類INTEGER說(shuō)明VARCHAR2(500)標(biāo)準(zhǔn)依據(jù)VARCHAR2(100)最后修改時(shí)間DATE標(biāo)準(zhǔn)-數(shù)據(jù)元目錄數(shù)據(jù)元類別【D數(shù)據(jù)標(biāo)準(zhǔn)1D衛(wèi)生部標(biāo)識(shí)符自定義標(biāo)識(shí)符名稱數(shù)據(jù)元類型NUMBER(6)VARaiAR2(16)VARCH

7、AR2C50)VARCHAR2(50)VARaiAR2(50)VARCHAR2標(biāo)準(zhǔn)-數(shù)據(jù)組標(biāo)準(zhǔn)-數(shù)據(jù)集內(nèi)容數(shù)據(jù)集IDNUMBER(6)數(shù)據(jù)標(biāo)準(zhǔn)【DVARCHAR2(16)衛(wèi)生部標(biāo)識(shí)符VARCHAR2(50)自定義標(biāo)識(shí)符VAKCHAR2(50)名稱VARCHAR2(50)目錄INTEGER說(shuō)明VARCI1AR2(5OO)啟用INTEGER數(shù)據(jù)集映射VARCHAR2(1000)依賴數(shù)據(jù)集VAKCHAR2(50)關(guān)聯(lián)外梃VARCHAR2(50)標(biāo)準(zhǔn)-數(shù)據(jù)集集集元義標(biāo)內(nèi)IDID標(biāo)識(shí)容識(shí)符ID符L8圖haiOO-hai基礎(chǔ)碼次性數(shù)數(shù)標(biāo)據(jù)值名認(rèn)名段型度志值默表字類長(zhǎng)標(biāo)NUMBER(6)INTEGERINT

8、EGERVARCIIAK2(5O)VARCHAR2(50)VARCIIAR2(5O)VARCILR2(500)VARC11AR2(5O)GIAR(l)GIAR(l)INTEGERINTEGERVARCILR2(50)INTEGERINTEGERVAKCHAK2(500)VARCIIAR2(500)VARCIIAR2(5O)VARCILR2(50)varchar(2)varchar(15)aiAR(l)數(shù)據(jù)組ID數(shù)據(jù)標(biāo)準(zhǔn)ID標(biāo)識(shí)符所屬數(shù)據(jù)狙出現(xiàn)次數(shù)強(qiáng)制性標(biāo)識(shí)NUMBER(6)VARCHAR2(16)VARCHAR2(50)VARCIIAR2C50)INTEGERINTEGERchar(l)標(biāo)準(zhǔn)-

9、字輿審核記錄典本核核核ID字版審申審INTEGERVARaiAR2(200)VARQIAR2(50)VARQIAR2(50)DATEINTEGER10-ods業(yè)務(wù)10-CDR庫(kù)11-采集日志表（參112-數(shù)據(jù)采集配置SIQ(W印90某lOCiW?gAg心WMCIWHOW.10(1ZggA9*由WmHgA牛由由蛾中aivt出日琳史由蛾中WZUWgA知KZJ1PIOI2U也gA位月瓶討5H郵中IOIZggAlOtRHWA3AWExlUB5frg/ggAwwzwr*呻ZggAFWW9Sfi(ggg*NAaVtt-Sfi1)51g。沖1051?HWWA1051?W5*JtAJltlWKa：IOSI?X

10、W5*WA第蒙*Q，lOSWVmVAiosiIO?IJKWATA岫g:UW(?3XW(HWllt0WifW4i*VtIOU?WWW*A窣*由尊由(gSWiMA1051WtftUMA奇n/ftiiiosizmg*fe*bTttionM3A成Kion7tnuzr.iosiManwAtMWYlocirvwztfv.KiosinnsMAt必Wiosir*nsztfv.iocirmttZtfVA有!lacirgg.eH曰玉所“1中(g】tfVSg.!U-larirwsiztfY.KfeBfiiir-larirwsizwr.K也由儀痛I0ZI?tf33W.心Dlaziwmzwa(coilWVT3WA尖，l

11、aciewszwAUCIWK?(zlwto!叫10霹“snbX+刷收即由mtOI”lpCS1rWH4VA封狗*，WEOM(WirM4/.NK到*WirwMyY/.陸A*召版:祈,2123舊版門出*婦NJkKCIlP(csi*fuyw.STOMZCM.，皿a*(Mirwuiv/.您妊212(沖成日妊!to*rmu/.引妥法諼(D：jrcfu：fiw.&由(os)rrnifY/.ODt)refiiiY/.iitH(Dr)rtffMv/.:)rcwiY/.，以出W33LV3Cflte*f3P2(Dt)rMMV/.9i2oce)rBWMY/.SMNiagEHAVAgw日tti(ODmglVAaMWMB

12、XTM目gEHEVA0XM3(0DrtMH：t4V/.“3(0l)rWH2W.Si犯幻(W)H：edV/.iiSaWYb*g渤H*vnHMgV冬gewnwn功分知XY$，W)?WH：t4VAt!VHVWgEHAVAfc*rn-rWXVA&wwun.SQ0所日壬帶1【”叫f8U-(M)?VH：tVAgBgH：做IC?I7WHMVA(tn?wc時(shí)8*(宙)ClooorHWft功君境，(WITWKMVAIK)W3H身IE*壬I2)WWD尊ir)tiW3SOx)miDmraIPiWOSOO)23習(xí)引go【83iW0gZ抑JtfiA”)53金當(dāng)Kt35lY2!OaW*g/tMO永AttMY?Gq：ai的

13、O4RtflHJtfAgY2!0火，gZ抑3孫ttY?GVawo012抑3打&*丫拳IOOU?eW5VAgZMJWAiggewmgZM3WIggMWfA051?HW3TfftBW0feiUWDMarb.llfW0Y(IRWWiWAMgg(liEwrwiASfW051gjmSR5SB051ctmizwAWV5SH0；icrm:wrA0517iWt?fAlOOgmwAW偵IIUWWAewmiMA告耕(t。grmncfAMVWieWirtMZWA&為w廿(gm而aioon7iwAktatowxiggesfA(：lirtM36t)wmo踏2fSNl”8D)pgus：u廠”01害巳棗炭【038|spo圍

14、0TI前置機(jī)原始數(shù)據(jù)文檔IDCHAR(16)數(shù)據(jù)集名稱VARCHAR2(32)文檔標(biāo)題VARCHAR2(50)有效時(shí)間DATE機(jī)構(gòu)名稱VARCHAR2(56)作者所在機(jī)構(gòu)VARCHAR2(56)數(shù)據(jù)來(lái)源1DVARCHAR2(32)數(shù)據(jù)集版本VARCHAR2(10)作者VARCHAR2(32)系統(tǒng)時(shí)間DATE上傳時(shí)間DATE文檔格式VARCHAR2(8)壓縮類型VARCHAR2C8)患者主索引VARCHAR2(1OO)錯(cuò)誤信息VARCHAR2(4000)錯(cuò)誤時(shí)間DATE狀態(tài)碼INTEGER錯(cuò)誤次數(shù)INTEGER重試次數(shù)INTEGERnsxx二二MMaoiM:mw一W三HH蘭安是至一h:=w前置機(jī)

15、原始數(shù)據(jù)臨時(shí)表文檔IDCHAR(16)數(shù)據(jù)集名稱VARCHAR2(32)上傳時(shí)間DATE文檔頭部VARCH/R2(4000)文檔正文BLOB原始文檔正文BLOB患者主索引錯(cuò)誤信息VARCHAR2(2000)iatnnrnA；il.HlUJiSftS.AifWtkvrM.tcUm.V-kJI*AU.WKrarxt”1.15圖寸52uiLn門（急）診病歷5200fJ(急)診病歷(EIREncountcrMcdicalRe文檔查引號(hào)CHAR(16)就診標(biāo)識(shí)CHAR(16)愚者類型CHAR主素引標(biāo)識(shí)CHAR(32)來(lái)源標(biāo)識(shí)VARCIIAR2(5O)分區(qū)標(biāo)詛CIIAR(l)統(tǒng)計(jì)口期DATE記錄分類VAR

16、CHAR250)記錄名稱VARGIAR250)記錄時(shí)間DATE有效標(biāo)志CHAR1)版本VARaiAR2(10)創(chuàng)建機(jī)材代碼VARCIIAR2(5O)創(chuàng)建機(jī)構(gòu)名稱VARCHAR2創(chuàng)注人VARGIAR232)創(chuàng)建時(shí)間DATE審核人VARGIAR2文檔索引號(hào)CHAR(16)就診標(biāo)識(shí)CIIAR(16)患者炎型CHAR(2)主索引標(biāo)識(shí)CHAR(32)分K標(biāo)識(shí)CIIAR(l)統(tǒng)計(jì)日期DATE有效標(biāo)志CIIAR(l)創(chuàng)建機(jī)構(gòu)代碼VARGIAR2科室名稱VARCHAR2現(xiàn)病史VARCIIAR2(2000)既往史VARCHAR2處理意見(jiàn)VARCIIAR22000)中醫(yī)”四診”觀察姑果描述VARCIIAR2(20

17、00)辨證分型代碼VARCIIAR2(7)記錄號(hào)文檔索引號(hào)文檔格式文檔內(nèi)容5200門（急）診病歷-文檔（EMREncountcrMccCHAR(16)DkCHAR(16)CHAR(2)BLOB5300(1急)診處方(EURPrescriptions)CHAR(16)X：搜次。cmv(ia)5301)門(公)vit/j,-iCt5(FMR_Prescriptiorkii文檔索的號(hào)文性格式girrun】inUCmR(l6)瀏岫ttl5301(1急)診蛇方記錄DIRPrrscriptionRccord)記錄與加更時(shí)文檔術(shù)aiAR(!6)MSClhk(l6)小村cnFU)主修明似枳ClhfcCU)vv

18、Kineiw)KUvJCHlf(lSUHM(MTf同山EWMKW代HVMKinWISO)0.aiuuz4YQKIlgllOW邱年舫（歲）Vk心3)*:*cmYWUK2I2O)歡為旅七；vmnk2i2頃)中土稅名名牧YUKHIK13X11中飯任做代曰vwinQ)中版近皺名馱丫戚巾處頃|vwiniioci中MIX片*方VOKHIll中肖女片斛數(shù)YQXinKJIUMU中傳川為方?jīng)QYWKinKISO)*敗，氏車若幺YWnR2l5O)voKinwifio)敢方督田方制印整幺VI心50)段與珂M知窩&VMKintol50)成為種仆笏幺YU偵心t)致。而品介卬MMMMIIKJ)vxmn!i)chu(iVWK

19、HlfcilSO)5301(J(急誨處方用ft(EMRPrescriptionDiCHAR(16)女農(nóng)記朵、CHAR文計(jì)時(shí)今分lSWaUEl)偵1以auEn處力J1I藥與AiUIUt2(20lMW!F什為檀用次UHF;*UMIVn(A頑mua片初性州偵率VM1HB2(2OI昔咨”用攻F代小IAHHB2i2OI地方悅用天敷MWF(01WK1K_2I9WHVtworn(2o用gliSDH-Fda.21目錄一. 概述3支持?jǐn)?shù)據(jù)庫(kù)及版本3二. 數(shù)據(jù)庫(kù)文檔的管理4命名規(guī)范4三. 數(shù)據(jù)類型5注意事項(xiàng)6四. 系統(tǒng)數(shù)據(jù)表結(jié)構(gòu)設(shè)計(jì)6模型描述61.17圖454檢查檢驗(yàn)記錄1.18圖寸55治療處置一般治療處置記錄萋

20、EFP_虹=三=互E三咨買=_一一111碼稱識(shí)代名識(shí)型標(biāo)識(shí)識(shí)期類稱間志構(gòu)構(gòu)間間間間要標(biāo)類引標(biāo)標(biāo)H分名時(shí)標(biāo)機(jī)機(jī)人時(shí)人時(shí)時(shí)時(shí)摘號(hào)診者索源區(qū)計(jì)錄錄錄效本建建建建核核傳新錄次就患主來(lái)分統(tǒng)記記記有版創(chuàng)創(chuàng)創(chuàng)創(chuàng)審審上更記批L19圖寸56治療處置一助產(chǎn)記錄5600治療處置-助產(chǎn)記錄(EMR_DeliveryRe文檔索引號(hào)CHAR(16)CHAR(16)CHARCHAR(32)VARCHAR2(50)CHAR(l)DATEVARCHAR2(50)VARCHAR2(50)DATECHAR(l)VARCHAR2(10)VARCHAR2(50)VARCHAR2(100)VARCHAR2(32)DATEVARCI1AR

21、2(32)DATEDATEDATEVARCHAR2(4000)CHAR(16)FK_EMR_Deliv?ryRecord_Doc5600治療處置-助產(chǎn)記錄文檔(EMR.Delive記錄號(hào)CHAR(16)文檔索引號(hào)CHAR(16)文檔格式CHAR(2)文檔內(nèi)容BLOB5800護(hù)理評(píng)估與計(jì)劃(EMRNurseAsessmentPlan)文檔索引號(hào)CHAR(16)notnullCHAR(16)notnul1CHAR(2)notnul1CHAR(32)notnul1VARCHAR2(50)notnul1CHAR(l)notnullDATEnotnullVARCHAR2(50)notnullVARCHA

22、R2(50)notnullDATEnotnul1CHAR(l)notnullVARCHAR2(IO)notnul1VARCHAR2(50)notnullVARCHAR2(100)notnul1VARCHAR2(32)notnullDATEnotnullVARC1【AR2(32)nullDATEnullDATEnullDATEnullVARCIIAR2(4000)nullCHAR(16)nullCHAR(l)nullCHAR(16)notnul1CHAR(2)notnul1CHAR(32)notnul1VARCHAR2(50)notnul1CHAR(l)notnullDATEnotnullVAR

23、CHAR2(50)notnullVARCHAR2(50)notnullDATEnotnul1CHAR(l)notnullVARCHAR2(IO)notnul1VARCHAR2(50)notnullVARCHAR2(100)notnul1VARCHAR2(32)notnullDATEnotnullVARC1【AR2(32)nullDATEnullDATEnullDATEnullVARCIIAR2(4000)nullCHAR(16)nullCHAR(l)null碼稱識(shí)代名識(shí)型標(biāo)識(shí)識(shí)期類稱間志構(gòu)構(gòu)間間間間要態(tài)標(biāo)類引標(biāo)標(biāo)口分名時(shí)標(biāo)機(jī)機(jī)人時(shí)人時(shí)時(shí)時(shí)摘號(hào)狀診者索源區(qū)計(jì)錄泉錄效本建建建建核核傳新錄次歷就患主

24、來(lái)分統(tǒng)記記記有版創(chuàng)創(chuàng)創(chuàng)創(chuàng)審審上更記批病gPKEMRXAPIDX_EMR_NAP_VPIIDIDX_EMR_NAP_VisitIDIDX_EMR_NAP_ZoneIDIDX_EMR_NAP_StatDateIDXEMRNAPEffectivcTinicFK_EMRNIJRS_REF!RENCE_EMRNURS5800護(hù)理評(píng)估與計(jì)劃文檔(EMRNurseAsessmentPh記錄號(hào)CHAR(16)Wknotnull文檔索引號(hào)CHAR(16)notnull文檔格式CHAR(2)notnull文檔內(nèi)容BLOBnullo.PKEMRNAPDOC印IDX_EMR一NAPDOCDCID5900知情告知信息(

25、EMRInformedConsent文檔索引號(hào)CHAR(16)標(biāo)類引標(biāo)標(biāo)日分名時(shí)標(biāo)機(jī)機(jī)人時(shí)人時(shí)時(shí)時(shí)摘狀號(hào)診者索源區(qū)計(jì)錄錄錄效本建建建建核核傳新錄歷次就患主來(lái)分統(tǒng)記記id有版創(chuàng)創(chuàng)創(chuàng)創(chuàng)審審上更記病批標(biāo)類引標(biāo)標(biāo)日分名時(shí)標(biāo)機(jī)機(jī)人時(shí)人時(shí)時(shí)時(shí)摘狀號(hào)診者索源區(qū)計(jì)錄錄錄效本建建建建核核傳新錄歷次就患主來(lái)分統(tǒng)記記id有版創(chuàng)創(chuàng)創(chuàng)創(chuàng)審審上更記病批構(gòu)構(gòu)碼稱CHAR(16)CHAR(2)CHAR(32)VARCHAR2(50)CHAR(l)DATEVARCHAR2(50)VARCHAR2C50)DATECHAR(l)VARCHAR2(10)VARCHAR2(50)VARCHAR2C100)VARCHAR2(32)DAT

26、EVARCHAR2(32)DATED/TEDATEVARCHAR2C4000)CHAR(l)CHAR(16)5900知情告知信息-文檔(EMRInformedCon記錄號(hào)CHAR(16)6k文檔索引號(hào)CHAR(16)文檔格式CHAR(2)文檔內(nèi)容BLOBft(UHlnpfttiemRenyi：nwicunohiiVIK1M12IIIIpV/3MA2MItA.VA3MA22OJI!；AJM”用X1(515(*lf“KgSM(Mll(llIrallalmlallradiACHAkfidl4pki掃*：IVci戚uonM(W住阪稅褰II火trilFMKKHBlUPwjE?HABH-InputIcst

27、RocoidHoBo)iJLS.CHAM16)MnuwXV!iHlitWCIXWlKtUH4MMt2UI15E,1lXI44比1吃ffM.Smitt4心0，It!*ikt*.mViKMt2lM)r.rnICR、5HSIlYNt/UIzq?unaLKfVizQi*unyiVlfeWl2l略WKIVIgw”luu.tLtit心MMi.furjiMiIKHUt*liiltiKdiM.A*iVIMUVOJItilUil1；HVIMUtJOJiHu”，xeKBUtt*35骨AlliMH(K.fllAniWfiMllMtnMlitM*lltt*/9i/HIM1Hi-H.30nWs.AllMUt-m，3：X

28、h*kNLMMK.Al1flNLtt-tlI.hKHLMKiI|.Bill小Lh*klKMHlt.A.JIm心心nwynnft/JtUM&M.3lUKMUIIIWMIlt2llVIMMUIMIDliAMUWMH*I人W胃可&代嶺!MMffi.VIJA)!trtVIMMVfJW-1Jatrton*4!R*ar*n-Hr)HKQRXOVlklWlMl1KWIXO、仲a*MCnXMWICZ*JtKiVaKM.n2心*JCCOilKHi、】F，JCEdgmvoiurjuiVIMUtUI:rHn.KUWH.*rvimuchiitnKnnaitn.v9時(shí).tsMHULTUI“n”n?rS4MI412UIV

29、43Mt2ilVlfeXtClMlZ2由，,.心E111Wilt- lt5Itl(IlnldOIIKHIMS5ttM。IIMHIM?wll itmimwin時(shí)?！渴顺身崳?yè)-宏有儉倪菠(Dttl3inHxn!ivCHU16)OnuRdf.irawiwx*himitiMweis*W2HOtsriKXUwaMtffliiMWCI的住就加是ii貝-費(fèi)Sr4til4(KHiPntietitJlS.EZ仞imsKxm心WWUAirOMlgOUJOM1aMJi)HlI，炒“，wx，*ZV4S削L，TH小VVTMV2tC4r.WMV2lVCtV2IWILgSgrvoiv:rrV：Ch(016PiVjIrtt

30、tEURInnuticnlRrrordHns(Mt)#NrOA；xnn-lHWlWnKeinnt*莎xurtrawirrnr:律學(xué)0始crt*Ck4KC*4fK/74linS，hSMr*r?A9*0Mf4rr#rlibsef心Mf.wr晃u!nftn,，M；tftM!Himxittellllll32l2l2l2l2l2l2l2l:l:l:l2lll2lllllllll3n”2l:l鯽s:=si5EE:mHB:HE51.24圖中醫(yī)住院病案首頁(yè)it豚耕*UWkuttim心勺典m隊(duì)airnwuHatm心*fcittAaitx”，冊(cè)“iWrtycHuoaytlKUIC1ARI12ISIMMtZiai.

31、wrewrewreTCMITGflnpatRciidta.就被史矣n時(shí)“MMi*n，？!JHJ力犬(VIItwennwAIS0mivifIHlmuMtHttrtllLA,mtt占u-xmt)411MlHtttl-WK.tlFlMIItk：ltMOO中房住RMiXfiKXn(BKKUInpzr；林引吊Ext0VKZZfs.!ilil.I-“gTT.akViii-biTVlMUKm*(IMill(MWK1M饋劉VMHKIWvnuEi?a，V4MUI2IM*VgtlFR，VIK1MEIMVIHVKIMiVK1UE：I：IK1UE；I2IVIMUKJI2IviMMKrmWOMftC.viMMKiMif

32、tMVfMMKflM*YIMHClWn.aao*t*VlMNR?lMiH*A.M)VOIMt/lMi(UtVEIIstoat-UK)Mt2llVlklMblMipniet-K-ougitsKA史奇”UH盤*戲fnttM*.HI#1-Vi.riimwawtn*mM-a.)!.fVCHLM-fi.ma人“人aiiH-co人HZ-K.|AI”人“H-ftn.i”人n：ili.ni?itvEr*tw”人檢/人aAiiftw.iipumit-xexR4ttniRIIWOIARMSRI*.flRHRHR51ROVA4lR#KKHilRMWn5*tvrtftn*itrtn3)t*rtatvrtfcn、atv

33、rtrmi5檢ttLUAUfflf由R4?UE.flRPAtMK-.flR*tsAiWt*由SHOUEt!*出R+UMflUam5IUPWbJ!nabArtMVMMSCBWnMI2lVVIK1MI2IMK-W，何，ywnN：rumiHlCKtlMei撲4lR*lLMKtil“dmyiumajuhesrfr*jmiiRttas-ni!RivcnrURi*artrtfittAfStX-innWfMiRsrrs明”gtM*KSgJL，)5叫、1久向押”4X8dlRJiMlWH貌3VIK1UEIM，VIMUI2IMIwmyVIK1UK：IMVIMIUEJIM*Y1K1UE；IMVIK1UE：IMYKM

34、K；IIVIKIHRIMi、1岫SVIKIHK/IM*VK1NKIMiVIMHKIM(UKVOIMKiaO：V4MMtZlMiViKlMUIMigV4MUl2liViKlMt2IM)V1MM12IMI“KWUlg皿心，0V4K1UUIMIWKW偵gV4HUEIM，OMIIIaatiicraiiii(1MIIIIOfMEctmtnYKNK2IMmigWV1HK/IMOeX，仙iMi|liriMtzon*4K)Mt2V4MUt2IXV4M1UI2IMIV4MUUIJWC-CKNIIIvmUEflllK1MK2I1Ivoiticin*V4M1UE：IWVlK1UK；ltaVK1UKTinviniie

35、riMiiVlKIMKriiQiYOCWKJM)、5HR?g、如MSIIVlK|R2lM：i(MVViMMblM)atiiMW4心cz523ixv：utwxotv:nf?.ei(：“/口*wf：1*f*Mlf/mWISMfnISWSEIMIISM3勺頑WS)SMJO3,5gO,印r汕.，IlWilII25relll3nwo6101中侃住隆3*nJl-it(EUFTCMInpattecoi4lk.oa6200入院記錄(EMRAdmissionRecords)CHAR(16)就飲標(biāo)iRCHAR(16)用四類型WAR主索引標(biāo)識(shí)WAR(32)VARCmR2(5O)分區(qū)標(biāo)識(shí)bR(l)統(tǒng)計(jì)日期DATE械分

36、類VARCIUR2(5O)祀錄名稱VARCHAR2(5O)記聚時(shí)間DATE有效標(biāo)志QIAR版本VARCHAR2(IO)創(chuàng)建機(jī)均代碼VARTHAR2(5O)創(chuàng)it機(jī)構(gòu)名林YARCILKR2(100)創(chuàng)it人VARCHAR2(32)創(chuàng)it時(shí)間(UTE申核人YARTIIAR2(32)審核時(shí)間MIE上傳時(shí)間HUE更新時(shí)何DATE記錄摘姿VARTHAR2(IOOO)柄歷狀態(tài)CHAR我次號(hào)UbR(!6)6200入院記錄文檔(EMRAdmissionRecords文檔索引易f式文4內(nèi)容CHAR(16)CHAR(16)GUR(2)Bixm6201入院記錄(EMRAdmissionRecord)CHAR(16)

37、她診標(biāo)識(shí)CHAR(16)主索引標(biāo)iRCHAR(32)用為類型CHAR分區(qū)標(biāo)識(shí)UUR(ICHAR統(tǒng)計(jì)n期M7E&建機(jī)將代碼VARnLR2侶技機(jī)構(gòu)名稱VARUimdOO)而K名彌VARCHAR2村室名所;VARCHAR250)入fitH期時(shí)間DATE主,VARCHAR2疾柄史(含外傷)VARni)R2(2OOO切者傳染性標(biāo)志UUR(l傳染柄史VARCHAR2200(預(yù)場(chǎng)接種史VAR(W2100)手術(shù)史VAKniiR22000輸值史VARCW2100)過(guò)域史VARCHAR2200)個(gè)人史VAROIAR2系統(tǒng)1“閭MQIAR2am史VAHabK22(XM月經(jīng)史VARaiAR2*族史VARClhR220

38、0W休格檢奩(V)1)體略枚夜一收率次Juin)MNBKR(3)體存栓黃一坂率MW：R(3)體恪檢資一fiftUi(mHg)MNBER休洛&合好張壓-mlk)MNBER體格珍杏一身高(cn)MJMBER(5.1)tKta一體收(kg)VARCHAR2M情況VARCWAR24000ffl助VARC1IAR21OOD)中國(guó)洌伶”觀察站果描還VAROi)R2出證分中代碼VAJW仃)泓證分咀名你VARCHAR25(泊觸泊法VARGIAR2(100)確定診斷vAKnimdooo)倆定診斷HWMIXUE接診躍生笠名VARCHAR250)住院醫(yī)師笠名VARniAR250)E治醫(yī)&簽名VARaim50)主任醫(yī)忡簽名VARlHm文檔索引號(hào)文檔格式文檔內(nèi)容6300住院病程記錄(EMR1npatientMedicalPr文檔災(zāi)引導(dǎo)CHAR(16)就診板識(shí)CHAHU6)CHAR主索引標(biāo)譏CHAR(32)來(lái)粉標(biāo)4!YARaiiU?2(5O)分區(qū)標(biāo)illOUR統(tǒng)計(jì)日明DATE記航分類傾HM2(IO。)VARCHAR2(S00)iMW何DATE有效標(biāo)志CHAR(I)版本VAR(H)R2(l(l)（Hit機(jī)構(gòu)代碼ARaiAR2(5(l)懈建扎構(gòu)名稱VAR