| 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; |