- CREATE TABLE Client (
- ClientID INT PRIMARY KEY AUTO_INCREMENT,
- Name VARCHAR(255),
- Email VARCHAR(255),
- Phone VARCHAR(20)
- );
- CREATE TABLE Appointment (
- AppointmentID INT PRIMARY KEY AUTO_INCREMENT,
- ClientID INT,
- ServiceID INT,
- StaffID INT,
- StartTime DATETIME,
- EndTime DATETIME,
- FOREIGN KEY (ClientID) REFERENCES Client(ClientID),
- FOREIGN KEY (ServiceID) REFERENCES Service(ServiceID),
- FOREIGN KEY (StaffID) REFERENCES Staff(StaffID)
- );
- CREATE TABLE Service (
- ServiceID INT PRIMARY KEY AUTO_INCREMENT,
- Name VARCHAR(255),
- Description TEXT,
- Duration INT
- );
- CREATE TABLE Staff (
- StaffID INT PRIMARY KEY AUTO_INCREMENT,
- Name VARCHAR(255),
- Role VARCHAR(255)
- );
- CREATE TABLE Resource (
- ResourceID INT PRIMARY KEY AUTO_INCREMENT,
- Name VARCHAR(255),
- Description TEXT
- );
- CREATE TABLE Appointment_Resource (
- AppointmentID INT,
- ResourceID INT,
- PRIMARY KEY (AppointmentID, ResourceID),
- FOREIGN KEY (AppointmentID) REFERENCES Appointment(AppointmentID),
- FOREIGN KEY (ResourceID) REFERENCES Resource(ResourceID)
- );
[text] SAMPLE
Viewer
Editor
You can edit this paste and save as new: