Revision 5767
Added by Aaron Marcuse-Kubitza almost 12 years ago
vegbien.sql | ||
---|---|---|
1530 | 1530 |
iscultivated boolean, |
1531 | 1531 |
cultivatedbasis text, |
1532 | 1532 |
isnative boolean, |
1533 |
accessioncode text |
|
1533 |
accessioncode text, |
|
1534 |
CONSTRAINT taxonoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (locationevent_id IS NOT NULL))) |
|
1534 | 1535 |
); |
1535 | 1536 |
|
1536 | 1537 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonoccurrence: Added taxonoccurrence_required_key check constraint to ensure that all taxonoccurrences are properly identified, and empty taxonoccurrences are properly pruned. This fixes a bug where taxon-only and stem-only data did not properly prune the taxonoccurrence that would otherwise get created because it's included in the mappings.