mysql> desc bball_players;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(6)      |      | PRI | NULL    | auto_increment |
| name        | varchar(25) | YES  |     | NULL    |                |
| position_id | int(6)      | YES  |     | NULL    |                |
| team_id     | int(6)      | YES  |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+

mysql> desc bball_positions;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(6)      |      | PRI | NULL    | auto_increment |
| position | varchar(25) | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)


mysql> desc bball_teams;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(6)      |      | PRI | NULL    | auto_increment |
| team  | varchar(25) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)