Revision 7011
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 732 | 732 |
`coordinateUncertaintyInMeters` double precision, |
| 733 | 733 |
geovalid int(11), |
| 734 | 734 |
`isNewWorld` int(11), |
| 735 |
`locationName` varchar(255) NOT NULL,
|
|
| 735 |
`locationID` varchar(255) NOT NULL,
|
|
| 736 | 736 |
`elevationInMeters` double precision, |
| 737 | 737 |
`plotArea_ha` double precision, |
| 738 | 738 |
`samplingProtocol` varchar(255), |
| ... | ... | |
| 776 | 776 |
geovalid int(11), |
| 777 | 777 |
`isNewWorld` int(11), |
| 778 | 778 |
`projectID` varchar(255), |
| 779 |
`locationName` varchar(255) NOT NULL,
|
|
| 779 |
`locationID` varchar(255) NOT NULL,
|
|
| 780 | 780 |
`elevationInMeters` double precision, |
| 781 | 781 |
`plotArea_ha` double precision, |
| 782 | 782 |
`samplingProtocol` varchar(255), |
| ... | ... | |
| 4995 | 4995 |
|
| 4996 | 4996 |
|
| 4997 | 4997 |
-- |
| 4998 |
-- Name: analytical_aggregate_datasource_locationName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4998 |
-- Name: analytical_aggregate_datasource_locationID_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4999 | 4999 |
-- |
| 5000 | 5000 |
|
| 5001 |
CREATE INDEX `analytical_aggregate_datasource_locationName_dateCollected_idx` ON analytical_aggregate (datasource, `locationName`, `dateCollected`);
|
|
| 5001 |
CREATE INDEX `analytical_aggregate_datasource_locationID_dateCollected_idx` ON analytical_aggregate (datasource, `locationID`, `dateCollected`);
|
|
| 5002 | 5002 |
|
| 5003 | 5003 |
|
| 5004 | 5004 |
-- |
| ... | ... | |
| 5016 | 5016 |
|
| 5017 | 5017 |
|
| 5018 | 5018 |
-- |
| 5019 |
-- Name: analytical_stem_datasource_projectID_locationName_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5019 |
-- Name: analytical_stem_datasource_projectID_locationID_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5020 | 5020 |
-- |
| 5021 | 5021 |
|
| 5022 |
CREATE INDEX `analytical_stem_datasource_projectID_locationName_dateColle_idx` ON analytical_stem (datasource, `projectID`, `locationName`, `dateCollected`);
|
|
| 5022 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_dateColle_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `dateCollected`);
|
|
| 5023 | 5023 |
|
| 5024 | 5024 |
|
| 5025 | 5025 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Renamed locationName to locationID because it's now globally unique (within the datasource) and can be used as a sourceaccessioncode