Revision 6779
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 702 | 702 |
-- |
| 703 | 703 |
|
| 704 | 704 |
CREATE TABLE analytical_aggregate ( |
| 705 |
`institutionCode` varchar(255) NOT NULL,
|
|
| 705 |
datasource varchar(255) NOT NULL,
|
|
| 706 | 706 |
country varchar(255), |
| 707 | 707 |
`stateProvince` varchar(255), |
| 708 | 708 |
county varchar(255), |
| ... | ... | |
| 741 | 741 |
-- |
| 742 | 742 |
|
| 743 | 743 |
CREATE TABLE analytical_stem ( |
| 744 |
`institutionCode` varchar(255) NOT NULL,
|
|
| 744 |
datasource varchar(255) NOT NULL,
|
|
| 745 | 745 |
`subInstitutionCode` varchar(255), |
| 746 | 746 |
`collectionCode` varchar(255), |
| 747 | 747 |
`catalogNumber` varchar(255), |
| ... | ... | |
| 4890 | 4890 |
|
| 4891 | 4891 |
|
| 4892 | 4892 |
-- |
| 4893 |
-- Name: analytical_aggregate_institutionCode_locationName_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4893 |
-- Name: analytical_aggregate_datasource_locationName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4894 | 4894 |
-- |
| 4895 | 4895 |
|
| 4896 |
CREATE INDEX `analytical_aggregate_institutionCode_locationName_dateColle_idx` ON analytical_aggregate (`institutionCode`, `locationName`, `dateCollected`);
|
|
| 4896 |
CREATE INDEX `analytical_aggregate_datasource_locationName_dateCollected_idx` ON analytical_aggregate (datasource, `locationName`, `dateCollected`);
|
|
| 4897 | 4897 |
|
| 4898 | 4898 |
|
| 4899 | 4899 |
-- |
| 4900 |
-- Name: analytical_stem_institutionCode_occurrenceID_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4900 |
-- Name: analytical_stem_datasource_occurrenceID_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4901 | 4901 |
-- |
| 4902 | 4902 |
|
| 4903 |
CREATE INDEX `analytical_stem_institutionCode_occurrenceID_idx` ON analytical_stem (`institutionCode`, `occurrenceID`);
|
|
| 4903 |
CREATE INDEX `analytical_stem_datasource_occurrenceID_idx` ON analytical_stem (datasource, `occurrenceID`);
|
|
| 4904 | 4904 |
|
| 4905 | 4905 |
|
| 4906 | 4906 |
-- |
| 4907 |
-- Name: analytical_stem_institutionCode_projectID_locationName_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4907 |
-- Name: analytical_stem_datasource_projectID_locationName_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4908 | 4908 |
-- |
| 4909 | 4909 |
|
| 4910 |
CREATE INDEX `analytical_stem_institutionCode_projectID_locationName_date_idx` ON analytical_stem (`institutionCode`, `projectID`, `locationName`, `dateCollected`);
|
|
| 4910 |
CREATE INDEX `analytical_stem_datasource_projectID_locationName_dateColle_idx` ON analytical_stem (datasource, `projectID`, `locationName`, `dateCollected`);
|
|
| 4911 | 4911 |
|
| 4912 | 4912 |
|
| 4913 | 4913 |
-- |
| 4914 |
-- Name: analytical_stem_institutionCode_subInstitutionCode_collecti_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4914 |
-- Name: analytical_stem_datasource_subInstitutionCode_collectionCod_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4915 | 4915 |
-- |
| 4916 | 4916 |
|
| 4917 |
CREATE INDEX `analytical_stem_institutionCode_subInstitutionCode_collecti_idx` ON analytical_stem (`institutionCode`, `subInstitutionCode`, `collectionCode`, `catalogNumber`);
|
|
| 4917 |
CREATE INDEX `analytical_stem_datasource_subInstitutionCode_collectionCod_idx` ON analytical_stem (datasource, `subInstitutionCode`, `collectionCode`, `catalogNumber`);
|
|
| 4918 | 4918 |
|
| 4919 | 4919 |
|
| 4920 | 4920 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Renamed institutionCode to datasource because this is actually the top-level datasource providing the record, not the institution storing the specimen