Table 3. Structure of the GameCategories table.
| Field | Type | Null | Key | Default | Extra | Foreign Key |
|---|---|---|---|---|---|---|
| Id | int(11) | NO | PRI | NULL | auto increment | |
| GameId | int(11) | NO | MUL | NULL | Games – Id | |
| CategoryId | int(11) | NO | MUL | NULL | Categories – Id |
| Field | Type | Null | Key | Default | Extra | Foreign Key |
|---|---|---|---|---|---|---|
| Id | int(11) | NO | PRI | NULL | auto increment | |
| GameId | int(11) | NO | MUL | NULL | Games – Id | |
| CategoryId | int(11) | NO | MUL | NULL | Categories – Id |