第十八组 陈建国钟仪玲 HIS系统之门诊管理
1.导包
2.搭建项目工程
3.设计数据库表
1.地址信息表
create table t_addressinfo(
addressid varchar(40) primary key,
province varchar(30),
city varchar(30),
low_country varchar(30),
town varchar(30),
small_country varchar(30),
door_number varchar(30),
ems_code varchar(20),
district_code varchar(20),
address_classify_code varchar(20)
);
2.医疗保险表（它和电子病历一对一关系）
create table t_cureinsurance(
cureinsid varchar(40) primary key,
cureins_classify_code varchar(20),
cureins_classify varchar(30)
);
3.病人点子健康表（它和科室关系是多对多关系，它和医疗保险是一对一关系，它和详细地址表时一对一关系，它和医生是多对多关系）
create table t_euserhealthdoc(
ehealthid varchar(40) primary key,
createdate datetime,
pat_username varchar(50) not null,
username_identify_code varchar(20),
identify_code_classify_code varchar(20),
identify_code_number varchar(20),
identify_code_effect_date datetime,
identify_code_lose_date datetime,
identify_code_privoder varchar(50),
usually_address text,
phone_classify varchar(30),
phone_chassify_code varchar(20),
phone_number varchar(18),
email_address varchar(100),
birthdate date,
sex_code varchar(20),
country_code varchar(20),
nation_code varchar(20),
marriage_status varchar(20),
start_working_date Date,
occupation_code varchar(20),
education_code varchar(20),
addressid varchar(40),
cureinsid varchar(40),
patient_headimage text,
constraint euserhealthdoc_addressinfo_FK foreign key(addressid) references t_addressinfo(addressid),
constraint euserhealthdoc_cureinsurance_FK foreign key(cureinsid) references t_cureinsurance(cureinsid)
);
4.科室表（它和挂号表是一对多关系，它和病人关系是多对多关系，它和医生表时一对多关系，它和科室主任是一对一关系）
create table t_department(
departmentid varchar(40) primary key,
deparment_code varchar(40),
deparment_name varchar(30),
createdate datetime,
deparment_headerid varchar(40)
);
5.医生表（它和科室表时一对一，它和地址表一对一关系，它和病人表时多对多关系）
create table t_doctorinfo(
doctorid varchar(40) primary key,
doctor_name varchar(50),
doctor_idcard varchar(18),
doctor_sex varchar(10),
doctor_birthdate date,
education_level varchar(30),
company_name varchar(100),
work_experience text,
createdate datetime,
phone varchar(11),
email varchar(100),
doctortype varchar(50),
departmentid varchar(40),
addressid varchar(40),
doctor_headimage text,
visit_time text,
constraint t_doctorinfo_t_addressinfo_FK foreign key(addressid) references t_addressinfo(addressid),
constraint t_doctorinfo_t_department_FK foreign key(departmentid) references t_department(departmentid)
);
6.用户表（它和病人健康档案一对一关系，它和医生表是一对一关系）
create table t_user(
userid varchar(40) primary key,
username varchar(40) not null,
password varchar(40) not null,
email varchar(100),
phone varchar(11),
usertype varchar(20),
headimage text,
createdate datetime,
idcard varchar(18)
);
constraint user_euserhealthdoc_FK foreign key(idcard) references t_euserhealthdoc(identify_code_number),
constraint user_doctorinfo_FK foreign key(idcard) references t_doctorinfo(doctor_idcard)
7.病人和医生关系多对多关系中间表
create table t_euserhealthdoc_doctorinfo(
doctorid varchar(40),
ehealthid varchar(40),
primary key (doctorid,ehealthid),
constraint t_euserhealthdoc_doctorinfo_doctorinfo_FK foreign key(doctorid) references t_doctorinfo(doctorid),
constraint t_euserhealthdoc_doctorinfo_euserhealthdoc_FK foreign key(ehealthid) references t_euserhealthdoc(ehealthid)
);
8.病人和科室是多对多关系中间表
create table t_euserhealthdoc_department(
ehealthid varchar(40),
departmentid varchar(40),
primary key (departmentid,ehealthid),
constraint t_euserhealthdoc_department_department_FK foreign key(departmentid) references t_department(departmentid),
constraint t_euserhealthdoc_department_euserhealthdoc_FK foreign key(ehealthid) references t_euserhealthdoc(ehealthid)
);
9.电子诊疗卡表(它和挂号表一对多关系,它和电子处方表一对多关系,它和病人档案一对一关系)
create table t_treatmentcard(
treatmentid varchar(40) primary key,
treatment_status varchar(20),
treatment_effect_date Date,
idcard varchar(18),
ispay varchar(10),
ehealthid varchar(40),
constraint t_treatmentcard_t_euserhealthdoc_FK foreign key(ehealthid) references t_euserhealthdoc(ehealthid)
);
10.挂号表(它和病人是一对一关系，它和科室是多对一关系,它和医生是多对一关系)
create table t_register(
registerid varchar(40) primary key,
patient_birthdate Date,
patient_phone varchar(11),
patient_name varchar(50),
patient_sex varchar(20),
patient_idcard varchar(18),
patient_certype varchar(20),
card_id varchar(20),
card_type varchar(20),
password_level varchar(20),
patient_age int,
age_unit varchar(20),
next_plan text,
after_treatment text,
major_past_history text,
turnout_bed_id varchar(20),
turnout_deparment_id varchar(40),
turnout_time Date,
turnout_agent_id varchar(20),
turnout_doctor_name varchar(50),
turn_sign varchar(20),
turn_reason text,
treatmentid varchar(40),
departmentid varchar(40),
doctorid varchar(40),
ehealthid varchar(40),
constraint t_register_department_FK foreign key(departmentid) references t_department(departmentid),
constraint t_register_t_doctorinfo_FK foreign key(doctorid) references t_doctorinfo(doctorid),
constraint t_register_t_euserhealthdoc_FK foreign key(ehealthid) references t_euserhealthdoc(ehealthid),
constraint t_register_t_treatmentcard_FK foreign key(treatmentid) references t_treatmentcard(treatmentid)
);
11.电子处方表（它和中药表多对多关系，它和西药表多对多关系，它和病人是多对一关系，它和费用表时一对一关系）
create table t_electrecipe(
doctorid varchar(40),
electrecid varchar(40) primary key,
diag_date Date,
diag_categroy varchar(20),
diag_categroy_id varchar(20),
diag_order_id varchar(40),
disease_name varchar(100),
disease_id varchar(40),
diag_basis Text,
diag_basis_id varchar(40),
medicine_usage text,
medicine_ues_frequency Text,
medicine_ues_unit text,
medicine_use_dose float,
medicine_use_totaldose float,
medicine_name text,
medicine_doseform_id varchar(40),
medicine_type varchar(20),
medicine_id varchar(40),
ehealthid varchar(40),
treatmentid varchar(40),
constraint t_electrecipe_t_euserhealthdoc_FK foreign key(ehealthid) references t_euserhealthdoc(ehealthid),
constraint t_electrecipe_t_treatmentcard_FK foreign key(treatmentid) references t_treatmentcard(treatmentid)
);
12.费用表（费用表和电子处方是一对一关系，）
create table t_cost(
costid varchar(40) primary key,
cost_date date,
no_cure_ins_total_cost float,
already_cure_ins_total float,
electrecid varchar(40),
constraint t_cost_t_electrecipe_FK foreign key(electrecid) references t_electrecipe(electrecid)
);
13.中药表（它和电子处方多对多关系）
create table t_china_druginfo(
china_medicine_id varchar(40) primary key,
chian_medicine_type varchar(20),
chian_medic
医院管理系统完整毕业设计代码
1星 需积分: 50 122 浏览量
2017-12-19
23:19:07
上传
评论 7
收藏 11.94MB ZIP 举报 
医院管理系统完整毕业设计代码 （797个子文件） 
Emergency_door_interrogation.class 10KB Add_Patient_Servlet.class 9KB InitDataListener.class 8KB Add_Nurser_Servlet.class 8KB AddDoctor_Servlet.class 8KB EUserHealthDoc.class 7KB DoctorInfo.class 6KB Register.class 6KB add_China_DrugServlet.class 6KB ElectRecipe.class 5KB WebUtils.class 5KB EUserHealthDocDao.class 4KB DepartmentService.class 4KB DepartmentDao.class 4KB Add_Register_Servlet.class 4KB EUserHealthDocService.class 4KB Add_West_DrugServlet.class 4KB RoleService.class 4KB PrivilegeDao.class 4KB DoctorDao.class 4KB InitDoctor.class 4KB ElectRecipeDao.class 3KB Computer_Money_Sevlet.class 3KB Search_DepartmentBy_DepNameServlet.class 3KB UpdateRoleServlet.class 3KB RoleDao.class 3KB User.class 3KB ElectRecipeService.class 3KB PersonalCenter_Servlet.class 3KB LoginOnlineCounterSessionListener.class 3KB PrivilegeService.class 3KB LoginServlet.class 3KB DoctorService.class 3KB AddUserRoleServlet.class 3KB Index_System_ManagerUIServlet.class 3KB PrivilegeTypeEnum.class 3KB ShowPageListRecipeIndexServlet.class 2KB TreatmentCardDao.class 2KB AddressInfo.class 2KB Role_UserDao.class 2KB Page.class 2KB China_Druginfo.class 2KB Department.class 2KB Search_Eheathdoc_bymohu_Idcard_Servlet.class 2KB Search_RegisterUser_ByIdcard_Servlet.class 2KB Search_recipe_bymohu_Idcard_Servlet.class 2KB AddPrivilegeServlet.class 2KB Emergency_door_examination.class 2KB Search_UserByIdcard_Servlet.class 2KB Register_On_this_DepartmentServlet.class 2KB TreatmentCardService.class 2KB Privilege_RoleDao.class 2KB AddRoleServlet.class 2KB ShowDoctorForPage_Servlet.class 2KB ShowNurse_ForPage_Servlet.class 2KB Western_Druginfo.class 2KB SetPrivilegeToRoleByroleid.class 2KB Privilege.class 2KB Emergency_door_diagnosis.class 2KB ShowEUserHealthDoc_ForPage_Servlet.class 2KB UserDao.class 2KB UpdateUserRoleUIServlet.class 2KB RegisterDao.class 2KB Menu_Plate.class 2KB Emergency_door_plan.class 2KB Add_ElectRecipe_UIServlet.class 2KB Role.class 2KB Pay_Money.class 2KB ClassifyDoctor_ByDepartment_UIServlet.class 2KB ClassifyNurse_ByDepartment_UIServlet.class 2KB LoginFilter.class 2KB Register_ByDepartmentServlet.class 2KB Privilege_RoleService.class 2KB DeleteRoleByroleid.class 2KB PageListPrivilegeServlet.class 2KB Role_UserService.class 2KB InitDepartment.class 2KB PageListRoleServlet.class 2KB Personal_Center_LeftMenu_Servlet.class 2KB InitMainPlate.class 2KB DeletePrivilegeByprivilegeid.class 2KB TreatmentCard.class 2KB CharacterEncodingFilter.class 2KB Add_PrivilegeUIServlet.class 2KB AddDoctor_UIServlet.class 2KB Add_NurseUIServlet.class 2KB MyRequest2.class 1KB China_DruginfoDao.class 1KB Western_DruginfoDao.class 1KB HtmlFilter.class 1KB UserService.class 1KB AddressDao.class 1KB Pay_MoneyDao.class 1KB Cost.class 1KB MyRequest.class 1KB System_Manager_Default_Main_Servlet.class 1KB SearchEhealthDocByIDcardServlet.class 1KB Personal_Center_DefaultMain_Servlet.class 1KB System_Manager_LeftMenu_Servlet.class 1KB PageListPrivilegeUIServlet.class 1KB共 797 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
qq_331806572018-01-07感觉不行啊
俞莫2018-03-27系统有错误，运行不了。- lw14215119892018-11-04随便的，，，，
杜小凡2022-03-19卧槽？就这？？？？？
