CREATE TABLE Staff (
    Staff_ID INT,
    Fname VARCHAR(60),
    Lname VARCHAR(60),
    Phone VARCHAR(20),
    Role ENUM('Chef', 'Waiter', 'Cashier')
);

CREATE TABLE Orders (
    Order_ID INT,
    Customer_ID INT,
    Staff_ID INT,
    Order_DateTime DATETIME,
    Order_Type ENUM('Dine_in', 'Takeaway'),
    Payment_Method ENUM('Cash', 'Card'),
    Total_Amount DECIMAL(8,2)
);

CREATE TABLE Dish (
    Dish_ID INT,
    Dish_Name VARCHAR(100),
    Category ENUM('Appetizer', 'Main_Dish', 'Dessert', 'Drink'),
    Price DECIMAL(6,2)
);

CREATE TABLE Order_Details (
    Order_ID INT,
    Dish_ID INT,
    Quantity INT
);

CREATE TABLE Customer (
    Customer_ID INT,
    Fname VARCHAR(60),
    Lname VARCHAR(60),
    Phone VARCHAR(20)
);

SHOW TABLES;
select * from customer ;