Revision 678
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.my.sql | ||
|---|---|---|
| 226 | 226 |
sourceaccessioncode character varying(100), |
| 227 | 227 |
plantobservation_id int(11), |
| 228 | 228 |
stratum_id int(11), |
| 229 |
sizeclass_id int(11), |
|
| 230 |
coverindex_id int(11), |
|
| 229 | 231 |
CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ), |
| 230 | 232 |
CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) |
| 231 | 233 |
REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE |
| 232 | 234 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 235 |
CONSTRAINT aggregateoccurrence_sizeclass_id FOREIGN KEY (sizeclass_id) |
|
| 236 |
REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE |
|
| 237 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 233 | 238 |
CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) |
| 234 | 239 |
REFERENCES stratum (stratum_id) MATCH SIMPLE |
| 235 | 240 |
ON UPDATE CASCADE ON DELETE CASCADE, |
Also available in: Unified diff
vegbien.sql: Added taxonbinmethod fields to aggregateoccurrence