2019年HIS數(shù)據(jù)表

1、1 .醫(yī)院信息表hospital列名數(shù)據(jù)類型約束醫(yī)院編號hosipitalidvarcharNot null主鍵醫(yī)院名稱hosipitalnamevarcharNot null醫(yī)院院長hosipitalbossvarchar醫(yī)院地址hosipitaladdressvarchar聯(lián)系電話hosipitaltelvarchar醫(yī)院等級hosipitallevelvarchar2 .職位表role列名數(shù)據(jù)類型約束主鍵roleidint職位名稱rolenamevarcharNot null職位描述roledetailsvarchar3 .功能菜單表tree列名數(shù)據(jù)類型約束菜單idtidintNot n

2、ull主鍵自增菜單名稱tnamevarcharNot null菜單屬性tvaluevarchar父類菜單fidint為空則為頂層菜單4 .權(quán)限表（角色功能中間表）role_tree列名數(shù)據(jù)類型約束角色idroleidintNot null外鍵角色表功能菜單idtidintNot null外鍵功能菜單表rtidintNot null主鍵5 .部門表（科室 ）dept列名數(shù)據(jù)類型約束部門編號deptnumbervarcharNot null名稱deptnamevarcharNot null上級部門idparentidint為空則為頂層部門部門電話depttelvarchar所屬醫(yī)院hosipita

3、lidvarchar職稱等級表doctor_level列名數(shù)據(jù)類型約束職稱iddlidintNot null主鍵自增職稱名稱dlnamevarcharNot null職稱說明dldetailvarcharNot null職稱職業(yè)roleidintNot null外鍵職業(yè)表6 .員工信息表worker列名數(shù)據(jù)類型約束員工idworkeridIntNot null主鍵員工性別workersexcharNot null角色jobidint外鍵角色表所屬部門（科室）deptnumbervarchar外鍵部門表出生日期workerdatedate家庭地址workeradressvarchar手機號碼wo

4、rkerphonevarchar工號workernumvarcharNot null唯一民族workernationVarcharNot null血型bloodtypevarchar戶籍patienthrvarchar身份證號workeridcardvarchar唯一政治面貌workerpartyvarchar學(xué)歷workerdegreevarchar身高workerheighvarchar婚姻狀態(tài)workermarriaboolean職稱等級dlidIntNot null外鍵職稱等級表7 .病人信息表patient列名數(shù)據(jù)類型約束病人編號patientidIntNot null主鍵自增姓名p

5、atientnamevarcharNot null性別patientsexvarcharNot null身份證號patientidcardvarchar唯一出生日期patientbirthdaydateNot null手機號patienttelvarcharNot null民族patientnationvarchar血型bloodtypevarchar戶籍patienthrvarchar家庭地址patientadressvarchar8 .診療卡表patient_card列名數(shù)據(jù)類型約束cardidintNot null主鍵自增卡號cardnumvarcharNot null唯一卡上余額car

6、dmoneydoubleNot null病人編號patientidIntNot null外鍵病人開卡日期carddatedateNot null經(jīng)辦員工workeridintNot null外鍵員工9 .病歷表medicalrecord列名數(shù)據(jù)類型約束mridIntNot null主鍵病人編號patientidIntNot null外鍵病人表診斷醫(yī)師workeridintNot null外鍵員工表確診病名mrnamevarcharNot null病情描述mrdetailsVarcharNot null確診日期mrdatedateNot null其他病史otherdetailsVarchar診斷

7、類型mrtypevarcharNot null初診或復(fù)診病歷編號mrnumbervarcharNot null唯一10 .醫(yī)療服務(wù)類型表medical_service_type（1.綜合醫(yī)療服務(wù)類2.醫(yī)技診療類3.臨床診療類4.手術(shù)治療類5.其他類型）列名數(shù)據(jù)類型約束服務(wù)類型idmstidIntNot null主鍵自增服務(wù)類型名稱mstnameVarcharNot null服務(wù)類型說明mstdetailsvarchar11 .醫(yī)療服務(wù)項目表medical_service_project列名數(shù)據(jù)類型約束服務(wù)項目編號mspnumbervarcharNot null主鍵服務(wù)項目名稱mspnameva

8、rcharNot null服務(wù)詳情mspdetailsVarchar服務(wù)項目類型mstidIntNot null服務(wù)類型外鍵服務(wù)項目價格msppricedoubleNot null16.掛號記錄表registration列名數(shù)據(jù)類型約束掛號idregidIntNot null主鍵病人編號patientidIntNot null外鍵病人科室編號deptnumbervarcharNot null外鍵部門科室被掛醫(yī)生編號workeridInt外鍵員工掛號日期regdatedate醫(yī)事服務(wù)費regpricedoubleNot null醫(yī)事服務(wù)類型mspnumbervarcharNot null外鍵醫(yī)療

9、服務(wù)項目表（急診號，普通號，專家號等等）藥房表 drug_room列名數(shù)據(jù)類型約束藥房編號drnumbervarcharNot null主鍵藥房名稱drnamevarchar所屬科室deptnumbervarcharNot null外鍵部門科室表12 .藥品種類表drug_type列名數(shù)據(jù)類型約束藥品種類iddtidintNot null主鍵自增藥品種類名稱dtnamevarcharNot null藥品種類說明mstexplainvarchar13 .藥品表drug列名數(shù)據(jù)類型約束藥品iddrugidIntNot null主鍵自增藥品編號drugnumbervarcharNot null唯一藥

10、品名稱durgnamevarcharNot null藥品說明durgdetailsVarchar藥品價格durgpricedoubleNot null藥品規(guī)格drugspecVarcharNot null單位drugunitvarcharNot null14 .藥品處方表drug_prescription列名數(shù)據(jù)類型約束處方號dpnumberVarcharNot null主鍵開藥醫(yī)師workeridIntNot null外鍵員工表病人idpatientidIntNot null外鍵病人表開處方時間dpdatedateNot null備注dppsvarchar15 .藥品處方明細表drug_pr

11、escription_detail列名數(shù)據(jù)類型約束明細iddpdidintNot null主鍵自增處方號dpnumbervarcharNot null外鍵處方表藥品iddrugidintNot null外鍵藥品表藥品數(shù)量drugnumintNot null藥品單價priceDoubleNot null小計subtotalDoubleNot null取藥時間dpddatedate未取藥時為空醫(yī)療服務(wù)治療方案表medical_service_way列名數(shù)據(jù)類型約束方案號mswnumbervarcharNot null主鍵制定醫(yī)師workeridIntNot null外鍵員工表病人idpatient

12、idintNot null外鍵病人表制定時間mswdatedateNot null備注mswpsdatemedical_service_way_detail列名數(shù)據(jù)類型約束明細idmswdintNot null主鍵自增方案號mswnumbervarchar外鍵醫(yī)療服務(wù)治療方案表醫(yī)療服務(wù)項目mspnumbervarcharNot null外鍵醫(yī)療服務(wù)項目表治療次數(shù)mswdnumintNot null治療單價（次）pricedoubleNot null小計subtotalDoubleNot null治療時間mswddatedate未治療時為空17 .醫(yī)院出藥記錄表drug _record列名數(shù)據(jù)類

13、型約束記錄iddridIntNot null主鍵自增藥品iddrugidintNot null外鍵藥品表病人idpatientidIntNot null外鍵病人表藥品數(shù)量drugnumIntNot null藥品單價drugpriceDoubleNot null小計drugsubtotaldoubleNot null出藥日期drdatedateNot null是否付款payifbooleanNot null出藥藥房drnumbervarcharNot null外鍵藥房表18 .醫(yī)院醫(yī)療服務(wù)記錄表medical_service_record列名數(shù)據(jù)類型約束記錄idmsridintNot null主

14、鍵自增醫(yī)療服務(wù)項目號mspnumbervarcharNot null外鍵醫(yī)療服務(wù)項目表病人idpatientidIntNot null外鍵病人表醫(yī)療服務(wù)價格msrdpricedoubleNot null消費價格治療次數(shù)msrnumberintNot null通常都是1小計msrsubtotaldoubleNot null治療日期msrdatedateNot null是否付款payifbooleanNot null治療科室科室deptidIntNot null外鍵部門科室表19 .診療卡充值記錄表recharge_record列名數(shù)據(jù)類型約束記錄idrridintNot null主鍵自增卡 id

15、cardidIntNot null診療卡外鍵充值金額rrmoneydoubleNot null充值類型rrtypeVarcharNot null人工或存款機自助操作人員workeridint外鍵員工表充值時間rrdatedateNot null20 .診療卡消費記錄表spend_record列名數(shù)據(jù)類型約束記錄idsridintNot null主鍵自增卡 idcardidIntNot null診療卡外鍵扣費金額srmoneydoubleNot null扣費時間srdatedateNot null備注srpsvarchar21 .診療卡醫(yī)療服務(wù)消費明細表spend_record_detail列名

16、數(shù)據(jù)類型約束明細idsrdidIntNot null主鍵自增所屬消費記錄sridintNot null外鍵診療卡消費記錄表消費類型srdtypevarcharNot null醫(yī)療服務(wù)或藥品消費醫(yī)療服務(wù)記錄號msridIntNot null外鍵醫(yī)院醫(yī)療服務(wù)記錄表22 .診療卡藥品消費明細表spend_record_detail列名數(shù)據(jù)類型約束明細idsrdidIntNot null主鍵自增所屬消費記錄sridintNot null外鍵診療卡消費記錄表消費類型srdtypevarcharNot null醫(yī)療服務(wù)或藥品消費出藥號dridIntNot null外鍵醫(yī)院售藥記錄表23 .病房種類表sic

17、kroom_type（綜合性重癥監(jiān)護病房、冠心病重癥監(jiān)護病房、vip 病房、普通病房）列名數(shù)據(jù)類型約束種類idstidintNot null主鍵自增種類名稱stnamevarcharNot null種類描述stdetailsvarchar23 .病房表sickroom列名數(shù)據(jù)類型約束病房編號roomnumbervarcharNot null主鍵病房種類stidintNot null外鍵病房種類id床位數(shù)量roomnumintNot null所屬科室deptidIntNot null外鍵科室表病房位置roomadressvarcharNot null24 .床位表bed列名數(shù)據(jù)類型約束床位編號b

18、ednumberVarcharNot null主鍵所屬病房roomnumbervarcharNot null外鍵病房表床位狀態(tài)bedstatebooleanNot nullfalse 為已經(jīng)有人對應(yīng)醫(yī)療服務(wù)項目號mspnumbervarcharNot null外鍵醫(yī)療服務(wù)項目25 .住院記錄表hospital_ization_record列名數(shù)據(jù)類型約束病案號hirnumbervarcharNot null主鍵病人idpatientidintNot null外鍵病人表主治醫(yī)師doctorIntNot null外鍵員工表護理人員（護士）nurseIntNot null外鍵員工表分配床位bednumbervarcharNot null外鍵床位表入院時間hirdateindateNot null出院時間hirdateoutdate26 住院床位變更記錄表bed_change列名數(shù)據(jù)類型約束記錄idbcidintNot null主鍵自增病案號hirnumbervarcharNot null外鍵住院記錄表變更前床位oldbedvarcharNot null外鍵床位表變更后床位newbedvarcharNot null外鍵床位表變更日期changedatedateNot null27.住院主治醫(yī)師變更記錄表doctor_