Revision 498
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2260 | 2260 |
reference_id integer NOT NULL, |
| 2261 | 2261 |
collectioncode_dwc character varying(255), |
| 2262 | 2262 |
catalognumber_dwc character varying(255), |
| 2263 |
collectiondate timestamp with time zone |
|
| 2263 |
collectiondate timestamp with time zone, |
|
| 2264 |
collector_id integer |
|
| 2264 | 2265 |
); |
| 2265 | 2266 |
|
| 2266 | 2267 |
|
| ... | ... | |
| 4905 | 4906 |
|
| 4906 | 4907 |
|
| 4907 | 4908 |
-- |
| 4909 |
-- Name: fki_specimen_collector_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4910 |
-- |
|
| 4911 |
|
|
| 4912 |
CREATE INDEX fki_specimen_collector_id ON specimen USING btree (collector_id); |
|
| 4913 |
|
|
| 4914 |
|
|
| 4915 |
-- |
|
| 4908 | 4916 |
-- Name: fki_specimen_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4909 | 4917 |
-- |
| 4910 | 4918 |
|
| ... | ... | |
| 6428 | 6436 |
|
| 6429 | 6437 |
|
| 6430 | 6438 |
-- |
| 6439 |
-- Name: specimen_collector_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6440 |
-- |
|
| 6441 |
|
|
| 6442 |
ALTER TABLE ONLY specimen |
|
| 6443 |
ADD CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6444 |
|
|
| 6445 |
|
|
| 6446 |
-- |
|
| 6431 | 6447 |
-- Name: specimen_individualplant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6432 | 6448 |
-- |
| 6433 | 6449 |
|
Also available in: Unified diff
vegbien.sql: Added specimen.collector_id column