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) );