Different "versions" of the same organism (e.g. hg38/t2t) can have chromosomes with same names/accession numbers. This change pulls the DDL from the Postgres server that is currently live, where Henri has already made this minor change.
This is not an ideal change since the absolutely "correct" thing to do here would be to have a unique constraint on (organism, name) and another unique constraint on (organism, accession). The current change leaves open the possibility of having two identical accession numbers for an organism with different "names", which doesn't make sense. However, this change is already deployed and "good enough" for practical purposes, so let's not change it.
Different "versions" of the same organism (e.g.
hg38/t2t) can have chromosomes with same names/accession numbers. This change pulls the DDL from the Postgres server that is currently live, where Henri has already made this minor change.This is not an ideal change since the absolutely "correct" thing to do here would be to have a unique constraint on (organism, name) and another unique constraint on (organism, accession). The current change leaves open the possibility of having two identical accession numbers for an organism with different "names", which doesn't make sense. However, this change is already deployed and "good enough" for practical purposes, so let's not change it.