This was missed off the first implementation of the table. It has resulted
in silly long query times because MySQL was forced into performing full
table scans to find evidence related to the transcript. Adding an index
in should fix this.