建库建表代码

USE master;
IF DB_ID('病区管理') IS NOT NULL
BEGIN
ALTER DATABASE EduBaseDemo
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
DROP DATABASE 病区管理;
END
CREATE DATABASE 病区管理
ON
(NAME='Datafile'
,FILENAME='E:\病区管理系统\DataFile.mdf')
LOG ON
(NAME='Logfile'
,FILENAME='E:\病区管理系统\Logfile.ldf');
GO
USE 病区管理
CREATE TABLE operator
(op_id
CHAR(10)
NOT NULL
PRIMARY KEY
,op_pass
VARCHAR(20)
NOT NULL
,op_name
VARCHAR(20)
NOT NULL
)
INSERT operator
(op_id,op_name,op_pass)
VALUES
('3160707001','张三','7001')
CREATE TABLE patients
(pa_no
CHAR(10)
NOT NULL
PRIMARY KEY
,pa_name
varchar(40)
not null
,pa_sex
varchar(10)
not null
,pa_sfid
char(18)
not null
,pa_type
varchar(40)
not null
,pa_depart
varchar(40)
not null
,pa_ward
char(3)
not null
,pa_bed
char(10)
not null
,pa_RuYuanTime
varchar(40)
not null
,pa_LiKaiTime
varchar(40)
not null)
CREATE TABLE beds
(be_no
char(10)
primary key
not null
,be_depart
varchar(10)
not null
,be_ward
varchar(40)
not null
,be_patient
varchar(40)
not null
,be_doctor
varchar(40)
not null
)
CREATE TABLE ward
(wa_no
varchar(10)
primary key
not null
,wa_bed
varchar(10)
not null
,wa_depart
char(10)
not null
)
CREATE TABLE departs
(de_no
char(10)
primary key
,de_doctorno
char(10)
not null
,de_doctor
varchar(40)
not null)
CREATE TABLE doctor
(do_no
char(10)
primary key
,do_name
varchar(40)
not null
,do_title
varchar(40)
not null
,do_depart
char(10)
not null
,do_bed
varchar(10)
not null)
CREATE TABLE drugs
(dr_no
char(10)
primary key
,dr_amount
int
not null
,dr_date
varchar(40)
not null
)
CREATE TABLE record
(re_no
char(10)
primary key
,re_startdate
varchar(40)
not null
,re_dano
char(10)
not null
,re_datype
varchar(40)
not null
,re_etp
varchar(40)
not null
,re_efq
int
not null
,re_epp
varchar(40)
not null
,re_endate
varchar(40)
)
CREATE TABLE advice
(ad_no
char(10)
primary key
,ad_pano
char(10)
not null
,ad_depart
varchar(40)
not null
,ad_doctor
varchar(40)
not null
,ad_date
varchar(40)
not null
,ad_content
varchar(400)
not null
)
CREATE TABLE list
(li_no
char(10)
primary key
,li_dname
varchar(40)
not null
,li_dsc
varchar(40)
not null
,li_boxs
int
not null
,li_boxunit
varchar(40)
not null
,li_bulks
int
not null
,li_bulkunit
int
not null
,li_peopleno
char(10)
not null
,li_depart
varchar(40)
not null
,li_date
varchar(40)
not null)
CREATE TABLE bill
(bi_no
char(10)
primary key
,bi_type
varchar(40)
not null
,bi_amount
int
not null
,bi_date
varchar(40)
not null
,bi_patientno
char(10)
not null
)
CREATE TABLE eorder
(eo_no
char(10)
primary key
,eo_name
varchar(40)
not null
,eo_date
varchar(40)
not null)