{"College": {"columns": [[0, "cName", "varchar(20)", 1, null, 1], [1, "state", "varchar(2)", 0, null, 0], [2, "enr", "numeric(5,0)", 0, null, 0]], "primary_keys": ["cName"], "foreign_keys": [], "unique_constraints": [[[0, 0, "cName"]]], "check_constraints": []}, "Player": {"columns": [[0, "pID", "numeric(5,0)", 1, null, 1], [1, "pName", "varchar(20)", 0, null, 0], [2, "yCard", "varchar(3)", 0, null, 0], [3, "HS", "numeric(5,0)", 0, null, 0]], "primary_keys": ["pID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "pID"]]], "check_constraints": []}, "Tryout": {"columns": [[0, "pID", "numeric(5,0)", 0, null, 1], [1, "cName", "varchar(20)", 0, null, 2], [2, "pPos", "varchar(8)", 0, null, 0], [3, "decision", "varchar(3)", 0, null, 0]], "primary_keys": ["pID", "cName"], "foreign_keys": [[0, 0, "College", "cName", "cName", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "Player", "pID", "pID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "pID"], [1, 1, "cName"]]], "check_constraints": []}}
CREATE TABLE College (
    cName varchar(20) NOT NULL  PRIMARY KEY,
    state varchar(2),
    enr numeric(5,0),
    UNIQUE (cName)
);

CREATE TABLE Player (
    pID numeric(5,0) NOT NULL  PRIMARY KEY,
    pName varchar(20),
    yCard varchar(3),
    HS numeric(5,0),
    UNIQUE (pID)
);

CREATE TABLE Tryout (
    pID numeric(5,0)   PRIMARY KEY,
    cName varchar(20)   PRIMARY KEY,
    pPos varchar(8),
    decision varchar(3),
    PRIMARY KEY (pID, cName),
    UNIQUE (pID, cName),
    FOREIGN KEY (cName) REFERENCES College(cName),
    FOREIGN KEY (pID) REFERENCES Player(pID)
);