sql_tables.config

 CREATE TABLE DOCTORS( MLICENSE VARCHAR(10) PRIMARY KEY, FNAME VARCHAR(20) NOT NULL, LNAME VARCHAR(20) NOT NULL, EMAIL VARCHAR(50) UNIQUE NOT NULL, QUALIFICATIONS VARCHAR(255), AGE INT, GENDER CHAR(1), SPECIALIZATION VARCHAR(255), ABOUT VARCHAR(255));
 
 CREATE TABLE DOCTORS_LOGIN(EMAIL VARCHAR(50) UNIQUE REFERENCES DOCTORS(EMAIL) ON DELETE CASCADE, PASSWORD VARCHAR(16));
 
 CREATE TABLE PATIENTS( PATIENT_ID INT PRIMARY KEY AUTO_INCREMENT, FNAME VARCHAR(20) NOT NULL, LNAME VARCHAR(20) NOT NULL, EMAIL VARCHAR(50) UNIQUE NOT NULL, BLOOD_GROUP VARCHAR(6), GENDER CHAR(1), AGE INT, HEIGHT INT, WEIGHT INT, ALLERGIES VARCHAR(255));
 ALTER TABLE PATIENTS AUTO_INCREMENT = 4490;
 
 CREATE TABLE PATIENTS_LOGIN(EMAIL VARCHAR(50) UNIQUE REFERENCES PATIENTS(EMAIL) ON DELETE CASCADE, PASSWORD VARCHAR(16));
 
 CREATE TABLE HEALTH_RECORDS(RECORD_NO INT PRIMARY KEY AUTO_INCREMENT, CREATE_DATE DATE, SYMPTOMS VARCHAR(255), MED_CONDITION VARCHAR(255), DIAGNOSIS VARCHAR(1000), MEDICATION VARCHAR(255));
 ALTER TABLE HEALTH_RECORDS AUTO_INCREMENT = 65000;
 
 CREATE TABLE CONSULTATIONS( MLICENSE VARCHAR(10) NOT NULL REFERENCES DOCTORS(MLICENSE), P_ID INT NOT NULL REFERENCES PATIENTS(PATIENT_ID), HR_ID INT NOT NULL REFERENCES HEALTH_RECORDS(RECORD_NO) ,DATE_OF_CONSULT DATE);
 
 CREATE TABLE MEDICINES(MED_ID INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(255), COST INT, FOR_CONDITION VARCHAR(255));

 CREATE TABLE MEDIC_ASSN_LOGIN(USERNAME VARCHAR(50) PRIMARY KEY, PASSWORD VARCHAR(16) NOT NULL);
 
 //insert
 INSERT INTO PATIENTS(FNAME, LNAME, EMAIL, BLOOD_GROUP, GENDER, AGE, HEIGHT, WEIGHT, ALLERGIES) VALUES ('John', 'Doe', 'john@gmail.com', 'o+ve', 'M', 21, 178, 68, 'Peanut Butter');
 INSERT INTO DOCTORS VALUES("INKA6745", 'Harish', 'Kumar', 'harish@gmail.com', "M.D M.B.B.S, AIIMS Delhi", 45, 'M', "CARDIOLOGIST, SURGEON", "An experienced cardiologist surgeon");
 

INSERT INTO DOCTORS_LOGIN VALUES('harish@gmail.com','abc123');
INSERT INTO PATIENTS_LOGIN VALUES('john@gmail.com','xyz123');
Add these too