{"mountain": {"columns": [[0, "Mountain_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Height", "REAL", 0, null, 0], [3, "Prominence", "REAL", 0, null, 0], [4, "Range", "TEXT", 0, null, 0], [5, "Country", "TEXT", 0, null, 0]], "primary_keys": ["Mountain_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Mountain_ID"]]], "check_constraints": []}, "climber": {"columns": [[0, "Climber_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Country", "TEXT", 0, null, 0], [3, "Time", "TEXT", 0, null, 0], [4, "Points", "REAL", 0, null, 0], [5, "Mountain_ID", "INT", 0, null, 0]], "primary_keys": ["Climber_ID"], "foreign_keys": [[0, 0, "mountain", "Mountain_ID", "Mountain_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Climber_ID"]]], "check_constraints": []}}
CREATE TABLE mountain (
    Mountain_ID INT   PRIMARY KEY,
    Name TEXT,
    Height REAL,
    Prominence REAL,
    Range TEXT,
    Country TEXT,
    UNIQUE (Mountain_ID)
);

CREATE TABLE climber (
    Climber_ID INT   PRIMARY KEY,
    Name TEXT,
    Country TEXT,
    Time TEXT,
    Points REAL,
    Mountain_ID INT,
    UNIQUE (Climber_ID),
    FOREIGN KEY (Mountain_ID) REFERENCES mountain(Mountain_ID)
);