Table 5. Structure of the GamePeriods 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 | |
PeriodId | int(11) | NO | MUL | NULL | Periods – 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 | |
PeriodId | int(11) | NO | MUL | NULL | Periods – Id |