{"storm": {"columns": [[0, "Storm_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Dates_active", "TEXT", 0, null, 0], [3, "Max_speed", "INT", 0, null, 0], [4, "Damage_millions_USD", "REAL", 0, null, 0], [5, "Number_Deaths", "INT", 0, null, 0]], "primary_keys": ["Storm_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Storm_ID"]]], "check_constraints": []}, "region": {"columns": [[0, "Region_id", "INT", 0, null, 1], [1, "Region_code", "TEXT", 0, null, 0], [2, "Region_name", "TEXT", 0, null, 0]], "primary_keys": ["Region_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Region_id"]]], "check_constraints": []}, "affected_region": {"columns": [[0, "Region_id", "INT", 0, null, 1], [1, "Storm_ID", "INT", 0, null, 2], [2, "Number_city_affected", "REAL", 0, null, 0]], "primary_keys": ["Region_id", "Storm_ID"], "foreign_keys": [[0, 0, "storm", "Storm_ID", "Storm_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "region", "Region_id", "Region_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Region_id"], [1, 1, "Storm_ID"]]], "check_constraints": []}}
CREATE TABLE storm (
    Storm_ID INT   PRIMARY KEY,
    Name TEXT,
    Dates_active TEXT,
    Max_speed INT,
    Damage_millions_USD REAL,
    Number_Deaths INT,
    UNIQUE (Storm_ID)
);

CREATE TABLE region (
    Region_id INT   PRIMARY KEY,
    Region_code TEXT,
    Region_name TEXT,
    UNIQUE (Region_id)
);

CREATE TABLE affected_region (
    Region_id INT   PRIMARY KEY,
    Storm_ID INT   PRIMARY KEY,
    Number_city_affected REAL,
    PRIMARY KEY (Region_id, Storm_ID),
    UNIQUE (Region_id, Storm_ID),
    FOREIGN KEY (Storm_ID) REFERENCES storm(Storm_ID),
    FOREIGN KEY (Region_id) REFERENCES region(Region_id)
);