Revision 5200
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 864 | 864 |
variety text, |
| 865 | 865 |
forma text, |
| 866 | 866 |
cultivar text, |
| 867 |
morphospecies text, |
|
| 867 | 868 |
otherranks text, |
| 868 | 869 |
scope_id int(11), |
| 869 | 870 |
accessioncode text |
| ... | ... | |
| 1004 | 1005 |
|
| 1005 | 1006 |
|
| 1006 | 1007 |
-- |
| 1008 |
-- Name: COLUMN taxonpath.morphospecies; Type: COMMENT; Schema: public; Owner: - |
|
| 1009 |
-- |
|
| 1010 |
|
|
| 1011 |
|
|
| 1012 |
|
|
| 1013 |
|
|
| 1014 |
-- |
|
| 1007 | 1015 |
-- Name: COLUMN taxonpath.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 1008 | 1016 |
-- |
| 1009 | 1017 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1185 | 1185 |
variety text, |
| 1186 | 1186 |
forma text, |
| 1187 | 1187 |
cultivar text, |
| 1188 |
morphospecies text, |
|
| 1188 | 1189 |
otherranks rankedtaxonname[], |
| 1189 | 1190 |
scope_id integer, |
| 1190 | 1191 |
accessioncode text, |
| ... | ... | |
| 1337 | 1338 |
|
| 1338 | 1339 |
|
| 1339 | 1340 |
-- |
| 1341 |
-- Name: COLUMN taxonpath.morphospecies; Type: COMMENT; Schema: public; Owner: - |
|
| 1342 |
-- |
|
| 1343 |
|
|
| 1344 |
COMMENT ON COLUMN taxonpath.morphospecies IS 'The morphospecies portion of the taxonomic name.'; |
|
| 1345 |
|
|
| 1346 |
|
|
| 1347 |
-- |
|
| 1340 | 1348 |
-- Name: COLUMN taxonpath.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 1341 | 1349 |
-- |
| 1342 | 1350 |
|
| ... | ... | |
| 4790 | 4798 |
-- Name: taxonpath_unique_within_datasource_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4791 | 4799 |
-- |
| 4792 | 4800 |
|
| 4793 |
CREATE UNIQUE INDEX taxonpath_unique_within_datasource_by_name ON taxonpath USING btree (datasource_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(otherranks, ARRAY[]::rankedtaxonname[])), (COALESCE(scope_id, 2147483647))) WHERE (identifyingtaxonomicname IS NULL);
|
|
| 4801 |
CREATE UNIQUE INDEX taxonpath_unique_within_datasource_by_name ON taxonpath USING btree (datasource_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(morphospecies, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedtaxonname[])), (COALESCE(scope_id, 2147483647))) WHERE (identifyingtaxonomicname IS NULL);
|
|
| 4794 | 4802 |
|
| 4795 | 4803 |
|
| 4796 | 4804 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonpath: Added morphospecies