Revision 678
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 91 | 91 |
accessioncode character varying(255), |
| 92 | 92 |
sourceaccessioncode character varying(100), |
| 93 | 93 |
plantobservation_id integer, |
| 94 |
stratum_id integer |
|
| 94 |
stratum_id integer, |
|
| 95 |
sizeclass_id integer, |
|
| 96 |
coverindex_id integer |
|
| 95 | 97 |
); |
| 96 | 98 |
|
| 97 | 99 |
|
| ... | ... | |
| 6069 | 6071 |
|
| 6070 | 6072 |
|
| 6071 | 6073 |
-- |
| 6074 |
-- Name: aggregateoccurrence_sizeclass_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6075 |
-- |
|
| 6076 |
|
|
| 6077 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 6078 |
ADD CONSTRAINT aggregateoccurrence_sizeclass_id FOREIGN KEY (sizeclass_id) REFERENCES sizeclass(sizeclass_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6079 |
|
|
| 6080 |
|
|
| 6081 |
-- |
|
| 6072 | 6082 |
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6073 | 6083 |
-- |
| 6074 | 6084 |
|
Also available in: Unified diff
vegbien.sql: Added taxonbinmethod fields to aggregateoccurrence