Revision 1028
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 134 | 134 |
sizeclass_id integer, |
| 135 | 135 |
coverindex_id integer, |
| 136 | 136 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
| 137 |
method_id integer, |
|
| 137 | 138 |
CONSTRAINT aggregateoccurrence_plantobs_count_1 CHECK (((plantobservation_id IS NULL) OR (NOT (count IS DISTINCT FROM 1)))) |
| 138 | 139 |
); |
| 139 | 140 |
|
| ... | ... | |
| 2838 | 2839 |
authorplantname text, |
| 2839 | 2840 |
reference_id integer, |
| 2840 | 2841 |
emb_taxonoccurrence integer, |
| 2841 |
accessioncode text, |
|
| 2842 |
method_id integer |
|
| 2842 |
accessioncode text |
|
| 2843 | 2843 |
); |
| 2844 | 2844 |
|
| 2845 | 2845 |
|
| ... | ... | |
| 5411 | 5411 |
|
| 5412 | 5412 |
|
| 5413 | 5413 |
-- |
| 5414 |
-- Name: fki_taxonoccurrence_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5415 |
-- |
|
| 5416 |
|
|
| 5417 |
CREATE INDEX fki_taxonoccurrence_method_id ON taxonoccurrence USING btree (method_id); |
|
| 5418 |
|
|
| 5419 |
|
|
| 5420 |
-- |
|
| 5421 | 5414 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5422 | 5415 |
-- |
| 5423 | 5416 |
|
| ... | ... | |
| 6260 | 6253 |
|
| 6261 | 6254 |
|
| 6262 | 6255 |
-- |
| 6256 |
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6257 |
-- |
|
| 6258 |
|
|
| 6259 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 6260 |
ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6261 |
|
|
| 6262 |
|
|
| 6263 |
-- |
|
| 6263 | 6264 |
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6264 | 6265 |
-- |
| 6265 | 6266 |
|
| ... | ... | |
| 7164 | 7165 |
|
| 7165 | 7166 |
|
| 7166 | 7167 |
-- |
| 7167 |
-- Name: taxonoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7168 |
-- |
|
| 7169 |
|
|
| 7170 |
ALTER TABLE ONLY taxonoccurrence |
|
| 7171 |
ADD CONSTRAINT taxonoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7172 |
|
|
| 7173 |
|
|
| 7174 |
-- |
|
| 7175 | 7168 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7176 | 7169 |
-- |
| 7177 | 7170 |
|
Also available in: Unified diff
vegbien.sql: Attach method to aggregateoccurrence instead of taxonoccurrence