/*The following statements will create the tables needed for the Medical System database


CREATE TABLE Patient
{
Patient_ID integer,
Fname varchar(20),
Lname varchar(20),
Address varchar(20),
Phone_Number integer,
}

CREATE TABLE Invoice
{
Visit_ID integer,
TotalAmount integer,
AmountPaid integer,
Balance integer,
PaymentMethod varchar(20),
Deductible integer,
}

CREATE TABLE Visit
{
Visit_ID integer,
Patient_ID integer,
Doctor_ID integer,
Diagnosis varchar(20),
Treatment varchar(20),
}

CREATE TABLE Doctor
{
Doctor_ID integer,
Fname varchar(20),
Lname varchar(20),
Office_ID integer,
}

CREATE TABLE Appointment
{
Doctor_ID integer,
Patient_ID integer,
Visit_ID integer,
Reason varchar(20),
Time date(yyymmdd),
}