Revision 500
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2511 | 2511 |
currentdetermination boolean NOT NULL, |
| 2512 | 2512 |
taxonfit character varying(50), |
| 2513 | 2513 |
taxonconfidence character varying(50), |
| 2514 |
collector_id integer, |
|
| 2515 | 2514 |
museum_id integer, |
| 2516 | 2515 |
museumaccessionnumber character varying(100), |
| 2517 | 2516 |
grouptype character varying(20), |
| ... | ... | |
| 5515 | 5514 |
|
| 5516 | 5515 |
|
| 5517 | 5516 |
-- |
| 5518 |
-- Name: taxondetermination_collector_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5519 |
-- |
|
| 5520 |
|
|
| 5521 |
CREATE INDEX taxondetermination_collector_id_x ON taxondetermination USING btree (collector_id); |
|
| 5522 |
|
|
| 5523 |
|
|
| 5524 |
-- |
|
| 5525 | 5517 |
-- Name: taxondetermination_museum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5526 | 5518 |
-- |
| 5527 | 5519 |
|
| ... | ... | |
| 6532 | 6524 |
|
| 6533 | 6525 |
|
| 6534 | 6526 |
-- |
| 6535 |
-- Name: taxondetermination_collector_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6536 |
-- |
|
| 6537 |
|
|
| 6538 |
ALTER TABLE ONLY taxondetermination |
|
| 6539 |
ADD CONSTRAINT taxondetermination_collector_id FOREIGN KEY (collector_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6540 |
|
|
| 6541 |
|
|
| 6542 |
-- |
|
| 6543 | 6527 |
-- Name: taxondetermination_individualplant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6544 | 6528 |
-- |
| 6545 | 6529 |
|
Also available in: Unified diff
vegbien.sql: Removed taxondetermination.collector_id because that's now in specimen