CREATE TABLE Doctor (
DoctorNo Number(1) primary key,
DoctorName Varchar2(40) NOT NULL,
QualifidDoctor Varchar2(12)
Check(QualifidDoctor in('Bachelor','Master's','Doctorate')),
DateOfGraduation Date NOT NULL,
DateOfAppointed Date NOT NULL,
DateOfBirth Date NOT NULL,
Phone Number(9) Unique ) ;
CREATE TABLE Patients(
PatientNo Number(5) Primary key,
patientName Varchar2(40) NOT NULL,
Date_of_hearth Date NOT NULL,
Sex Varchar2(5) check(Sex in('male','famle')),
Phone Number(9) Unique,
VisitationNo Number(2) NOT NULL) ;
CREATE TABLE Operating(
OperatingNo Number(4) primary key,
OperatingType Varchar2(10)
Check(operatingType in('pull out','Fever','cBreak')),
DateOperating Date ,
DoctorNo references Doctor(DoctorNo), PatientNo references Patients(PatientNo));
CREATE TABLE Secretary(
SecretaryNo Number(1) primary key,
SecretaryName Varchar2(40) NOT NULL,
QualifiedSecretary Varchar2(12)
Check(QualifiedSecretary in('Diploma','Bachelor')),
DateOfGraduation Date NOT NULL,
DateEmployed Date NOT NULL);
CREATE TABLE Revenues(
BillNo Number(5) primary key,
RevenuesType Varchar2(60),
DateOfCollecting Date NOT NULL,
SecretaryNo Number(1) references secretary(SecretaryNo) ,
patientNo references Patients(PatientNo) ) ;
CREATE TABLE Reserve(
ReserveNo Number(2) primary key,
DateOfReserve Date NOT NULL,
D_M_S Date NOT NULL,
T_M_S date Unique,
StateType Varchar2(10) check(StateType in('pull out','Fever','Break')),
T_A_P date Unique,
SecretaryNo references Secretary(SecretaryNo),
PatientNo references Patients(PatientNo) ) ;
