id | name |
---|---|
1 | Canada |
2 | USA |
3 | Australia |
id | type_name |
---|---|
1 | Baseball Team |
2 | Basketball Team |
3 | Football Team |
4 | Tennis Team |
5 | Hockey Team |
id | team_name |
---|---|
1 | Toronto Blue Jays |
2 | Los Angeles Lakers |
3 | Melbourne Stars |
4 | New York Knicks |
5 | Adelaide Strikers |
country_id | sport_type_id | team_id |
---|---|---|
(→ Countries.id) | (→ SportsTypes.id) | (→ Teams.id) |
1 | 2 | 3 |
1 | 3 | 4 |
2 | 3 | 5 |
3 | 2 | 6 |
3 | 1 | 7 |