Revision 615
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 285 | 285 |
collectioncode_dwc character varying(255), |
| 286 | 286 |
catalognumber_dwc character varying(255), |
| 287 | 287 |
collectiondate timestamp NULL, |
| 288 |
collector_id int(11), |
|
| 289 | 288 |
museum_id int(11), |
| 290 | 289 |
sourceaccessioncode character varying(100), |
| 291 | 290 |
accessioncode character varying(255), |
| ... | ... | |
| 293 | 292 |
verbatimcollectorname character varying(255), |
| 294 | 293 |
authorspecimencode character varying(20), |
| 295 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 296 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
|
| 297 |
REFERENCES party (party_id) MATCH SIMPLE |
|
| 298 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 299 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 300 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| 301 | 297 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 98 | 98 |
collectioncode_dwc character varying(255), |
| 99 | 99 |
catalognumber_dwc character varying(255), |
| 100 | 100 |
collectiondate timestamp with time zone, |
| 101 |
collector_id integer, |
|
| 102 | 101 |
museum_id integer, |
| 103 | 102 |
sourceaccessioncode character varying(100), |
| 104 | 103 |
accessioncode character varying(255), |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 285 | 285 |
collectioncode_dwc character varying(255), |
| 286 | 286 |
catalognumber_dwc character varying(255), |
| 287 | 287 |
collectiondate timestamp with time zone, |
| 288 |
collector_id integer, |
|
| 289 | 288 |
museum_id integer, |
| 290 | 289 |
sourceaccessioncode character varying(100), |
| 291 | 290 |
accessioncode character varying(255), |
| ... | ... | |
| 293 | 292 |
verbatimcollectorname character varying(255), |
| 294 | 293 |
authorspecimencode character varying(20), |
| 295 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 296 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
|
| 297 |
REFERENCES party (party_id) MATCH SIMPLE |
|
| 298 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 299 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 300 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| 301 | 297 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| schemas/vegbien.sql | ||
|---|---|---|
| 2268 | 2268 |
collectioncode_dwc character varying(255), |
| 2269 | 2269 |
catalognumber_dwc character varying(255), |
| 2270 | 2270 |
collectiondate timestamp with time zone, |
| 2271 |
collector_id integer, |
|
| 2272 | 2271 |
museum_id integer, |
| 2273 | 2272 |
sourceaccessioncode character varying(100), |
| 2274 | 2273 |
accessioncode character varying(255), |
| ... | ... | |
| 5022 | 5021 |
|
| 5023 | 5022 |
|
| 5024 | 5023 |
-- |
| 5025 |
-- Name: fki_specimen_collector_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5026 |
-- |
|
| 5027 |
|
|
| 5028 |
CREATE INDEX fki_specimen_collector_id ON specimen USING btree (collector_id); |
|
| 5029 |
|
|
| 5030 |
|
|
| 5031 |
-- |
|
| 5032 | 5024 |
-- Name: fki_specimen_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5033 | 5025 |
-- |
| 5034 | 5026 |
|
| ... | ... | |
| 6552 | 6544 |
|
| 6553 | 6545 |
|
| 6554 | 6546 |
-- |
| 6555 |
-- Name: specimen_collector_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6556 |
-- |
|
| 6557 |
|
|
| 6558 |
ALTER TABLE ONLY specimen |
|
| 6559 |
ADD CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6560 |
|
|
| 6561 |
|
|
| 6562 |
-- |
|
| 6563 | 6547 |
-- Name: specimen_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6564 | 6548 |
-- |
| 6565 | 6549 |
|
Also available in: Unified diff
vegbien.sql: Removed no longer needed specimen.collector_id