
CREATE TABLE Staff (
StaffId VARCHAR(10) PRIMARY KEY,
StaffName VARCHAR(20),
StaffRole VARCHAR(20)
);
CREATE TABLE Therapists (
TherapitId VARCHAR(10) PRIMARY KEY,
F_Name VARCHAR(20),
L_Name VARCHAR(20),
StaffId VARCHAR(10) FOREIGN KEY REFERENCES Staff
);
CREATE TABLE Customer (
CustomerId VARCHAR(10) PRIMARY KEY,
CustomerName VARCHAR(20),
);
CREATE TABLE Booking (
BookingId VARCHAR(10) PRIMARY KEY,
Booking_Date DATE,
Booking_Time time(7),
CustomerId VARCHAR(10) FOREIGN KEY REFERENCES Customer,
TherapistId VARCHAR(10) FOREIGN KEY REFERENCES Therapists
);
CREATE TABLE Treatments (
TreatmentId VARCHAR(10) PRIMARY KEY,
Treatment_Name VARCHAR(20),
Treatment_Type VARCHAR(20),
fees MONEY,
TherapistId VARCHAR(10) FOREIGN KEY REFERENCES Therapists
);
INSERT INTO Staff VALUES
PayPal Gateway not configured
PayPal Gateway not configured