Table 16. Structure of the Evidence table.
| Field | Type | Null | Key | Default | Extra | Foreign Key |
|---|---|---|---|---|---|---|
| Id | int(11) | NO | PRI | NULL | auto
increment |
|
| TypeId | int(11) | NO | MUL | NULL | EvidenceTypes – Id | |
| GameId | int(11) | NO | MUL | NULL | Games – Id | |
| RulesetId | int(11) | YES | MUL | NULL | GameRulesets – Id | |
| DateStart | date | YES | NULL | |||
| DateStartBC | tinyint(1) | YES | 0 | |||
| DateEnd | date | YES | NULL | |||
| DateEndBC | tinyint(1) | YES | 0 | |||
| Location | text | YES | NULL | |||
| KML | varchar(45) | YES | NULL | |||
| Rules | text | YES | NULL | |||
| Misc | text | YES | NULL | |||
| ConfidenceMultiplier | int(11) | NO | 100 | |||
| Username | varchar(45) | NO | Walter.Crist | |||
| Verified | tinyint(1) | NO | 1 | |||
| DateAdded | timestamp | YES | CURRENT TIMESTAMP | |||
| ExternalDB | int(11) | YES | MUL | NULL | ExternalDB – Id | |
| ExternalDBId | int(11) | YES | NULL |