Draft: Deduplicated AccessionRefs
We use SubsetAccessionRef
and DatasetAccessionRef
to store references to accessions. Each reference may point to an actual Accession
in Genesys, or has a null
reference. Each subset and dataset has its own copy of accession references, meaning that when referring to the same accession (for example inst=NGA039, acce=TMp-419, genu=Manihot, spec=esculenta, doi=...
) we have multiple entries every time the same combination of instituteCode
, accessionNumer
, genus
, ... is referenced.
In this issue we extract AccessionReference
to a new entity with @Table("accession_ref")
. Each reference can appear only once in this table. Instead of using null
, we will use a blank string ""
to enable unique constraint checks in MariaDB.