{"gymnast": {"columns": [[0, "Gymnast_ID", "INT", 0, null, 1], [1, "Floor_Exercise_Points", "REAL", 0, null, 0], [2, "Pommel_Horse_Points", "REAL", 0, null, 0], [3, "Rings_Points", "REAL", 0, null, 0], [4, "Vault_Points", "REAL", 0, null, 0], [5, "Parallel_Bars_Points", "REAL", 0, null, 0], [6, "Horizontal_Bar_Points", "REAL", 0, null, 0], [7, "Total_Points", "REAL", 0, null, 0]], "primary_keys": ["Gymnast_ID"], "foreign_keys": [[0, 0, "people", "Gymnast_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Gymnast_ID"]]], "check_constraints": []}, "people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Age", "REAL", 0, null, 0], [3, "Height", "REAL", 0, null, 0], [4, "Hometown", "TEXT", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}}
CREATE TABLE gymnast (
    Gymnast_ID INT   PRIMARY KEY,
    Floor_Exercise_Points REAL,
    Pommel_Horse_Points REAL,
    Rings_Points REAL,
    Vault_Points REAL,
    Parallel_Bars_Points REAL,
    Horizontal_Bar_Points REAL,
    Total_Points REAL,
    UNIQUE (Gymnast_ID),
    FOREIGN KEY (Gymnast_ID) REFERENCES people(People_ID)
);

CREATE TABLE people (
    People_ID INT   PRIMARY KEY,
    Name TEXT,
    Age REAL,
    Height REAL,
    Hometown TEXT,
    UNIQUE (People_ID)
);