{"election": {"columns": [[0, "Election_ID", "INT", 0, null, 1], [1, "Representative_ID", "INT", 0, null, 0], [2, "Date", "TEXT", 0, null, 0], [3, "Votes", "REAL", 0, null, 0], [4, "Vote_Percent", "REAL", 0, null, 0], [5, "Seats", "REAL", 0, null, 0], [6, "Place", "REAL", 0, null, 0]], "primary_keys": ["Election_ID"], "foreign_keys": [[0, 0, "representative", "Representative_ID", "Representative_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Election_ID"]]], "check_constraints": []}, "representative": {"columns": [[0, "Representative_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "State", "TEXT", 0, null, 0], [3, "Party", "TEXT", 0, null, 0], [4, "Lifespan", "TEXT", 0, null, 0]], "primary_keys": ["Representative_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Representative_ID"]]], "check_constraints": []}}
CREATE TABLE election (
    Election_ID INT   PRIMARY KEY,
    Representative_ID INT,
    Date TEXT,
    Votes REAL,
    Vote_Percent REAL,
    Seats REAL,
    Place REAL,
    UNIQUE (Election_ID),
    FOREIGN KEY (Representative_ID) REFERENCES representative(Representative_ID)
);

CREATE TABLE representative (
    Representative_ID INT   PRIMARY KEY,
    Name TEXT,
    State TEXT,
    Party TEXT,
    Lifespan TEXT,
    UNIQUE (Representative_ID)
);