| DROP TABLE TeamPlayer ; | |
| DROP TABLE Player ; | |
| DROP TABLE Team ; | |
| DROP TABLE League ; | |
| commit; | |
| CREATE TABLE Player | |
| ( | |
| player_Id VARCHAR(255) PRIMARY KEY, | |
| name VARCHAR(255), | |
| position VARCHAR(255), | |
| salary DOUBLE PRECISION NOT NULL | |
| ); | |
| commit; | |
| CREATE TABLE League | |
| ( | |
| league_Id VARCHAR(255) PRIMARY KEY, | |
| name VARCHAR(255), | |
| sport VARCHAR(255) | |
| ); | |
| commit; | |
| CREATE TABLE Team | |
| ( | |
| team_Id VARCHAR(255) PRIMARY KEY, | |
| city VARCHAR(255), | |
| name VARCHAR(255), | |
| league_Id VARCHAR(255), | |
| CONSTRAINT FK_1 FOREIGN KEY (league_Id) REFERENCES League (league_Id) | |
| ); | |
| commit; | |
| CREATE TABLE TeamPlayer | |
| ( | |
| player_Id VARCHAR(255), | |
| team_Id VARCHAR(255), | |
| CONSTRAINT FK_2 FOREIGN KEY (team_Id) REFERENCES Team (team_Id), | |
| CONSTRAINT FK_3 FOREIGN KEY (player_Id) REFERENCES Player (player_Id) | |
| ); | |
| commit; | |
| quit; |