Revision 4734
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 414 | 414 |
CREATE TABLE locationplace ( |
| 415 | 415 |
locationplace_id int(11) NOT NULL, |
| 416 | 416 |
location_id int(11) NOT NULL, |
| 417 |
placepath_id int(11) NOT NULL |
|
| 417 |
placepath_id int(11) NOT NULL, |
|
| 418 |
identifier_id int(11) |
|
| 418 | 419 |
); |
| 419 | 420 |
|
| 420 | 421 |
|
| ... | ... | |
| 3277 | 3278 |
|
| 3278 | 3279 |
|
| 3279 | 3280 |
-- |
| 3280 |
-- Name: locationplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3281 |
-- |
|
| 3282 |
|
|
| 3283 |
ALTER TABLE locationplace |
|
| 3284 |
ADD CONSTRAINT locationplace_unique UNIQUE (location_id, placepath_id); |
|
| 3285 |
|
|
| 3286 |
|
|
| 3287 |
-- |
|
| 3288 | 3281 |
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3289 | 3282 |
-- |
| 3290 | 3283 |
|
| ... | ... | |
| 3841 | 3834 |
|
| 3842 | 3835 |
|
| 3843 | 3836 |
-- |
| 3837 |
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3838 |
-- |
|
| 3839 |
|
|
| 3840 |
|
|
| 3841 |
|
|
| 3842 |
|
|
| 3843 |
-- |
|
| 3844 | 3844 |
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3845 | 3845 |
-- |
| 3846 | 3846 |
|
| ... | ... | |
| 4495 | 4495 |
|
| 4496 | 4496 |
|
| 4497 | 4497 |
-- |
| 4498 |
-- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4499 |
-- |
|
| 4500 |
|
|
| 4501 |
|
|
| 4502 |
|
|
| 4503 |
|
|
| 4504 |
-- |
|
| 4498 | 4505 |
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4499 | 4506 |
-- |
| 4500 | 4507 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationplace: Added identifier_id, so that different identifiers (e.g. the data provider and GNRS) can provide separate locationplaces even if the standardized name happens to be the same as the original name