Table 17. Structure of the EvidenceSources table.
| Field | Type | Null | Key | Default | Extra | Foreign Key |
|---|---|---|---|---|---|---|
| Id | int(11) | NO | PRI | NULL | auto
increment |
|
| SourceId | int(11) | NO | MUL | NULL | Sources – Id | |
| EvidenceId | int(11) | NO | MUL | NULL | Evidence – Id |
| Field | Type | Null | Key | Default | Extra | Foreign Key |
|---|---|---|---|---|---|---|
| Id | int(11) | NO | PRI | NULL | auto
increment |
|
| SourceId | int(11) | NO | MUL | NULL | Sources – Id | |
| EvidenceId | int(11) | NO | MUL | NULL | Evidence – Id |