| Table Name | Uses Of Table |
| Games | |
| S No | Field Name | Data Type | Length | Key | Require | Default Value | Description |
| 1) | GameID | int | 4 | | | | |
| 2) | TeamAID | int | 4 | | | | |
| 3) | TeamAScore | int | 4 | | | | |
| 4) | TeamBID | int | 4 | | | | |
| 5) | TeamBScore | int | 4 | | | | |
| 6) | Date | datetime | 16 | | | | |
| 7) | Time | datetime | 16 | | | | |
| 8) | Duration | varchar | 50 | | | | |
| 9) | AreaID | int | 4 | | | | |
| 10) | LeagueID | int | 4 | | | | |
| 11) | LeagueID2 | int | 4 | | | | |
| 12) | Completed | int | 4 | | | | |
| 13) | NeedReSch | int | 4 | | | | |
| 14) | DivID | int | 4 | | | | |
| 15) | DivID2 | int | 4 | | | | |
| 16) | GameType | int | 4 | | | | |
| 17) | ScoreEnteredBy | varchar | 50 | | | | |
| 18) | ScoreEnteredAdmin | varchar | 50 | | | | |
| 19) | ScoreEnteredLM | varchar | 50 | | | | |
| 20) | ScoreEnteredT | varchar | 50 | | | | |
| 21) | ScoreEnteredTM | varchar | 50 | | | | |
| 22) | ScoreEnteredDate | varchar | 50 | | | | |
| 23) | ScoreEnteredTime | varchar | 50 | | | | |
| 24) | BackupScoreA | varchar | 50 | | | | |
| 25) | BackupScoreB | varchar | 50 | | | | |
| 26) | BackupScoreEnteredT | varchar | 50 | | | | |
| 27) | BackupScoreEnteredTM | varchar | 50 | | | | |
| 28) | BackupScoreEnteredDate | varchar | 50 | | | | |
| 29) | BackupScoreEnteredTime | varchar | 50 | | | | |
| 30) | EmailedTM1 | varchar | 50 | | | | |
| 31) | EmailedTM2 | varchar | 50 | | | | |
| 32) | EmailedLM | varchar | 50 | | | | |
| 33) | EmailedAdmin | varchar | 50 | | | | |
| 34) | GameSummary | varchar | 4000 | | | | |
| 35) | GameName | varchar | 50 | | | | |
| 36) | GameDescription | varchar | 2000 | | | | |
| 37) | T1GameID | int | 4 | | | | |
| 38) | T1GameWL | varchar | 50 | | | | |
| 39) | T2GameID | int | 4 | | | | |
| 40) | T2GameWL | varchar | 50 | | | | |
| 41) | GameCreated | datetime | 16 | | | | |
| 42) | GameEdited | datetime | 16 | | | | |
| 43) | AutoSchBatchID | int | 4 | | | | |
| 44) | GroupSchID | int | 4 | | | | |
| 45) | AltGameID | varchar | 15 | | | | |
| 46) | NF1 | varchar | 50 | | | | |
| 47) | NF2 | int | 4 | | | | |
| 48) | NF3 | varchar | 50 | | | | |
| 49) | Status | varchar | 50 | | | | |
| 50) | TeamaName | varchar | 100 | | | | |
| 51) | TeamBName | varchar | 100 | | | | |
| 52) | TeamADivName | varchar | 100 | | | | |
| 53) | TeamBDivName | varchar | 100 | | | | |
| 54) | OrgID | int | 4 | | | | |
| 55) | OrgID2 | int | 4 | | | | |