CREATE TABLE Gamelog (
id INTEGER PRIMARY KEY,
game_number INTEGER,
home_team_id INTEGER,
away_team_id INTEGER
);
CREATE TABLE Teams (
id INTEGER PRIMARY KEY,
name TEXT
);
CREATE TABLE Goals (
id INTEGER PRIMARY KEY,
game_number_id INTEGER,
team_id_goal INTEGER
);
INSERT INTO Gamelog (id, game_number, home_team_id, away_team_id)
VALUES (1, 1, 1, 2),
(2, 2, 3, 4);
INSERT INTO Teams (id, name)
VALUES (1, 'MTL'),
(2, 'BOS'),
(3, 'CGY'),
(4, 'EDM');
INSERT INTO Goals (id, game_number_id, team_id_goal)
VALUES (1, 1, 2),
(2, 1, 2),
(3, 1, 1),
(4, 2, 4),
(5, 2, 4);