医院信息管理系统mysql数据库创建语句
医院信息管理系统oracle数据库创建语句
医院信息管理系统sqlserver数据库创建语句
医院信息管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
医院信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
医院信息管理系统登录注册界面
医院信息管理系统mysql数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);
SQLCopy
用户表创建语句如下:
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
customerName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
bs varchar(100) comment ‘病史’,
sfz varchar(100) comment ‘社保卡’,
sbk varchar(100) comment ‘身份证’
) comment ‘用户’;
SQLCopy
住院医生查房记录表创建语句如下:
create table t_fymx(
id int primary key auto_increment comment ‘主键’,
zhuyuanId int comment ‘住院’,
fy int comment ‘费用’,
showDate datetime comment ‘费用日期’,
content varchar(100) comment ‘内容记录’
) comment ‘住院医生查房记录’;
SQLCopy
公告表创建语句如下:
create table t_gg(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
cotnent varchar(100) comment ‘内容’,
showDate datetime comment ‘日期’
) comment ‘公告’;
SQLCopy
挂号表创建语句如下:
create table t_guahao(
id int primary key auto_increment comment ‘主键’,
ksId int comment ‘科室’,
customerId int comment ‘用户’,
ysId int comment ‘医生’,
ypfee int comment ‘药品费用’,
ypmx varchar(100) comment ‘药品明细’,
zfyfee int comment ‘总费用’,
zfymx varchar(100) comment ‘总费用明细’,
zdjl varchar(100) comment ‘诊断记录’,
showDate datetime comment ‘日期’,
status varchar(100) comment ‘’
) comment ‘挂号’;
SQLCopy
科室表创建语句如下:
create table t_ks(
id int primary key auto_increment comment ‘主键’,
ksName varchar(100) comment ‘科室’
) comment ‘科室’;
SQLCopy
药品表创建语句如下:
create table t_yaopin(
id int primary key auto_increment comment ‘主键’,
yaopinName varchar(100) comment ‘药品名称’,
pic varchar(100) comment ‘图片’,
gg varchar(100) comment ‘规格’,
num int comment ‘当前库存’
) comment ‘药品’;
SQLCopy
药品进出详情表创建语句如下:
create table t_yaopinlist(
id int primary key auto_increment comment ‘主键’,
yaopinId int comment ‘药品名称’,
sl int comment ‘数量’,
types varchar(100) comment ‘类型’,
showDate datetime comment ‘日期’,
fzr varchar(100) comment ‘负责人’
) comment ‘药品进出详情’;
SQLCopy
医生表创建语句如下:
create table t_ys(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
ysName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
js varchar(100) comment ‘岗位’,
ksId int comment ‘科室’
) comment ‘医生’;
SQLCopy
住院表创建语句如下:
create table t_zhuyuan(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
ysId int comment ‘主治医生’,
beginDate datetime comment ‘住院日期’,
endDate datetime comment ‘出院日期’,
yfk int comment ‘预付款’,
zje int comment ‘总费用’,
pic varchar(100) comment ‘拍照’,
status varchar(100) comment ‘状态’,
zhuyuanName varchar(100) comment ‘’
) comment ‘住院’;
SQLCopy
住院医生查房记录表创建语句如下:
create table t_zhuyuanlist(
id int primary key auto_increment comment ‘主键’,
zhuyuanId int comment ‘住院’,
ysId int comment ‘医生’,
showDate datetime comment ‘查房日期’,
content varchar(100) comment ‘内容记录’
) comment ‘住院医生查房记录’;
SQLCopy
医院信息管理系统oracle数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,‘admin’,‘123456’);
–超级管理员字段加注释
comment on column t_admin.id is ‘主键’;
comment on column t_admin.username is ‘超级管理员账号’;
comment on column t_admin.password is ‘超级管理员密码’;
–超级管理员表加注释
comment on table t_admin is ‘超级管理员’;
SQLCopy
用户表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bs varchar(100),
sfz varchar(100),
sbk varchar(100)
);
–用户字段加注释
comment on column t_customer.id is ‘主键’;
comment on column t_customer.username is ‘账号’;
comment on column t_customer.password is ‘密码’;
comment on column t_customer.customerName is ‘姓名’;
comment on column t_customer.phone is ‘电话’;
comment on column t_customer.age is ‘年龄’;
comment on column t_customer.sex is ‘性别’;
comment on column t_customer.bs is ‘病史’;
comment on column t_customer.sfz is ‘社保卡’;
comment on column t_customer.sbk is ‘身份证’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
住院医生查房记录表创建语句如下:
create table t_fymx(
id integer,
zhuyuanId int,
fy int,
showDate datetime,
content varchar(100)
);
–住院医生查房记录字段加注释
comment on column t_fymx.id is ‘主键’;
comment on column t_fymx.zhuyuanId is ‘住院’;
comment on column t_fymx.fy is ‘费用’;
comment on column t_fymx.showDate is ‘费用日期’;
comment on column t_fymx.content is ‘内容记录’;
–住院医生查房记录表加注释
comment on table t_fymx is ‘住院医生查房记录’;
SQLCopy
公告表创建语句如下:
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
–公告字段加注释
comment on column t_gg.id is ‘主键’;
comment on column t_gg.title is ‘标题’;
comment on column t_gg.pic is ‘图片’;
comment on column t_gg.cotnent is ‘内容’;
comment on column t_gg.showDate is ‘日期’;
–公告表加注释
comment on table t_gg is ‘公告’;
SQLCopy
挂号表创建语句如下:
create table t_guahao(
id integer,
ksId int,
customerId int,
ysId int,
ypfee int,
ypmx varchar(100),
zfyfee int,
zfymx varchar(100),
zdjl varchar(100),
showDate datetime,
status varchar(100)
);
–挂号字段加注释
comment on column t_guahao.id is ‘主键’;
comment on column t_guahao.ksId is ‘科室’;
comment on column t_guahao.customerId is ‘用户’;
comment on column t_guahao.ysId is ‘医生’;
comment on column t_guahao.ypfee is ‘药品费用’;
comment on column t_guahao.ypmx is ‘药品明细’;
comment on column t_guahao.zfyfee is ‘总费用’;
comment on column t_guahao.zfymx is ‘总费用明细’;
comment on column t_guahao.zdjl is ‘诊断记录’;
comment on column t_guahao.showDate is ‘日期’;
comment on column t_guahao.status is ‘’;
–挂号表加注释
comment on table t_guahao is ‘挂号’;
SQLCopy
科室表创建语句如下:
create table t_ks(
id integer,
ksName varchar(100)
);
–科室字段加注释
comment on column t_ks.id is ‘主键’;
comment on column t_ks.ksName is ‘科室’;
–科室表加注释
comment on table t_ks is ‘科室’;
SQLCopy
药品表创建语句如下:
create table t_yaopin(
id integer,
yaopinName varchar(100),
pic varchar(100),
gg varchar(100),
num int
);
–药品字段加注释
comment on column t_yaopin.id is ‘主键’;
comment on column t_yaopin.yaopinName is ‘药品名称’;
comment on column t_yaopin.pic is ‘图片’;
comment on column t_yaopin.gg is ‘规格’;
comment on column t_yaopin.num is ‘当前库存’;
–药品表加注释
comment on table t_yaopin is ‘药品’;
SQLCopy
药品进出详情表创建语句如下:
create table t_yaopinlist(
id integer,
yaopinId int,
sl int,
types varchar(100),
showDate datetime,
fzr varchar(100)
);
–药品进出详情字段加注释
comment on column t_yaopinlist.id is ‘主键’;
comment on column t_yaopinlist.yaopinId is ‘药品名称’;
comment on column t_yaopinlist.sl is ‘数量’;
comment on column t_yaopinlist.types is ‘类型’;
comment on column t_yaopinlist.showDate is ‘日期’;
comment on column t_yaopinlist.fzr is ‘负责人’;
–药品进出详情表加注释
comment on table t_y