{"mission": {"columns": [[0, "Mission_ID", "INT", 0, null, 1], [1, "Ship_ID", "INT", 0, null, 0], [2, "Code", "TEXT", 0, null, 0], [3, "Launched_Year", "INT", 0, null, 0], [4, "Location", "TEXT", 0, null, 0], [5, "Speed_knots", "INT", 0, null, 0], [6, "Fate", "TEXT", 0, null, 0]], "primary_keys": ["Mission_ID"], "foreign_keys": [[0, 0, "ship", "Ship_ID", "Ship_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Mission_ID"]]], "check_constraints": []}, "ship": {"columns": [[0, "Ship_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Type", "TEXT", 0, null, 0], [3, "Nationality", "TEXT", 0, null, 0], [4, "Tonnage", "INT", 0, null, 0]], "primary_keys": ["Ship_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Ship_ID"]]], "check_constraints": []}}
CREATE TABLE mission (
    Mission_ID INT   PRIMARY KEY,
    Ship_ID INT,
    Code TEXT,
    Launched_Year INT,
    Location TEXT,
    Speed_knots INT,
    Fate TEXT,
    UNIQUE (Mission_ID),
    FOREIGN KEY (Ship_ID) REFERENCES ship(Ship_ID)
);

CREATE TABLE ship (
    Ship_ID INT   PRIMARY KEY,
    Name TEXT,
    Type TEXT,
    Nationality TEXT,
    Tonnage INT,
    UNIQUE (Ship_ID)
);