| DROP TABLE TEAMPLAYER ; |
| DROP TABLE PLAYER ; |
| DROP TABLE TEAM ; |
| DROP TABLE LEAGUE ; |
| |
| CREATE TABLE PLAYER |
| ( |
| player_Id VARCHAR(255) PRIMARY KEY NOT NULL, |
| name VARCHAR(255), |
| position VARCHAR(255), |
| salary DOUBLE PRECISION NOT NULL |
| ); |
| |
| CREATE TABLE LEAGUE |
| ( |
| league_Id VARCHAR(255) PRIMARY KEY NOT NULL, |
| name VARCHAR(255), |
| sport VARCHAR(255) |
| ); |
| |
| CREATE TABLE TEAM |
| ( |
| team_Id VARCHAR(255) PRIMARY KEY NOT NULL, |
| 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) NOT NULL, |
| team_Id VARCHAR(255) NOT NULL, |
| 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) |
| ); |