mysql> desc club; 
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name       | varchar(128)     | NO   |     |         |                |
| short_name | varchar(128)     | NO   |     |         |                |
| groundId   | int(10) unsigned | NO   | MUL |         |                |
| leagueId   | tinyint(4)       | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

mysql> desc fixture;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| homeId   | int(10) unsigned | YES  | MUL | NULL    |                |
| awayId   | int(10) unsigned | YES  | MUL | NULL    |                |
| groundId | int(10) unsigned | YES  | MUL | NULL    |                |
| date     | date             | NO   |     |         |                |
| time     | time             | NO   |     |         |                |
+----------+------------------+------+-----+---------+----------------+
6 rows in set (0.01 sec)