[sql] Beauty
Viewer
- CREATE TABLE Clients (
- ClientID INT PRIMARY KEY,
- FirstName VARCHAR(50),
- LastName VARCHAR(50),
- Email VARCHAR(100),
- Phone VARCHAR(20),
- Gender VARCHAR(10),
- Birthday DATE
- );
- CREATE TABLE Services (
- ServiceID INT PRIMARY KEY,
- ServiceName VARCHAR(100),
- Description TEXT,
- Price DECIMAL(10, 2),
- Duration INT
- );
- CREATE TABLE Employees (
- EmployeeID INT PRIMARY KEY,
- FirstName VARCHAR(50),
- LastName VARCHAR(50),
- Email VARCHAR(100),
- Phone VARCHAR(20),
- Specialization VARCHAR(100),
- Schedule VARCHAR(100)
- );
- CREATE TABLE Appointments (
- AppointmentID INT PRIMARY KEY,
- ClientID INT,
- EmployeeID INT,
- ServiceID INT,
- AppointmentDateTime DATETIME,
- FOREIGN KEY (ClientID) REFERENCES Clients(ClientID),
- FOREIGN KEY (EmployeeID) REFERENCES Employees(EmployeeID),
- FOREIGN KEY (ServiceID) REFERENCES Services(ServiceID)
- );
- CREATE TABLE Inventory (
- InventoryID INT PRIMARY KEY,
- ItemName VARCHAR(100),
- Description TEXT,
- Quantity INT,
- Price DECIMAL(10, 2)
- );
Editor
You can edit this paste and save as new: