c语言药房挂号收费系统,挂号收费数据库.sql

IF DB_ID ('RegistrationFee') IS NOT NULL

DROP DATABASE RegistrationFee;

CREATE DATABASE RegistrationFee

ON

(NAME='DataFile_1'

,FILENAME='D:\RegistrationFee\DataFile_1.mdf')

LOG ON

(NAME='LogFile_1'

,FILENAME='D:\RegistrationFee\LogFile_1.ldf');

Use RegistrationFee;

IF OBJECT_ID('tb_Clinic')IS NOT NULL

DROP TABLE tb_Clinic;

CREATE TABLE tb_Clinic

(RegisterNo

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Clinic_RegisterNo

PRIMARY KEY(RegisterNo)

,PatientNo

VARCHAR(10)

NOT NULL

CONSTRAINT fk_Clinic_PatientNo

FOREIGN KEY(PatientNo)

REFERENCES tb_Patient(No)

,OperatorNo

VARCHAR(10)

NOT NULL

CONSTRAINT fk_Clinic_OperatorNo

FOREIGN KEY(OperatorNo)

REFERENCES tb_Operator(No)

,DoctorNo

VARCHAR(10)

NOT NULL

CONSTRAINT fk_Clinic_DoctorNo

FOREIGN KEY(DoctorNo)

REFERENCES tb_Doctor(No)

,Time

DATE

NOT NULL

CONSTRAINT df_Clinic_Time

DEFAULT(GETDATE()));

Use RegistrationFee;

IF OBJECT_ID('tb_Doctor')IS NOT NULL

DROP TABLE tb_Doctor;

CREATE TABLE tb_Doctor

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Doctor_No

PRIMARY KEY(No)

,Name

VARCHAR(10)

NOT NULL

,JobTitle

VARCHAR(10)

NOT NULL

,Department

VARCHAR(10)

NOT NULL

,DepartmentNo

VARCHAR(10)

NOT NULL

CONSTRAINT uk_Doctor_DepartmentNo

UNIQUE(DepartmentNo));

Use RegistrationFee;

IF OBJECT_ID('tb_Patient')IS NOT NULL

DROP TABLE tb_Patient;

CREATE TABLE tb_Patient

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Patient_No

PRIMARY KEY(No)

,Name

VARCHAR(10)

NOT NULL

,Gender

BIT

NOT NULL

,NativePlace

VARCHAR(20)

NOT NULL

,BirthDate

DATE

,Profession

VARCHAR(40)

NOT NULL

,Department

VARCHAR(20)

NOT NULL

,DoctorNo

VARCHAR(10)

NOT NULL

CONSTRAINT fk_Patient_DoctorNo

FOREIGN KEY(DoctorNo)

REFERENCES tb_Doctor(No));

Use RegistrationFee;

IF OBJECT_ID('tb_Registered')IS NOT NULL

DROP TABLE tb_Registered;

CREATE TABLE tb_Registered

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Registered_No

PRIMARY KEY(No)

,Type

BIT

NOT NULL

,PatientType

VARCHAR(40)

NOT NULL

,Date

DATE

NOT NULL);

Use RegistrationFee;

IF OBJECT_ID('tb_Recipe')IS NOT NULL

DROP TABLE tb_Recipe;

CREATE TABLE tb_Recipe

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Recipe_No

PRIMARY KEY(No)

,DoctorNo

VARCHAR(10)

NOT NULL

CONSTRAINT fk_Recipe_DoctorNo

FOREIGN KEY(DoctorNo)

REFERENCES tb_Doctor(No)

,DepartmentNo

VARCHAR(10)

NOT NULL

,Date

DATE

NOT NULL);

Use RegistrationFee;

IF OBJECT_ID('tb_Drug')IS NOT NULL

DROP TABLE tb_Drug;

CREATE TABLE tb_Drug

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Drug_No

PRIMARY KEY(No)

,Name

VARCHAR(20)

NOT NULL

,Value

VARCHAR(10)

NOT NULL

,Insurance

BIT

NOT NULL

,Time

DATE

NOT NULL

,Validity

TIME

NOT NULL);

Use RegistrationFee;

IF OBJECT_ID('tb_Charge')IS NOT NULL

DROP TABLE tb_Charge;

CREATE TABLE tb_Charge

(No

VARCHAR(20)

NOT NULL

CONSTRAINT pk_Charge_No

PRIMARY KEY

,Type

VARCHAR(20)

NOT NULL

,Gone

VARCHAR(20)

NOT NULL

,Date

DATE

NOT NULL

,OwnExpense

MONEY

NOT NULL

,Insurance

MONEY

NOT NULL

,Total

MONEY

NOT NULL

,Drawer

VARCHAR(10)

NOT NULL);

Use RegistrationFee;

IF OBJECT_ID('tb_MedicalCard')IS NOT NULL

DROP TABLE tb_MedicalCard;

CREATE TABLE tb_MedicalCard

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_MedicalCard_No

PRIMARY KEY(No)

,Name

VARCHAR(20)

NOT NULL

,Type

VARCHAR(10)

NOT NULL

,Number

VARCHAR(2)

NOT NULL);

Use RegistrationFee;

IF OBJECT_ID('tb_Operator')IS NOT NULL

DROP TABLE tb_Operator;

CREATE TABLE tb_Operator

(No

VARCHAR(10)

NOT NULL

CONSTRAINT pk_Operator_No

PRIMARY KEY(No)

,Name

VARCHAR(10)

NOT NULL);

一键复制

编辑

Web IDE

原始数据

按行查看

历史