practice
Tables (3)
BodyInfo
- player_id — PK — Foreign key → Player.player_id — NOT NULL
- height — INT
- weight — INT
Player
- player_id — PK — Primary key — NOT NULL
- team_id — PK — Foreign key → Team.team_id — NOT NULL
- number — INT
- name — VARCHAR(50)
- age — INT
- position — VARCHAR(30)
Team
- team_id — PK — Primary key — NOT NULL
- team_name — VARCHAR(50)
- home_city — VARCHAR(50)
- mascot — VARCHAR(50)
- coach_name — VARCHAR(50)