Actions
Task #565
closedpartition the TaxonDetermination table by row into the different types of determinations
Start date:
02/14/2013
Due date:
% Done:
100%
Estimated time:
Activity type:
Description
- this makes it easy to horizontally join the different types of determinations for a row
- it avoids the need for special partial indexes which restrict themselves to a particular determination type
- note that this is an inheritance relationship (AcceptedTaxonDetermination is a TaxonDetermination)
- this means the subclass's pkey is an fkey to the superclass's pkey
- there should be an exclusion index that ensures each determination is a member of only one determination subclass
Actions