easyhis.sql

醫院管理 還不錯 醫院管理 還不錯 醫院管理 還不錯

/*
date: Jun 12, 2004
Access 97

Author: Nizvoo Kensen

医院基本信息表
操作用户表
来诊用户表

*/

create database StoreMIS
--1
--医院基本信息
create table basicinf
(
id	text(6) primary key,	/*商店编号*/
name	text(20),	/*商店名称*/
tele	text(25),	/*电话号码*/
email	text(40),	/*电邮*/
post	text(12),	/*邮编*/
addr	text(64),	/*地址*/
webpg	text(64),	/*商店网站*/
remark	text(64)	/*商店备注*/
)

create unique index BasicInf on BasicInf (id)

insert into basicinf (id) values ('100100')
--2
--来诊基本信息表
create table employeeinf
(
id  integer primary key,
name 	text(20),	
EMPLOYEE_NO text(100),
PROFESSION text(50),
department  text(20),       
sex	integer,	
birth	datetime,	
age integer,
maritalstatus integer,
placeofbirth text(100),
 HEIGHT integer,
weight integer,
SUPR_NAME text(25),
EMERGENCYname text(100),
EMERGENCY_tel text(25),
tele 	text(25),	
handset 	text(25),	
email 	text(40),	
post 	text(12),	
addr 	text(128),	
logusr 	text(20),	
logpwd 	text(20),
optid 	integer,
MEDICINE_ALLERGIES text(255),
other_ALLERGIES text(255),
MEDICINE text(255),
MEDICAL_HISTORY text(255),
FAMILY_HISTORY text(255),
MENSTRUATION_child_birth text(255),
OSPITALIZATION_OPERATION text(255),
SOCIAL_HISTORY text(255),
HABITS_CIGARETTES_ALCOHOL text(255),
remark 	text(255),

optdate 	datetime	
)

create unique index cltinf on cltinf(id)

--3
--操作员信息表

create table optinf
(
id	integer primary key,
name	text(20),
sex	integer,
birth	datetime,
optknd  integer,
handset	text(25),
logusr	text(20),
logpwd	text(20),
remark	text(255)
)
create table optinf
(
id	integer identity primary key,
name	text(20),
sex	integer,
birth	datetime,
optknd	tinyint,	
handset	text(25),
logusr	text(20),
logpwd	text(20),
remark	text(255)
)
create unique index optinf on optinf (id)

insert into optinf (name,sex,birth,optknd,logusr) values ('管理员',0,'1974-07-04',0,'管理员')

--4
--操作员类型表
create	table optknd
(
id	integer primary key,		
name	text(20),	/*操作名称*/
remark	text(255)	/*备注部分*/
)
create unique index optknd on optknd (id)


create unique index billinf on billinf (id)



--7
--数据存放表
create table datainf
id
data	image,		/*数据部分*/
remark	text(255)	/*数据描述*/

--8
--需求表
create table reqinf
id
name	text(30),	/*需求名称*/
remark	text(255),	/*需求备注*/

--9
--状态信息表
crete table statinf
id
name	text(30),	/*状态信息*/
remark	text(255)	/*状态备注*/


//基本病历信息
create table