mysql tables

CREATE TABLE customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    firebase_id VARCHAR(255),
    customer_name VARCHAR(50) UNIQUE NOT NULL,
    fcm_token VARCHAR(255),
    default_phone VARCHAR(20),
    default_address VARCHAR(255),
    last_order_date DATE
);

CREATE TABLE dish_categories (
    category_id INT AUTO_INCREMENT PRIMARY KEY,
    category_name VARCHAR(50) UNIQUE NOT NULL,
    category_image_url VARCHAR(255)
);

CREATE TABLE dishes (
    dish_id INT AUTO_INCREMENT PRIMARY KEY,
    dish_name VARCHAR(100) UNIQUE NOT NULL,
    category_id INT,
    price_half DECIMAL(10, 2) DEFAULT 0,
    price_full DECIMAL(10, 2) DEFAULT 0,
    discount DECIMAL(5, 2) DEFAULT 0,
    dish_image_url VARCHAR(255),
    FOREIGN KEY (category_id) REFERENCES dish_categories(category_id)
);

CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT,
    customer_name VARCHAR(100),
    customer_phone VARCHAR(20),
    whatsapp_enabled BOOLEAN DEFAULT FALSE,
    delivery_address VARCHAR(255),
    order_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    total_amount DECIMAL(10, 2),
    status ENUM('pending', 'processing', 'completed', 'cancelled') DEFAULT 'pending',
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);

CREATE TABLE order_dishes (
    order_id INT,
    dish_id INT,
    quantity INT,
    portion_size ENUM('half', 'full') DEFAULT 'full',
    PRIMARY KEY (order_id, dish_id),
    FOREIGN KEY (order_id) REFERENCES orders(order_id),
    FOREIGN KEY (dish_id) REFERENCES dishes(dish_id)
);