Revision 5768
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 400 | 400 |
aggregateoccurrence_id int(11) NOT NULL, |
| 401 | 401 |
creator_id int(11) NOT NULL, |
| 402 | 402 |
sourceaccessioncode text, |
| 403 |
taxonoccurrence_id int(11) NOT NULL,
|
|
| 403 |
taxonoccurrence_id int(11), |
|
| 404 | 404 |
collectiondate date, |
| 405 | 405 |
cover_fraction double precision, |
| 406 | 406 |
linecover_m double precision, |
Also available in: Unified diff
schemas/vegbien.sql: aggregateoccurrence: Made taxonoccurrence_id optional when sourceaccessioncode is specified, so that aggregateoccurrence doesn't get pruned away in datasource tables that link just a stemobservation to a plantobservation (and therefore don't provide a taxonoccurrence to satisfy the previous taxonoccurrence_id NOT NULL constraint)