CREATE TABLE Patient (
PatientID INT AUTO_INCREMENT,
Name VARCHAR(255),
Gender VARCHAR(10),
DateOfBirth DATE,
Address VARCHAR(255),
ContactInfo VARCHAR(255),
PHN VARCHAR(20),
Username VARCHAR(50),
Password VARCHAR(50),
PRIMARY KEY (PatientID)
);
-- Create Receptionist table
CREATE TABLE Receptionist (
ReceptionistID INT AUTO_INCREMENT,
Name VARCHAR(255),
OPDNumber INT,
PRIMARY KEY (ReceptionistID)
);
-- Create Doctor table
CREATE TABLE Doctor (
DoctorID INT AUTO_INCREMENT,
Name VARCHAR(255),
PRIMARY KEY (DoctorID)
);
-- Create Pharmacy table
CREATE TABLE Pharmacy (
PharmacyID INT AUTO_INCREMENT,
MedicationDetails VARCHAR(255),
Instructions VARCHAR(255),
PRIMARY KEY (PharmacyID)
);
-- Create Appointment table
CREATE TABLE Appointment (
AppointmentID INT AUTO_INCREMENT,
OPDNumber INT,
Date DATE,
Time TIME,
PRIMARY KEY (AppointmentID)
);
-- Create FollowUp table
CREATE TABLE FollowUp (
FollowUpID INT AUTO_INCREMENT,
OPDNumber INT,
FollowUp