Revision 11401
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 877 | 877 |
datasource varchar(255) NOT NULL, |
| 878 | 878 |
`specimenHolderInstitutions` varchar(255), |
| 879 | 879 |
collection varchar(255), |
| 880 |
`catalogNumber` varchar(255),
|
|
| 880 |
`accessionNumber` varchar(255),
|
|
| 881 | 881 |
`occurrenceID` varchar(255), |
| 882 | 882 |
country varchar(255), |
| 883 | 883 |
`stateProvince` varchar(255), |
| ... | ... | |
| 5181 | 5181 |
-- Name: analytical_stem_datasource_specimenHolderInstitutions_colle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5182 | 5182 |
-- |
| 5183 | 5183 |
|
| 5184 |
CREATE INDEX `analytical_stem_datasource_specimenHolderInstitutions_colle_idx` ON analytical_stem (datasource, `specimenHolderInstitutions`, collection, `catalogNumber`);
|
|
| 5184 |
CREATE INDEX `analytical_stem_datasource_specimenHolderInstitutions_colle_idx` ON analytical_stem (datasource, `specimenHolderInstitutions`, collection, `accessionNumber`);
|
|
| 5185 | 5185 |
|
| 5186 | 5186 |
|
| 5187 | 5187 |
-- |
Also available in: Unified diff
fix: schemas/vegbien.sql: analytical_stem_view: renamed specimens columns to use the VegCore names, where these differ from DwC, so that the now-VegCore staging table column names are the same as the analytical_stem_view column names