Revision 5262
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 1116 | 1116 |
creator_id integer NOT NULL, |
| 1117 | 1117 |
identifyingtaxonomicname text, |
| 1118 | 1118 |
canon_taxonconcept_id integer, |
| 1119 |
taxonname text, |
|
| 1119 | 1120 |
rank taxonrank, |
| 1120 | 1121 |
verbatimrank text, |
| 1121 | 1122 |
taxon_id integer, |
| ... | ... | |
| 1134 | 1135 |
variety text, |
| 1135 | 1136 |
forma text, |
| 1136 | 1137 |
cultivar text, |
| 1137 |
morphospecies text, |
|
| 1138 | 1138 |
otherranks rankedtaxonname[], |
| 1139 | 1139 |
accessioncode text, |
| 1140 | 1140 |
CONSTRAINT taxonconcept_required_key CHECK (((((((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 (otherranks IS NOT NULL))) |
| ... | ... | |
| 1176 | 1176 |
|
| 1177 | 1177 |
|
| 1178 | 1178 |
-- |
| 1179 |
-- Name: COLUMN taxonconcept.taxonname; Type: COMMENT; Schema: public; Owner: - |
|
| 1180 |
-- |
|
| 1181 |
|
|
| 1182 |
COMMENT ON COLUMN taxonconcept.taxonname IS 'The lowest-rank portion of the taxonomic name. |
|
| 1183 |
|
|
| 1184 |
The morphospecies suffix goes in this field.'; |
|
| 1185 |
|
|
| 1186 |
|
|
| 1187 |
-- |
|
| 1179 | 1188 |
-- Name: COLUMN taxonconcept.taxon_id; Type: COMMENT; Schema: public; Owner: - |
| 1180 | 1189 |
-- |
| 1181 | 1190 |
|
| ... | ... | |
| 1295 | 1304 |
|
| 1296 | 1305 |
|
| 1297 | 1306 |
-- |
| 1298 |
-- Name: COLUMN taxonconcept.morphospecies; Type: COMMENT; Schema: public; Owner: - |
|
| 1299 |
-- |
|
| 1300 |
|
|
| 1301 |
COMMENT ON COLUMN taxonconcept.morphospecies IS 'The morphospecies portion of the taxonomic name.'; |
|
| 1302 |
|
|
| 1303 |
|
|
| 1304 |
-- |
|
| 1305 | 1307 |
-- Name: COLUMN taxonconcept.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 1306 | 1308 |
-- |
| 1307 | 1309 |
|
| ... | ... | |
| 4738 | 4740 |
-- Name: taxonconcept_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4739 | 4741 |
-- |
| 4740 | 4742 |
|
| 4741 |
CREATE UNIQUE INDEX taxonconcept_unique_within_creator_by_name ON taxonconcept USING btree (creator_id, (COALESCE(creator_id, 2147483647)), (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(morphospecies, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedtaxonname[]))) WHERE (identifyingtaxonomicname IS NULL);
|
|
| 4743 |
CREATE UNIQUE INDEX taxonconcept_unique_within_creator_by_name ON taxonconcept USING btree (creator_id, (COALESCE(creator_id, 2147483647)), (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);
|
|
| 4742 | 4744 |
|
| 4743 | 4745 |
|
| 4744 | 4746 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Renamed morphospecies to taxonname since it's used in the same way as taxon.taxonname: to store the lowest-rank portion of the taxonomic name, such as the morphospecies suffix