SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Teams ( team_id INT PRIMARY KEY AUTO_INCREMENT, team_name VARCHAR(100) NOT NULL, city VARCHAR(100) NOT NULL, established_year YEAR NOT NULL ); CREATE TABLE Players ( player_id INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, position VARCHAR(20) NOT NULL, team_id INT, FOREIGN KEY (team_id) REFERENCES Teams(team_id) ); CREATE TABLE Games ( game_id INT PRIMARY KEY AUTO_INCREMENT, date DATE NOT NULL, home_team_id INT, away_team_id INT, home_team_score INT, away_team_score INT, FOREIGN KEY (home_team_id) REFERENCES Teams(team_id), FOREIGN KEY (away_team_id) REFERENCES Teams(team_id) ); CREATE TABLE Statistics ( stat_id INT PRIMARY KEY AUTO_INCREMENT, game_id INT, player_id INT, points INT, rebounds INT, assists INT, FOREIGN KEY (game_id) REFERENCES Games(game_id), FOREIGN KEY (player_id) REFERENCES Players(player_id) );