Revision 520
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2262 | 2262 |
collectioncode_dwc character varying(255), |
| 2263 | 2263 |
catalognumber_dwc character varying(255), |
| 2264 | 2264 |
collectiondate timestamp with time zone, |
| 2265 |
collector_id integer |
|
| 2265 |
collector_id integer, |
|
| 2266 |
museum_id integer, |
|
| 2267 |
sourceaccessionnumber character varying(100) |
|
| 2266 | 2268 |
); |
| 2267 | 2269 |
|
| 2268 | 2270 |
|
| ... | ... | |
| 2512 | 2514 |
currentdetermination boolean NOT NULL, |
| 2513 | 2515 |
taxonfit character varying(50), |
| 2514 | 2516 |
taxonconfidence character varying(50), |
| 2515 |
museum_id integer, |
|
| 2516 |
sourceaccessionnumber character varying(100), |
|
| 2517 | 2517 |
grouptype character varying(20), |
| 2518 | 2518 |
notes text, |
| 2519 | 2519 |
notespublic boolean, |
| ... | ... | |
| 4930 | 4930 |
|
| 4931 | 4931 |
|
| 4932 | 4932 |
-- |
| 4933 |
-- Name: fki_specimen_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4934 |
-- |
|
| 4935 |
|
|
| 4936 |
CREATE INDEX fki_specimen_museum_id ON specimen USING btree (museum_id); |
|
| 4937 |
|
|
| 4938 |
|
|
| 4939 |
-- |
|
| 4933 | 4940 |
-- Name: fki_specimen_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4934 | 4941 |
-- |
| 4935 | 4942 |
|
| ... | ... | |
| 5532 | 5539 |
|
| 5533 | 5540 |
|
| 5534 | 5541 |
-- |
| 5535 |
-- Name: taxondetermination_museum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5536 |
-- |
|
| 5537 |
|
|
| 5538 |
CREATE INDEX taxondetermination_museum_id_x ON taxondetermination USING btree (museum_id); |
|
| 5539 |
|
|
| 5540 |
|
|
| 5541 |
-- |
|
| 5542 | 5542 |
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5543 | 5543 |
-- |
| 5544 | 5544 |
|
| ... | ... | |
| 6462 | 6462 |
|
| 6463 | 6463 |
|
| 6464 | 6464 |
-- |
| 6465 |
-- Name: specimen_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6466 |
-- |
|
| 6467 |
|
|
| 6468 |
ALTER TABLE ONLY specimen |
|
| 6469 |
ADD CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6470 |
|
|
| 6471 |
|
|
| 6472 |
-- |
|
| 6465 | 6473 |
-- Name: specimen_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6466 | 6474 |
-- |
| 6467 | 6475 |
|
| ... | ... | |
| 6550 | 6558 |
|
| 6551 | 6559 |
|
| 6552 | 6560 |
-- |
| 6553 |
-- Name: taxondetermination_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6554 |
-- |
|
| 6555 |
|
|
| 6556 |
ALTER TABLE ONLY taxondetermination |
|
| 6557 |
ADD CONSTRAINT taxondetermination_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6558 |
|
|
| 6559 |
|
|
| 6560 |
-- |
|
| 6561 | 6561 |
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6562 | 6562 |
-- |
| 6563 | 6563 |
|
Also available in: Unified diff
VegBIEN: Moved taxondetermination.sourceaccessionnumber and museum_id to specimen