{"mountain": {"columns": [[0, "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": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "camera_lens": {"columns": [[0, "id", "INT", 0, null, 1], [1, "brand", "TEXT", 0, null, 0], [2, "name", "TEXT", 0, null, 0], [3, "focal_length_mm", "REAL", 0, null, 0], [4, "max_aperture", "REAL", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "photos": {"columns": [[0, "id", "INT", 0, null, 1], [1, "camera_lens_id", "INT", 0, null, 0], [2, "mountain_id", "INT", 0, null, 0], [3, "color", "TEXT", 0, null, 0], [4, "name", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "mountain", "mountain_id", "id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "camera_lens", "camera_lens_id", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}}
CREATE TABLE mountain (
    id INT   PRIMARY KEY,
    name TEXT,
    Height REAL,
    Prominence REAL,
    Range TEXT,
    Country TEXT,
    UNIQUE (id)
);

CREATE TABLE camera_lens (
    id INT   PRIMARY KEY,
    brand TEXT,
    name TEXT,
    focal_length_mm REAL,
    max_aperture REAL,
    UNIQUE (id)
);

CREATE TABLE photos (
    id INT   PRIMARY KEY,
    camera_lens_id INT,
    mountain_id INT,
    color TEXT,
    name TEXT,
    UNIQUE (id),
    FOREIGN KEY (mountain_id) REFERENCES mountain(id),
    FOREIGN KEY (camera_lens_id) REFERENCES camera_lens(id)
);