CREATE DATABASE IF NOT EXISTS copd_tb_db;
USE copd_tb_db;

CREATE TABLE IF NOT EXISTS questions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    section VARCHAR(50),
    question VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS results (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    age VARCHAR(10),
    gender VARCHAR(10),
    answers TEXT,
    diagnosis VARCHAR(255)
);
