SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Patient ( SSN NUMERIC(7, 0), FirstName VARCHAR(40), LastName VARCHAR(50), Address VARCHAR(250), DOB VARCHAR(10), -- 2022-03-05 PrimaryDoc_SSN VARCHAR(7), PRIMARY KEY (SSN) ); CREATE TABLE Prescription ( Id VARCHAR(18), Date VARCHAR(10), Doctor_ssn NUMERIC(7, 0), Patient_ssn NUMERIC(7, 0), PRIMARY KEY (Id), FOREIGN KEY (Doctor_ssn) REFERENCES Doctor (SSN) ON DELETE SET NULL, FOREIGN KEY (Patient_ssn) REFERENCES Patient (SSN) ON DELETE SET NULL );