| drop table TEAMPLAYER |
| drop table PLAYER |
| drop table TEAM |
| drop TABLE LEAGUE |
| go |
| |
| 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) |
| ) |
| |
| go |