Revision 5310
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1129 | 1129 |
species text, |
| 1130 | 1130 |
description text, |
| 1131 | 1131 |
accessioncode text, |
| 1132 |
CONSTRAINT taxonconcept_required_key CHECK ((((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (family IS NOT NULL)) OR (genus IS NOT NULL)) OR ((parent_id IS NOT NULL) AND (author IS NOT NULL))))
|
|
| 1132 |
CONSTRAINT taxonconcept_required_key CHECK ((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND (author IS NOT NULL))))
|
|
| 1133 | 1133 |
); |
| 1134 | 1134 |
|
| 1135 | 1135 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: taxonconcept_required_key: Removed family and genus because these are now cached fields only, and are not used for scoping a taxonconcept. Instead, *taxonomicname and taxonname+parent_id are used for this purpose.