{"college": {"columns": [[0, "College_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Leader_Name", "TEXT", 0, null, 0], [3, "College_Location", "TEXT", 0, null, 0]], "primary_keys": ["College_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "College_ID"]]], "check_constraints": []}, "member": {"columns": [[0, "Member_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Country", "TEXT", 0, null, 0], [3, "College_ID", "INT", 0, null, 0]], "primary_keys": ["Member_ID"], "foreign_keys": [[0, 0, "college", "College_ID", "College_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Member_ID"]]], "check_constraints": []}, "round": {"columns": [[0, "Round_ID", "INT", 0, null, 2], [1, "Member_ID", "INT", 0, null, 1], [2, "Decoration_Theme", "TEXT", 0, null, 0], [3, "Rank_in_Round", "INT", 0, null, 0]], "primary_keys": ["Round_ID", "Member_ID"], "foreign_keys": [[0, 0, "member", "Member_ID", "Member_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 1, "Member_ID"], [1, 0, "Round_ID"]]], "check_constraints": []}}
CREATE TABLE college (
    College_ID INT   PRIMARY KEY,
    Name TEXT,
    Leader_Name TEXT,
    College_Location TEXT,
    UNIQUE (College_ID)
);

CREATE TABLE member (
    Member_ID INT   PRIMARY KEY,
    Name TEXT,
    Country TEXT,
    College_ID INT,
    UNIQUE (Member_ID),
    FOREIGN KEY (College_ID) REFERENCES college(College_ID)
);

CREATE TABLE round (
    Round_ID INT   PRIMARY KEY,
    Member_ID INT   PRIMARY KEY,
    Decoration_Theme TEXT,
    Rank_in_Round INT,
    PRIMARY KEY (Round_ID, Member_ID),
    UNIQUE (Member_ID, Round_ID),
    FOREIGN KEY (Member_ID) REFERENCES member(Member_ID)
);