DROP TABLE TeamPlayer;
DROP TABLE Player;
DROP TABLE Team;
DROP TABLE League;

CREATE TABLE Player
(
        player_Id VARCHAR(255) PRIMARY KEY,
        name VARCHAR(255) ,
        position VARCHAR(255) ,
        salary DOUBLE PRECISION NOT NULL
);

CREATE TABLE League
(
        league_Id VARCHAR(255) PRIMARY KEY,
        name VARCHAR(255) ,
        sport VARCHAR(255)
);

CREATE TABLE Team
(
        team_Id VARCHAR(255) PRIMARY KEY,
        city VARCHAR(255) ,
        name VARCHAR(255) ,
        league_Id VARCHAR(255) ,
        FOREIGN KEY (league_Id)   REFERENCES League (league_Id)
);

CREATE TABLE TeamPlayer
(
        player_Id VARCHAR(255) ,
        team_Id VARCHAR(255),
        CONSTRAINT pk_TeamPlayer PRIMARY KEY (player_Id , team_Id) ,
        FOREIGN KEY (team_Id)   REFERENCES Team (team_Id),
        FOREIGN KEY (player_Id)   REFERENCES Player (player_Id)
);