{"candidate": {"columns": [[0, "Candidate_ID", "INT", 0, null, 1], [1, "People_ID", "INT", 0, null, 0], [2, "Poll_Source", "TEXT", 0, null, 0], [3, "Date", "TEXT", 0, null, 0], [4, "Support_rate", "REAL", 0, null, 0], [5, "Consider_rate", "REAL", 0, null, 0], [6, "Oppose_rate", "REAL", 0, null, 0], [7, "Unsure_rate", "REAL", 0, null, 0]], "primary_keys": ["Candidate_ID"], "foreign_keys": [[0, 0, "people", "People_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Candidate_ID"]]], "check_constraints": []}, "people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Sex", "TEXT", 0, null, 0], [2, "Name", "TEXT", 0, null, 0], [3, "Date_of_Birth", "TEXT", 0, null, 0], [4, "Height", "REAL", 0, null, 0], [5, "Weight", "REAL", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}}
CREATE TABLE candidate (
    Candidate_ID INT   PRIMARY KEY,
    People_ID INT,
    Poll_Source TEXT,
    Date TEXT,
    Support_rate REAL,
    Consider_rate REAL,
    Oppose_rate REAL,
    Unsure_rate REAL,
    UNIQUE (Candidate_ID),
    FOREIGN KEY (People_ID) REFERENCES people(People_ID)
);

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