Revision 5270
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 1137 | 1137 |
variety text, |
| 1138 | 1138 |
forma text, |
| 1139 | 1139 |
cultivar text, |
| 1140 |
otherranks rankedtaxonname[], |
|
| 1141 | 1140 |
accessioncode text, |
| 1142 |
CONSTRAINT taxonconcept_required_key CHECK ((((((((identifyingtaxonomicname IS NOT NULL) OR (taxonname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (family IS NOT NULL)) OR (genus IS NOT NULL)) OR (otherranks IS NOT NULL)))
|
|
| 1141 |
CONSTRAINT taxonconcept_required_key CHECK (((((((identifyingtaxonomicname IS NOT NULL) OR (taxonname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (family IS NOT NULL)) OR (genus IS NOT NULL)))
|
|
| 1143 | 1142 |
); |
| 1144 | 1143 |
|
| 1145 | 1144 |
|
| ... | ... | |
| 1149 | 1148 |
|
| 1150 | 1149 |
COMMENT ON TABLE taxonconcept IS 'A taxon concept defined by an entity. Can be either verbatim or accepted. For accepted names, also points to the identified taxon in the tree of life. |
| 1151 | 1150 |
|
| 1152 |
To include a taxon name at a rank with no explicit column, add it to the otherranks array.
|
|
| 1151 |
To include a taxon name at a rank with no explicit column, create a parent taxonconcept for it and point to it using parent_id. To include multiple such names, chain the taxonconcepts together using parent_id. Note that lower-level taxa should point to higher-level taxa.
|
|
| 1153 | 1152 |
|
| 1154 | 1153 |
Equivalent to VegBank''s plantConcept table.'; |
| 1155 | 1154 |
|
| ... | ... | |
| 1313 | 1312 |
|
| 1314 | 1313 |
|
| 1315 | 1314 |
-- |
| 1316 |
-- Name: COLUMN taxonconcept.otherranks; Type: COMMENT; Schema: public; Owner: - |
|
| 1317 |
-- |
|
| 1318 |
|
|
| 1319 |
COMMENT ON COLUMN taxonconcept.otherranks IS 'Additional ranks which do not have a named column. Put ranks in path order, so that lower-level taxa come after higher-level taxa.'; |
|
| 1320 |
|
|
| 1321 |
|
|
| 1322 |
-- |
|
| 1323 | 1315 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1324 | 1316 |
-- |
| 1325 | 1317 |
|
| ... | ... | |
| 4749 | 4741 |
-- Name: taxonconcept_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4750 | 4742 |
-- |
| 4751 | 4743 |
|
| 4752 |
CREATE UNIQUE INDEX taxonconcept_unique_within_creator_by_name ON taxonconcept USING btree (creator_id, (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(domain, '\\N'::text)), (COALESCE(kingdom, '\\N'::text)), (COALESCE(phylum, '\\N'::text)), (COALESCE(class, '\\N'::text)), (COALESCE("order", '\\N'::text)), (COALESCE(family, '\\N'::text)), (COALESCE(genus, '\\N'::text)), (COALESCE(species, '\\N'::text)), (COALESCE(subspecies, '\\N'::text)), (COALESCE(variety, '\\N'::text)), (COALESCE(forma, '\\N'::text)), (COALESCE(cultivar, '\\N'::text)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedtaxonname[]))) WHERE (identifyingtaxonomicname IS NULL);
|
|
| 4744 |
CREATE UNIQUE INDEX taxonconcept_unique_within_creator_by_name ON taxonconcept USING btree (creator_id, (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(domain, '\\N'::text)), (COALESCE(kingdom, '\\N'::text)), (COALESCE(phylum, '\\N'::text)), (COALESCE(class, '\\N'::text)), (COALESCE("order", '\\N'::text)), (COALESCE(family, '\\N'::text)), (COALESCE(genus, '\\N'::text)), (COALESCE(species, '\\N'::text)), (COALESCE(subspecies, '\\N'::text)), (COALESCE(variety, '\\N'::text)), (COALESCE(forma, '\\N'::text)), (COALESCE(cultivar, '\\N'::text)), (COALESCE(taxonname, '\\N'::text))) WHERE (identifyingtaxonomicname IS NULL);
|
|
| 4753 | 4745 |
|
| 4754 | 4746 |
|
| 4755 | 4747 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Changed instructions for including a taxon name at a rank with no explicit column to create a parent taxonconcept for it and point to it using parent_id instead of using otherranks. Removed no longer used otherranks field.