{"county": {"columns": [[0, "County_Id", "INT", 0, null, 1], [1, "County_name", "TEXT", 0, null, 0], [2, "Population", "REAL", 0, null, 0], [3, "Zip_code", "TEXT", 0, null, 0]], "primary_keys": ["County_Id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "County_Id"]]], "check_constraints": []}, "party": {"columns": [[0, "Party_ID", "INT", 0, null, 1], [1, "Year", "REAL", 0, null, 0], [2, "Party", "TEXT", 0, null, 0], [3, "Governor", "TEXT", 0, null, 0], [4, "Lieutenant_Governor", "TEXT", 0, null, 0], [5, "Comptroller", "TEXT", 0, null, 0], [6, "Attorney_General", "TEXT", 0, null, 0], [7, "US_Senate", "TEXT", 0, null, 0]], "primary_keys": ["Party_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Party_ID"]]], "check_constraints": []}, "election": {"columns": [[0, "Election_ID", "INT", 0, null, 1], [1, "Counties_Represented", "TEXT", 0, null, 0], [2, "District", "INT", 0, null, 0], [3, "Delegate", "TEXT", 0, null, 0], [4, "Party", "INT", 0, null, 0], [5, "First_Elected", "REAL", 0, null, 0], [6, "Committee", "TEXT", 0, null, 0]], "primary_keys": ["Election_ID"], "foreign_keys": [[0, 0, "county", "District", "County_Id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "party", "Party", "Party_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Election_ID"]]], "check_constraints": []}}
CREATE TABLE county (
    County_Id INT   PRIMARY KEY,
    County_name TEXT,
    Population REAL,
    Zip_code TEXT,
    UNIQUE (County_Id)
);

CREATE TABLE party (
    Party_ID INT   PRIMARY KEY,
    Year REAL,
    Party TEXT,
    Governor TEXT,
    Lieutenant_Governor TEXT,
    Comptroller TEXT,
    Attorney_General TEXT,
    US_Senate TEXT,
    UNIQUE (Party_ID)
);

CREATE TABLE election (
    Election_ID INT   PRIMARY KEY,
    Counties_Represented TEXT,
    District INT,
    Delegate TEXT,
    Party INT,
    First_Elected REAL,
    Committee TEXT,
    UNIQUE (Election_ID),
    FOREIGN KEY (District) REFERENCES county(County_Id),
    FOREIGN KEY (Party) REFERENCES party(Party_ID)
);