{"body_builder": {"columns": [[0, "Body_Builder_ID", "INT", 0, null, 1], [1, "People_ID", "INT", 0, null, 0], [2, "Snatch", "REAL", 0, null, 0], [3, "Clean_Jerk", "REAL", 0, null, 0], [4, "Total", "REAL", 0, null, 0]], "primary_keys": ["Body_Builder_ID"], "foreign_keys": [[0, 0, "people", "People_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Body_Builder_ID"]]], "check_constraints": []}, "people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Height", "REAL", 0, null, 0], [3, "Weight", "REAL", 0, null, 0], [4, "Birth_Date", "TEXT", 0, null, 0], [5, "Birth_Place", "TEXT", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}}
CREATE TABLE body_builder (
    Body_Builder_ID INT   PRIMARY KEY,
    People_ID INT,
    Snatch REAL,
    Clean_Jerk REAL,
    Total REAL,
    UNIQUE (Body_Builder_ID),
    FOREIGN KEY (People_ID) REFERENCES people(People_ID)
);

CREATE TABLE people (
    People_ID INT   PRIMARY KEY,
    Name TEXT,
    Height REAL,
    Weight REAL,
    Birth_Date TEXT,
    Birth_Place TEXT,
    UNIQUE (People_ID)
);