病案管理系统数据库表结构Word格式文档下载.docx

1、TSYSUSER系统权限表TRight系统菜单表TMenu权限菜单设置表TRightMenu二/三级医院评审统计基表tJudgeBase报表记录表tReport科室门诊工作日志tWorklogNoDoctor医生门诊工作日志tWorklog急诊工作日志（不分科）tEmergeLogNoKs急诊工作日志（分科）tEmergeLog观察室工作日志（不分科）tObservelogNoKs观察室工作日志（分科）tObservelog专科门诊病人数tSpecialLog门诊工作报表医技科室tMedicalTechLog医技科室（自定义）tMedicalTechPlog门（急）诊工作报表TMzMjzWor

2、kReport专科门诊病人分科报表TMzZkmzbrfkReport门诊手术病人分科数报表TMzSsbrfkReport门诊各科医生诊疗工作量报表TMzGkyszlgzlReport门诊医生个人诊疗工作量报表TMzYsgrzlgzlReport急诊、观察室工作报表TMzJzgcsWorkReport医院工作报表（门诊部分）TMzHospitalWorkReport病人最新信息TPATIENT病人诊断信息tDiagnose病人手术信息tOperation妇婴卡tBabyCard病人转科情况tSwitchKs中医院病人附加信息tChAdd肿瘤卡信息tKnubCard肿瘤化疗记录tKnubHl医保表

3、TBAYB病人住院信息tPatientVisit病房工作动态日志TZyWardWorklog病案借阅登记表tbaLend病案日志表tBaLog科室字典备份明细表tWorkroomBakDetail系统用户组表TGroup用户组权限设置表TGroupRight科室字典备份主表TWorkroomBakMain门诊报表（主表）TMzReportMain医院工作报表（医技科室）TMzYjksHospitalWorkReport专家门诊病人数报表TMzZjmzbrsReport急诊病人分科报表TMzJzbrfkReport观察室病人分科报表TMzGcsbrfkReport医技科室（自定义项目）报表TMz

4、YjkszdyReport节假日表TPlaytime疾病分类方式表tJBFLFSB二/三级医院评审统计表TZyJudgeReport门（急）诊工作日报Tmzmjzdayworkreport观察室日报Tmzgcsdayreport家庭病床工作月报TZyHomeBedReport住院报表（主表）TZyReportMain医院出院病人疾病分类疗效、疗程、费用情况TZyOutPateintICDReport医院部分病种住院医疗费用TZyICDPartFeeReport医院出院病人疾病分类年龄别情况（一）TZyOutPatientICDAgeReport1医院出院病人疾病分类年龄别情况（二）TZyOut

5、PatientICDAgeReport2医院住院病人手术分类报表TZyOperateSortReport医院各科（区）经济收入报表TZyEconomyIncomeReport产妇及婴儿情况报表TZyWomenBabyReport全部手术统计分析表TZyAllOperateReport医院住院病人病种质量控制统计报表TZySingleDiseaseReport住院医生经管病人数及疗效报表TZyDoctorPatientReport医生主刀手术病人数及疗效报表TZyDoctorOperPatientReport门（急）诊工作量逐日台帐TmzmjzworkreportByDay二十种疾病术后十日内死

6、亡统计报表TZy20ICDDeadInTenReport疾病分类报表疾病转归情况TZyDiseaseZgReport疾病分类年龄别情况卫生部报表TZyICDAgeWsbReport住院病人病伤死原因报表（总表）TZyDeadReasonReport1住院病人病伤死原因报表（婴儿死亡日月年龄分组）TZyDeadReasonReport2二/三级医院评审统计日志表TZyJudgeLog家庭病床工作日志TZyHomeBedLog病房工作动态日报TZyWardWorkDayReport医院工作报表（住院部份）TZyHospitalWorkReport医院收支情况及经济效益分析表TZyHosEcInOu

7、tReport广东省医院部分病种住院医疗费用TZyICDPartFeeReportGD医院收支情况及经济效益分析日志TZyHosEcInOutLog综合查询自定义显示（字段）TQuerySelfShow综合查询自定义条件TQuerySelfCondition汉字拼音对照表Twinpy导入导出表TExport科室对照表TDeptRelationHIS_病人住院信息HIS_BA1HIS_病人转科情况HIS_BA2HIS_病人诊断信息HIS_BA3HIS_病人手术信息HIS_BA4HIS_妇婴卡HIS_BA5HIS_肿瘤卡HIS_BA6HIS_肿瘤化疗记录HIS_BA7HIS_中医院病人附加信息HI

8、S_BA8HIS_病房工作动态日志HIS_ZYLOGHIS_科室门诊工作日志HIS_MZLOG1HIS_医生门诊工作日志HIS_MZLOG2HIS_急诊工作日志（不分科）HIS_MZLOG3HIS_急诊工作日志（分科）HIS_MZLOG4HIS_观察室工作日志（不分科）HIS_MZLOG5HIS_观察室工作日志（分科）HIS_MZLOG6HIS_门诊工作报表医技科室HIS_MZLOG7HIS_医技科室（自定义）HIS_MZLOG8HIS_专科门诊病人数HIS_MZLOG9综合查询自定义显示（模板）TQuerySelfShowTemplate综合查询自定义显示（模板字段对照关系）TQuerySe

9、lfShowTemplateField病案首页验证规则表TBasyValidation导入导出字段表TExportField数据核查及平衡结果Tbalance病人诊断码附加编码TDiagnoseAdd打印设置表Tprintset病案上交登记表tbaSubmitHIS_病人诊断码附加编码HIS_BA9首页核查结果表TBasyBalance病案首页核查设置表TCheckSet住院记帐信息表TZyjz上传医保住院病案UPLOADZYBA1.1.2 表格键清单表格主键tStandardMain_PKtStandardMx_PKtICD_PKtJBFLB_PKtCHDISEASE_PKTSDISEASE

10、_PKtOperate_PKtOperateFlb_PKtBurnICD_PKtSDISEASERemark_PKtParam_PKtWorkroom_PKtSpecialRoom_PKtMzOperateRoom_PKTitemSelfDef_PKtdoctor_PKtdoctorWorkRoom_PKTSYSUSER_PKtQxzsz_PKtSysMenus_PKtQxzMenu_PKtJudgeBase_PKtReport_PKtWorklogNoDoctor_PKtWorklog_PKtEmergeLogNoKs_PKtEmergeLog_PKtObservelogNoKs_PKtOb

11、servelog_PKtSpecialLog_PKtMedicalTechLog_PKtMedicalTechPlog_PKTMzMjzWorkReport_PKTMzZkmzbrfkReport_PKTMzSsbrfkReport_PKTMzGkyszlgzlReport_PKTMzYsgrzlgzlReport_PKTMzJzgcsWorkReport_PKTMzHospitalWorkReport_PKtPatient_PKtdiagnose_PKtOperation_PKtbabycard_PKtswitchks_PKtchadd_PKtKnubCard_PKtknubhl_PKtba

12、yb_PKTpatientvisit_PKTZyWardWorklog_PKTbalend_PKtBaLog_PKtWorkroomBak_PKTGroup_PKTUserGroupRight_PKTWorkroomBakMain_PKTMzReportMain_PKTMzYjksHospitalWorkReport_PKTMzZjmzbrsReport_PKTMzJzbrfkReport_PKTMzGcsbrfkReport_PKTMzYjkszdyReport_PKTPlaytime_PKtJBFLFSB_PKTZyJudgeReport_PKTMzMjzDayReport_PKTMzGc

13、sDayReport_PKTZyHomeBedReport_PKTZyReportMain_PKTZyOutPateintICDReport_PKTZyICDPartFeeReport_PKTZyOutPatientICDAgeReport1_PKTZyOutPatientICDAgeReport2_PKTZyOperateSortReport_PKTZyEconomyIncomeReport_PKTZyWomenBabyReport_PKTZyAllOperateReport_PKTZySingleDiseaseReport_PKTZyDoctorPatientReport_PKTZyDoc

14、torOperPatientReport_PKTmzmjzworkreportByDay_PKTZy20ICDDeadInTenReport_PKTZyDiseaseZg_PKTZyICDAgeWsbReport_PKTZyDeadReasonReport1_PKTZyDeadReasonReport2_PKTZyJudgeLog_PKTZyHomeBedLog_PKTZyWardWorkDayReport_PKTZyHospitalWorkReport_PKTZyHosEcInOutReport_PKTZyICDPartFeeReportGD_PKTZyHosEcInOutLog_PKTQu

15、erySelfShow_PKTQuerySelfCondition_PKTwinpy_PKTExport_PKTDeptRelation_PKHIS_BA1_PKHIS_BA2_PKHIS_BA3_PKHIS_BA4_PKHIS_BA5_PKHIS_BA6_PKHIS_BA7_PKHIS_BA8_PKHIS_ZYLOG_PKHIS_MZLOG1_PKHIS_MZLOG2_PKHIS_MZLOG3_PKHIS_MZLOG4_PKHIS_MZLOG5_PKHIS_MZLOG6_PKHIS_MZLOG7_PKHIS_MZLOG8_PKHIS_MZLOG9_PKTQuerySelfShowTempla

16、te_PKTQuerySelfShowTemplateField_PKTBasyValidation_PK主健TExportField_PKTDiagnoseAdd_PKTprintset_PKtbaSubmit_PKHIS_BA9_PKTBasyBalance_PKTCheckSet_PKTZyjz_PK1.1.3 表格索引清单唯一的群集器主要的外键候选键唯一性索引index_fcodeTRUEFALSEindex_fcode_fbhindex_ftype_ficdmindex_ficdversion_fcode_fflfscodeindex_ficdm_ficdversionindex_f

17、code_ficdversion_ftypeindex_fopcode科号唯一性索引index_fkh_ftype_fny统一科号唯一性索引index_ftykh_fny专科号唯一性索引index_fzkcode统一专科号唯一性索引index_ftzkcode手术室编号唯一性索引index_fopbh统一手术室编号唯一性索引index_ftyopbh项目编号唯一性索引index_FItemCode项目统一编号唯一性索引index_FTyitemCode工号唯一性索引index_fgh统一工号唯一性索引index_ftyghindex_ftykh_ftygh用户编号唯一性索引统一用户编号唯一性索引index_ftyyhbhindex_fbhindex_fmenubhinex_fqxzbh_fmenubhindex_fzbxh_fzbjbindex_ftykh_frqindex_ftykh_ftygh_frq医生门诊工作