SQLize Online / PHPize Online  /  SQLtest Online

Create Table Specialty( SpecialtyNumber char(10) Not Null, SpecialtyName char (40), CONSTRAINT pk_sn PRIMARY KEY (SpecialtyNumber), CONSTRAINT uq_sn Unique (SpecialtyNumber) ); Create Table Doctor( DoctorID char(10) Not Null, Name char (40) Not Null, Phone char (20) Not Null, SpecialtyNumber char(10) Not Null, Supervisor char(10), CONSTRAINT pk_did PRIMARY KEY (DoctorID), CONSTRAINT uq_did Unique (DoctorID) ); ALTER TABLE Doctor ADD CONSTRAINT fk_Specialty FOREIGN KEY (SpecialtyNumber) REFERENCES Specialty(SpecialtyNumber); Create Table Patient( PatientID char(10) Not Null, Name char(40) Not Null, Phone char(20) Not Null, Email char(40), Address char(100) Not Null, AddedDate date Not Null, DoctorID char(10) Not Null, CONSTRAINT pk_pid PRIMARY KEY (PatientID), CONSTRAINT uq_pid Unique (PatientID), CONSTRAINT fk_doctor FOREIGN KEY (DoctorID) REFERENCES Doctor (DoctorID) ); Create Table Allergy( AllergyID char(10) Not Null, AllergyName char(40) Not Null, CONSTRAINT pk_aid PRIMARY KEY (AllergyID), CONSTRAINT uq_aid Unique (AllergyID) ); Create Table PatientAllergy( AllergyID char(10) Not Null, PatientID char(10) Not Null, CONSTRAINT pk_apid PRIMARY KEY (AllergyID,PatientID), CONSTRAINT uq_apid Unique (AllergyID,PatientID), CONSTRAINT fk_allergy FOREIGN KEY (AllergyID) REFERENCES Allergy(AllergyID), CONSTRAINT fk_patient FOREIGN KEY (PatientID) REFERENCES Patient(PatientID) ); Create Table Appointment( AppointmentID char(10) Not Null, PatientID char(10) Not Null, DoctorID char(10) Not Null, AppointmentDate date Not Null, BloodPressure smallint Not Null, Weight decimal(5,2) Not Null, TreatmentNotes char(255) Not Null, CONSTRAINT pk_appid PRIMARY KEY (AppointmentID), CONSTRAINT uq_appid Unique (AppointmentID), CONSTRAINT fk_doctor_app FOREIGN KEY (DoctorID) REFERENCES Doctor(DoctorID), CONSTRAINT fk_patient_app FOREIGN KEY (PatientID) REFERENCES Patient(PatientID) );