java—Web（项目）数据库（一）

实现代码：

CREATE DATABASE hospital;

USE hospital;

CREATE TABLE feesDetails(
ID INT(4) COMMENT'收费项目',
drugNum VARCHAR(10) COMMENT'药品编号',
amount FLOAT COMMENT'数量',
total FLOAT COMMENT'小计'
)COMMENT='收费详情表'

CREATE TABLE payItems(
ID INT(4) COMMENT'收费项目',
payName CHAR(6) COMMENT'收费名称',
sickNum INT(8) COMMENT'挂号编号（病人编号）'  PRIMARY KEY,
payDate DATE COMMENT'收费日期',
payPeople INT(6) COMMENT'收费人',
cost FLOAT COMMENT'费用'
)COMMENT='收费项目表' CHARSET='utf8'

CREATE TABLE sickMessage(
sickNum INT(8) COMMENT'挂号编号' PRIMARY KEY,
hospitalId INT(10) COMMENT'医院ID',
registeredType INT(8) COMMENT'挂号类型',
sickName DECIMAL COMMENT'姓名',
sickSex CHAR(2) DEFAULT'男' COMMENT'性别',
sickAge INT(4) COMMENT'年龄',
registeredDate DATE COMMENT'挂号日期',
registeredNum INT(8) COMMENT'挂号人编号'
)COMMENT='病人基本信息表' CHARSET='utf8'

DROP TABLE sickMessage;

CREATE TABLE registeredtype(
registeredType INT(8) COMMENT'类型编号',
TYPE DECIMAL COMMENT'类型',
price FLOAT COMMENT'价钱'
)COMMENT='挂号类型表' CHARSET='utf8'

CREATE TABLE sickHospitalMessage(
hospitalId INT(8) COMMENT'医院ID',
sickNum INT(8) COMMENT'病人编号',
sickBedNum INT(8) COMMENT'病床编号' PRIMARY KEY,
doctorNum INT(8) COMMENT'医生编号',
nurseNum INT(8) COMMENT'护士编号',
sickName CHAR(8) COMMENT'姓名',
sickSex CHAR(2) DEFAULT'男' COMMENT'性别',
sickAge INT(4) COMMENT'年龄',
beHospital DATE COMMENT'入院日期',
leaveHospital DATE COMMENT'出院日期',
sickHome DECIMAL COMMENT'家庭住址',
contact DECIMAL COMMENT'联系方式',
bondsman CHAR(4) COMMENT'担保人',
leaveHospitalSay DECIMAL COMMENT'出院结论',
cash FLOAT COMMENT'押金'
)COMMENT='住院病人基本信息表'  CHARSET='utf8'

CREATE TABLE sickBedNum(
sickBedNum INT(8) COMMENT'病床编号',
sickBedCode DECIMAL COMMENT'病床代号',
occupy INT(4) COMMENT'是否被占用'
)COMMENT='病床表'  CHARSET='utf8'

CREATE TABLE sickRoomMessage(
hospitalId INT(8) COMMENT'医院ID',
sickBedNum INT(8) COMMENT'病房编号',
section INT(8) COMMENT'科室编号' PRIMARY KEY,
sickRoomBedNum INT(4) COMMENT'病房病床数',
residueBedNum INT(4) COMMENT'剩余病床数',
price FLOAT COMMENT'价位'
)COMMENT='病房信息表'  CHARSET='utf8'

DROP TABLE sickRoomMessage;

CREATE TABLE section(
section INT(8) COMMENT'科室编号' PRIMARY KEY,
sectionType CHAR(4) COMMENT'科室类型'
)COMMENT='科室表'  CHARSET='utf8'

CREATE TABLE loginMessage(
number INT(8) COMMENT'编号',
userNum INT(8) COMMENT'用户编号',
online DATE COMMENT'上线时间'
)COMMENT='登录详情表'  CHARSET='utf8'

DROP TABLE loginMessage;

CREATE TABLE loginUser(
userNum INT(8) COMMENT'用户编号' PRIMARY KEY,
staffNum INT(8) COMMENT'员工编号',
userName CHAR(2) COMMENT'用户名',
pwd DECIMAL COMMENT'密码',
authority INT(4) COMMENT'权限'
)COMMENT='登录用户表'  CHARSET='utf8'

CREATE TABLE hospitalStaff(
staffNum INT(8) COMMENT'员工编号',
hospitalId INT(8) COMMENT'医院ID',
postNum INT(8) COMMENT'职位编号',
section INT(8) COMMENT'科室编号',
staffName DECIMAL COMMENT'姓名',
staffSex DECIMAL COMMENT'性别',
staffAge INT(4) COMMENT'年龄',
birth DATE COMMENT'出生日期',
staffHome DECIMAL COMMENT'家庭住址',
fixedTelephone DECIMAL COMMENT'固定电话',
moveTelephone DECIMAL COMMENT'移动电话'
)COMMENT='医院员工信息表'  CHARSET='utf8'

CREATE TABLE post(
postNum INT(8) COMMENT'职位编号' PRIMARY KEY,
postName CHAR(2) COMMENT'职称'
)COMMENT='职位表'  CHARSET='utf8'

CREATE TABLE hospitalMessage(
hospitalId INT(8) COMMENT'医院ID' PRIMARY KEY,
hospitalName DECIMAL COMMENT'名称',
hospitalHome DECIMAL COMMENT'地址',
hospitalBoss DECIMAL COMMENT'院长',
rank INT(4) COMMENT'等级',
hospitalTelphone DECIMAL COMMENT'联系电话'
)COMMENT='医院信息表'  CHARSET='utf8'

CREATE TABLE drugStorage(
houseId INT(4) COMMENT'库/房',
hospital INT(4) COMMENT'医院',
staffNum INT(8) COMMENT'员工编号（管理员）' PRIMARY KEY,
drugStorage DECIMAL COMMENT'药库/房名称'
)COMMENT='药库/房表'  CHARSET='utf8'

CREATE TABLE drugSort(
sortNum INT(8) COMMENT'类别编号',
sortName DECIMAL COMMENT'类别名称'
)COMMENT='药品类别表'  CHARSET='utf8'

CREATE TABLE drugMessage(
drugNum INT(8) COMMENT'药品编号',
sortNum INT(8) COMMENT'类别编号' PRIMARY KEY,
drugName DECIMAL COMMENT'药品名称',
unit DOUBLE COMMENT'单价',
size DECIMAL COMMENT'规格',
drugStock FLOAT COMMENT'库存量',
drugDate DATE COMMENT'日期'
)COMMENT='药品信息表'  CHARSET='utf8'

CREATE TABLE allot(
allotId INT(8) COMMENT'ID',
hospitalId INT(4) COMMENT'医院ID',
originNum DATE COMMENT'起点库房编号',
endNum FLOAT COMMENT'终点库房编号',
drugNum INT(8) COMMENT'药品编号' PRIMARY KEY,
allotDate INT(4) COMMENT'调拨时间',
allotNumber INT(4) COMMENT'数量',
unit INT(4) COMMENT'单位'
)COMMENT='调拨表'  CHARSET='utf8'

CREATE TABLE bePut(
bePutId INT(8) COMMENT'入库单',
drugName INT(8) COMMENT'药品编号' PRIMARY KEY,
bePutDate DATE COMMENT'入库日期',
primeCost FLOAT COMMENT'进货价格',
primeNumber INT(4) COMMENT'进货数量',
unitName INT(4) COMMENT'单位编号',
staffNum INT(8) COMMENT'员工编号（管理员）',
supplierId INT(4) COMMENT'供应商',
birthDate DATE COMMENT'生产日期',
indate DATE COMMENT'有效期'
)COMMENT='入库单表'  CHARSET='utf8'

CREATE TABLE drugBreak(
breakId INT(8) COMMENT'报损ID',
hospitalId INT(8) COMMENT'医院ID',
drugNum INT(8) COMMENT'药品编号' PRIMARY KEY,
breakNumber INT(8) COMMENT'报损数量',
unitNum INT(4) COMMENT'单位编号',
brealReason DECIMAL COMMENT'报损原因',
breakDate DATE COMMENT'报损日期',
declarant CHAR(2) COMMENT'申报人',
auditor CHAR(2) COMMENT'审核人',
declareDate DATE COMMENT'申报日期'
)COMMENT='药品报损表'  CHARSET='utf8'

CREATE TABLE returnCrgo(
returnId INT(8) COMMENT'退货单ID',
hospitalId INT(8) COMMENT'医院ID',
drugNum INT(8) COMMENT'药品编号' PRIMARY KEY,
returnPrice FLOAT COMMENT'退货单价',
returnNumber INT(4) COMMENT'退货数量',
unitNum INT(4) COMMENT'单位编号',
returnReason DECIMAL COMMENT'原因',
returnDate DATE COMMENT'退货日期'
)COMMENT='退货单表'  CHARSET='utf8'

实现效果：

以上均为个人所写，如有错误，欢迎指出，谢谢！