Scribd
Upload
13 views3 pages

Sai Dbms Code

Uploaded by

1324 Vaibhav Achalkhamb
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views3 pages

Sai Dbms Code

Uploaded by

1324 Vaibhav Achalkhamb
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

CREATE TABLE Patient

email varchar(20) NOT NULL,

password varchar(10) NOT NULL,

name varchar(10) NOT NULL,

address varchar(10) NOT NULL,

gender VARCHAR(10) NOT NULL

);

CREATE TABLE MedicalHistory

id NUMBER NOT NULL,

conditions VARCHAR(30) NOT NULL,

surgeries VARCHAR(20) NOT NULL,

medication VARCHAR(20) NOT NULL

);

CREATE TABLE Doctor

email varchar(20) NOT NULL,

gender varchar(10) NOT NULL,

password varchar(10) NOT NULL,

name varchar(10) NOT NULL

);
CREATE TABLE PatientsAttendAppointments

patient varchar(20) NOT NULL,

appt int NOT NULL,

concerns varchar(10) NOT NULL,

symptoms varchar(10) NOT NULL

);

CREATE TABLE PatientsFillHistory

patient varchar(50) NOT NULL,

history int NOT NULL

);

CREATE TABLE Diagnose

appt int NOT NULL,

doctor varchar(20) NOT NULL,

diagnosis varchar(10) NOT NULL,

prescription varchar(20) NOT NULL

);
CREATE TABLE DocsHaveSchedules

sched int NOT NULL,

doctor varchar(20) NOT NULL

);

CREATE TABLE DoctorViewsHistory

history int NOT NULL,

doctor varchar(20) NOT NULL

);

You might also like