Revision 5134
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 838 | 838 |
|
| 839 | 839 |
CREATE TABLE taxonpath ( |
| 840 | 840 |
taxonpath_id int(11) NOT NULL, |
| 841 |
datasource_id int(11) NOT NULL, |
|
| 842 |
plantcode text, |
|
| 841 | 843 |
canon_taxonpath_id int(11), |
| 842 | 844 |
taxon_id int(11), |
| 843 | 845 |
taxonomicname text, |
| ... | ... | |
| 869 | 871 |
|
| 870 | 872 |
|
| 871 | 873 |
-- |
| 874 |
-- Name: COLUMN taxonpath.plantcode; Type: COMMENT; Schema: public; Owner: - |
|
| 875 |
-- |
|
| 876 |
|
|
| 877 |
|
|
| 878 |
|
|
| 879 |
|
|
| 880 |
-- |
|
| 872 | 881 |
-- Name: COLUMN taxonpath.canon_taxonpath_id; Type: COMMENT; Schema: public; Owner: - |
| 873 | 882 |
-- |
| 874 | 883 |
|
| ... | ... | |
| 4131 | 4140 |
|
| 4132 | 4141 |
|
| 4133 | 4142 |
-- |
| 4134 |
-- Name: taxonpath_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4143 |
-- Name: taxonpath_unique_within_datasource_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4135 | 4144 |
-- |
| 4136 | 4145 |
|
| 4137 |
CREATE UNIQUE INDEX taxonpath_unique ON taxonpath (taxonomicnamewithauthor); |
|
| 4138 | 4146 |
|
| 4139 | 4147 |
|
| 4148 |
|
|
| 4140 | 4149 |
-- |
| 4150 |
-- Name: taxonpath_unique_within_datasource_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4151 |
-- |
|
| 4152 |
|
|
| 4153 |
|
|
| 4154 |
|
|
| 4155 |
|
|
| 4156 |
-- |
|
| 4141 | 4157 |
-- Name: taxonscope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4142 | 4158 |
-- |
| 4143 | 4159 |
|
| ... | ... | |
| 5098 | 5114 |
|
| 5099 | 5115 |
|
| 5100 | 5116 |
-- |
| 5117 |
-- Name: taxonpath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5118 |
-- |
|
| 5119 |
|
|
| 5120 |
|
|
| 5121 |
|
|
| 5122 |
|
|
| 5123 |
-- |
|
| 5101 | 5124 |
-- Name: taxonpath_scope_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5102 | 5125 |
-- |
| 5103 | 5126 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonpath: Added back datasource_id, plantcode to make taxonpath datasource-specific again. This way, the original name components can still be stored in taxonpath, in addition to storing the concatenated name in a datasource-general taxonpath for use by TNRS.