1、1.預(yù)交金明細(xì)表 dhc_sfprdetail2.基本信息表 PA_patmas,pa_字段名描述prt_rowidprt_rcptno(1)收據(jù)號(hào) prt_prdate(2)打印日期 prt_prtime(3)打印時(shí)間prt_adm_dr(4)指向 pa_adm,找到信息prt_rcpt_dr指向 ar_receiptsprt_payamount(6)金額prt_refundrcpt被沖紅的收據(jù)號(hào)prt_sus收據(jù)狀態(tài)“1”正常，”2”作廢，”3”沖紅，”4”已沖紅，”5”打印prt_paymode(9)支付方式prt_bprt_cardno號(hào)pany支付prt_deit_dr押金類型，指向

2、 arc_deptype 為空時(shí)代表非押金prt_adduserid(14)收款人prt_deliverdate轉(zhuǎn)交日期prt_delivertime轉(zhuǎn)交時(shí)間prt_receivedate接收日期prt_receivetime接收時(shí)間prt receiveuser接收人prt jkuser交款人prt_jkflag交款標(biāo)志（即：也是收款員結(jié)算時(shí)間，每天上交財(cái)務(wù)科）prt_jkdate交款日期prt_jktime交款時(shí)間prt_confirmuser核銷人prt_confirmdate核銷日期prt_confirmtime核銷時(shí)間prt_confirmflag核銷標(biāo)志prt_deliverfla

3、g轉(zhuǎn)交標(biāo)志prt_title標(biāo)題Prt_jk_drDhc_jfuserjkment1備用 1(財(cái)務(wù)接收rowid)ment2備用 2ment3備用 3ment4備用 43.就診信息表PA_Adm(Dhc_sfprdetail. prt_adm_dr-pa_adm)(pa_adm.paadm_papmi_dr-pa_patmas)Dhc_patientbill(賬單總表：費(fèi)用總額) Dhc_patbillorder（賬單醫(yī)囑明細(xì)表）Dhc_patbilldetails（賬單項(xiàng)目明細(xì)表）預(yù)交金明細(xì) Ar_receipts Ar_rcptalloc Ar_rcptpaymode找出這三張表的關(guān)系，并

4、分別寫出三張表的物理結(jié)構(gòu)主map 的結(jié)構(gòu)定義；PAADM_AdmDate就診日期PAADM_AdmTime就診時(shí)間 PAADM_VisitSus在院狀態(tài)PAADM_AdmReason_DR類別,pac_admreasonPAADM_Type就診類型PAADM_Papmi_dr指向 PA_PATMASPAADM_UpdateDate修改日期PAADM_UpdateTime修改時(shí)間PAADM_UpdateUser_DR修改人PAADM_CurrentRoom_DRPAADM_CurrentBed_DR床位PAADM_AdmCateg_DR入院情況Paadm_dischargedate最終結(jié)算日期Paadm_dischargetime最終結(jié)算時(shí)間PAADM_btype_DR就診類別PAADM_BillFlag財(cái)務(wù)結(jié)算標(biāo)志PAADM_CurrentWard_DR病區(qū)PAPMI_Name:PAPMI_Sex_DRPAPMI_No登記號(hào)PAPMI_IPNo住院登記號(hào)PAPMI_OPNo門診登記號(hào)PAPMI_SafetyNetCardN