| 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) |
| ); |
| |
| commit; |
| |
| quit; |