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
Updated by Aaron Marcuse-Kubitza about 11 years ago
- % Done changed from 0 to 100
- Status changed from New to Resolved
See TNRS.AcceptedTaxon, MatchedTaxon, ScrubbedTaxon
Updated by Aaron Marcuse-Kubitza about 11 years ago
- Subject changed from vertically partition the TaxonDetermination table into the different types of determinations to partition the TaxonDetermination table by row into the different types of determinations
changed vertical/horizontal to row/column for clarity
Actions