Table 8. Structure of the GameRulesets 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 | |
| Name | varchar(45) | NO | Default | |||
| NativeName | varchar(45) | YES | NULL | |||
| Summary | text | YES | NULL | |||
| Type | int(11) | NO | MUL | 1 | EvidenceTypes – Id | |
| Description | text | YES | NULL | |||
| Rules | text | YES | NULL | |||
| Reference | text | YES | NULL | |||
| Origin | text | YES | NULL | |||
| Author | varchar(45) | YES | NULL | |||
| Publisher | varchar(45) | YES | NULL | |||
| Date | date | YES | NULL | |||
| OriginPoint | varchar(45) | YES | NULL | |||
| EvidenceRange | varchar(45) | YES | NULL | |||
| SelfContained | tintint(1) | YES | NULL |