Revision 3177
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2110 | 2110 |
collectioncode_dwc text, |
| 2111 | 2111 |
catalognumber_dwc text, |
| 2112 | 2112 |
collectiondate timestamp NULL, |
| 2113 |
museum_id int(11),
|
|
| 2113 |
institution_id int(11),
|
|
| 2114 | 2114 |
sourceaccessioncode text, |
| 2115 | 2115 |
taxonoccurrence_id int(11) NOT NULL, |
| 2116 | 2116 |
collectionnumber text, |
| ... | ... | |
| 2135 | 2135 |
|
| 2136 | 2136 |
|
| 2137 | 2137 |
-- |
| 2138 |
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: - |
|
| 2139 |
-- |
|
| 2140 |
|
|
| 2141 |
|
|
| 2142 |
|
|
| 2143 |
|
|
| 2144 |
-- |
|
| 2138 | 2145 |
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: - |
| 2139 | 2146 |
-- |
| 2140 | 2147 |
|
| ... | ... | |
| 4057 | 4064 |
|
| 4058 | 4065 |
|
| 4059 | 4066 |
-- |
| 4060 |
-- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4067 |
-- Name: fki_specimenreplicate_institution_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4061 | 4068 |
-- |
| 4062 | 4069 |
|
| 4063 |
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate (museum_id);
|
|
| 4070 |
CREATE INDEX fki_specimenreplicate_institution_id ON specimenreplicate (institution_id);
|
|
| 4064 | 4071 |
|
| 4065 | 4072 |
|
| 4066 | 4073 |
-- |
| ... | ... | |
| 5590 | 5597 |
|
| 5591 | 5598 |
|
| 5592 | 5599 |
-- |
| 5593 |
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5600 |
-- Name: specimenreplicate_institution_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5594 | 5601 |
-- |
| 5595 | 5602 |
|
| 5596 | 5603 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Renamed museum_id to institution_id to correspond with DwC's institutionCode, so that it would be more obvious where to map institutionCode fields to