{"building": {"columns": [[0, "building_id", "TEXT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Street_address", "TEXT", 0, null, 0], [3, "Years_as_tallest", "TEXT", 0, null, 0], [4, "Height_feet", "INT", 0, null, 0], [5, "Floors", "INT", 0, null, 0]], "primary_keys": ["building_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "building_id"]]], "check_constraints": []}, "Institution": {"columns": [[0, "Institution_id", "TEXT", 0, null, 1], [1, "Institution", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Founded", "REAL", 0, null, 0], [4, "Type", "TEXT", 0, null, 0], [5, "Enrollment", "INT", 0, null, 0], [6, "Team", "TEXT", 0, null, 0], [7, "Primary_Conference", "TEXT", 0, null, 0], [8, "building_id", "TEXT", 0, null, 0]], "primary_keys": ["Institution_id"], "foreign_keys": [[0, 0, "building", "building_id", "building_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Institution_id"]]], "check_constraints": []}, "protein": {"columns": [[0, "common_name", "TEXT", 0, null, 1], [1, "protein_name", "TEXT", 0, null, 0], [2, "divergence_from_human_lineage", "REAL", 0, null, 0], [3, "accession_number", "TEXT", 0, null, 0], [4, "sequence_length", "REAL", 0, null, 0], [5, "sequence_identity_to_human_protein", "TEXT", 0, null, 0], [6, "Institution_id", "TEXT", 0, null, 0]], "primary_keys": ["common_name"], "foreign_keys": [[0, 0, "Institution", "Institution_id", "Institution_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "common_name"]]], "check_constraints": []}}
CREATE TABLE building (
    building_id TEXT   PRIMARY KEY,
    Name TEXT,
    Street_address TEXT,
    Years_as_tallest TEXT,
    Height_feet INT,
    Floors INT,
    UNIQUE (building_id)
);

CREATE TABLE Institution (
    Institution_id TEXT   PRIMARY KEY,
    Institution TEXT,
    Location TEXT,
    Founded REAL,
    Type TEXT,
    Enrollment INT,
    Team TEXT,
    Primary_Conference TEXT,
    building_id TEXT,
    UNIQUE (Institution_id),
    FOREIGN KEY (building_id) REFERENCES building(building_id)
);

CREATE TABLE protein (
    common_name TEXT   PRIMARY KEY,
    protein_name TEXT,
    divergence_from_human_lineage REAL,
    accession_number TEXT,
    sequence_length REAL,
    sequence_identity_to_human_protein TEXT,
    Institution_id TEXT,
    UNIQUE (common_name),
    FOREIGN KEY (Institution_id) REFERENCES Institution(Institution_id)
);