I don't think this table is really needed after all... but this requires significant refactoring.
A clear and concise description of todo items.
Association is in relation with Data, not Dataset. In Association, a dataset_id may appear more than once for a different selection_id. This is used in many places, but this is clumsy. This makes things also complex to retrieve taxa_id for a dataset. I think Dataset should contain taxa_id, even if this is redundant. Data should have directly dataset_id, and selection_id, replacing association_id.
Aims/objectives.
I don't think this table is really needed after all... but this requires significant refactoring.
A clear and concise description of todo items.
Association
is in relation withData
, notDataset
. InAssociation
, adataset_id
may appear more than once for a differentselection_id
. This is used in many places, but this is clumsy. This makes things also complex to retrievetaxa_id
for a dataset. I thinkDataset
should containtaxa_id
, even if this is redundant.Data
should have directlydataset_id
, andselection_id
, replacingassociation_id
.