Revision 666
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.sql | ||
|---|---|---|
| 224 | 224 |
count integer, |
| 225 | 225 |
accessioncode character varying(255), |
| 226 | 226 |
sourceaccessioncode character varying(100), |
| 227 |
individualplant_id integer, |
|
| 227 | 228 |
CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ), |
| 229 |
CONSTRAINT aggregateoccurrence_individualplant_id FOREIGN KEY (individualplant_id) |
|
| 230 |
REFERENCES individualplant (individualplant_id) MATCH SIMPLE |
|
| 231 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 228 | 232 |
CONSTRAINT aggregateoccurrence_taxonbinmethod_id FOREIGN KEY (taxonbinmethod_id) |
| 229 | 233 |
REFERENCES taxonbinmethod (taxonbinmethod_id) MATCH SIMPLE |
| 230 | 234 |
ON UPDATE CASCADE ON DELETE CASCADE, |
Also available in: Unified diff
Redoing commit that linked aggregateoccurrence forward to individualplant, allowing many taxonoccurrences (e.g. one for each specimen) to point to the same plant (e.g. that those specimens came from)