mysql> desc teams;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| team_id    | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| team_value | varchar(255)     | NO   |     |         |                |
| school_id  | int(11) unsigned | NO   | MUL |         |                |
| sport_id   | int(11) unsigned | NO   | MUL |         |                |
+------------+------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> desc element_fixture;
+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| fixture_id   | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| publish_name | varchar(255)     | NO   |     |         |                |
| element_uid  | int(11)          | NO   |     |         |                |
| element_gid  | int(11)          | NO   |     |         |                |
| team         | int(11) unsigned | YES  |     | NULL    |                |
| school       | int(11) unsigned | YES  |     | NULL    |                |
| userDate     | datetime         | YES  |     | NULL    |                |
| for          | int(11) unsigned | YES  |     | NULL    |                |
| against      | int(11) unsigned | YES  |     | NULL    |                |
| home         | tinyint(1)       | YES  |     | NULL    |                |
| opponents    | varchar(255)     | YES  | MUL | NULL    |                |
+--------------+------------------+------+-----+---------+----------------+
11 rows in set (0.01 sec)