|
|
|
|
|
by michae2
799 days ago
|
|
> If that is a team level, it should be in the team table, not the player table. It's all contrived, of course, but the reason I would consider skill level to be a player attribute rather than a team attribute is that there could be free agents with a skill level but no team: INSERT INTO player VALUES (10, 'Pavlo', 'AAA', NULL); Then with enough free agents, you could imagine building a new team out of free agents that are all at the same skill level: UPDATE player SET team = 'Otters' WHERE level = 'AAA' AND team IS NULL ORDER BY id LIMIT 3; |
|