CREATE TABLE project_details_extended_dnd (
    id INT AUTO_INCREMENT PRIMARY KEY,
    project_id INT NOT NULL,
    unique_designs1 INT,
    iterations1 INT,
    hours_unique_design1 FLOAT,
    hours_per_iteration1 FLOAT,
    total_hours1 FLOAT,
    unique_designs2 INT,
    iterations2 INT,
    hours_unique_design2 FLOAT,
    hours_per_iteration2 FLOAT,
    total_hours2 FLOAT,
    developer_cost FLOAT,
    development_cost FLOAT,
    designer_cost FLOAT,
    designing_cost FLOAT,
    total_project_hours FLOAT,
    project_timeline INT,
    total_project_cost FLOAT,
    notes TEXT,
    terms_and_conditions TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);