I am working on a NGS database and I found a problem to create the table for coverage data. Each row is a contains an interval of the entire exome sequenced. In some cases, there are multiple transcripts per interval. For this reason, I created an extra table to collect all the NMs ids.
The problem I found is related to the exons because in most cases there is more than one exon and they are separated by commas, for example: "1, 2, 3". As the exons are represented as numbers, creating an extra table is a nonsense and using ENUM is not an option. I think the best solution is consider the field as text but, is it correct?